SAP Table

TVFK Billing: Document Types

SAP table TVFK has 2 primary key fields being MANDT,FKART.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

TVFK columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyFKART Billing Type CHAR 4 0 FKART
KOPGR Screen sequence group in doc. header CHAR 4 0 KOPGR
NUMKI Number Range of Internal Number Assignment CHAR 2 0 NUMKI
NUMKE Number Range of External Number Assignment CHAR 2 0 NUMKE
INCPO Item Number Increment of SD Documents NUMC 6 0 INCPO
KUNN0 Billing type for rebate processing CHAR 1 0 BOFKT
UEVOR F-code default for overview screen CHAR 4 0 UEVOR_VF
UMFNG Display Range CHAR 20 0 UMFNG
RFBFK Blocked for transfer to accounting CHAR 1 0 RFBFK
TRVOG Transaction Group CHAR 1 0 TRVOG
TXN08 Number of the Standard Text CHAR 8 0 TXN08
VBTYP SD Document Category CHAR 4 0 VBTYPL
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
PARGK Partner determination procedure for the billing doc.header CHAR 4 0 PARGK
PARGP Partner determination procedure for the billing doc.item CHAR 4 0 PARGP
KALSMC Account Determination Procedure for G/L Accounts CHAR 6 0 T683 KALSMC
FKARTS Billing Type for Cancellation CHAR 4 0 TVFK FKARTS
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
KAPPL Application for output conditions CHAR 2 0 T681A NA_KAPPL
KALSM Output determination procedure CHAR 6 0 T683 KALSMB
KSCHL Output Type CHAR 4 0 NA_KSCHL
STAFO Update Group for statistics update CHAR 6 0 STAFO
KVSLV Account key for cash allocation CHAR 3 0 T687 KVSLV
KALVG Document Classification for Pricing Procedure Determination CHAR 2 0 TVKV KALVG
TXTGR_P Text determination procedure for billing item CHAR 2 0 TTXG TXTGR_P
STATI Update statistics CHAR 1 0 STATI
KALSMBP Procedure for item output CHAR 6 0 T683 KALSMBP
BORVF Billing Document is Relevant for Sales Rebate Processing CHAR 1 0 BORVF
FKART_RL Invoice List Type CHAR 4 0 TVFK FKART_RL
RELEP Forward invoice lists with line items to FI CHAR 1 0 RELEP
TXTLF Copy texts from delivery note CHAR 1 0 TXTLF
HITYP_PR Hierarchy type for pricing CHAR 1 0 THIT HITYP_PR
FKART_AB Accrual Billing Type CHAR 4 0 TVFK FKART_AB
GRBED_S Copying Requirements NUMC 3 0 GRBED
ORDNR_FI_S Assignment Number (Financial Accounting) CHAR 1 0 ORDNR_FI
XBLNR_FI_S FI reference number CHAR 1 0 XBLNR_FI
J_1BNFREL Nota Fiscal Relevance CHAR 1 0 J_1BNFREL
J_1BMAINPA Main partner function ID (e.g. SH for ship-to party) CHAR 2 0 J_1BAD J_1BMAINPA
J_1BTDIDH Text Id. Nota Fiscal header CHAR 4 0 TTXID J_1BTDIDH
J_1BTDCOH Number of text lines header NUMC 1 0 J_1BTDCOH
J_1BTDIDL Text Id Nota Fiscal lines CHAR 4 0 TTXID J_1BTDIDL
J_1BTDCOL Counter Number of text lines NF line NUMC 1 0 J_1BTDCOL
FKTYP Billing Category CHAR 1 0 FKTYP_2
XNEGP Negative posting CHAR 1 0 XNEGP_VF
BLART Document Type CHAR 2 0 T003 BLART
XFILKD Branch/head office relationship CHAR 1 0 XFILKD_VF
XVALGS Correction Document with Value Date CHAR 1 0 XVALGS
KALSMCA Pricing procedure for account determination extra pay CHAR 6 0 T683 KALSMCA
KALSMCB Pricing procedure for acc. determ. reconciliation account CHAR 6 0 T683 KALSMCB
KALSMCC Pricing procedure for account determination cash settlement CHAR 6 0 T683 KALSMCC
KALSMCD Pricing procedure for account determination payment cards CHAR 6 0 T683 KALSMCD
XKOIV Account assignment offsetting entry in intercompany billing CHAR 1 0 XKOIV
J_1AINVREF Invoice reference in billing document CHAR 1 0 J_1AINVREF
J_1ACPDEL Indicator: Copy branch from Delivery note CHAR 1 0 J_1ACPDEL
UVEIB Doc. pricing procedure for incomplete export/import data CHAR 3 0 UVEIB
FKART_MEV_RESET Billing Document Type for Period-End Reset CHAR 4 0 TVFK FKART_MEV_RESET
VBTYP_EXT Extension of SD Document Category - Obsolete CHAR 4 0 TDD_VBTYP_EXT_OBSOLETE
FLEXNUM_ROUTINE_NO Routine No. for Flexible Billing Doc. Numbering NUMC 7 0 SDBIL_FLEXNUM_ROUTINE_NO
FLEXCANC_ROUTINE_NO Routine No. for Flexible Billing Document Cancellation NUMC 7 0 SDBIL_FLEXCANC_ROUTINE_NO
OICINPD Invoice pricing date rule CHAR 1 0 OIC_INPD
OIFEEPD Fee pricing date CHAR 1 0 OIA_FEEPD
OIINVCYC1 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC2 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC3 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC4 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC5 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC6 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC7 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC8 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OIINVCYC9 Invoice cycle indicator active (X/ ) CHAR 1 0 OIA_INCYCA
OINETEXIT User exit for netting cycle determination NUMC 3 0 OIA_NEXIT
OIPTRMEX Payment term transfer to VBRK NUMC 3 0 OIA_PTEXIT
OIC_DIFFIN Differential invoice CHAR 1 0 OIC_DIFFIN
OIC_DICNTR Differential invoice control CHAR 1 0 OIC_DICNTR
OIC_ACCVAL User exit to accumulate already-invoiced values NUMC 3 0 OIC_ACCVAL
OIC_ERRHA User exit for error handling/no breakdown of diff. amount NUMC 3 0 OIC_ERRHA
OIC_FKART Default billing type for cancel / rebill CHAR 4 0 TVFK OIC_FKART
OISELEXIT Movements index selection exit NUMC 3 0 OIA_SELEX
OIFINEXIT Financial document selection exit NUMC 3 0 OIA_FINEX
OINETRPT ABAP Program Name CHAR 40 0 TRDIR PROGNAME
OIBTCEXIT BTCI generation exit for movements based netting NUMC 3 0 OIA_BTCEX
OIAMWOFI Movements without financials indicator CHAR 1 0 OIA_MWOFI
OIABALAN Include balances indicator CHAR 1 0 OIA_BALAN
OIINVAPP Invoice Approval Process (IAP) active flag CHAR 1 0 OIC_SDP_INAPPR
OIINDCM Active flag f. Document Change Management (DCM) for invoice CHAR 1 0 OIC_SDP_DCM
/ Relationships

