VLPKM

Transparent Table Application Table
15 Fields 3 CDS Views

Scheduling agreements by customer material

VLPKM is an SAP database table in S/4HANA. Scheduling agreements by customer material. It contains 15 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_JITSlsSchedgAgrmtBasic view_entity inner BASIC JIT Sales Scheduling Agreement
P_SlsSchedgAgrmtPartDesc view from BASIC Partner Description in Sales Scheduling Agreements
SHSM_VLPMA view from CDS view replacing M_VLPMA in search help VLPMA

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kdmat kdmat Customer Mat.
KEY kunnr kunag Sold-to Party
KEY knref knref Partner desc.
KEY ablad ablad Unloading Point
KEY abrvw abrvw Usage
KEY vkorg vkorg Sales Org.
KEY vtweg vtweg Distr. Channel
KEY spart spart Division
KEY auart auart Sales Doc. Type
KEY vbeln vbeln SD Document
KEY posnr posnr Item
abgru abgru RejectionReason
ktext ktext_v Description
_dataaging data_temperature Data Aging

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.

-- Scheduling agreements by customer material
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VLPKM (
    MANDT,       -- Client [mandt]
    KDMAT,       -- Customer Mat. [kdmat]
    KUNNR,       -- Sold-to Party [kunag]
    KNREF,       -- Partner desc. [knref]
    ABLAD,       -- Unloading Point [ablad]
    ABRVW,       -- Usage [abrvw]
    VKORG,       -- Sales Org. [vkorg]
    VTWEG,       -- Distr. Channel [vtweg]
    SPART,       -- Division [spart]
    AUART,       -- Sales Doc. Type [auart]
    VBELN,       -- SD Document [vbeln]
    POSNR,       -- Item [posnr]
    ABGRU,       -- RejectionReason [abgru]
    KTEXT,       -- Description [ktext_v]
    _DATAAGING,  -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, KDMAT, KUNNR, KNREF, ABLAD, ABRVW, VKORG, VTWEG, SPART, AUART, VBELN, POSNR)
);

Learn More