PPS_PC_CPITM_D

Transparent Table Application Table
23 Fields 1 CDS Views

Draft table for entity R_PPS_PURCONTRCMTMTPLANITEMTP

PPS_PC_CPITM_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCONTRCMTMTPLANITEMTP. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurContrCmtmtPlnItmDrft view_entity from BASIC PPS Pur Contr Commtmt Pln Item - Draft

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchasecontract EBELN Purchasing Doc.
KEY purchasecontractitem EBELP Item
KEY commitmentplanitemnumber CPITEM Comm. Plan Item
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
commitmentplanitemvaliditydate CPDATE Valid
documentcurrency WAERS Currency
commitmentplanitemamount CPVALUE Comm. Amount
generateearmarkedfundisset CPGENERATE Generate
commitmentplanitemisclosed CPCLOSED Closed
earmarkedfundsdocument KBLNR Earmarked Funds
ismarkedfordeletion ELOEK Del. Indicator
purchasecontractdraftuuid SDRAFT_UUID Draft Document ID
purcontritemdraftuuid SDRAFT_UUID Draft Document ID
companycode BUKRS Company Code
lastchangedatetime CHANGEDATETIME Last Changed
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

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.

-- Draft table for entity R_PPS_PURCONTRCMTMTPLANITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PC_CPITM_D (
    MANDT,                           -- Client [MANDT]
    PURCHASECONTRACT,                -- Purchasing Doc. [EBELN]
    PURCHASECONTRACTITEM,            -- Item [EBELP]
    COMMITMENTPLANITEMNUMBER,        -- Comm. Plan Item [CPITEM]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    COMMITMENTPLANITEMVALIDITYDATE,  -- Valid [CPDATE]
    DOCUMENTCURRENCY,                -- Currency [WAERS]
    COMMITMENTPLANITEMAMOUNT,        -- Comm. Amount [CPVALUE]
    GENERATEEARMARKEDFUNDISSET,      -- Generate [CPGENERATE]
    COMMITMENTPLANITEMISCLOSED,      -- Closed [CPCLOSED]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked Funds [KBLNR]
    ISMARKEDFORDELETION,             -- Del. Indicator [ELOEK]
    PURCHASECONTRACTDRAFTUUID,       -- Draft Document ID [SDRAFT_UUID]
    PURCONTRITEMDRAFTUUID,           -- Draft Document ID [SDRAFT_UUID]
    COMPANYCODE,                     -- Company Code [BUKRS]
    LASTCHANGEDATETIME,              -- Last Changed [CHANGEDATETIME]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PURCHASECONTRACT, PURCHASECONTRACTITEM, COMMITMENTPLANITEMNUMBER, DRAFTUUID)
);

Learn More