SRCGPROJQTNITMCOMMODITYTERM
SRCGPROJQTNITMCOMMODITYTERM is an SAP database table in S/4HANA. It contains 75 fields.
Fields (75)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ConditionRecord | ConditionRecord | 1 |
| KEY | ConditionSequentialNumberShort | ConditionSequentialNumberShort | 1 |
| _CmmdtyPrcgCalcRuleText | _CmmdtyPrcgCalcRuleText | 1 | |
| _CmmdtyPrcgQuotationRuleText | _CmmdtyPrcgQuotationRuleText | 1 | |
| _CmmdtyPrcgTermCalcTypeText | _CmmdtyPrcgTermCalcTypeText | 1 | |
| _CmmdtyPricingTermRuleText | _CmmdtyPricingTermRuleText | 1 | |
| _CommodityPricingTermText | _CommodityPricingTermText | 1 | |
| _OriginSystem | _OriginSystem | 1 | |
| _PrcgCndnFmlaCmmdtyQtyUnit | _PrcgCndnFmlaCmmdtyQtyUnit | 1 | |
| _PrcgCndnSourceQuantityUnit | _PrcgCndnSourceQuantityUnit | 1 | |
| _PrcgCndnTargetQuantityUnit | _PrcgCndnTargetQuantityUnit | 1 | |
| _PrcgConditionSourceCurrency | _PrcgConditionSourceCurrency | 1 | |
| _PrcgConditionTargetCurrency | _PrcgConditionTargetCurrency | 1 | |
| CndnCalcRuleValdtyStrtDateTime | CndnCalcRuleValdtyStrtDateTime | 1 | |
| CndnCnvrsnRuleValdtyStrtDteTme | CndnCnvrsnRuleValdtyStrtDteTme | 1 | |
| CndnExchRatePerdDetnResultUUID | CndnExchRatePerdDetnResultUUID | 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 | |
| PrcgCndnSourceQuantityUnit | PrcgCndnSourceQuantityUnit | 1 | |
| PrcgCndnTargetQuantityUnit | PrcgCndnTargetQuantityUnit | 1 | |
| PrcgCndnTermCalculationRule | PrcgCndnTermCalculationRule | 1 | |
| PrcgCndnTermCalculationType | PrcgCndnTermCalculationType | 1 | |
| PrcgCndnTermConversionRsltUUID | PrcgCndnTermConversionRsltUUID | 1 | |
| PrcgCndnTermFixedRateQtyUnit | PrcgCndnTermFixedRateQtyUnit | 1 | |
| PrcgCndnTermQuotationRule | PrcgCndnTermQuotationRule | 1 | |
| PrcgCndnTrmConversionInputUUID | PrcgCndnTrmConversionInputUUID | 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 | |
| PrcgConditionTermQuotationRate | PrcgConditionTermQuotationRate | 1 | |
| PrcgConditionTermRateCrcy | PrcgConditionTermRateCrcy | 1 | |
| PrcgConditionTermRateQty | PrcgConditionTermRateQty | 1 | |
| PrcgConditionTermRateQtyUnit | PrcgConditionTermRateQtyUnit | 1 | |
| PrcgConditionTermSurchargeRate | PrcgConditionTermSurchargeRate | 1 | |
| PricingConditionConversionRule | PricingConditionConversionRule | 1 | |
| PricingConditionFormulaKey | PricingConditionFormulaKey | 1 | |
| PricingConditionSourceCurrency | PricingConditionSourceCurrency | 1 | |
| PricingConditionTargetCurrency | PricingConditionTargetCurrency | 1 | |
| PricingConditionTerm | PricingConditionTerm | 1 | |
| PricingConditionTermFixedRate | PricingConditionTermFixedRate | 1 | |
| PricingConditionTermGroup | PricingConditionTermGroup | 1 | |
| PricingConditionTermKey | PricingConditionTermKey | 1 | |
| PricingConditionTermRate | PricingConditionTermRate | 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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SRCGPROJQTNITMCOMMODITYTERM (
CONDITIONRECORD,
CONDITIONSEQUENTIALNUMBERSHORT,
_CMMDTYPRCGCALCRULETEXT,
_CMMDTYPRCGQUOTATIONRULETEXT,
_CMMDTYPRCGTERMCALCTYPETEXT,
_CMMDTYPRICINGTERMRULETEXT,
_COMMODITYPRICINGTERMTEXT,
_ORIGINSYSTEM,
_PRCGCNDNFMLACMMDTYQTYUNIT,
_PRCGCNDNSOURCEQUANTITYUNIT,
_PRCGCNDNTARGETQUANTITYUNIT,
_PRCGCONDITIONSOURCECURRENCY,
_PRCGCONDITIONTARGETCURRENCY,
CNDNCALCRULEVALDTYSTRTDATETIME,
CNDNCNVRSNRULEVALDTYSTRTDTETME,
CNDNEXCHRATEPERDDETNRESULTUUID,
CNDNQTANRULEVALDTYSTRTDATETIME,
CNDNTRMCALCTYPEROUTINESUBMDL,
CNDNTRMCNVRSNVALDTYSTRTDTETME,
CNDNTRMEXCHRATEPERDBASEDTETIME,
CNDNTRMEXCHRATEPERDENDDATETIME,
CNDNTRMEXCHRATEPERDSTRTDTETIME,
CNDNTRMRULEVALDTYSTARTDATETIME,
CONDITIONTYPE,
DERIVATIVECONTRSPECIFICATION,
DOCITEMCOMMODITYPRICINGUUID,
MARKETIDENTIFIERCODE,
ORIGINSYSTEM,
PRCGCNDNFMLACMMDTYQUANTITYUNIT,
PRCGCNDNFMLACOMMODITYQUANTITY,
PRCGCNDNFMLAEVALUATIONDATETIME,
PRCGCNDNFMLAEVALUATIONMODULE,
PRCGCNDNGRPTRMVALDTYSTRTDTETME,
PRCGCNDNSOURCEQUANTITYUNIT,
PRCGCNDNTARGETQUANTITYUNIT,
PRCGCNDNTERMCALCULATIONRULE,
PRCGCNDNTERMCALCULATIONTYPE,
PRCGCNDNTERMCONVERSIONRSLTUUID,
PRCGCNDNTERMFIXEDRATEQTYUNIT,
PRCGCNDNTERMQUOTATIONRULE,
PRCGCNDNTRMCONVERSIONINPUTUUID,
PRCGCNDNTRMEXCHRATEPERDREFDATE,
PRCGCNDNTRMQTANPERDBASEDTETIME,
PRCGCNDNTRMQTANPERDENDDATETIME,
PRCGCNDNTRMQTANPERDREFDATE,
PRCGCNDNTRMQTANPERDSTRTDTETIME,
PRCGCNDNTRMQTANRATECURRENCY,
PRCGCNDNTRMQTANRATEQTYUNIT,
PRCGCNDNTRMQTANRATEQUANTITY,
PRCGCNDNTRMSURCHARGERTECRCY,
PRCGCNDNTRMSURCHARGERTEQTY,
PRCGCNDNTRMSURCHARGERTEQTYUNIT,
PRCGCNDNTRMVALDTYSTARTDATETIME,
PRCGCONDITIONCONVERSIONPLACE,
PRCGCONDITIONFIXEDEXCHANGERATE,
PRCGCONDITIONFORMULAINPUTUUID,
PRCGCONDITIONTERMFIXEDRATECRCY,
PRCGCONDITIONTERMFIXEDRATEQTY,
PRCGCONDITIONTERMQUOTATIONRATE,
PRCGCONDITIONTERMRATECRCY,
PRCGCONDITIONTERMRATEQTY,
PRCGCONDITIONTERMRATEQTYUNIT,
PRCGCONDITIONTERMSURCHARGERATE,
PRICINGCONDITIONCONVERSIONRULE,
PRICINGCONDITIONFORMULAKEY,
PRICINGCONDITIONSOURCECURRENCY,
PRICINGCONDITIONTARGETCURRENCY,
PRICINGCONDITIONTERM,
PRICINGCONDITIONTERMFIXEDRATE,
PRICINGCONDITIONTERMGROUP,
PRICINGCONDITIONTERMKEY,
PRICINGCONDITIONTERMRATE,
PRICINGCONDITIONTERMRULE,
QUOTATIONPRICETYPE,
TIMETOMATURITY,
PRIMARY KEY (CONDITIONRECORD, CONDITIONSEQUENTIALNUMBERSHORT)
);Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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