VPKDLI SAP table for – Sales Pricing Dynamic Items

Here we would like to draw your attention to VPKDLI table in SAP. As we know it is being mainly used with the SAP PS-REV (Revenues and Earnings in PS) component which is coming under PS module (Project Systems). VPKDLI is a SAP standard transparent table used for storing Sales Pricing Dynamic Items related data in SAP. It comes under the package VPK.

SAP VPKDLI table

Table VPKDLI technical data

TableVPKDLI
Data storingSales Pricing Dynamic Items
ModulePS
ComponentPS-REV
SAP PackageVPK
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • POSNRVPK
    Its data type is N (Character String with Digits Only) with field length 6
  • UEPOSVPK
    Its data type is N (Character String with Digits Only) with field length 6
  • MATNR_SD
    Its data type is C (Character String) with field length 18
  • SO_WTGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SO_WOGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SO_WKGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SO_MEGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BI_WTGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • VPKID
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • BI_WOGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BI_WKGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BI_MEGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • OP_WTGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • OP_WOGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • OP_WKGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • OP_MEGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CA_WTGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • DLINR : Number of the Dynamic Item
    Its a key field. Its data type is N (Character String with Digits Only) with field length 20
  • CA_WOGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CA_WKGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CA_MEGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • IN_WTGBTR : Amount referenced for invoicing
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • IN_WOGBTR : Amount referenced for invoicing
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • IN_WKGBTR : Amount referenced for invoicing
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • IN_MEGBTR : Quantity billed
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LA_WTGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LOCKED
    Its data type is C (Character String) with field length 1
  • LA_WOGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LA_WKGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LA_MEGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • NO_WTGBTR : Sum never
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • NO_WOGBTR : Sum never
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • NO_WKGBTR : Sum never
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • NO_MEGBTR : Quantity never
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BA_WTGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BEMOT : Accounting Indicator
    Its data type is C (Character String) with field length 2
  • BA_WOGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BA_WKGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BA_MEGBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • NETVALUE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • AUMOT : Apportionment reason
    Its data type is C (Character String) with field length 2
  • VWAER
    Its data type is C (Character String) with field length 5
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is VPK_SDINFO
  • POSNR : Item number of the SD document
    Its data type is N (Character String with Digits Only) with field length 6