P_Cpe_T_Rate_Stock_Deltaqty

Adapted Quantity by Stock Delta Records | view: PCPETRATESTOD | Extraction: Not supported | Component: Basic Functions
Tables used: CMM_DEND_RUN, CMM_VLOGP_KONVD, CMM_FIX_SPREAD, CMM_GMDA, CMM_GMDACC, CMM_GMDAFX, CMM_MARKET_ROLL, CMM_QUOTGRPITEM, CMM_VLOGP_TSER, CMM_VLOGP, CMM_VLOGP_CONV_C, CMM_VLOGP_CONV_U
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
FXvaluationDate Evaluation Key Date
FXvaluationDateDocToStstc Snapshot Date
Scenario null
Column Name Description
💲 CPE Term - Currency (ConditionTermValueCurrency):
OldConditionTermValue CPE Term - Value
ConditionTermValue CPE Term - Value
💲 null (QuotationCurrency):
PrevVersionConditionTermValue CPE Term - Value
Column Name Description
📏 Unit of Measure for Commodity (CommodityUnit):
CommodityQuantity Open Commodity Quantity
PrevVersionCommodityQuantity Open Commodity Quantity
📏 CPE Term - Unit of Measure (ConditionTermRateQuantityUnit):
CommodityQuantityInTermUnit null
📏 null (MaterialBaseUnit):
CommodityQuantityInBaseUnit null
Column Name Description
valuationDate Latest Evaluation Date
FXvaluationDate Evaluation Key Date
FXvaluationDateDocToStstc Snapshot Date
SnapshotDate0 null
SnapshotDate1 null
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
MarketToDocExchrateDate null
QuotationPeriodReferenceDate Reference 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
MaturityKeyDate null
OldestQuotationDate null
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
QuotationKeyType Quotation Key Type in Document UI (all values) 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
ConditionTermExchRateIsFixed Indicates that the Foreign Exchange Rate is fixed Show values
Column Name Description Domain name
DataSelectionType null
SourceTransactionEventDateTime Valid-From Timestamp TZNTSTMPS
SourceTransacEventEndDateTime Valid-To Timestamp TZNTSTMPS
EndOfDayTimestampFrom Timestamp defining a End-of-day snapshot TZNTSTMPS
EndOfDayTimestampTo Timestamp defining a End-of-day snapshot TZNTSTMPS
EndOfDayBusinessEntityKey Key of an Business Entity requiring an End-of-day snapshot
MaximumVersion Highest Version Number CMM_MTM_VERSION
PreviousVersion Version of an MtM Valuation Record CMM_MTM_VERSION
PreviousSubConditionType 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
GoodsMovementType Movement type (inventory management) BWART
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsTransferLocation Incoterms (Part 2) INCO2
ConditionApplication Application KAPPL
SourceDocument Document CMM_MTM_OBJID
SourceDocumentItem Condition item number NUM6
SourceDocumentBusObjType Document (BOR) Object Type OJ_NAME
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
ConditionTermRate null
ConditionTermRateConv null
OldConditionTermrate Term Rate
MarketToDocExchrate null
MarketToDocFrozenExchrate null
ConditionTermRateQuantity CPE Term - Price Unit CPE_PRUN
ConditionTermName Description TEXT40
ConditionTermStatus CPE Term - Status CPE_TERMSTATUS
RoundingDecimalPlaces Decimals of Calculated Term/Formula Rate INT1
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
BasisID null
BasisType null
QuotationGroup Quotation Group (Technical Key Field) CHAR40
DerivativeContrSpecification null
MarketIdentifierCode null
CommodityContractMaturityCode null
QuotationPriceType null
QuantitySign Sign of Quantity CMM_VLOGP_SIGNAGE_QTY
ValueSign null
MTMConditionGroup MtM Condition Group CMM_MTM_CGROUP
MTMCalculationGroup MtM Calculation Group CMM_MTM_CGROUP
MTMCalcGrpMarketPriceCondition Market Price Condition within a calculation group KSCHL
ConditionTermRateFixation CPE Term - Number in Formula NUMC5
SystemMessageNumber null
PnLDataType null
PreviousVersionQuantitySign Sign of Quantity CMM_VLOGP_SIGNAGE_QTY