I_VersionedLogcDocument

Versioned pricing data of logistic docs | view: IVERSLOGDOC | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: CMM_VLOGP
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
💲 CPE Term - Currency (ConditionTermValueCurrency):
ConditionRateAmount Condition Amount or Percentage
ConditionTermValue CPE Term - Value
PrevVersionConditionTermValue CPE Term - Value
Column Name Description
📏 Unit of Measure for Commodity (CommodityUnit):
CommodityQuantity Open Commodity Quantity
📏 CPE Term - Unit of Measure (ConditionTermRateQuantityUnit):
CommodityQuantityInTermUnit Open Commodity Quantity
📏 QuantityVolume UoM (CmmdtyPriceExpsrVolumeUnit):
PrevVersionCommodityQuantity Open Commodity Quantity
ComparativeCmmdtyQtyInTermUnit Commodity Quantity in Price Unit
CmmdtyPriceExpsrQtyInVolUnit Open Commodity Quantity In Volume
📏 Mass Unit of Measure (CmmdtyPriceExpsrMassUnit):
CmmdtyPriceExpsrQtyInMassUnit Open Commodity Quantity In MASS
Column Name Description
ValidityStartDate Valid-From Date
ValidityEndDate Valid-To Date
ValidityStartTime Valid-From Time
ValidityEndTime Valid-To Time
DeliveryPeriodStartDate Start of Delivery Period for which the Market Norm applies
DeliveryPeriodEndDate End of Delivery Period for which the Market Norm applies
DeliveryDate Delivery Date
ExpectedPaymentDate Payment Date
QuotationPeriodReferenceDate Reference Date
CmmdtyLtstEvaluationKeyDate Latest Evaluation Date
QuotationPeriodStartDate Start Date of Quotation Period
QuotationPeriodEndDate End Date of Quotation Period
MaturityKeyDate Maturity Key Date
CndnTermRateFixationDate Rate Fixation Date
CndnTermRateFixationTime Rate Fixation Time
CndnTermExchRateFixationDate FX Fixation Date
CndnTermExchRateFixationTime FX Fixation Time
FixedExchRateDate Date when forward FX rate is frozen
ExchRateMaturityDate Maturity Date of Exchange Rate
OldMarketNormMaturityKeyDate Maturity Key Date
NewMarketNormMaturityKeyDate Second Maturity Key Date in a Spread Pair
ReferenceEvaluationKeyDate Reference Evaluation Key Date
DCSReportingDate Reporting Date
Column Name Description
MTMDataSourceType Type of Data Record Show values
IsIntercompanyTransfer Intercompany Transfer Show values
ConditionCalculationType Calculation Type for Condition Show values
ConditionTermRateIsRounded Indicates whether the term rate is rounded Show values
ConditionTermExtensionUsage CPE Extension Usage Show values
CmmdtyForwardIndexTiming Timing/Periodicity of Commodity Forward Indexes Show values
MaturitySelectionType Maturity Selection Type Show values
QuotationKeyType Quotation Key Type in Document UI (all values) Show values
QuotationGroupCalculationRule Quotation Group Operation Show values
PricingStatus Future/Basis Price Fixation Status Show values
MTMConditionGroupCategory Categorization of Condition Group Show values
MTMAdjustmentType Type of adjustment for the MtM or TPL calculation Show values
ConditionTermRateIsFixed Indicates that the term is fixed Show values
ConditionTermExchRateIsFixed Indicates that the Foreign Exchange Rate is fixed Show values
PriceIsRealized Indicates that the MtM value is realized Show values
FixedSpreadIsInverted Fixed Spread needs to be inversed Show values
PnLEvaluationPeriod PnL Evaluation Period Show values
PrevVersCndnTermRateIsFixed Indicates that the term is fixed Show values
PrevVersCndnTrmExchRateIsFixed Indicates that the Foreign Exchange Rate is fixed Show values
ComparativePricingStatus Future/Basis Price Fixation Status Show values
TreasuryContractType Contract Type Show values
TreasuryPositionLongShortCode Short/Long Indicator Show values
DCSPeriodType Period Type Show values
CommodityPriceFixationStatus Future/Basis Price Fixation Status Show values
ContrPriceExposureIsExecuted Indicates that the goods movement has been executed Show values
ImplicitFixationIsRelevant Implicit Fixation Relevant Show values
ComparImplicitFixationIsRlvt Implicit Fixation Relevant Show values
FixedCalculationType FX Fixation Calculation Type Term to Document Currency Conv Show values
SkipReportingIndicatorIsSet Skip reporting Show values
Column Name Description Domain name
SourceTransactionEventDateTime Valid-From Timestamp TZNTSTMPS
SourceTransacEventEndDateTime Valid-To Timestamp TZNTSTMPS
EndOfDayBusinessEntityKey Key of an Business Entity requiring an End-of-day snapshot
MarketNormBusinessEntityKey Entity Key determining the Market Norm
SpreadBusinessEntityKey Business Entity Key for Spreads
MaximumVersion Highest Version Number CMM_MTM_VERSION
PreviousVersion Version of an MtM Valuation Record CMM_MTM_VERSION
PrevVersionSubConditionType The key of a sub-condition type CMM_VLOGP_SUBKEY
CompanyCode Company Code BUKRS
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
Creditor Vendor's account number LIFNR
SoldToParty Sold-to Party KUNNR
Material Material Number MATNR
PhysicalCommodity Commodity TBA_STOEFFCHEN
Plant Plant WERKS
StorageLocation Storage location LGORT
Batch Batch Number CHARG
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsTransferLocation Incoterms (Part 2) INCO2
ConditionApplication Application KAPPL
SourceDocumentShortNumber Document CMM_DOCUMENT_CHAR10
SourceDocument Document CMM_MTM_OBJID
SourceDocumentBusObjType Document (BOR) Object Type OJ_NAME
OrignRefDocumentShortNumber Root Document CMM_DOCUMENT_CHAR10
OriginReferenceDocument Root Document CMM_MTM_OBJID
OriginReferenceDocumentItem Root Document Item CMM_VLOGP_ROOT_ITEM
OriginReferenceDocBusObjType Root Document (BOR) Object Type OJ_NAME
ReferenceDocument Predecessor Document CMM_MTM_OBJID
ReferenceDocumentItem Predecessor Document Item CMM_VLOGP_REF_ITEM
ReferenceDocBusObjType Ref (BOR) Object Type OJ_NAME
ProfitCenter Profit Center PRCTR
BusinessArea Business Area GSBER
PurchasingOrganization Purchasing organization EKORG
MaterialGroup Material Group MATKL
ConditionQuantity Condition Pricing Unit KPEIN
QuotationPriceType Type of Price Quotation VVSKURSART
ConditionTermRate Term Rate
ConditionTermRateQuantity CPE Term - Price Unit CPE_PRUN
ConditionTermName Description TEXT40
ConditionTermStatus CPE Term - Status CPE_TERMSTATUS
RoundingDecimalPlaces Decimals of Calculated Term/Formula Rate INT1
ConditionTermRateNmrtr Rate factor numerator
ConditionTermRateDnmntr Rate factor denominator
CommodityCurve GMDACC Key CHAR40
QuotationDateList The key of a date list CHAR40
FutureRefQuotationDateList The key of a date list CHAR40
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
MarketIdentifierCode Market Identifier Code TBA_MIC
DerivativeContractMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
BasisID Basis ID TBAC_BASIS_ID
BasisType Basis Type TBAC_BASIS_TYPE
QuotationGroup Quotation Group (Technical Key Field) CHAR40
ConditionTermRateFixation CPE Term - Number in Formula NUMC5
MarketDataAccessKey A key required to access market data CHAR40
MinimumConditionTermLimitRate Minimum of Commodity Rate Calculation
MaximumConditionTermLimitRate Maximum of Commodity Rate Calculation
ConditionTermLimitRateQuantity CPE Term - Price Unit of Rate Calculation Limits CPE_PRUN
QuantitySign Sign of Quantity CMM_VLOGP_SIGNAGE_QTY
MTMConditionGroup MtM Condition Group CMM_MTM_CGROUP
MTMCalculationGroup MtM Calculation Group CMM_MTM_CGROUP
MTMCalcGrpMarketPriceCondition Market Price Condition within a calculation group KSCHL
PreviousVersionQuantitySign Sign of Quantity CMM_VLOGP_SIGNAGE_QTY
PrevVersionConditionTermRate Term Rate
PrevVersMktToDocSrceCnvrsnFctr CPE - From-Factor for Conversion CPE_CONVFACTOR
PrevVersMktDocTgtCnvrsnFctr CPE - To-Factor for Conversion CPE_CONVFACTOR
PrevVersDocStstcSrceCnvrsnFctr CPE - From-Factor for Conversion CPE_CONVFACTOR
PrevVersDocStstcTgtCnvrsnFctr CPE - To-Factor for Conversion CPE_CONVFACTOR
FinancialInstrumentProductType Product Type VVSART
FinancialInstrTransactionType Financial Transaction Type T_SFHAART
BusinessPartner Business Partner Number BU_PARTNER
SecurityClass Security Class ID Number WP_RANL
NumberOfCommodityContracts No. of Units for Financial Instruments ASTUECK
TreasuryPositionAccount Futures Account for Listed Options and Futures CMM_POS_ACCOUNT_FUT
MaturitySelectionRoutine Maturity Selection Routine CPE_ROUTINE
TimeToMaturity Time to Maturity TBA_TENOR
ComparCndnTermFactorNumerator Term Factor num for quantity based on the comb rout
ComparCndnTrmFctrDenominator Term Factor deno for quantity based on the comb rout
ComparMinCndnTermLimitRate Minimum of Commodity Rate Calculation
ComparMaxCndnTermLimitRate Maximum of Commodity Rate Calculation
ConditionTermFactorNumerator Term Factor num for quantity based on the comb rout
ConditionTermFactorDenominator Term Factor deno for quantity based on the comb rout
CreationDateCharacterValue Latest Evaluation Key Timestamp CMM_LATEST_EVAL_KEYDATETIME
MarketToTermExchangeRateType Exch. Rate Type for Conversion from Market to Term Currency KURST
ConditionToDocExchangeRateType Exch. Rate Type for Conv. from Condition to Document Crcy KURST
DocToStstcExchangeRateType Exch Rate Type for Conv. from Document to Statistics Crcy KURST
CndnToStstcExchangeRateType Exch. Rate Type for Conv. from Condition to Stat. Crcy KURST
ExchangeRateType Exchange Rate Type KURST
OldScore Factor From: Quotation UoM to Term UoM CPE_CONVFACTOR
NewScore Factor To: Quotation UoM to Term UoM CPE_CONVFACTOR
ThresholdValueLow FX Fixation From-Factor Term to Document Currency Conv CPE_CONVFACTOR
ThresholdValueHigh FX Fixation To-Factor Term to Document Currency Conv CPE_CONVFACTOR
NumberOfDaysInQuotationPeriod null
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
Master Data Relations Join Conditions
Market Identifier Code
  • Market Identifier Code
  • Client
  • I_VERSIONEDLOGCDOCUMENT.FUTUREREFMARKETIDENTIFIERCODE == TBAC_MIC.MIC
  • I_VERSIONEDLOGCDOCUMENT.MANDT == TBAC_MIC.CLIENT
Profit and Loss Event Type
  • Profit and Loss Event Type
  • Client