TVFK

Transparent Table Customizing (protected)
86 Fields 8 CDS Views

Billing: Document Types

TVFK is an SAP database table in S/4HANA. Billing: Document Types. It contains 86 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_BillingDocumentType view from BASIC Billing Document Type
I_BillingProcessDocumentType view_entity from BASIC Billing Process Document Type
I_PL_SAFTBillingDocTypeMap view inner BASIC SAF-T PL: Billing Document Type Mapping
P_PL_SAFTDwnPayInvoice view inner BASIC
TMA_V_VBRK_VBRP_1 view inner Business Volume from Billing Document
V_WB2_VBRK_VBRP_1 view inner Business Volume from Billing Document
V_Wb2_Vbrk_Vbrp_Tpm view inner CCS: Business Volume from Sales for TPM
V_WB2_VBRK_VBRP_TPM_1 view inner Business Volume from Billing Document with Campaign

Fields (86)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fkart FKART Billing Type
kopgr KOPGR Scr.seq.group
numki NUMKI NR of Int. Asst
numke NUMKE NR of Ext. Asst
incpo INCPO ItemNoIncrement
kunn0 BOFKT RebateSettlemnt
uevor UEVOR_VF FCode-OvervScrn
umfng UMFNG Display Range
rfbfk RFBFK Posting Block
trvog TRVOG Transact.Group
txn08 TXN08 Standard Text
vbtyp VBTYPL Document Cat.
ernam ERNAM Created By
pargk PARGK Header Partners
pargp PARGP Item Partners
kalsmc KALSMC Act Det.G/L Act
fkarts FKARTS CancelBillType
txtgr TXTGR TextDetermProc.
kappl NA_KAPPL Application
kalsm KALSMB OutputDet.Proc.
kschl NA_KSCHL Output Type
stafo STAFO Update Group
kvslv KVSLV Cash alloc.acct
kalvg KALVG_VF DocPricingProc.
txtgr_p TXTGR_P Text Proced.Itm
stati STATI Statistics
kalsmbp KALSMBP OutputDetrmProc
borvf BORVF Rel. for Rebate
fkart_rl FKART_RL Inv. List Type
relep RELEP InvListLineItms
txtlf TXTLF Delivery Texts
hityp_pr HITYP_PR HierTypePricing
fkart_ab FKART_AB AccrualBillType
grbed_s GRBED Copying Reqs
ordnr_fi_s ORDNR_FI Assignment No.
xblnr_fi_s XBLNR_FI Reference No.
j_1bnfrel J_1BNFREL NF relevance
j_1bmainpa J_1BMAINPA Main partner id
j_1btdidh J_1BTDIDH Text id header
j_1btdcoh J_1BTDCOH Counter header
j_1btdidl J_1BTDIDL Text id lines
j_1btdcol J_1BTDCOL Counter lines
fktyp FKTYP_2 BillingCategory
xnegp XNEGP_VF Negative Pstng
blart BLART Document Type
xfilkd XFILKD_VF Branch/H.Office
xvalgs XVALGS CD w/ Val. Date
kalsmca KALSMCA PP extra pay
kalsmcb KALSMCB AccDet RecAcc
kalsmcc KALSMCC AccDet CashSet
kalsmcd KALSMCD AccDet PayCards
xkoiv XKOIV AA offset.entry
j_1ainvref J_1AINVREF Inv. reference
j_1acpdel J_1ACPDEL Copy branch
uveib UVEIB DocPricingProc.
fkart_mev_reset FKART_MEV_RESET Period-End Reset
vbtyp_ext TDD_VBTYP_EXT_OBSOLETE Cat. Ext. obsol
flexnum_routine_no SDBIL_FLEXNUM_ROUTINE_NO Flex.Doc.No. Routine
flexcanc_routine_no SDBIL_FLEXCANC_ROUTINE_NO Flex. Doc. Canc. Rtn
oicinpd OIC_INPD Inv.pric.rules
oifeepd OIA_FEEPD Fee.pricing dt.
oiinvcyc1 OIA_INCYCA Inv.cycle ind.
oiinvcyc2 OIA_INCYCA Inv.cycle ind.
oiinvcyc3 OIA_INCYCA Inv.cycle ind.
oiinvcyc4 OIA_INCYCA Inv.cycle ind.
oiinvcyc5 OIA_INCYCA Inv.cycle ind.
oiinvcyc6 OIA_INCYCA Inv.cycle ind.
oiinvcyc7 OIA_INCYCA Inv.cycle ind.
oiinvcyc8 OIA_INCYCA Inv.cycle ind.
oiinvcyc9 OIA_INCYCA Inv.cycle ind.
oinetexit OIA_NEXIT Netting exit
oiptrmex OIA_PTEXIT Pymt.term exit
oic_diffin OIC_DIFFIN Diff.inv.
oic_dicntr OIC_DICNTR Diff.inv.ctrl
oic_accval OIC_ACCVAL UserE./acc.val.
oic_errha OIC_ERRHA Error handling
oic_fkart OIC_FKART Billing type
oiselexit OIA_SELEX Mvt.sel. exit
oifinexit OIA_FINEX Fin.doc. exit
oinetrpt PROGNAME Program Name
oibtcexit OIA_BTCEX BTCI gen.exit
oiamwofi OIA_MWOFI Mov. w/o FI
oiabalan OIA_BALAN Balance ind.
oiinvapp OIC_SDP_INAPPR Inv.App.Proc
oiindcm OIC_SDP_DCM Active DCM

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Billing: Document Types
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVFK (
    MANDT,                -- Client [MANDT]
    FKART,                -- Billing Type [FKART]
    KOPGR,                -- Scr.seq.group [KOPGR]
    NUMKI,                -- NR of Int. Asst [NUMKI]
    NUMKE,                -- NR of Ext. Asst [NUMKE]
    INCPO,                -- ItemNoIncrement [INCPO]
    KUNN0,                -- RebateSettlemnt [BOFKT]
    UEVOR,                -- FCode-OvervScrn [UEVOR_VF]
    UMFNG,                -- Display Range [UMFNG]
    RFBFK,                -- Posting Block [RFBFK]
    TRVOG,                -- Transact.Group [TRVOG]
    TXN08,                -- Standard Text [TXN08]
    VBTYP,                -- Document Cat. [VBTYPL]
    ERNAM,                -- Created By [ERNAM]
    PARGK,                -- Header Partners [PARGK]
    PARGP,                -- Item Partners [PARGP]
    KALSMC,               -- Act Det.G/L Act [KALSMC]
    FKARTS,               -- CancelBillType [FKARTS]
    TXTGR,                -- TextDetermProc. [TXTGR]
    KAPPL,                -- Application [NA_KAPPL]
    KALSM,                -- OutputDet.Proc. [KALSMB]
    KSCHL,                -- Output Type [NA_KSCHL]
    STAFO,                -- Update Group [STAFO]
    KVSLV,                -- Cash alloc.acct [KVSLV]
    KALVG,                -- DocPricingProc. [KALVG_VF]
    TXTGR_P,              -- Text Proced.Itm [TXTGR_P]
    STATI,                -- Statistics [STATI]
    KALSMBP,              -- OutputDetrmProc [KALSMBP]
    BORVF,                -- Rel. for Rebate [BORVF]
    FKART_RL,             -- Inv. List Type [FKART_RL]
    RELEP,                -- InvListLineItms [RELEP]
    TXTLF,                -- Delivery Texts [TXTLF]
    HITYP_PR,             -- HierTypePricing [HITYP_PR]
    FKART_AB,             -- AccrualBillType [FKART_AB]
    GRBED_S,              -- Copying Reqs [GRBED]
    ORDNR_FI_S,           -- Assignment No. [ORDNR_FI]
    XBLNR_FI_S,           -- Reference No. [XBLNR_FI]
    J_1BNFREL,            -- NF relevance [J_1BNFREL]
    J_1BMAINPA,           -- Main partner id [J_1BMAINPA]
    J_1BTDIDH,            -- Text id header [J_1BTDIDH]
    J_1BTDCOH,            -- Counter header [J_1BTDCOH]
    J_1BTDIDL,            -- Text id lines [J_1BTDIDL]
    J_1BTDCOL,            -- Counter lines [J_1BTDCOL]
    FKTYP,                -- BillingCategory [FKTYP_2]
    XNEGP,                -- Negative Pstng [XNEGP_VF]
    BLART,                -- Document Type [BLART]
    XFILKD,               -- Branch/H.Office [XFILKD_VF]
    XVALGS,               -- CD w/ Val. Date [XVALGS]
    KALSMCA,              -- PP extra pay [KALSMCA]
    KALSMCB,              -- AccDet RecAcc [KALSMCB]
    KALSMCC,              -- AccDet CashSet [KALSMCC]
    KALSMCD,              -- AccDet PayCards [KALSMCD]
    XKOIV,                -- AA offset.entry [XKOIV]
    J_1AINVREF,           -- Inv. reference [J_1AINVREF]
    J_1ACPDEL,            -- Copy branch [J_1ACPDEL]
    UVEIB,                -- DocPricingProc. [UVEIB]
    FKART_MEV_RESET,      -- Period-End Reset [FKART_MEV_RESET]
    VBTYP_EXT,            -- Cat. Ext. obsol [TDD_VBTYP_EXT_OBSOLETE]
    FLEXNUM_ROUTINE_NO,   -- Flex.Doc.No. Routine [SDBIL_FLEXNUM_ROUTINE_NO]
    FLEXCANC_ROUTINE_NO,  -- Flex. Doc. Canc. Rtn [SDBIL_FLEXCANC_ROUTINE_NO]
    OICINPD,              -- Inv.pric.rules [OIC_INPD]
    OIFEEPD,              -- Fee.pricing dt. [OIA_FEEPD]
    OIINVCYC1,            -- Inv.cycle ind. [OIA_INCYCA]
    OIINVCYC2,            -- Inv.cycle ind. [OIA_INCYCA]
    OIINVCYC3,            -- Inv.cycle ind. [OIA_INCYCA]
    OIINVCYC4,            -- Inv.cycle ind. [OIA_INCYCA]
    OIINVCYC5,            -- Inv.cycle ind. [OIA_INCYCA]
    OIINVCYC6,            -- Inv.cycle ind. [OIA_INCYCA]
    OIINVCYC7,            -- Inv.cycle ind. [OIA_INCYCA]
    OIINVCYC8,            -- Inv.cycle ind. [OIA_INCYCA]
    OIINVCYC9,            -- Inv.cycle ind. [OIA_INCYCA]
    OINETEXIT,            -- Netting exit [OIA_NEXIT]
    OIPTRMEX,             -- Pymt.term exit [OIA_PTEXIT]
    OIC_DIFFIN,           -- Diff.inv. [OIC_DIFFIN]
    OIC_DICNTR,           -- Diff.inv.ctrl [OIC_DICNTR]
    OIC_ACCVAL,           -- UserE./acc.val. [OIC_ACCVAL]
    OIC_ERRHA,            -- Error handling [OIC_ERRHA]
    OIC_FKART,            -- Billing type [OIC_FKART]
    OISELEXIT,            -- Mvt.sel. exit [OIA_SELEX]
    OIFINEXIT,            -- Fin.doc. exit [OIA_FINEX]
    OINETRPT,             -- Program Name [PROGNAME]
    OIBTCEXIT,            -- BTCI gen.exit [OIA_BTCEX]
    OIAMWOFI,             -- Mov. w/o FI [OIA_MWOFI]
    OIABALAN,             -- Balance ind. [OIA_BALAN]
    OIINVAPP,             -- Inv.App.Proc [OIC_SDP_INAPPR]
    OIINDCM,              -- Active DCM [OIC_SDP_DCM]
    PRIMARY KEY (MANDT, FKART)
);

Learn More