TVAK SAP table for – Sales Document Types

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

SAP TVAK table

Table TVAK technical data

TableTVAK
Data storingSales Document Types
ModuleSD
ComponentSD-SLS
SAP PackageVA0C
Delivery ClassG – Customer table, SAP may insert new data records but may not overwrite or delete existing ones
Table CategoryTRANSPARENT

SAP TVAK 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 TVAK table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • UEVOR
    Its data type is C (Character String) with field length 20
  • ATPGM
    Its data type is C (Character String) with field length 1
  • VERLI
    Its data type is C (Character String) with field length 1
  • TENUR
    Its data type is C (Character String) with field length 1
  • J_1AFCTYPE
    Its data type is C (Character String) with field length 2
  • FAUPR
    Its data type is C (Character String) with field length 14
  • PVBSM
    Its data type is C (Character String) with field length 2
  • BPROC
    Its data type is C (Character String) with field length 4
  • ERMAT
    Its data type is C (Character String) with field length 1
  • BSTVO
    Its data type is C (Character String) with field length 1
  • EXTCONT
    Its data type is C (Character String) with field length 1
  • AUGRP
    Its data type is C (Character String) with field length 2
  • KSCHL_BUDGET
    Its data type is C (Character String) with field length 4
  • KSCHL_CAPS
    Its data type is C (Character String) with field length 4
  • MSR_ACTIVE
    Its data type is C (Character String) with field length 1
  • MSR_NEXT_NUMBER
    Its data type is C (Character String) with field length 1
  • MSR_AUARA
    Its data type is C (Character String) with field length 4
  • MSR_BILLING_BLK
    Its data type is C (Character String) with field length 2
  • MSR_CM_IMMEDIATE
    Its data type is C (Character String) with field length 1
  • MSR_LFART
    Its data type is C (Character String) with field length 4
  • FCS_ACTIVE
    Its data type is C (Character String) with field length 1
  • MSR_DELIVERY_BLK
    Its data type is C (Character String) with field length 2
  • UMFNG
    Its data type is C (Character String) with field length 20
  • MSR_SDF_AUART
    Its data type is C (Character String) with field length 4
  • RDP_PROFILE
    Its data type is C (Character String) with field length 8
  • FKART_MEV_POST
    Its data type is C (Character String) with field length 4
  • FKART_MEV_POST_IB
    Its data type is C (Character String) with field length 4
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is /SAPHT/SW_TVAK_SD
  • VCLASSIFIC
    Its data type is C (Character String) with field length 1
  • KALPG
    Its data type is C (Character String) with field length 6
  • KALVL
    Its data type is C (Character String) with field length 6
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is /SAPMP/INC_TVAK_CE
  • DABAR
    Its data type is C (Character String) with field length 1
  • /SAPMP/PDACT
    Its data type is C (Character String) with field length 1
  • /SAPMP/PPROT
    Its data type is C (Character String) with field length 1
  • /SAPMP/PUSER
    Its data type is C (Character String) with field length 1
  • /SAPMP/PAUSW
    Its data type is C (Character String) with field length 1
  • /SAPMP/GAUF
    Its data type is C (Character String) with field length 1
  • AD01AURET
    Its data type is C (Character String) with field length 4
  • AD04NUMFLG
    Its data type is C (Character String) with field length 1
  • PARGR
    Its data type is C (Character String) with field length 4
  • KALGT
    Its data type is C (Character String) with field length 6
  • UNITSALE
    Its data type is C (Character String) with field length 1
  • CPFREE
    Its data type is C (Character String) with field length 1
  • NO_BUTTON
    Its data type is N (Character String with Digits Only) with field length 1
  • XZEROORDER
    Its data type is C (Character String) with field length 1
  • XASSORTMENT
    Its data type is C (Character String) with field length 1
  • ISM_CONTRACT
    Its data type is C (Character String) with field length 2
  • ISM_WERKSDET
    Its data type is C (Character String) with field length 1
  • FAKSK
    Its data type is C (Character String) with field length 2
  • J_3GKBAUL
    Its data type is C (Character String) with field length 1
  • MILL_SE_ATNAM
    Its data type is C (Character String) with field length 30
  • OIPIPEVAL
    Its data type is C (Character String) with field length 1
  • OIISOILPD
    Its data type is C (Character String) with field length 1
  • OICSEGI
    Its data type is C (Character String) with field length 1
  • LIFSK
    Its data type is C (Character String) with field length 2
  • OIMSG_PRD
    Its data type is C (Character String) with field length 1
  • OIMSG_SHP
    Its data type is C (Character String) with field length 1
  • OIMSG_QTY
    Its data type is C (Character String) with field length 1
  • OIMSG_TRM
    Its data type is C (Character String) with field length 1
  • OIMSG_DAT
    Its data type is C (Character String) with field length 1
  • OIMSG_UOM
    Its data type is C (Character String) with field length 1
  • OIPRTFNC
    Its data type is C (Character String) with field length 2
  • OIFCONTI
    Its data type is C (Character String) with field length 1
  • OICFKARTDI
    Its data type is C (Character String) with field length 4
  • OIPARVW1
    Its data type is C (Character String) with field length 2
  • TRVOG
    Its data type is C (Character String) with field length 1
  • OIPARVW2
    Its data type is C (Character String) with field length 2
  • OIPARVW3
    Its data type is C (Character String) with field length 2
  • OIPARVW4
    Its data type is C (Character String) with field length 2
  • OIPARVW5
    Its data type is C (Character String) with field length 2
  • OIPARVW6
    Its data type is C (Character String) with field length 2
  • OIPARVW7
    Its data type is C (Character String) with field length 2
  • OIPARVW8
    Its data type is C (Character String) with field length 2
  • OIPARVW9
    Its data type is C (Character String) with field length 2
  • OISUBHEAD
    Its data type is C (Character String) with field length 4
  • OISUBITEM
    Its data type is C (Character String) with field length 4
  • SPAPO
    Its data type is C (Character String) with field length 1
  • OIUSEREXIT
    Its data type is N (Character String with Digits Only) with field length 3
  • OIU_FKARA
    Its data type is C (Character String) with field length 4
  • SPAPR
    Its data type is C (Character String) with field length 1
  • AUART : Order Type
    Its a key field. Its data type is C (Character String) with field length 4
  • VSTRM
    Its data type is C (Character String) with field length 1
  • TRTRM
    Its data type is C (Character String) with field length 1
  • TXN08
    Its data type is C (Character String) with field length 8
  • DIAFE
    Its data type is C (Character String) with field length 1
  • FELDK
    Its data type is C (Character String) with field length 4
  • DATVO
    Its data type is C (Character String) with field length 1
  • AWAHR
    Its data type is N (Character String with Digits Only) with field length 3
  • VBTYP
    Its data type is C (Character String) with field length 1
  • VSBED
    Its data type is C (Character String) with field length 2
  • BEZOB
    Its data type is C (Character String) with field length 1
  • KOPGR
    Its data type is C (Character String) with field length 4
  • TXTGR
    Its data type is C (Character String) with field length 2
  • KALVG
    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
  • FEHGR
    Its data type is C (Character String) with field length 2
  • INFLS
    Its data type is C (Character String) with field length 1
  • KUNN0
    Its data type is C (Character String) with field length 1
  • KLIMP
    Its data type is C (Character String) with field length 1
  • KALSM : Costing Sheet
    Its data type is C (Character String) with field length 6
  • KAPPL : Application
    Its data type is C (Character String) with field length 2
  • KSCHL : Condition Type
    Its data type is C (Character String) with field length 4
  • LFARV
    Its data type is C (Character String) with field length 4
  • SPERR : CHAR01 data element for SYST
    Its data type is C (Character String) with field length 1
  • STGAK
    Its data type is C (Character String) with field length 2
  • KALSU
    Its data type is C (Character String) with field length 6
  • KALLI
    Its data type is C (Character String) with field length 6
  • KALAU
    Its data type is C (Character String) with field length 6
  • FKAIV
    Its data type is C (Character String) with field length 4
  • CMGRA
    Its data type is C (Character String) with field length 2
  • OBJART_HIN
    Its data type is C (Character String) with field length 10
  • OBJART_VER
    Its data type is C (Character String) with field length 10
  • HITYP_PR
    Its data type is C (Character String) with field length 1
  • FKARV
    Its data type is C (Character String) with field length 4
  • ABRVW
    Its data type is C (Character String) with field length 3
  • ABDIS
    Its data type is C (Character String) with field length 1
  • KPRGBZ
    Its data type is C (Character String) with field length 1
  • PRDATV
    Its data type is C (Character String) with field length 1
  • VLAUF
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • GUEBGV
    Its data type is C (Character String) with field length 1
  • VTERL
    Its data type is C (Character String) with field length 1
  • HNWAG
    Its data type is C (Character String) with field length 1
  • HNWKM
    Its data type is C (Character String) with field length 1
  • STSMA : Status Profile
    Its data type is C (Character String) with field length 8
  • FKARA
    Its data type is C (Character String) with field length 4
  • LISOF
    Its data type is C (Character String) with field length 1
  • AUARA
    Its data type is C (Character String) with field length 4
  • KORLI
    Its data type is C (Character String) with field length 4
  • VPROF
    Its data type is C (Character String) with field length 4
  • AUFAK : Scrap factor
    Its data type is C (Character String) with field length 4
  • DIAPA
    Its data type is C (Character String) with field length 1
  • FPART
    Its data type is C (Character String) with field length 2
  • KSCHL_KO
    Its data type is C (Character String) with field length 4
  • EXCOK
    Its data type is C (Character String) with field length 1
  • EXMOD
    Its data type is C (Character String) with field length 1
  • NUMKI
    Its data type is C (Character String) with field length 2
  • KSKPF
    Its data type is C (Character String) with field length 6
  • KSPOS
    Its data type is C (Character String) with field length 6
  • LIFSM
    Its data type is C (Character String) with field length 2
  • FKTKT
    Its data type is C (Character String) with field length 4
  • EXDIA
    Its data type is C (Character String) with field length 1
  • ABGRU_IN
    Its data type is C (Character String) with field length 2
  • PRBST
    Its data type is C (Character String) with field length 1
  • SCHEME_GRP
    Its data type is C (Character String) with field length 4
  • HNWGK
    Its data type is C (Character String) with field length 1
  • PUSH_GRP
    Its data type is C (Character String) with field length 1
  • NUMKE
    Its data type is C (Character String) with field length 2
  • ABRUF_PART
    Its data type is C (Character String) with field length 1
  • RPART
    Its data type is C (Character String) with field length 2
  • AKTFI
    Its data type is C (Character String) with field length 1
  • VBKLT
    Its data type is C (Character String) with field length 1
  • J_1BNFTYPE
    Its data type is C (Character String) with field length 2
  • INCUP
    Its data type is N (Character String with Digits Only) with field length 6
  • BABSS
    Its data type is C (Character String) with field length 2
  • EMPFI
    Its data type is C (Character String) with field length 1
  • DELCF
    Its data type is C (Character String) with field length 1
  • CCPGR
    Its data type is C (Character String) with field length 2
  • INCPO : Include Purchase Order in ROC / Prio Calculation
    Its data type is N (Character String with Digits Only) with field length 6
  • EXCBC
    Its data type is C (Character String) with field length 1
  • EXCEM
    Its data type is C (Character String) with field length 1
  • EXCLG
    Its data type is C (Character String) with field length 1
  • HNWK2
    Its data type is C (Character String) with field length 1
  • EXTNR_RMA
    Its data type is C (Character String) with field length 1
  • TDID
    Its data type is C (Character String) with field length 4
  • AAUART1
    Its data type is C (Character String) with field length 4
  • AAUART2
    Its data type is C (Character String) with field length 4
  • RFPA_SW
    Its data type is C (Character String) with field length 1
  • VARIANT : Variant with which the archiving program was executed
    Its data type is C (Character String) with field length 30