PPS_PC_ITMCAMT_D

Transparent Table Application Table
54 Fields 1 CDS Views

Draft table for entity R_PPS_PURCONTRITEMCNDNAMOUNTTP

PPS_PC_ITMCAMT_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCONTRITEMCNDNAMOUNTTP. It contains 54 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurContrItmCndnAmtDrft view_entity from BASIC Item Condition Amount draft

Fields (54)

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 conditionsequentialnumbershort kopos Sequent. No. of Cond
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
conditionvaliditystartdate kodatab Valid From
conditionapplication kappl Application
conditiontype kscha Condition Type
plant werks_d Plant
conditiontextid knumt Text number
conditioncalculationtypeshort krech Calculat.Type
conditionratevalue kbetr_kond Amount
conditionratevalueunit konwa Cond. Currency
conditionquantity kpein Pricing Unit
conditionrateratiounit msehiunit Unit of Measure
conditionrateratio vfprc_element_ratio Ratio
conditioncurrency konwa Cond. Currency
conditionrateamount vfprc_element_amount Amount
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
conditionlowerlimitamount vfprc_element_amount Amount
conditionlowerlimitratio vfprc_element_ratio Ratio
conditionupperlimitamount vfprc_element_amount Amount
conditionupperlimitratio vfprc_element_ratio Ratio
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
conditionratevalueisamount boole_d TRUE
conditionratevalueisratio boole_d TRUE
pricingscaletype stfkz Scale Type
pricingscalebasisshort kzbzg Scale Base Type
pricingscaleline klf_kal Pricing scale
conditionhasscales kostkz Scales
pricingscalecheckingrule kstpr Check Scale
conditionchangereason cndn_chgreason Cndn Change Reason
minimumconditionbasisvalue mikbas MinCondBaseVal.
maximumconditionbasisvalue mxkbas MaxCondBaseVal.
maximumconditionamount komxwrt MaxConditValue
conditionreleasestatus kfrst Release Status
purchasingorganization ekorg Purchasing Org.
lastchangedatetime changedatetime Last Changed
conditionchangereasontext vtxtm Description
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_PURCONTRITEMCNDNAMOUNTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PC_ITMCAMT_D (
    MANDT,                           -- Client [mandt]
    PURCHASECONTRACT,                -- Purchasing Doc. [ebeln]
    PURCHASECONTRACTITEM,            -- Item [ebelp]
    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]
    CONDITIONAPPLICATION,            -- Application [kappl]
    CONDITIONTYPE,                   -- Condition Type [kscha]
    PLANT,                           -- Plant [werks_d]
    CONDITIONTEXTID,                 -- Text number [knumt]
    CONDITIONCALCULATIONTYPESHORT,   -- Calculat.Type [krech]
    CONDITIONRATEVALUE,              -- Amount [kbetr_kond]
    CONDITIONRATEVALUEUNIT,          -- Cond. Currency [konwa]
    CONDITIONQUANTITY,               -- Pricing Unit [kpein]
    CONDITIONRATERATIOUNIT,          -- Unit of Measure [msehiunit]
    CONDITIONRATERATIO,              -- Ratio [vfprc_element_ratio]
    CONDITIONCURRENCY,               -- Cond. Currency [konwa]
    CONDITIONRATEAMOUNT,             -- Amount [vfprc_element_amount]
    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]
    CONDITIONLOWERLIMITAMOUNT,       -- Amount [vfprc_element_amount]
    CONDITIONLOWERLIMITRATIO,        -- Ratio [vfprc_element_ratio]
    CONDITIONUPPERLIMITAMOUNT,       -- Amount [vfprc_element_amount]
    CONDITIONUPPERLIMITRATIO,        -- Ratio [vfprc_element_ratio]
    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]
    CONDITIONRATEVALUEISAMOUNT,      -- TRUE [boole_d]
    CONDITIONRATEVALUEISRATIO,       -- TRUE [boole_d]
    PRICINGSCALETYPE,                -- Scale Type [stfkz]
    PRICINGSCALEBASISSHORT,          -- Scale Base Type [kzbzg]
    PRICINGSCALELINE,                -- Pricing scale [klf_kal]
    CONDITIONHASSCALES,              -- Scales [kostkz]
    PRICINGSCALECHECKINGRULE,        -- Check Scale [kstpr]
    CONDITIONCHANGEREASON,           -- Cndn Change Reason [cndn_chgreason]
    MINIMUMCONDITIONBASISVALUE,      -- MinCondBaseVal. [mikbas]
    MAXIMUMCONDITIONBASISVALUE,      -- MaxCondBaseVal. [mxkbas]
    MAXIMUMCONDITIONAMOUNT,          -- MaxConditValue [komxwrt]
    CONDITIONRELEASESTATUS,          -- Release Status [kfrst]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    CONDITIONCHANGEREASONTEXT,       -- Description [vtxtm]
    PURCHASECONTRACTDRAFTUUID,       -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, PURCHASECONTRACT, PURCHASECONTRACTITEM, CONDITIONRECORD, CONDITIONVALIDITYENDDATE, CONDITIONSEQUENTIALNUMBERSHORT, DRAFTUUID)
);

Learn More