C_CmmdtyMTMLogDayOverDayQry_2

Day-over-Day MtM Logistics Documents | view: CCOMTMLDODQRY2 | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: MARA, TBACC_BAS_ID, TBACC_BAS_ID_T, TBAC_PHYSCOMM, TBAC_PHYSCOMMT, T001, TKA02, TBAC_DCST, TBAC_DCS, T156, TINC, TINCT, TBAC_MIC, TBAC_MICT, CMM_MTM_CGROUPTT, T001W, CMM_FBFIX_STTXT, MARA, MAKT, T100, CMM_VLOGP_C_GRP
Column Name Description
PricingKey A key required to access versioned pricing data
Column Name Description
💲 Price Currency (ConditionTermRateCurrency):
ConditionTermRate Price
💲 Statistics Currency (StatisticsCurrency):
ConditionTermValueInStstcCrcy Value in Statistical Currency
Column Name Description
📏 Unit of Measure for Commodity (CommodityUnit):
CommodityQuantity Commodity Quantity
📏 Price UoM (ConditionTermRateQuantityUnit):
CommodityQuantityInTermUnit Commodity Quantity in Price Unit
📏 Mass Unit of Measure (CmmdtyPriceExpsrMassUnit):
CmmdtyPriceExpsrQtyInMassUnit Open Commodity Quantity In MASS
📏 QuantityVolume UoM (CmmdtyPriceExpsrVolumeUnit):
CmmdtyPriceExpsrQtyInVolUnit Open Commodity Quantity In Volume
Column Name Description
EndOfDaySnapshotDate Snapshot Date
ValidityStartDate Last Changed Date
MaturityKeyDate Maturity Key Date
QuotationPeriodReferenceDate Reference Date
DeliveryDate Delivery Date
ExpectedPaymentDate Payment Date
ExchRateEvaluationDate Exchange Rate Evaluation Date
DocToStstcCrcyExchRateEvalDate Document to Statistics Currency Evaluation Date
CndnTermRateFixationDate Rate Fixation Date
CndnTermRateFixationTime Rate Fixation Time
CndnTermExchRateFixationDate FX Fixation Date
CndnTermExchRateFixationTime FX Fixation Time
ExchRateMaturityDate Maturity Date
OldestQuotationDate Oldest Quotation Date
QuotationPeriodStartDate Start Date of Quotation Period
QuotationPeriodEndDate End Date of Quotation Period
Column Name Description
IsIntercompanyTransfer Intercompany Transfer Show values
HasError Flag: Error occured Show values
CmmdtyForwardIndexTiming Timing/Periodicity of Commodity Forward Indexes Show values
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
ProfitCenter Profit Center PRCTR
PlantName Plant Name TEXT30
CommodityName Commodity Description TEXT40
ProductName Product Description TEXT40
OrignRefDocumentShortNumber Root Document CMM_DOCUMENT_CHAR10
OriginReferenceDocument Root Document CMM_MTM_OBJID
SourceDocumentShortNumber Document CMM_DOCUMENT_CHAR10
SourceDocument Source Document CMM_MTM_OBJID
SourceDocumentItem Source Document Item
SourceDocumentBusObjTypeName Name TEXT20
IncotermsClassificationName Description TEXT30
IncotermsTransferLocation Incoterms (Part 2) INCO2
ConditionApplication Application KAPPL
MTMCalculationGroupName Condition Group - Description TEXT20
MTMConditionGroupCategoryName Short Text for Fixed Values DDTEXT
DerivativeContractMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
BasisIDName Basis ID Description TBAC_BASIS_ID_TEXT
DerivativeContrSpecName Description of Derivative Contract Specification TEXT40
MarketIdentifierCodeName Market Identifier Code Description TEXT40
PricingStatusName Future/Basis Price Fixation Status - Long Text TEXT50
MTMAdjustmentTypeName Short Text for Fixed Values DDTEXT
ConditionTermRateFixation Fixation ID
ConditionType Condition Type KSCHL
SubConditionType The key of a sub-condition type CMM_VLOGP_SUBKEY
MarketToDocExchRate Exchange Rate: Market to Document Currency
DocToStatisticalExchRate Exchange Rate: Document to Statistics Currency
ConditionTermValueInDocCrcy Value in Document Currency
CompanyCode Company Code BUKRS
PhysicalCommodity Commodity TBA_STOEFFCHEN
Material Material Number MATNR
MaterialGroup Material Group MATKL
Plant Plant WERKS
Creditor Account Number of Supplier LIFNR
SoldToParty Customer Number KUNNR
OriginRefDocBusObjTypeName Name TEXT20
OriginReferenceDocBusObjType Root Document (BOR) Object Type OJ_NAME
OriginReferenceDocumentItem Root Document Item CMM_VLOGP_ROOT_ITEM
ReferenceDocument Predecessor Document CMM_MTM_OBJID
ReferenceDocBusObjTypeName Name TEXT20
ReferenceDocBusObjType Ref (BOR) Object Type OJ_NAME
ReferenceDocumentItem Predecessor Document Item CMM_VLOGP_REF_ITEM
DeliveryYear Abjusted Reporting Year
DeliveryMonth Adjusted Reporting Month CHAR3
ConditionTermFactor CPE condition type term factor
BsMktRefDrvtvContrMaturityCode Basis Market Reference Contract Maturity Code CMM_BAS_MKT_REF_CONTRACT_CODE
BasisMarketRefRate Original Basis Market reference rate CMM_GMDA_PRICE
BasisMarketRefAdjustmentSpread Adjustment Value CMM_GMDA_PRICE
MarketToDocFrozenExchRate Exchange Rate: Market to Document Currency at a Key Date
ConditionTermRateQuantity Price Unit
Batch Batch Number CHARG
SystemMessageText Message Text NATXT
CmmdtyForwardIndexTimingText Short Text for Fixed Values DDTEXT
MarketToTermExchangeRateType Exch. Rate Type for Conversion from Market to Term Currency KURST
CndnToStstcExchangeRateType Exch. Rate Type for Conv. from Condition to Document Crcy KURST
ConditionToDocExchangeRateType Exch Rate Type for Conv. from Document to Statistics Crcy KURST
DocToStstcExchangeRateType Exch. Rate Type for Conv. from Condition to Stat. Crcy KURST
pricesettingmethod Price Setting Method CPE_PSMETHOD
pricesettingmethodstatus Price Setting Method Status CPE_PSMSTATUS
validtodatetime Valid-To Timestamp TZNTSTMPS
pricingprocedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
pricingconditionterm CPE Term - Number in Formula NUMC5