TVAP SAP table for – Sales Document: Item Categories

Here we would like to draw your attention to TVAP 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). TVAP is a SAP standard transparent table used for storing Sales Document: Item Categories related data in SAP. It comes under the package VA0C.

SAP TVAP table

Table TVAP technical data

TableTVAP
Data storingSales Document: Item Categories
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 TVAP 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 TVAP table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • STRUM
    Its data type is C (Character String) with field length 1
  • EVRWR
    Its data type is C (Character String) with field length 1
  • KOWRR
    Its data type is C (Character String) with field length 1
  • FELDP
    Its data type is C (Character String) with field length 4
  • FAKSP
    Its data type is C (Character String) with field length 2
  • SHELL
    Its data type is C (Character String) with field length 1
  • ERLRE
    Its data type is C (Character String) with field length 1
  • TXN08
    Its data type is C (Character String) with field length 8
  • DIAFM
    Its data type is C (Character String) with field length 1
  • KDERL
    Its data type is C (Character String) with field length 1
  • PSTYV
    Its a key field. Its data type is C (Character String) with field length 4
  • TXTGR
    Its data type is C (Character String) with field length 2
  • POSAR
    Its data type is C (Character String) with field length 1
  • LFREL
    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
  • ETERL
    Its data type is C (Character String) with field length 1
  • GWREL
    Its data type is C (Character String) with field length 1
  • KOMPP
    Its data type is C (Character String) with field length 1
  • FEHGR
    Its data type is C (Character String) with field length 2
  • SHKZG : Debit/Credit Indicator
    Its data type is C (Character String) with field length 1
  • EQMAT
    Its data type is C (Character String) with field length 1
  • FKREL
    Its data type is C (Character String) with field length 1
  • STGAP
    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
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • CMPNT
    Its data type is C (Character String) with field length 1
  • STRAT
    Its data type is C (Character String) with field length 2
  • STSMA : Status Profile
    Its data type is C (Character String) with field length 8
  • MENG1
    Its data type is C (Character String) with field length 1
  • ALEKZ
    Its data type is C (Character String) with field length 1
  • FPART
    Its data type is C (Character String) with field length 2
  • CHAUT
    Its data type is C (Character String) with field length 1
  • PRSFD
    Its data type is C (Character String) with field length 1
  • EXCOP
    Its data type is C (Character String) with field length 1
  • SVGNG
    Its data type is C (Character String) with field length 4
  • TYPFD
    Its data type is C (Character String) with field length 1
  • LTYPA
    Its data type is C (Character String) with field length 1
  • LTYPV
    Its data type is C (Character String) with field length 1
  • WKMAT
    Its data type is C (Character String) with field length 18
  • RKTIO
    Its data type is C (Character String) with field length 1
  • SEGAL
    Its data type is C (Character String) with field length 2
  • STDTE
    Its data type is C (Character String) with field length 1
  • RDERL
    Its data type is C (Character String) with field length 1
  • POSGR
    Its data type is C (Character String) with field length 4
  • EFFEC
    Its data type is C (Character String) with field length 1
  • FFPRF
    Its data type is C (Character String) with field length 8
  • SCHEME_RMA
    Its data type is C (Character String) with field length 4
  • SCHEME_VF
    Its data type is C (Character String) with field length 4
  • FAKTF : Billing Form
    Its data type is C (Character String) with field length 2
  • RRREL
    Its data type is C (Character String) with field length 1
  • ACDATV
    Its data type is C (Character String) with field length 1
  • UVEIB
    Its data type is C (Character String) with field length 3
  • OIBOM
    Its data type is C (Character String) with field length 1
  • OIBCST
    Its data type is C (Character String) with field length 1
  • PARGR
    Its data type is C (Character String) with field length 4
  • OIUSEREXIT
    Its data type is N (Character String with Digits Only) with field length 3
  • REVSP
    Its data type is C (Character String) with field length 1
  • REVEVTYP
    Its data type is C (Character String) with field length 1
  • MILL_BATCH_REF
    Its data type is C (Character String) with field length 1
  • MILL_BATCH_SEL_D
    Its data type is C (Character String) with field length 1
  • RBACONTROL
    Its data type is C (Character String) with field length 1
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is BOS_APP_TVAP
  • LVART
    Its data type is C (Character String) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is MILL_INC_TVAP
  • PSGRP
    Its data type is C (Character String) with field length 4
  • MILL_SE_KKNMT
    Its data type is C (Character String) with field length 1
  • STULI
    Its data type is C (Character String) with field length 1
  • ASWPA
    Its data type is C (Character String) with field length 1