TVMS SAP table for – Materials: Status in Sales and Distribution

Here we would like to draw your attention to TVMS table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). TVMS is a SAP standard transparent table used for storing Materials: Status in Sales and Distribution related data in SAP. It comes under the package VS.

SAP TVMS table

Table TVMS technical data

TableTVMS
Data storingMaterials: Status in Sales and Distribution
ModuleLO
ComponentLO-MD
SAP PackageVS
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SPVBH
    Its data type is C (Character String) with field length 1
  • SPVBI
    Its data type is C (Character String) with field length 1
  • SPVBJ
    Its data type is C (Character String) with field length 1
  • SPVBK
    Its data type is C (Character String) with field length 1
  • SPVBL
    Its data type is C (Character String) with field length 1
  • LIFSP
    Its data type is C (Character String) with field length 2
  • WAUFT
    Its data type is C (Character String) with field length 1
  • WREPL
    Its data type is C (Character String) with field length 1
  • WSTOR
    Its data type is C (Character String) with field length 1
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is JSPVMS
  • VMSTA
    Its a key field. Its data type is C (Character String) with field length 2
  • JSPQP
    Its data type is C (Character String) with field length 1
  • JSPOG
    Its data type is C (Character String) with field length 1
  • JSPRP
    Its data type is C (Character String) with field length 1
  • JSPIP
    Its data type is C (Character String) with field length 1
  • SPVBA
    Its data type is C (Character String) with field length 1
  • SPVBB
    Its data type is C (Character String) with field length 1
  • SPVBC
    Its data type is C (Character String) with field length 1
  • SPVBD
    Its data type is C (Character String) with field length 1
  • SPVBE
    Its data type is C (Character String) with field length 1
  • SPVBF
    Its data type is C (Character String) with field length 1
  • SPVBG
    Its data type is C (Character String) with field length 1