PPS_PC_HDRSCL_D

Transparent Table Application Table
32 Fields 1 CDS Views

Draft table for entity R_PPS_CONTRHDRCNDNSCALETP

PPS_PC_HDRSCL_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_CONTRHDRCNDNSCALETP. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurContrHdrCndnScDrft view_entity from BASIC Purch Contr Hdr Pricing Condition Scales

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchasecontract EBELN Purchasing Doc.
KEY conditionrecord KNUMH Cond.Record No.
KEY conditionsequentialnumber KOPOS Sequent. No. of Cond
KEY conditionvalidityenddate KODATBI Valid To
KEY conditionscaleline KLFN1 Line number
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
conditionscalequantity KSTBM Scale Quantity
conditionscalequantityunit KONMS Scale UoM
conditionscaleamount KSTBW Scale Value
conditionscaleamountcurrency KONWS Scale Currency
conditionratevalue KBETR Amount
conditionratevalueunit KONWA Cond. Currency
conditionrateratio VFPRC_ELEMENT_RATIO Ratio
conditionrateratiounit MSEHIUNIT Unit of Measure
conditionrateamount VFPRC_ELEMENT_AMOUNT Amount
conditioncurrency KONWA Cond. Currency
conditionscaleisdeleted LOEVM_KO Deletion Indic.
pricingscaletype STFKZ Scale Type
conditionquantity KPEIN Pricing Unit
conditionquantityunit KMEIN Unit of Measure
lastchangedatetime CHANGEDATETIME Last Changed
conditionratevalueisamount BOOLE_D TRUE
conditionratevalueisratio BOOLE_D TRUE
purchasecontractdraftuuid SDRAFT_UUID Draft Document ID
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field 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_CONTRHDRCNDNSCALETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PC_HDRSCL_D (
    MANDT,                          -- Client [MANDT]
    PURCHASECONTRACT,               -- Purchasing Doc. [EBELN]
    CONDITIONRECORD,                -- Cond.Record No. [KNUMH]
    CONDITIONSEQUENTIALNUMBER,      -- Sequent. No. of Cond [KOPOS]
    CONDITIONVALIDITYENDDATE,       -- Valid To [KODATBI]
    CONDITIONSCALELINE,             -- Line number [KLFN1]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    CONDITIONSCALEQUANTITY,         -- Scale Quantity [KSTBM]
    CONDITIONSCALEQUANTITYUNIT,     -- Scale UoM [KONMS]
    CONDITIONSCALEAMOUNT,           -- Scale Value [KSTBW]
    CONDITIONSCALEAMOUNTCURRENCY,   -- Scale Currency [KONWS]
    CONDITIONRATEVALUE,             -- Amount [KBETR]
    CONDITIONRATEVALUEUNIT,         -- Cond. Currency [KONWA]
    CONDITIONRATERATIO,             -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONRATERATIOUNIT,         -- Unit of Measure [MSEHIUNIT]
    CONDITIONRATEAMOUNT,            -- Amount [VFPRC_ELEMENT_AMOUNT]
    CONDITIONCURRENCY,              -- Cond. Currency [KONWA]
    CONDITIONSCALEISDELETED,        -- Deletion Indic. [LOEVM_KO]
    PRICINGSCALETYPE,               -- Scale Type [STFKZ]
    CONDITIONQUANTITY,              -- Pricing Unit [KPEIN]
    CONDITIONQUANTITYUNIT,          -- Unit of Measure [KMEIN]
    LASTCHANGEDATETIME,             -- Last Changed [CHANGEDATETIME]
    CONDITIONRATEVALUEISAMOUNT,     -- TRUE [BOOLE_D]
    CONDITIONRATEVALUEISRATIO,      -- TRUE [BOOLE_D]
    PURCHASECONTRACTDRAFTUUID,      -- Draft Document ID [SDRAFT_UUID]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PURCHASECONTRACT, CONDITIONRECORD, CONDITIONSEQUENTIALNUMBER, CONDITIONVALIDITYENDDATE, CONDITIONSCALELINE, DRAFTUUID)
);

Learn More