1. Home
  2. Resources
  3. SAP Tables
  4. VPKDLI - Sales Pricing Dynamic Items

SAP Table VPKDLI

Sales Pricing Dynamic Items

VPKDLI (Sales Pricing Dynamic Items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VPKDLI to other SAP tables.

VPKDLI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VPKID Sales pricing document number VPKID VPKHEAD NUMC 10 0
DLINR Number of the Dynamic Item AD01DLINR AD01DLI NUMC 20 0
LOCKED Element locked or not VPKITEMLOCK CHAR 1 0
X Yes
NULL No
BEMOT Accounting Indicator BEMOT TBMOT CHAR 2 0
AUMOT Apportionment reason AUMOT AD01C_CT CHAR 2 0
VWAER SD Document Currency WAERK CUKY 5 0
POSNR Sales Document Item POSNR_VA NUMC 6 0
POSNRVPK Item number of sales document (internal for SPc) VPKPOSNR NUMC 6 0
UEPOSVPK Main internal item number VPKUEPOSNR VBUP NUMC 6 0
MATNR_SD Material number for determining the sales price VPK_MATNR_SD CHAR 18 0
SO_WTGBTR Total Value in Transaction Currency WTGXXX CURR 15 2
SO_WOGBTR Total Value in Object Currency WOGXXX CURR 15 2
SO_WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15 2
SO_MEGBTR Total Quantity MEGXXX QUAN 15 3
BI_WTGBTR Total Value in Transaction Currency WTGXXX CURR 15 2
BI_WOGBTR Total Value in Object Currency WOGXXX CURR 15 2
BI_WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15 2
BI_MEGBTR Total Quantity MEGXXX QUAN 15 3
OP_WTGBTR Total Value in Transaction Currency WTGXXX CURR 15 2
OP_WOGBTR Total Value in Object Currency WOGXXX CURR 15 2
OP_WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15 2
OP_MEGBTR Total Quantity MEGXXX QUAN 15 3
CA_WTGBTR Total Value in Transaction Currency WTGXXX CURR 15 2
CA_WOGBTR Total Value in Object Currency WOGXXX CURR 15 2
CA_WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15 2
CA_MEGBTR Total Quantity MEGXXX QUAN 15 3
IN_WTGBTR Total Value in Transaction Currency WTGXXX CURR 15 2
IN_WOGBTR Total Value in Object Currency WOGXXX CURR 15 2
IN_WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15 2
IN_MEGBTR Total Quantity MEGXXX QUAN 15 3
LA_WTGBTR Total Value in Transaction Currency WTGXXX CURR 15 2
LA_WOGBTR Total Value in Object Currency WOGXXX CURR 15 2
LA_WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15 2
LA_MEGBTR Total Quantity MEGXXX QUAN 15 3
NO_WTGBTR Total Value in Transaction Currency WTGXXX CURR 15 2
NO_WOGBTR Total Value in Object Currency WOGXXX CURR 15 2
NO_WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15 2
NO_MEGBTR Total Quantity MEGXXX QUAN 15 3
BA_WTGBTR Total Value in Transaction Currency WTGXXX CURR 15 2
BA_WOGBTR Total Value in Object Currency WOGXXX CURR 15 2
BA_WKGBTR Total Value in Controlling Area Currency WKGXXX CURR 15 2
BA_MEGBTR Total Quantity MEGXXX QUAN 15 3
NETVALUE Net value (price) VPKNETVALUE CURR 15 2

VPKDLI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VPKDLI AUMOT VPKDLI MANDT AD01C_CT Apportionment reason .INCLUDE
VPKDLI AUMOT VPKDLI AUMOT AD01C_CT Apportionment reason MANDT
VPKDLI BEMOT VPKDLI BEMOT TBMOT Accounting indicators BEMOT
VPKDLI BEMOT VPKDLI MANDT TBMOT Accounting indicators MANDT
VPKDLI DLINR VPKDLI MANDT AD01DLI Dynamic items (DI) MANDT
VPKDLI DLINR VPKDLI DLINR AD01DLI Dynamic items (DI) DLINR
VPKDLI MANDT VPKDLI MANDT T000 Clients MANDT
VPKDLI UEPOSVPK VPKDLI MANDT VBUP Sales Document: Item Status MANDT
VPKDLI UEPOSVPK VPKHEAD VBELN VBUP Sales Document: Item Status VBELN
VPKDLI UEPOSVPK VPKDLI UEPOSVPK VBUP Sales Document: Item Status POSNR
VPKDLI VPKID VPKDLI VPKID VPKHEAD Sales Pricing Header Data VPKID
VPKDLI VPKID VPKDLI MANDT VPKHEAD Sales Pricing Header Data MANDT