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