I_CmmdtyPhysPosQtyCube

Commodity Position Report Physical Cube | view: ICMDTYPOSREPCUBE | TRAN | 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
EvaluationDate Latest Evaluation Date
PriceQuotationDate Date of Price Quotation
Column Name Description
💲 CPE Term - Currency (ConditionTermValueCurrency):
ConditionTermValue CPE Term - Value
Column Name Description
📏 Material Stock Unit of Measure (MaterialStockPriceExposureUnit):
CommodityQuantity Open Commodity Quantity
CommodityQuantityInTermUnit null
OnHandStockQuantity Stock on Hand
UnrealizedGoodsRcptPrcExpsrQty Unrealized Goods Receipt Quantity
UnrealizedGoodsIssPrcExpsrQty Unrealized Goods Issue Quantity
OutrightPriceExposureQty Outright Exposure Quantity
📏 Unit of Measure for Commodity (CommodityUnit):
CommodityPriceExposureQuantity null
UnrealizedPriceExposureQty Not Realized Quantity
UnpricedUnrealizedPrcExpsrQty Unpriced Not Realized Quantity
TodayUnpricedUnrlzdCtrExpsrQty Today Unpriced Not Realized Quantity
PricedContractsExposureQty Priced Contract Quantity
UnpricedContrPriceExposureQty Unpriced Contract Quantity
UnrlzdMarketPriceExposureQty Unrealized Market Exposure Quantity
UnpricedUndeliveredCtrExpsrQty Unpriced Undelivered Contract Quantity
UnpricedDeliveredCtrExpsrQty Unpriced Delivered Contract Quantity
PricedUndeliveredContrExpsrQty Priced Undelivered Contract Quantity
PricedDeliveredContrExpsrQty Priced Delivered Contract Quantity
UndeliveredMarketPrExposureQty Undelivered Market Exposure Quantity
DeliveredMarketPrExposureQty Delivered Market Exposure
ReducnNoPrcEstablishedExpsrQty Reducing NPE Quantity
NoFutureEstabPurchaseContrQty NFE Purchase Contracts Quantity
NoFutureEstabSalesContrQty NFE Sales Contracts Quantity
FlatPricedContractsQty FLAT Contracts Quantity
NoFutrEstablishedContrExpsrQty NFE Contracts Quantity
NoBsEstablishedContrExpsrQty NBE Contracts Quantity
NoPrcEstablishedContrExpsrQty NPE Contracts Quantity
FixPricedDelivsPriceExpsrQty Priced Delivered Quantity
UndeliveredFixPrCtrPrExpsrQty Undelivered Not Realized Contract Quantity
UnpricedUnrlzdGdsIssExpsrQty Unpriced Not Realized GR Quantity
UnpricedUnrlzdGdsRcptExpsrQty Unpriced Not Realized GR Quantity
TodayPricedUndeliveredExpsrQty Today Priced Undelivered Quantity
FixPricedContrPriceExpsrQty Fix Priced Contract Quantity
TodayPricedContractsExpsrQty Today Priced Contracts Exposure Quantity
GoodsReceiptQuantity Not Realized Quantity
RealizedMaterialStkPrcExpsrQty Realized Stock Quantity
InventoryAndContractsQty Inventory and Contracts Quantity
TotalPhysicalPositionQty Total Physical Position quantity
ImpliedFuturesPositionQty Implied Futures Position Quantity
BasisPositionQty Basis Position Quantity
Column Name Description
EvaluationDate Latest Evaluation Date
PriceQuotationDate Date of Price Quotation
EndOfDaySnapshotFromDate Evaluation Date
EndOfDaySnapshotToDate Prev. Evaluation Date (to be compared with Evaluation Date)
ValidityStartDate Valid-From Date
ValidityStartDateTime Valid-From Time
ValidityEndDate Valid-To Date
ValidityEndDateTime Valid-To Time
EndOfDaySnapshotDate Snapshot Date
DeliveryDate Delivery Date
ExpectedPaymentDate Payment Date
QuotationPeriodReferenceDate Reference 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
ReportingDate Reporting Date
AdjustedReportingDate Adjusted Reporting Date
Column Name Description
MTMDataSelectionType VLOGP Data Selection Type Show values
MTMDataSourceType Type of Data Record Show values
IsIntercompanyTransfer Intercompany Transfer Show values
ConditionTermRateIsRounded Indicates whether the term rate is rounded Show values
ConditionTermExtensionUsage CPE Extension Usage 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
ConditionTermLimitRateStatus Pricing Status for Rate Limit Show values
MTMConditionGroupCategory Categorization of Condition Group Show values
MTMAdjustmentType Type of adjustment for the MtM or TPL calculation Show values
DisplayUnitOfMeasure View Variant Show values
PriceIsRealized Indicates that the MtM value is realized Show values
ContrPriceExposureIsExecuted Indicates that the goods movement has been executed Show values
CommodityPriceFixationStatus Future/Basis Price Fixation Status Show values
ImplicitFixationIsRelevant Implicit Fixation Relevant Show values
ConditionTermRateIsFixed Indicates that the term is fixed Show values
Column Name Description Domain name
SourceTransactionEventDateTime Valid-From Timestamp TZNTSTMPS
SourceTransacEventEndDateTime Valid-To Timestamp TZNTSTMPS
EndOfDaySnapshotDateTimeFrom Timestamp defining a End-of-day snapshot TZNTSTMPS
EndOfDaySnapshotDateTimeTo Timestamp defining a End-of-day snapshot TZNTSTMPS
MaximumVersion Highest Version Number CMM_MTM_VERSION
PreviousVersion Version of an MtM Valuation Record CMM_MTM_VERSION
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
SourceDocument Document CMM_MTM_OBJID
SourceDocumentBusObjType Document Type OJ_NAME
OriginReferenceDocument Root Document CMM_MTM_OBJID
OriginReferenceDocumentItem Root Document Item CMM_VLOGP_ROOT_ITEM
OriginReferenceDocBusObjType Root Document Type OJ_NAME
ReferenceDocument Predecessor Document CMM_MTM_OBJID
ReferenceDocumentItem Predecessor Document Item CMM_VLOGP_REF_ITEM
ReferenceDocBusObjType Predecessor Document Type OJ_NAME
ProfitCenter Profit Center PRCTR
BusinessArea Business Area GSBER
PurchasingOrganization Purchasing organization EKORG
MaterialGroup Material Group MATKL
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
QuotationDateList The key of a date list CHAR40
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
MarketIdentifierCode Market Identifier Code TBA_MIC
BasisType Basis Type TBAC_BASIS_TYPE
BasisID Basis ID TBAC_BASIS_ID
QuotationGroup Quotation Group (Technical Key Field) CHAR40
ConditionTermRateFixation CPE Term - Number in Formula NUMC5
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
ReportingYear Reporting Year
ReportingMonth Reporting Period TEM_PLANNING_PERIOD
AdjustedReportingYear Abjusted Reporting Year
AdjustedReportingMonth Adjusted Reporting Month CHAR3
GoodsMovement Document CMM_MTM_OBJID