PPS_PC_HDRPRC_D

Transparent Table Application Table
61 Fields 1 CDS Views

Draft table for entity R_PPS_PURCONTRHDRCNDNAMOUNTTP

PPS_PC_HDRPRC_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCONTRHDRCNDNAMOUNTTP. It contains 61 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurContrHdrCndnAmtDrft view_entity from BASIC Purchase contract header Cndn

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchasecontract EBELN Purchasing Doc.
KEY conditionrecord KNUMH Cond.Record No.
KEY conditionvalidityenddate KODATBI Valid To
KEY conditionsequentialnumbershort KOPOS Sequent. No. of Cond
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
conditionvaliditystartdate KODATAB Valid From
conditiontype KSCHA Condition Type
conditiontextid KNUMT Text number
conditioncalculationtype KRECH_LONG Calculat.Type
conditionrateratiounit MSEHIUNIT Unit of Measure
conditionrateratio VFPRC_ELEMENT_RATIO Ratio
conditioncurrency KONWA Cond. Currency
conditionrateamount VFPRC_ELEMENT_AMOUNT Amount
conditionratevalue KBETR_KOND Amount
conditionratevalueunit KONWA Cond. Currency
conditionquantity KPEIN Pricing Unit
conditionquantityunit KMEIN Unit of Measure
conditiontobaseqtynmrtr KUMZA Numer.for Conv.
conditiontobaseqtydnmntr KUMNE Den. for Conv.
baseunit MEINS Base Unit
conditionlowerlimit MXWRT Lower limit
conditionupperlimit GKWRT Upper limit
conditionalternativecurrency KWAEH Cndn Currency
conditionexclusion KZNEP Exclusion
conditionisdeleted LOEVM_KO Deletion Indic.
additionalvaluedays VALTG Add. Value Days
fixedvaluedate VALDT Fixed Val. Date
paymentterms DZTERM Pyt Terms
cndnmaxnumberofsalesorders ANZAUF NumberOfOrders
minimumconditionbasisvalue MIKBAS MinCondBaseVal.
maximumconditionbasisvalue MXKBAS MaxCondBaseVal.
maximumconditionamount KOMXWRT MaxConditValue
conditionreleasestatus KFRST Release Status
conditionchangereason CNDN_CHGREASON Cndn Change Reason
cmmdtypricingengineisenabled COND_IS_CPE_ENABLED Enabled for CPE
conditiontext VTXTK Name
pricingscaletype STFKZ Scale Type
pricingscalebasis KZBZG_LONG Scale Basis
pricingscaleline KLF_KAL Pricing scale
conditionscalequantity KSTBM Scale Quantity
conditionscalequantityunit KONMS Scale UoM
conditionscaleamount KSTBW Scale Value
conditionscaleamountcurrency KONWS Scale Currency
conditionhasscales KOSTKZ Scales
pricingscalecheckingrule KSTPR Check Scale
conditionlowerlimitamount VFPRC_ELEMENT_AMOUNT Amount
conditionlowerlimitratio VFPRC_ELEMENT_RATIO Ratio
conditionupperlimitamount VFPRC_ELEMENT_AMOUNT Amount
conditionupperlimitratio VFPRC_ELEMENT_RATIO Ratio
conditionratevalueisamount BOOLE_D TRUE
conditionratevalueisratio BOOLE_D TRUE
lastchangedatetime CHANGEDATETIME Last Changed
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_PURCONTRHDRCNDNAMOUNTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PC_HDRPRC_D (
    MANDT,                           -- Client [MANDT]
    PURCHASECONTRACT,                -- Purchasing Doc. [EBELN]
    CONDITIONRECORD,                 -- Cond.Record No. [KNUMH]
    CONDITIONVALIDITYENDDATE,        -- Valid To [KODATBI]
    CONDITIONSEQUENTIALNUMBERSHORT,  -- Sequent. No. of Cond [KOPOS]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    CONDITIONVALIDITYSTARTDATE,      -- Valid From [KODATAB]
    CONDITIONTYPE,                   -- Condition Type [KSCHA]
    CONDITIONTEXTID,                 -- Text number [KNUMT]
    CONDITIONCALCULATIONTYPE,        -- Calculat.Type [KRECH_LONG]
    CONDITIONRATERATIOUNIT,          -- Unit of Measure [MSEHIUNIT]
    CONDITIONRATERATIO,              -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONCURRENCY,               -- Cond. Currency [KONWA]
    CONDITIONRATEAMOUNT,             -- Amount [VFPRC_ELEMENT_AMOUNT]
    CONDITIONRATEVALUE,              -- Amount [KBETR_KOND]
    CONDITIONRATEVALUEUNIT,          -- Cond. Currency [KONWA]
    CONDITIONQUANTITY,               -- Pricing Unit [KPEIN]
    CONDITIONQUANTITYUNIT,           -- Unit of Measure [KMEIN]
    CONDITIONTOBASEQTYNMRTR,         -- Numer.for Conv. [KUMZA]
    CONDITIONTOBASEQTYDNMNTR,        -- Den. for Conv. [KUMNE]
    BASEUNIT,                        -- Base Unit [MEINS]
    CONDITIONLOWERLIMIT,             -- Lower limit [MXWRT]
    CONDITIONUPPERLIMIT,             -- Upper limit [GKWRT]
    CONDITIONALTERNATIVECURRENCY,    -- Cndn Currency [KWAEH]
    CONDITIONEXCLUSION,              -- Exclusion [KZNEP]
    CONDITIONISDELETED,              -- Deletion Indic. [LOEVM_KO]
    ADDITIONALVALUEDAYS,             -- Add. Value Days [VALTG]
    FIXEDVALUEDATE,                  -- Fixed Val. Date [VALDT]
    PAYMENTTERMS,                    -- Pyt Terms [DZTERM]
    CNDNMAXNUMBEROFSALESORDERS,      -- NumberOfOrders [ANZAUF]
    MINIMUMCONDITIONBASISVALUE,      -- MinCondBaseVal. [MIKBAS]
    MAXIMUMCONDITIONBASISVALUE,      -- MaxCondBaseVal. [MXKBAS]
    MAXIMUMCONDITIONAMOUNT,          -- MaxConditValue [KOMXWRT]
    CONDITIONRELEASESTATUS,          -- Release Status [KFRST]
    CONDITIONCHANGEREASON,           -- Cndn Change Reason [CNDN_CHGREASON]
    CMMDTYPRICINGENGINEISENABLED,    -- Enabled for CPE [COND_IS_CPE_ENABLED]
    CONDITIONTEXT,                   -- Name [VTXTK]
    PRICINGSCALETYPE,                -- Scale Type [STFKZ]
    PRICINGSCALEBASIS,               -- Scale Basis [KZBZG_LONG]
    PRICINGSCALELINE,                -- Pricing scale [KLF_KAL]
    CONDITIONSCALEQUANTITY,          -- Scale Quantity [KSTBM]
    CONDITIONSCALEQUANTITYUNIT,      -- Scale UoM [KONMS]
    CONDITIONSCALEAMOUNT,            -- Scale Value [KSTBW]
    CONDITIONSCALEAMOUNTCURRENCY,    -- Scale Currency [KONWS]
    CONDITIONHASSCALES,              -- Scales [KOSTKZ]
    PRICINGSCALECHECKINGRULE,        -- Check Scale [KSTPR]
    CONDITIONLOWERLIMITAMOUNT,       -- Amount [VFPRC_ELEMENT_AMOUNT]
    CONDITIONLOWERLIMITRATIO,        -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONUPPERLIMITAMOUNT,       -- Amount [VFPRC_ELEMENT_AMOUNT]
    CONDITIONUPPERLIMITRATIO,        -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONRATEVALUEISAMOUNT,      -- TRUE [BOOLE_D]
    CONDITIONRATEVALUEISRATIO,       -- TRUE [BOOLE_D]
    LASTCHANGEDATETIME,              -- Last Changed [CHANGEDATETIME]
    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, CONDITIONVALIDITYENDDATE, CONDITIONSEQUENTIALNUMBERSHORT, DRAFTUUID)
);

Learn More