I_CNTRLPURCONTRCMMDTYFMLANEW

CDS View
29 Fields 1 CDS Views

CCTR Commodity Formula sCPE

I_CNTRLPURCONTRCMMDTYFMLANEW is a CDS View in S/4HANA. CCTR Commodity Formula sCPE. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CntrlPurContrCmmdtyFmlaUnion view_entity from COMPOSITE Union Layer Central Contract for Formula

Fields (29)

KeyField CDS FieldsUsed in Views
KEY CentralPurchaseContract CentralPurchaseContract 1
KEY CentralPurchaseContractItem CentralPurchaseContractItem 1
KEY ConditionRecord ConditionRecord 1
KEY ConditionSequentialNumber ConditionSequentialNumber 1
KEY ConditionValidityEndDate ConditionValidityEndDate 1
_CmmdtyPricingCombRoutineText _CmmdtyPricingCombRoutineText 1
_CommodityCndnMapping _CommodityCndnMapping 1
_CommodityCodeMapping _CommodityCodeMapping 1
_CommodityPricingFormulaText _CommodityPricingFormulaText 1
_OriginSystem _OriginSystem 1
_PrcgCndnFormulaAmountCurrency _PrcgCndnFormulaAmountCurrency 1
_PrcgCndnFormulaRateCurrency _PrcgCndnFormulaRateCurrency 1
_PrcgCndnFormulaRateQtyUnit _PrcgCndnFormulaRateQtyUnit 1
_PurgPrcgCndnType _PurgPrcgCndnType 1
ConditionType ConditionType 1
DocItemCommodityPricingUUID DocItemCommodityPricingUUID 1
OriginSystem OriginSystem 1
PrcgCndnFmlaCmmdtyQuantityUnit PrcgCndnFmlaCmmdtyQuantityUnit 1
PrcgCndnFmlaCombinationRoutine PrcgCndnFmlaCombinationRoutine 1
PrcgCndnFmlaCombnRoutineSubMdl PrcgCndnFmlaCombnRoutineSubMdl 1
PrcgCndnFmlaCommodityQuantity PrcgCndnFmlaCommodityQuantity 1
PrcgCndnFmlaEvaluationModule PrcgCndnFmlaEvaluationModule 1
PrcgCndnFmlaValdtyStrtDateTime PrcgCndnFmlaValdtyStrtDateTime 1
PrcgCndnFormulaAmountCurrency PrcgCndnFormulaAmountCurrency 1
PrcgCndnFormulaRateCurrency PrcgCndnFormulaRateCurrency 1
PrcgCndnFormulaRateQtyUnit PrcgCndnFormulaRateQtyUnit 1
PrcgCndnFormulaRateQuantity PrcgCndnFormulaRateQuantity 1
PrcgConditionFormulaInputUUID PrcgConditionFormulaInputUUID 1
PricingConditionFormulaKey PricingConditionFormulaKey 1

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.

-- CCTR Commodity Formula sCPE
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNTRLPURCONTRCMMDTYFMLANEW (
    CENTRALPURCHASECONTRACT,
    CENTRALPURCHASECONTRACTITEM,
    CONDITIONRECORD,
    CONDITIONSEQUENTIALNUMBER,
    CONDITIONVALIDITYENDDATE,
    _CMMDTYPRICINGCOMBROUTINETEXT,
    _COMMODITYCNDNMAPPING,
    _COMMODITYCODEMAPPING,
    _COMMODITYPRICINGFORMULATEXT,
    _ORIGINSYSTEM,
    _PRCGCNDNFORMULAAMOUNTCURRENCY,
    _PRCGCNDNFORMULARATECURRENCY,
    _PRCGCNDNFORMULARATEQTYUNIT,
    _PURGPRCGCNDNTYPE,
    CONDITIONTYPE,
    DOCITEMCOMMODITYPRICINGUUID,
    ORIGINSYSTEM,
    PRCGCNDNFMLACMMDTYQUANTITYUNIT,
    PRCGCNDNFMLACOMBINATIONROUTINE,
    PRCGCNDNFMLACOMBNROUTINESUBMDL,
    PRCGCNDNFMLACOMMODITYQUANTITY,
    PRCGCNDNFMLAEVALUATIONMODULE,
    PRCGCNDNFMLAVALDTYSTRTDATETIME,
    PRCGCNDNFORMULAAMOUNTCURRENCY,
    PRCGCNDNFORMULARATECURRENCY,
    PRCGCNDNFORMULARATEQTYUNIT,
    PRCGCNDNFORMULARATEQUANTITY,
    PRCGCONDITIONFORMULAINPUTUUID,
    PRICINGCONDITIONFORMULAKEY,
    PRIMARY KEY (CENTRALPURCHASECONTRACT, CENTRALPURCHASECONTRACTITEM, CONDITIONRECORD, CONDITIONSEQUENTIALNUMBER, CONDITIONVALIDITYENDDATE)
);

Learn More