TVFK SAP table for – Billing: Document Types

Here we would like to draw your attention to TVFK table in SAP. As we know it is being mainly used with the SAP SD-BIL (Billing in SD) component which is coming under SD module (Sales & Distribution). TVFK is a SAP standard transparent table used for storing Billing: Document Types related data in SAP. It comes under the package VF0C.

SAP TVFK table

Table TVFK technical data

TableTVFK
Data storingBilling: Document Types
ModuleSD
ComponentSD-BIL
SAP PackageVF0C
Delivery ClassG – Customer table, SAP may insert new data records but may not overwrite or delete existing ones
Table CategoryTRANSPARENT

SAP TVFK Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TVFK table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • RFBFK
    Its data type is C (Character String) with field length 1
  • TRVOG
    Its data type is C (Character String) with field length 1
  • TXN08
    Its data type is C (Character String) with field length 8
  • VBTYP
    Its data type is C (Character String) with field length 1
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • PARGK
    Its data type is C (Character String) with field length 4
  • PARGP
    Its data type is C (Character String) with field length 4
  • KALSMC
    Its data type is C (Character String) with field length 6
  • FKARTS
    Its data type is C (Character String) with field length 4
  • TXTGR
    Its data type is C (Character String) with field length 2
  • FKART : Billing Type
    Its a key field. Its data type is C (Character String) with field length 4
  • KAPPL : Application
    Its data type is C (Character String) with field length 2
  • KALSM : Costing Sheet
    Its data type is C (Character String) with field length 6
  • KSCHL : Condition Type
    Its data type is C (Character String) with field length 4
  • STAFO
    Its data type is C (Character String) with field length 6
  • KVSLV
    Its data type is C (Character String) with field length 3
  • KALVG
    Its data type is C (Character String) with field length 1
  • TXTGR_P
    Its data type is C (Character String) with field length 2
  • STATI
    Its data type is C (Character String) with field length 1
  • KALSMBP
    Its data type is C (Character String) with field length 6
  • BORVF
    Its data type is C (Character String) with field length 1
  • KOPGR
    Its data type is C (Character String) with field length 4
  • FKART_RL
    Its data type is C (Character String) with field length 4
  • RELEP
    Its data type is C (Character String) with field length 1
  • TXTLF
    Its data type is C (Character String) with field length 1
  • HITYP_PR
    Its data type is C (Character String) with field length 1
  • FKART_AB
    Its data type is C (Character String) with field length 4
  • GRBED_S
    Its data type is N (Character String with Digits Only) with field length 3
  • ORDNR_FI_S
    Its data type is C (Character String) with field length 1
  • XBLNR_FI_S
    Its data type is C (Character String) with field length 1
  • J_1BNFREL
    Its data type is C (Character String) with field length 1
  • J_1BMAINPA
    Its data type is C (Character String) with field length 2
  • NUMKI
    Its data type is C (Character String) with field length 2
  • J_1BTDIDH
    Its data type is C (Character String) with field length 4
  • J_1BTDCOH
    Its data type is N (Character String with Digits Only) with field length 1
  • J_1BTDIDL
    Its data type is C (Character String) with field length 4
  • J_1BTDCOL
    Its data type is N (Character String with Digits Only) with field length 1
  • FKTYP
    Its data type is C (Character String) with field length 1
  • XNEGP : Indicator: Negative posting
    Its data type is C (Character String) with field length 1
  • BLART : Document type
    Its data type is C (Character String) with field length 2
  • XFILKD
    Its data type is C (Character String) with field length 1
  • XVALGS
    Its data type is C (Character String) with field length 1
  • KALSMCA
    Its data type is C (Character String) with field length 6
  • NUMKE
    Its data type is C (Character String) with field length 2
  • KALSMCB
    Its data type is C (Character String) with field length 6
  • KALSMCC
    Its data type is C (Character String) with field length 6
  • KALSMCD
    Its data type is C (Character String) with field length 6
  • XKOIV
    Its data type is C (Character String) with field length 1
  • J_1AINVREF
    Its data type is C (Character String) with field length 1
  • J_1ACPDEL
    Its data type is C (Character String) with field length 1
  • UVEIB
    Its data type is C (Character String) with field length 3
  • FKART_MEV_RESET
    Its data type is C (Character String) with field length 4
  • VBTYP_EXT
    Its data type is C (Character String) with field length 4
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is JHAVFK_XKRVO
  • INCPO : Include Purchase Order in ROC / Prio Calculation
    Its data type is N (Character String with Digits Only) with field length 6
  • ISM_XKRVO
    Its data type is C (Character String) with field length 1
  • OICINPD
    Its data type is C (Character String) with field length 1
  • OIFEEPD
    Its data type is C (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is OIA_INVCYC_ACT
  • OIINVCYC1
    Its data type is C (Character String) with field length 1
  • OIINVCYC2
    Its data type is C (Character String) with field length 1
  • OIINVCYC3
    Its data type is C (Character String) with field length 1
  • OIINVCYC4
    Its data type is C (Character String) with field length 1
  • OIINVCYC5
    Its data type is C (Character String) with field length 1
  • KUNN0
    Its data type is C (Character String) with field length 1
  • OIINVCYC6
    Its data type is C (Character String) with field length 1
  • OIINVCYC7
    Its data type is C (Character String) with field length 1
  • OIINVCYC8
    Its data type is C (Character String) with field length 1
  • OIINVCYC9
    Its data type is C (Character String) with field length 1
  • OINETEXIT
    Its data type is N (Character String with Digits Only) with field length 3
  • OIPTRMEX
    Its data type is N (Character String with Digits Only) with field length 3
  • OIC_DIFFIN
    Its data type is C (Character String) with field length 1
  • OIC_DICNTR
    Its data type is C (Character String) with field length 1
  • OIC_ACCVAL
    Its data type is N (Character String with Digits Only) with field length 3
  • OIC_ERRHA
    Its data type is N (Character String with Digits Only) with field length 3
  • UEVOR
    Its data type is C (Character String) with field length 4
  • OIC_FKART
    Its data type is C (Character String) with field length 4
  • OISELEXIT
    Its data type is N (Character String with Digits Only) with field length 3
  • OIFINEXIT
    Its data type is N (Character String with Digits Only) with field length 3
  • OINETRPT
    Its data type is C (Character String) with field length 40
  • OIBTCEXIT
    Its data type is N (Character String with Digits Only) with field length 3
  • OIAMWOFI
    Its data type is C (Character String) with field length 1
  • OIABALAN
    Its data type is C (Character String) with field length 1
  • OIINVAPP
    Its data type is C (Character String) with field length 1
  • OIINDCM
    Its data type is C (Character String) with field length 1
  • UMFNG
    Its data type is C (Character String) with field length 20