VPKDLI

Transparent Table Application Table
45 Fields 1 CDS Views

Sales Pricing Dynamic Items

VPKDLI is an SAP database table in S/4HANA. Sales Pricing Dynamic Items. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RRBSalesPricingDynamicItem view from BASIC RRB Sales Pricing Dynamic Items

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vpkid VPKID SPc.doc.no.
KEY dlinr AD01DLINR DI No.
locked VPKITEMLOCK Locked
bemot BEMOT AcctIndicator
aumot AUMOT AppReason
vwaer WAERK Doc. Currency
posnr POSNR_VA Item
posnrvpk VPKPOSNR Item number
ueposvpk VPKUEPOSNR Main item
matnr_sd VPK_MATNR_SD Material
so_wtgbtr WTGXXX_CS Value TranCurr
so_wogbtr WOGXXX_CS Value/Obj. Crcy
so_wkgbtr WKGXXX_CS Val/COArea Crcy
so_megbtr MEGXXX Total Quantity
bi_wtgbtr WTGXXX_CS Value TranCurr
bi_wogbtr WOGXXX_CS Value/Obj. Crcy
bi_wkgbtr WKGXXX_CS Val/COArea Crcy
bi_megbtr MEGXXX Total Quantity
op_wtgbtr WTGXXX_CS Value TranCurr
op_wogbtr WOGXXX_CS Value/Obj. Crcy
op_wkgbtr WKGXXX_CS Val/COArea Crcy
op_megbtr MEGXXX Total Quantity
ca_wtgbtr WTGXXX_CS Value TranCurr
ca_wogbtr WOGXXX_CS Value/Obj. Crcy
ca_wkgbtr WKGXXX_CS Val/COArea Crcy
ca_megbtr MEGXXX Total Quantity
in_wtgbtr WTGXXX_CS Value TranCurr
in_wogbtr WOGXXX_CS Value/Obj. Crcy
in_wkgbtr WKGXXX_CS Val/COArea Crcy
in_megbtr MEGXXX Total Quantity
la_wtgbtr WTGXXX_CS Value TranCurr
la_wogbtr WOGXXX_CS Value/Obj. Crcy
la_wkgbtr WKGXXX_CS Val/COArea Crcy
la_megbtr MEGXXX Total Quantity
no_wtgbtr WTGXXX_CS Value TranCurr
no_wogbtr WOGXXX_CS Value/Obj. Crcy
no_wkgbtr WKGXXX_CS Val/COArea Crcy
no_megbtr MEGXXX Total Quantity
ba_wtgbtr WTGXXX_CS Value TranCurr
ba_wogbtr WOGXXX_CS Value/Obj. Crcy
ba_wkgbtr WKGXXX_CS Val/COArea Crcy
ba_megbtr MEGXXX Total Quantity
netvalue VPKNETVALUE Net value
netpr NETPR Net Price

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sales Pricing Dynamic Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VPKDLI (
    MANDT,      -- Client [MANDT]
    VPKID,      -- SPc.doc.no. [VPKID]
    DLINR,      -- DI No. [AD01DLINR]
    LOCKED,     -- Locked [VPKITEMLOCK]
    BEMOT,      -- AcctIndicator [BEMOT]
    AUMOT,      -- AppReason [AUMOT]
    VWAER,      -- Doc. Currency [WAERK]
    POSNR,      -- Item [POSNR_VA]
    POSNRVPK,   -- Item number [VPKPOSNR]
    UEPOSVPK,   -- Main item [VPKUEPOSNR]
    MATNR_SD,   -- Material [VPK_MATNR_SD]
    SO_WTGBTR,  -- Value TranCurr [WTGXXX_CS]
    SO_WOGBTR,  -- Value/Obj. Crcy [WOGXXX_CS]
    SO_WKGBTR,  -- Val/COArea Crcy [WKGXXX_CS]
    SO_MEGBTR,  -- Total Quantity [MEGXXX]
    BI_WTGBTR,  -- Value TranCurr [WTGXXX_CS]
    BI_WOGBTR,  -- Value/Obj. Crcy [WOGXXX_CS]
    BI_WKGBTR,  -- Val/COArea Crcy [WKGXXX_CS]
    BI_MEGBTR,  -- Total Quantity [MEGXXX]
    OP_WTGBTR,  -- Value TranCurr [WTGXXX_CS]
    OP_WOGBTR,  -- Value/Obj. Crcy [WOGXXX_CS]
    OP_WKGBTR,  -- Val/COArea Crcy [WKGXXX_CS]
    OP_MEGBTR,  -- Total Quantity [MEGXXX]
    CA_WTGBTR,  -- Value TranCurr [WTGXXX_CS]
    CA_WOGBTR,  -- Value/Obj. Crcy [WOGXXX_CS]
    CA_WKGBTR,  -- Val/COArea Crcy [WKGXXX_CS]
    CA_MEGBTR,  -- Total Quantity [MEGXXX]
    IN_WTGBTR,  -- Value TranCurr [WTGXXX_CS]
    IN_WOGBTR,  -- Value/Obj. Crcy [WOGXXX_CS]
    IN_WKGBTR,  -- Val/COArea Crcy [WKGXXX_CS]
    IN_MEGBTR,  -- Total Quantity [MEGXXX]
    LA_WTGBTR,  -- Value TranCurr [WTGXXX_CS]
    LA_WOGBTR,  -- Value/Obj. Crcy [WOGXXX_CS]
    LA_WKGBTR,  -- Val/COArea Crcy [WKGXXX_CS]
    LA_MEGBTR,  -- Total Quantity [MEGXXX]
    NO_WTGBTR,  -- Value TranCurr [WTGXXX_CS]
    NO_WOGBTR,  -- Value/Obj. Crcy [WOGXXX_CS]
    NO_WKGBTR,  -- Val/COArea Crcy [WKGXXX_CS]
    NO_MEGBTR,  -- Total Quantity [MEGXXX]
    BA_WTGBTR,  -- Value TranCurr [WTGXXX_CS]
    BA_WOGBTR,  -- Value/Obj. Crcy [WOGXXX_CS]
    BA_WKGBTR,  -- Val/COArea Crcy [WKGXXX_CS]
    BA_MEGBTR,  -- Total Quantity [MEGXXX]
    NETVALUE,   -- Net value [VPKNETVALUE]
    NETPR,      -- Net Price [NETPR]
    PRIMARY KEY (MANDT, VPKID, DLINR)
);

Learn More