TVFK foreign keys.

Table Field Check Table Description Check Field
TVFK BLART T003 Document Types MANDT
TVFK FKARTS TVFK Billing: Document Types MANDT
TVFK FKARTS TVFK Billing: Document Types FKART
TVFK FKART_AB TVFK Billing: Document Types MANDT
TVFK FKART_AB TVFK Billing: Document Types FKART
TVFK FKART_MEV_RESET TVFK Billing: Document Types MANDT
TVFK FKART_MEV_RESET TVFK Billing: Document Types FKART
TVFK FKART_RL TVFK Billing: Document Types MANDT
TVFK FKART_RL TVFK Billing: Document Types FKART
TVFK HITYP_PR THIT Customer Hierarchy Types MANDT
TVFK HITYP_PR THIT Customer Hierarchy Types HITYP
TVFK J_1BMAINPA J_1BAD Partner function ID MANDT
TVFK J_1BMAINPA J_1BAD Partner function ID PARVW
TVFK KALSM T683 Pricing procedures KAPPL
TVFK KALSM T683 Pricing procedures KALSM
TVFK KALSMBP T683 Pricing procedures KAPPL
TVFK KALSMBP T683 Pricing procedures KALSM
TVFK KALSMC T683 Pricing procedures KAPPL
TVFK KALSMC T683 Pricing procedures KALSM
TVFK KALSMCA T683 Pricing procedures KAPPL
TVFK KALSMCA T683 Pricing procedures KALSM
TVFK KALSMCB T683 Pricing procedures KAPPL
TVFK KALSMCB T683 Pricing procedures KALSM
TVFK KALSMCC T683 Pricing procedures KAPPL
TVFK KALSMCC T683 Pricing procedures KALSM
TVFK KALSMCD T683 Pricing procedures KAPPL
TVFK KALSMCD T683 Pricing procedures KALSM
TVFK KALVG TVKV Document classification for pricing procedure determination MANDT
TVFK KALVG TVKV Document classification for pricing procedure determination KALVG
TVFK KAPPL T681A Conditions: Applications KAPPL
TVFK KVSLV T687 Account Determination: Account Key KAPPL
TVFK OIC_FKART TVFK Billing: Document Types MANDT
TVFK OIC_FKART TVFK Billing: Document Types FKART
TVFK OINETRPT TRDIR Generated Table for View NAME
TVFK TXTGR TTXG Text Processing: Text ID Groups MANDT
TVFK TXTGR_P TTXG Text Processing: Text ID Groups MANDT
Back to SAP tables