EKCPI

Transparent Table Application Table
10 Fields 1 CDS Views

Purchasing Contract Commitment Plan Item Information

EKCPI is an SAP database table in S/4HANA. Purchasing Contract Commitment Plan Item Information. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PurContrCommitmentPlanItem view_entity from BASIC

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY cpitem CPITEM Comm. Plan Item
cpdate CPDATE Valid
cpvalue_item CPVALUE Comm. Amount
generate CPGENERATE Generate
closed CPCLOSED Closed
kblnr KBLNR Earmarked Funds
loekz ELOEK Del. Indicator

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.

-- Purchasing Contract Commitment Plan Item Information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKCPI (
    MANDT,         -- Client [MANDT]
    EBELN,         -- Purchasing Doc. [EBELN]
    EBELP,         -- Item [EBELP]
    CPITEM,        -- Comm. Plan Item [CPITEM]
    CPDATE,        -- Valid [CPDATE]
    CPVALUE_ITEM,  -- Comm. Amount [CPVALUE]
    GENERATE,      -- Generate [CPGENERATE]
    CLOSED,        -- Closed [CPCLOSED]
    KBLNR,         -- Earmarked Funds [KBLNR]
    LOEKZ,         -- Del. Indicator [ELOEK]
    PRIMARY KEY (MANDT, EBELN, EBELP, CPITEM)
);

Learn More