I_CNTRLPURCONTRCMMDTYTERMNEW
CCTR Commodity Term sCPE
I_CNTRLPURCONTRCMMDTYTERMNEW is a CDS View in S/4HANA. CCTR Commodity Term sCPE. It contains 66 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CntrlPurContrCmmdtyTermUnion | view_entity | from | COMPOSITE | Union Layer Central Contract for Term |
Fields (66)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CentralPurchaseContract | CentralPurchaseContract | 1 |
| KEY | CentralPurchaseContractItem | CentralPurchaseContractItem | 1 |
| KEY | ConditionRecord | ConditionRecord | 1 |
| KEY | ConditionSequentialNumber | ConditionSequentialNumber | 1 |
| KEY | ConditionValidityEndDate | ConditionValidityEndDate | 1 |
| KEY | PricingConditionTerm | PricingConditionTerm | 1 |
| _CmmdtyPrcgCalcRuleText | _CmmdtyPrcgCalcRuleText | 1 | |
| _CmmdtyPrcgQuotationRuleText | _CmmdtyPrcgQuotationRuleText | 1 | |
| _CmmdtyPrcgTermCalcTypeText | _CmmdtyPrcgTermCalcTypeText | 1 | |
| _CmmdtyPricingTermRuleText | _CmmdtyPricingTermRuleText | 1 | |
| _CommodityPricingTermText | _CommodityPricingTermText | 1 | |
| _PrcgCndnFmlaCmmdtyQtyUnit | _PrcgCndnFmlaCmmdtyQtyUnit | 1 | |
| _PrcgConditionSourceCurrency | _PrcgConditionSourceCurrency | 1 | |
| _PrcgConditionTargetCurrency | _PrcgConditionTargetCurrency | 1 | |
| CndnCalcRuleValdtyStrtDateTime | CndnCalcRuleValdtyStrtDateTime | 1 | |
| CndnCnvrsnRuleValdtyStrtDteTme | CndnCnvrsnRuleValdtyStrtDteTme | 1 | |
| CndnQtanRuleValdtyStrtDateTime | CndnQtanRuleValdtyStrtDateTime | 1 | |
| CndnTrmCalcTypeRoutineSubMdl | CndnTrmCalcTypeRoutineSubMdl | 1 | |
| CndnTrmCnvrsnValdtyStrtDteTme | CndnTrmCnvrsnValdtyStrtDteTme | 1 | |
| CndnTrmExchRatePerdBaseDteTime | CndnTrmExchRatePerdBaseDteTime | 1 | |
| CndnTrmExchRatePerdEndDateTime | CndnTrmExchRatePerdEndDateTime | 1 | |
| CndnTrmExchRatePerdStrtDteTime | CndnTrmExchRatePerdStrtDteTime | 1 | |
| CndnTrmRuleValdtyStartDateTime | CndnTrmRuleValdtyStartDateTime | 1 | |
| ConditionType | ConditionType | 1 | |
| DerivativeContrSpecification | DerivativeContrSpecification | 1 | |
| DocItemCommodityPricingUUID | DocItemCommodityPricingUUID | 1 | |
| MarketIdentifierCode | MarketIdentifierCode | 1 | |
| OriginSystem | OriginSystem | 1 | |
| PrcgCndnFmlaCmmdtyQuantityUnit | PrcgCndnFmlaCmmdtyQuantityUnit | 1 | |
| PrcgCndnFmlaCommodityQuantity | PrcgCndnFmlaCommodityQuantity | 1 | |
| PrcgCndnFmlaEvaluationDateTime | PrcgCndnFmlaEvaluationDateTime | 1 | |
| PrcgCndnFmlaEvaluationModule | PrcgCndnFmlaEvaluationModule | 1 | |
| PrcgCndnGrpTrmValdtyStrtDteTme | PrcgCndnGrpTrmValdtyStrtDteTme | 1 | |
| PrcgCndnTermCalculationRule | PrcgCndnTermCalculationRule | 1 | |
| PrcgCndnTermCalculationType | PrcgCndnTermCalculationType | 1 | |
| PrcgCndnTermFixedRateQtyUnit | PrcgCndnTermFixedRateQtyUnit | 1 | |
| PrcgCndnTermQuotationRule | PrcgCndnTermQuotationRule | 1 | |
| PrcgCndnTrmExchRatePerdRefDate | PrcgCndnTrmExchRatePerdRefDate | 1 | |
| PrcgCndnTrmQtanPerdBaseDteTime | PrcgCndnTrmQtanPerdBaseDteTime | 1 | |
| PrcgCndnTrmQtanPerdEndDateTime | PrcgCndnTrmQtanPerdEndDateTime | 1 | |
| PrcgCndnTrmQtanPerdRefDate | PrcgCndnTrmQtanPerdRefDate | 1 | |
| PrcgCndnTrmQtanPerdStrtDteTime | PrcgCndnTrmQtanPerdStrtDteTime | 1 | |
| PrcgCndnTrmQtanRateCurrency | PrcgCndnTrmQtanRateCurrency | 1 | |
| PrcgCndnTrmQtanRateQtyUnit | PrcgCndnTrmQtanRateQtyUnit | 1 | |
| PrcgCndnTrmQtanRateQuantity | PrcgCndnTrmQtanRateQuantity | 1 | |
| PrcgCndnTrmSurchargeRteCrcy | PrcgCndnTrmSurchargeRteCrcy | 1 | |
| PrcgCndnTrmSurchargeRteQty | PrcgCndnTrmSurchargeRteQty | 1 | |
| PrcgCndnTrmSurchargeRteQtyUnit | PrcgCndnTrmSurchargeRteQtyUnit | 1 | |
| PrcgCndnTrmValdtyStartDateTime | PrcgCndnTrmValdtyStartDateTime | 1 | |
| PrcgConditionConversionPlace | PrcgConditionConversionPlace | 1 | |
| PrcgConditionFixedExchangeRate | PrcgConditionFixedExchangeRate | 1 | |
| PrcgConditionFormulaInputUUID | PrcgConditionFormulaInputUUID | 1 | |
| PrcgConditionTermFixedRateCrcy | PrcgConditionTermFixedRateCrcy | 1 | |
| PrcgConditionTermFixedRateQty | PrcgConditionTermFixedRateQty | 1 | |
| PrcgConditionTermRateCrcy | PrcgConditionTermRateCrcy | 1 | |
| PrcgConditionTermRateQty | PrcgConditionTermRateQty | 1 | |
| PrcgConditionTermRateQtyUnit | PrcgConditionTermRateQtyUnit | 1 | |
| PricingConditionConversionRule | PricingConditionConversionRule | 1 | |
| PricingConditionFormulaKey | PricingConditionFormulaKey | 1 | |
| PricingConditionSourceCurrency | PricingConditionSourceCurrency | 1 | |
| PricingConditionTargetCurrency | PricingConditionTargetCurrency | 1 | |
| PricingConditionTermGroup | PricingConditionTermGroup | 1 | |
| PricingConditionTermKey | PricingConditionTermKey | 1 | |
| PricingConditionTermRule | PricingConditionTermRule | 1 | |
| QuotationPriceType | QuotationPriceType | 1 | |
| TimeToMaturity | TimeToMaturity | 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 Term sCPE
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNTRLPURCONTRCMMDTYTERMNEW (
CENTRALPURCHASECONTRACT,
CENTRALPURCHASECONTRACTITEM,
CONDITIONRECORD,
CONDITIONSEQUENTIALNUMBER,
CONDITIONVALIDITYENDDATE,
PRICINGCONDITIONTERM,
_CMMDTYPRCGCALCRULETEXT,
_CMMDTYPRCGQUOTATIONRULETEXT,
_CMMDTYPRCGTERMCALCTYPETEXT,
_CMMDTYPRICINGTERMRULETEXT,
_COMMODITYPRICINGTERMTEXT,
_PRCGCNDNFMLACMMDTYQTYUNIT,
_PRCGCONDITIONSOURCECURRENCY,
_PRCGCONDITIONTARGETCURRENCY,
CNDNCALCRULEVALDTYSTRTDATETIME,
CNDNCNVRSNRULEVALDTYSTRTDTETME,
CNDNQTANRULEVALDTYSTRTDATETIME,
CNDNTRMCALCTYPEROUTINESUBMDL,
CNDNTRMCNVRSNVALDTYSTRTDTETME,
CNDNTRMEXCHRATEPERDBASEDTETIME,
CNDNTRMEXCHRATEPERDENDDATETIME,
CNDNTRMEXCHRATEPERDSTRTDTETIME,
CNDNTRMRULEVALDTYSTARTDATETIME,
CONDITIONTYPE,
DERIVATIVECONTRSPECIFICATION,
DOCITEMCOMMODITYPRICINGUUID,
MARKETIDENTIFIERCODE,
ORIGINSYSTEM,
PRCGCNDNFMLACMMDTYQUANTITYUNIT,
PRCGCNDNFMLACOMMODITYQUANTITY,
PRCGCNDNFMLAEVALUATIONDATETIME,
PRCGCNDNFMLAEVALUATIONMODULE,
PRCGCNDNGRPTRMVALDTYSTRTDTETME,
PRCGCNDNTERMCALCULATIONRULE,
PRCGCNDNTERMCALCULATIONTYPE,
PRCGCNDNTERMFIXEDRATEQTYUNIT,
PRCGCNDNTERMQUOTATIONRULE,
PRCGCNDNTRMEXCHRATEPERDREFDATE,
PRCGCNDNTRMQTANPERDBASEDTETIME,
PRCGCNDNTRMQTANPERDENDDATETIME,
PRCGCNDNTRMQTANPERDREFDATE,
PRCGCNDNTRMQTANPERDSTRTDTETIME,
PRCGCNDNTRMQTANRATECURRENCY,
PRCGCNDNTRMQTANRATEQTYUNIT,
PRCGCNDNTRMQTANRATEQUANTITY,
PRCGCNDNTRMSURCHARGERTECRCY,
PRCGCNDNTRMSURCHARGERTEQTY,
PRCGCNDNTRMSURCHARGERTEQTYUNIT,
PRCGCNDNTRMVALDTYSTARTDATETIME,
PRCGCONDITIONCONVERSIONPLACE,
PRCGCONDITIONFIXEDEXCHANGERATE,
PRCGCONDITIONFORMULAINPUTUUID,
PRCGCONDITIONTERMFIXEDRATECRCY,
PRCGCONDITIONTERMFIXEDRATEQTY,
PRCGCONDITIONTERMRATECRCY,
PRCGCONDITIONTERMRATEQTY,
PRCGCONDITIONTERMRATEQTYUNIT,
PRICINGCONDITIONCONVERSIONRULE,
PRICINGCONDITIONFORMULAKEY,
PRICINGCONDITIONSOURCECURRENCY,
PRICINGCONDITIONTARGETCURRENCY,
PRICINGCONDITIONTERMGROUP,
PRICINGCONDITIONTERMKEY,
PRICINGCONDITIONTERMRULE,
QUOTATIONPRICETYPE,
TIMETOMATURITY,
PRIMARY KEY (CENTRALPURCHASECONTRACT, CENTRALPURCHASECONTRACTITEM, CONDITIONRECORD, CONDITIONSEQUENTIALNUMBER, CONDITIONVALIDITYENDDATE, PRICINGCONDITIONTERM)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA