EKCPA

Transparent Table Application Table
30 Fields 1 CDS Views

Purchasing Contract Commitment Plan Account Assignment Data

EKCPA is an SAP database table in S/4HANA. Purchasing Contract Commitment Plan Account Assignment Data. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PurConCmtmtPlnAcctAssignment view_entity from BASIC

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY cpitem CPITEM Comm. Plan Item
KEY zekkn DZEKKN Account Assgmt No.
kblnr KBLNR Earmarked Funds
kblpos KBLPOS Document Item
cp_value CP_ACCOUNT_VALUE Net Value
fipos FIPOS Commitment item
fistl FISTL Funds Center
fkber FKBER Functional Area
grant_nbr GM_GRANT_NBR Grant
geber BP_GEBER Fund
sakto SAKNR G/L Account
nplnr NPLNR Network
vornr VORNR Activity
aufnr AUFNR Order
kostl KOSTL Cost Center
kokrs KOKRS CO Area
gsber GSBER Business Area
ps_psp_pnr PS_PSP_PNR WBS Element
loekz KLOEK Deletion Ind.
measure FM_MEASURE Funded Program
vproz VPROZ Distribution
check_deactive CP_CHECK_DEACTIVE AA Check Off
perop_beg FM_PEROP_LOW Per. of Perf. Start
perop_end FM_PEROP_HIGH Per. of Perf. End
budget_pd FM_BUDGET_PERIOD Budget Period
fdatk KBLFDATK Due On
acchang FM_ACCHANG AcctAss.Change.

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 Account Assignment Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKCPA (
    MANDT,           -- Client [MANDT]
    EBELN,           -- Purchasing Doc. [EBELN]
    EBELP,           -- Item [EBELP]
    CPITEM,          -- Comm. Plan Item [CPITEM]
    ZEKKN,           -- Account Assgmt No. [DZEKKN]
    KBLNR,           -- Earmarked Funds [KBLNR]
    KBLPOS,          -- Document Item [KBLPOS]
    CP_VALUE,        -- Net Value [CP_ACCOUNT_VALUE]
    FIPOS,           -- Commitment item [FIPOS]
    FISTL,           -- Funds Center [FISTL]
    FKBER,           -- Functional Area [FKBER]
    GRANT_NBR,       -- Grant [GM_GRANT_NBR]
    GEBER,           -- Fund [BP_GEBER]
    SAKTO,           -- G/L Account [SAKNR]
    NPLNR,           -- Network [NPLNR]
    VORNR,           -- Activity [VORNR]
    AUFNR,           -- Order [AUFNR]
    KOSTL,           -- Cost Center [KOSTL]
    KOKRS,           -- CO Area [KOKRS]
    GSBER,           -- Business Area [GSBER]
    PS_PSP_PNR,      -- WBS Element [PS_PSP_PNR]
    LOEKZ,           -- Deletion Ind. [KLOEK]
    MEASURE,         -- Funded Program [FM_MEASURE]
    VPROZ,           -- Distribution [VPROZ]
    CHECK_DEACTIVE,  -- AA Check Off [CP_CHECK_DEACTIVE]
    PEROP_BEG,       -- Per. of Perf. Start [FM_PEROP_LOW]
    PEROP_END,       -- Per. of Perf. End [FM_PEROP_HIGH]
    BUDGET_PD,       -- Budget Period [FM_BUDGET_PERIOD]
    FDATK,           -- Due On [KBLFDATK]
    ACCHANG,         -- AcctAss.Change. [FM_ACCHANG]
    PRIMARY KEY (MANDT, EBELN, EBELP, CPITEM, ZEKKN)
);

Learn More