P_CmmdtyStockValue_Final

Stock value final view | view: PCMMDTYSTKVALUEF | Extraction: Not supported | Component: Basic Functions
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
VersStockRecordUUID GUID assigned to the VlogP stock delta record
ValuationDate Latest Evaluation Date
EndOfDaySnapshotDate Snapshot Date
Column Name Description
💲 Price Currency (ConditionTermRateCurrency):
ConditionTermRate Price
💲 SD Document Currency (DocumentCurrency):
ConditionTermValueInStstcCrcy Value in Statistical Currency
💲 Market Price Currency (MarketPriceCurrency):
PrevVersionConditionTermValue CPE Term - Value
Column Name Description
📏 Unit of Measure for Commodity (CommodityUnit):
CommodityQuantity Commodity Quantity
PrevVersionCommodityQuantity Open Commodity Quantity
CmmdtyPriceExpsrQtyInMassUnit Open Commodity Quantity In MASS
CmmdtyPriceExpsrQtyInVolUnit Open Commodity Quantity In Volume
PricedContractQuantity Priced Contract Quantity
UnpricedContractQuantity Unpriced Contract Quantity
TodayPricedQuantity Today Unpriced Not Realized Quantity
PricedContractQuantityInMass Priced Quantity(Mass UoM)
UnpricedContractQuantityInMass Unpriced Quantity(Mass UoM)
TodayPricedQuantityInMass Today Quantity(Mass UoM)
PricedContractQuantityInVol Priced Quantity(Volume UoM)
UnpricedContractQuantityInVol Unpriced Quantity(Volume UoM)
TodayPricedQuantityInVol Today Quantity(Volume UoM)
📏 Price UoM (ConditionTermRateQuantityUnit):
CommodityQuantityInTermUnit Commodity Quantity in Price Unit
Column Name Description
ValuationDate Latest Evaluation Date
EndOfDaySnapshotDate Snapshot Date
ValidityStartDate Last Changed Date
ValidityStartDateTime Valid-From Time
DeliveryDate Delivery Date
ExpectedPaymentDate Payment Date
ExchRateEvaluationDate Exchange Rate Evaluation Date
DocToStstcCrcyExchRateEvalDate Document to Statistics Currency Evaluation Date
QuotationPeriodReferenceDate Reference Date
MaturityKeyDate Maturity Key Date
OldestQuotationDate Oldest Quotation 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
BasisMarketRefKeyDate Basis Market reference maturity keydate
quotationperiodstartdate Start Date of Quotation Period
quotationperiodenddate End Date of Quotation Period
Column Name Description
MTMDataSourceType Type of Data Record Show values
DataSelectionType VLOGP Data Selection Type Show values
IsIntercompanyTransfer Intercompany Transfer Show values
HasError Flag: Error occured 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 term is fixed Show values
PricingStatus Future/Basis Price Fixation Status Show values
ContrPriceExposureIsExecuted Indicates that the goods movement has been executed Show values
cmmdtyforwardindextiming Timing/Periodicity of Commodity Forward Indexes Show values
Column Name Description Domain name
EndOfDayBusinessEntityKey Key of an Business Entity End-of-day snapshot:Char format
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
EndOfDaySnapshotDateTimeFrom Timestamp defining a End-of-day snapshot TZNTSTMPS
EndOfDaySnapshotDateTimeTo Timestamp defining a End-of-day snapshot TZNTSTMPS
CompanyCode Company Code BUKRS
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
Creditor Account Number of Supplier LIFNR
SoldToParty Customer Number KUNNR
Material Material Number MATNR
PhysicalCommodity Commodity TBA_STOEFFCHEN
Plant Plant WERKS
StorageLocation Storage location LGORT
Batch Batch Number CHARG
GoodsMovementType Movement type (inventory management) BWART
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsTransferLocation Incoterms (Part 2) INCO2
ConditionApplication Application KAPPL
SourceDocumentShortNumber Document CMM_DOCUMENT_CHAR10
SourceDocument Source Document CMM_MTM_OBJID
SourceDocumentItem Source Document Item
SourceDocumentBusObjType Source Document Business Object Type
OrignRefDocumentShortNumber Root Document CMM_DOCUMENT_CHAR10
OriginReferenceDocument Root Document CMM_MTM_OBJID
OriginReferenceDocBusObjType Root Document (BOR) Object Type OJ_NAME
OriginReferenceDocumentItem Root Document Item CMM_VLOGP_ROOT_ITEM
ReferenceDocument Predecessor Document CMM_MTM_OBJID
ReferenceDocumentItem Predecessor Document Item CMM_VLOGP_REF_ITEM
ReferenceDocBusObjType Ref (BOR) Object Type OJ_NAME
DeliveryYear Abjusted Reporting Year
DeliveryMonth Adjusted Reporting Month CHAR3
ProfitCenter Profit Center PRCTR
BusinessArea Business Area GSBER
PurchasingOrganization Purchasing organization EKORG
MaterialGroup Material Group MATKL
MarketToDocExchRate Exchange Rate: Market to Document Currency
MarketToDocFrozenExchRate Exchange Rate: Market to Document Currency at a Key Date
ConditionTermRateQuantity Price Unit
ConditionTermValueInDocCrcy Value in Document Currency
DocToStatisticalExchRate Exchange Rate: Document to Statistics Currency
BasisID Basis ID TBAC_BASIS_ID
BasisType Basis Type TBAC_BASIS_TYPE
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
MarketIdentifierCode Market Identifier Code TBA_MIC
DerivativeContractMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
QuotationPriceType Type of Price Quotation VVSKURSART
SystemMessageNumber System Message Number
MTMConditionGroup MtM Condition Group CMM_MTM_CGROUP
MTMCalculationGroup MtM Calculation Group CMM_MTM_CGROUP
MTMCalcGrpMarketPriceCondition Market Price Condition within a calculation group KSCHL
ConditionTermRateFixation Fixation ID
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
ConditionTermFactor CPE condition type term factor
pnldatatype Character Field with Length 5 CHAR005
PreviousVersionQuantitySign Sign of Quantity CMM_VLOGP_SIGNAGE_QTY
PricedDays Number of priced quotation days until latest evaluation date CMM_NUMBEROFDAYS
UnpricedDays No of unpriced quotation days after latest evaluation date CMM_NUMBEROFDAYS
TodayDays Number of today's priced quotation days at latest eval. date CMM_NUMBEROFDAYS
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