I_ContrMTMValueCube

ACM Contract MTM Values - Cube | view: IACMMTMVALCUBE | TRAN | Extraction: Not supported | Component: SAP Agricultural Contract Management
Tables used: /ACCGO/T_CAKHDR, CMM_LOGSYNC, MARA, TBACC_BAS_ID, TBACC_BAS_ID_T, TBAC_PHYSCOMM, TBAC_PHYSCOMMT, T001, TKA02, CMM_VLOGP, TBAC_DCST, TBAC_DCS, T156, TINC, TINCT, TBAC_MIC, TBAC_MICT, CMM_MTM_CGROUPTT, T001W, CMM_FBFIX_STTXT, MAKT, T100
Column Name Description
PricingKey A key required to access versioned pricing data
Version Version of an MtM Valuation Record
PricingDocumentItem Condition item number
ConditionType Condition Type
SubConditionType The key of a sub-condition type
Column Name Description
💲 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
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
BasisMarketRefKeyDate Basis Market reference maturity keydate
ACMSnapshotDate null
ACMSnapshotFromDate null
ACMSnapshotToDate null
Column Name Description
IsIntercompanyTransfer Intercompany Transfer Show values
HasError Flag: Error occured Show values
MTMDataSourceType Type of Data Record Show values
MTMConditionGroupCategory Categorization of Condition Group Show values
MTMAdjustmentType Type of adjustment for the MtM or TPL calculation Show values
PricingStatus Future/Basis Price Fixation Status Show values
ConditionTermRateIsFixed Indicates that the term is fixed Show values
CmmdtyForwardIndexTiming Timing/Periodicity of Commodity Forward Indexes Show values
ConditionTermExchRateIsFixed Indicates that the term is fixed Show values
Column Name Description Domain name
EndOfDaySnapshotDateTimeTo Timestamp defining a End-of-day snapshot TZNTSTMPS
EndOfDaySnapshotDateTimeFrom Timestamp defining a End-of-day snapshot TZNTSTMPS
CompanyCodeName Name of Company Code or Company TEXT25
ProfitCenter Profit Center PRCTR
PlantName Plant Name TEXT30
CommodityName Commodity Description TEXT40
MaterialName Product Description TEXT40
OriginReferenceDocument Root Document CMM_MTM_OBJID
SourceDocument Source Document CMM_MTM_OBJID
SourceDocumentItem Source Document Item
SourceDocumentBusObjTypeName Name TEXT20
IncotermsClassificationName Description TEXT30
IncotermsTransferLocation Incoterms (Part 2) INCO2
ConditionApplication Application KAPPL
PricingProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
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
ConditionTermRate Term Rate
MarketToDocExchRate Exchange Rate: Market to Document Currency
DocToStatisticalExchRate Exchange Rate: Document to Statistics Currency
ConditionTermValueInDocCrcy Value in Document Currency
CompanyCode Company Code BUKRS
Commodity Commodity TBA_STOEFFCHEN
Material Material Number MATNR
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
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
SystemMessageText Message Text NATXT
PhysicalCommodity Physical Commodity TBA_STOEFFCHEN
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
StorageLocation Storage location LGORT
Batch Batch Number CHARG
GoodsMovementType Movement type (inventory management) BWART
IncotermsClassification Incoterms (Part 1) INCO1
BusinessArea Business Area GSBER
PurchasingOrganization Purchasing organization EKORG
MaterialGroup Material Group MATKL
BasisID Basis ID TBAC_BASIS_ID
SystemMessageNumber System Message Number
MTMCalculationGroup MtM Calculation Group CMM_MTM_CGROUP
MTMConditionGroup MtM Condition Group CMM_MTM_CGROUP
ConditionTermFactor CPE condition type term factor
SourceDocumentBusObjType Source Document Business Object Type
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
MarketIdentifierCode Market Identifier Code TBA_MIC
Trader Responsible Trader ID /ACCGO/D_TRADER_ID