P_ACMContractMtMValue

Business Logic for Contract MtM | view: PACMMTMCONTRVAL | Extraction: Not supported | Component: Application and Call Off
Tables used: CMM_LOGSYNC, MARM, CMM_UOM_CONV, CMM_VLOGP, TBAC_PHYSCOMM, T006, T006A
Column Name Description
PricingKey A key required to access versioned pricing data
ACMPricingVersion Version of an MtM Valuation Record
PricingDocumentItem Condition item number
ConditionType Condition Type
SubConditionType The key of a sub-condition type
VersStockRecordUUID GUID assigned to the VlogP stock delta record
EndOfDaySnapshotDate Snapshot Date
CommodityPriceExposure Commodity Price Exposure ID
CommodityExposureCategory Exposure Category Show values
CommodityPriceSubExposure Hash key
Column Name Description
💲 Price Currency (ConditionTermRateCurrency):
ConditionTermRate Price
💲 Statistics Currency (StatisticsCurrency):
ConditionTermValueInStstcCrcy Value in Statistical Currency
Column Name Description
📏 Mass Unit of Measure (CmmdtyPriceExpsrMassUnit):
CmmdtyPriceExpsrQtyInMassUnit Open Commodity Quantity In MASS
📏 QuantityVolume UoM (CmmdtyPriceExpsrVolumeUnit):
CmmdtyPriceExpsrQtyInVolUnit Open Commodity Quantity In Volume
📏 Unit of Measure of Commodity (PhysicalCommUOM):
CommodityQuantity Commodity Quantity
Column Name Description
EndOfDaySnapshotDate Snapshot Date
ValuationDate Latest Evaluation Date
ValidityStartTime Valid-From Time of Commodity Derivative
ValidityEndDate Valid-To Date of Commodity Derivative
ValidityEndTime Valid-To Time of Commodity Derivative
ExposureDueDate Date on which the exposure is due and expires
ReportingDate Reporting Date
TermStartDate Term Start
TermEndDate Term End
EvaluationDate null
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
Column Name Description
CommodityExposureCategory Exposure Category Show values
CashFlowDirection Transaction Flow Direction Show values
TreasuryPositionLongShortCode Code: Long or Short Position Show values
OptionPutCallCode Put/Call Indicator Show values
OptionExerciseType Exercise Type (American or European) Show values
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
ValidityStartDateTime Valid-From Timestamp of Commodity Derivative TZNTSTMPS
ValidityEndDateTime Valid-To Timestamp of Commodity Derivative TZNTSTMPS
MaximumVersion Highest Version Number CMM_MTM_VERSION
TimeToMaturity Time to Maturity TBA_TENOR
FinancialInstrProductCategory Product Category VVSANLF
FinancialAssetsMgmtProductType Product Type VVSART
FinInstrTransactionCategory Transaction Category T_SFGTYP
FinancialInstrumentProductType Financial Transaction Type T_SFHAART
FinancialInstrActivityCategory Transaction Activity Category T_SFGZUTY
FinancialObject Financial Object Number J_OBJNR
PnLEventType Profit and Loss Event Type CMM_EVENT
NumberOfCommodityContracts Number of Contracts ASTUECK
TreasuryPositionAccount Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT
DerivativeContract Contract for Listed Options and Futures WP_RANL
OptionStrikePrice Option Strike Price
ExternalKeyFigureValue External Key figures
OptionDeltaFactorKeyFigure Option Delta Factor CMM_EVAL_OPTION_DELTA_FACTOR
OptionDeltaFactor Option Delta Factor Value CDS_OPTION_DELTA_FACTOR
MTMDataSelectionType null
HasErrorDescription Error Description
CmmdtyQtyinPhyUOM null
CmmdtyQtytermUnitInMassUnit null
CmmdtyQtytermUnitInVolUnit null
PhysicalCommodity Physical Commodity TBA_STOEFFCHEN
EndOfDaySnapshotDateTimeTo Timestamp defining a End-of-day snapshot TZNTSTMPS
EndOfDaySnapshotDateTimeFrom Timestamp defining a End-of-day snapshot TZNTSTMPS
ProfitCenter Profit Center PRCTR
OriginReferenceDocument Root Document CMM_MTM_OBJID
SourceDocument Source Document CMM_MTM_OBJID
SourceDocumentItem Source Document Item
IncotermsTransferLocation Incoterms (Part 2) INCO2
ConditionApplication Application KAPPL
PricingProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
DerivativeContractMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
ConditionTermRateFixation Fixation ID
CommodityQuantityInTermUnit null
MarketToDocExchRate Exchange Rate: Market to Document Currency
DocToStatisticalExchRate Exchange Rate: Document to Statistics Currency
ConditionTermValueInDocCrcy Value in Document Currency
CompanyCode Company Code BUKRS
Material Material Number MATNR
Plant Plant WERKS
Creditor Account Number of Supplier LIFNR
SoldToParty Customer Number KUNNR
Commodity Commodity TBA_STOEFFCHEN
OriginReferenceDocBusObjType Root Document (BOR) Object Type OJ_NAME
OriginReferenceDocumentItem Root Document Item CMM_VLOGP_ROOT_ITEM
ReferenceDocument Reference document number AWREF
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
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
ConditionTermFactor CPE condition type term factor
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
MarketIdentifierCode Market Identifier Code TBA_MIC
MTMConditionGroup MtM Condition Group CMM_MTM_CGROUP
SourceDocumentBusObjType Source Document Business Object Type
Master Data Relations Join Conditions
Mass Unit of Measurement
  • Client
  • Mass Unit of Measurement
  • P_ACMCONTRACTMTMVALUE.MANDT == T006.MANDT
  • P_ACMCONTRACTMTMVALUE.CMMDTYQTYTERMMASSUNIT == T006.MSEHI
Volume Unit of Measurement
  • Client
  • Volume Unit of Measurement
  • P_ACMCONTRACTMTMVALUE.MANDT == T006.MANDT
  • P_ACMCONTRACTMTMVALUE.CMMDTYQTYTERMVOLUNIT == T006.MSEHI
Unit of Measure of Commodity
  • Client
  • Unit of Measure of Commodity
  • P_ACMCONTRACTMTMVALUE.MANDT == T006.MANDT
  • P_ACMCONTRACTMTMVALUE.PHYSICALCOMMUOM == T006.MSEHI