P_CmmdtyNewActPnLValue_Sum

PnL New Activity Calculation of Calculated Key Figures | view: PCMMPNLNASUM | 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
Column Name Description
💲 Condition Term Rate Currency (ConditionTermRateCurrency):
PnLValue PnLValue
MktPricePnLValue PnL Price Value
SpreadPnLValue PnL Spreads Value
DocToStstcFXPnLValue PnL Document to Statistics FX Value
MktToStstcFXPnLValue PnL Market to Statistics FX Value
ComparMktAdjmtValCndnTermValue CPE Term - Value
ConditionRate Condition Amount or Percentage
Column Name Description
📏 Price UoM (ConditionTermRateQuantityUnit):
CommodityQuantityInTermUnit Commodity Quantity in Price Unit
ComparativeCmmdtyQtyInTermUnit Comparative Contract Commodity Qty in Term Unit of Measure
PnLCalculationRelevantQuantity PnLRelevantTermQty
PnLCalcRelevantMarketQuantity PnL Calculation Relevant Market Rate Quantity
ContrCmmdtyQtyInTermUnit Commodity Quantity in Price Unit
ComparContrCmmdtyQtyInTrmUnit Comparative Contract Commodity Qty in Term Unit of Measure
CmmdtyPriceExpsrQtyInMassUnit Open Commodity Quantity In MASS
CmmdtyPriceExpsrQtyInVolUnit Open Commodity Quantity In Volume
📏 Unit of Measure for Commodity (CommodityUnit):
CommodityQuantity Commodity Quantity
Column Name Description
EvaluationDate Evaluation Key Date
ComparativeEvaluationDate 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
DeliveryDate Delivery Date
ExpectedPaymentDate Payment Date
ExchRateMaturityDate Maturity Date
FixedExchRateDate Date when forward FX rate is frozen
QuotationPeriodReferenceDate Reference Date
QuotationPeriodStartDate Start Date of Quotation Period
QuotationPeriodEndDate End Date of Quotation Period
ComparMktMaturityKeyDate Market Maturity Key Date
ContractMaturityKeyDate Contract Maturity Key Date
CndnTermRateFixationDate Rate Fixation Date
CndnTermRateFixationTime Rate Fixation Time
CndnTermExchRateFixationDate FX Fixation Date
CndnTermExchRateFixationTime FX Fixation Time
Column Name Description
PNLEventGroup Profit and Loss Event Group Show values
ContrCndnTrmRateIsFxd Indicates that the term is fixed Show values
ComparativeCndnTrmRateIsFixed Indicates that the term is fixed Show values
ContrTrmExchRateIsFxd Indicates that the Foreign Exchange Rate is fixed Show values
ComparCndnTrmExchrateIsFxd Indicates that the Foreign Exchange Rate is fixed Show values
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
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 term is fixed Show values
PriceIsRealized Indicates that the MtM value is realized Show values
HasError Flag: Error occured Show values
ImplicitFixationIsRelevant Implicit Fixation Relevant Show values
ComparImplicitFixationIsRlvt Implicit Fixation Relevant Show values
Column Name Description Domain name
PriceSetValue Price Set Value
PriceRemoveValue Price Remove Value
PriceChangeValue Price Change Value
DocumentToStstcFXSetValue Document to Statistics FX Set Value
DocumentToStstcFXRemoveValue Document to Statistics FX Remove Value
DocumentToStstcFXChangeValue Document to Statistics FX Change Value
MarketToStstcFXSetValue Market Adjustment Value Term Value
MarketToStstcFXRemoveValue Market Adjustment Value Term Value
MarketToStstcFXChangeValue null
PriceSetMarketSpreadValue Market Adjustment Value Term Value
PriceRemoveMarketSpreadValue Market Adjustment Value Term Value
PriceSetDocumentSpreadValue Market Adjustment Value Term Value
PriceRemoveDocumentSpreadValue Market Adjustment Value Term Value
PriceSetMktAdjmtValue Market Adjustment Value Term Value
PriceRemoveMktAdjmtValue Market Adjustment Value Term Value
PriceChangeMktAdjmtValue Market Adjustment Value Term Value
FxSetMktAdjmtValue Market Adjustment Value Term Value
FxRemoveMktAdjmtValue Market Adjustment Value Term Value
FXChangeMktAdjmtValue null
MarketConditionTermRate Market Term Rate
ContrSpreadCndnTermRate Contract Spread Term Rate
FloatingMktSpreadCndnTermRate Floating Market Spread Term Rate
FixedMktSpreadCndnTermRate Fixed Market Spread Term Rate
MktDocToStstcExchRate Market Exchange Rate: Document to Statistics Currency
MktMarketToDocExchRate Market Exchange Rate: Market to Document Currency
MarketAdjustmentValueRate Contract Condition Term Rate
ContractConditionType Contract Price Condition Type KSCHL
ContractConditionTermRate Contract Condition Term Rate
ComparContrCndnTermRate Comparative Contract Condition Term Rate
CalcRelContrConditionTermRate Calculation Relevant Contract Condition Term Rate
CalcRelComparContrCndnTermRate CalculationRelevant Comparative Contract Condition Term Rate
ContractMktToDocExchRate Contract Exchange Rate: Market to Document Currency
ComparContrMktToDocExchRate Comparative Contract Exchange Rate: Market to Document Curr.
ContrDocToStstcExchRate Contract Exchange Rate: Document to Statistics Currency
ComparContrDocToStstcExchRate Comparative Contr. Exch. Rate: Document to Statistics Curr.
ContrMarketToStstcExchRate Comparative Contr. Exch. Rate: Document to Statistics Curr.
MktMarketToStstcExchRate Market Exchange Rate: Market to Statistics Currency
MktAdjmtValueCndnTermValue Value in Document Currency
SourceTransactionEventDateTime Valid-From Timestamp TZNTSTMPS
SourceTransacEventEndDateTime Valid-To Timestamp TZNTSTMPS
EndOfDayBusinessEntityKey Key of an Business Entity End-of-day snapshot:Char format
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
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsTransferLocation Incoterms (Part 2) INCO2
ConditionApplication Application KAPPL
SourceDocument Document CMM_MTM_OBJID
SourceDocumentItem Source Document Item
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
ConditionQuantity Condition Pricing Unit KPEIN
QuotationPriceType Type of Price Quotation VVSKURSART
ConditionTermRate Term Rate
ConditionTermRateQuantity Price Unit
ConditionTermValue CPE Term - Rate in Term Currency(up to 14 decimals) CPE_INTERNAL_VALUE
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
ConditionTermFactor CPE condition type term factor
ComparConditionTermFactor Comparative CPE condition type term factor
QuotationDateList The key of a date list CHAR40
ComparativeMarketDCS Comparative Market Derivative Contract Specification ID TBA_DCSID
ComparMktMarketIdentifierCode Comparative Market Market Identifier Code TBA_MIC
ComparMktDrvtvContrCode Comparative Market Contract Maturity Code TBA_CONTRACT_CODE
ComparMarketBasisID Comparative Market Basis ID TBAC_BASIS_ID
ComparMarketBasisType Comparative Market Basis Type TBAC_BASIS_TYPE
ComparMktQuotationPriceType Comparative Market Type of Price Quotation VVSKURSART
ContractDCS Contractual Derivative Contract Specification ID TBA_DCSID
ContractMarketIdentifierCode Contract Market Identifier Code TBA_MIC
ContrDrvtvContrMaturityCode Contractual Contract Maturity Code TBA_CONTRACT_CODE
ContractBasisID Contract Basis ID TBAC_BASIS_ID
ContractBasisType Contract Basis Type TBAC_BASIS_TYPE
ContractQuotationPriceType Contract Type of Price Quotation VVSKURSART
QuotationGroup Quotation Group (Technical Key Field) CHAR40
ConditionTermRateFixation Fixation ID
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
PnLEventType Profit and Loss Event Type CMM_EVENT
PnLElementaryEventType Profit and Loss Elementary Event Type CMM_EVENT
MTMDataSourceGroup R/2 table CHAR5
VersStockRecordUUID GUID assigned to the VlogP stock delta record SYSUUID_X16
SystemMessageNumber System Message Number
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