PPS_PC_ITMCVAL_D

Transparent Table Application Table
15 Fields 1 CDS Views

Draft table for entity R_PPS_PURCONTRITEMCNDNVALDTYTP

PPS_PC_ITMCVAL_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCONTRITEMCNDNVALDTYTP. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurContrItmCndnValDrft view_entity from BASIC Item Condition draft

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchasecontract ebeln Purchasing Doc.
KEY purchasecontractitem ebelp Item
KEY conditionrecord knumh Cond.Record No.
KEY conditionvalidityenddate kodatbi Valid To
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
conditionapplication kappl Application
conditiontype kscha Condition Type
conditionvaliditystartdate kodatab Valid From
conditionisdeleted loevm_ko Deletion Indic.
plant werks_d Plant
plantname werks_name Plant Name
lastchangedatetime changedatetime Last Changed
purchasecontractdraftuuid sdraft_uuid Draft Document ID

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_PURCONTRITEMCNDNVALDTYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PC_ITMCVAL_D (
    MANDT,                       -- Client [mandt]
    PURCHASECONTRACT,            -- Purchasing Doc. [ebeln]
    PURCHASECONTRACTITEM,        -- Item [ebelp]
    CONDITIONRECORD,             -- Cond.Record No. [knumh]
    CONDITIONVALIDITYENDDATE,    -- Valid To [kodatbi]
    DRAFTUUID,                   -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,             -- Draft Document ID [sdraft_uuid]
    CONDITIONAPPLICATION,        -- Application [kappl]
    CONDITIONTYPE,               -- Condition Type [kscha]
    CONDITIONVALIDITYSTARTDATE,  -- Valid From [kodatab]
    CONDITIONISDELETED,          -- Deletion Indic. [loevm_ko]
    PLANT,                       -- Plant [werks_d]
    PLANTNAME,                   -- Plant Name [werks_name]
    LASTCHANGEDATETIME,          -- Last Changed [changedatetime]
    PURCHASECONTRACTDRAFTUUID,   -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, PURCHASECONTRACT, PURCHASECONTRACTITEM, CONDITIONRECORD, CONDITIONVALIDITYENDDATE, DRAFTUUID)
);

Learn More