P_Cmmdtynewactpnlvalue_Calc4

PnL New Activity Calculation Spread | view: PCMMPNLNACALC4 | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: CMM_TPL_EFFECT, CMM_GMDAFX, CMM_VLOGP, CMM_VLOGP_CONV_C
Column Name Description
PricingKey A key required to access versioned pricing data
Version null
PricingDocumentItem null
ConditionType null
SubConditionType null
Column Name Description
ComparMktAdjmtValCndnTermValue null
💲 CPE Term - Currency (ConditionTermValueCurrency):
ConditionRate Condition Amount or Percentage
ConditionTermValue CPE Term - Value
Column Name Description
📏 CPE Term - Unit of Measure (ConditionTermRateQuantityUnit):
ContrCmmdtyQtyInTermUnit null
ComparContrCmmdtyQtyInTrmUnit null
CommodityQuantityInTermUnit null
ComparativeCmmdtyQtyInTermUnit null
📏 Unit of Measure for Commodity (CommodityUnit):
CommodityQuantity Open Commodity Quantity
Column Name Description
EvaluationDate null
ComparativeEvaluationDate null
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 null
ContractMaturityKeyDate Maturity Key Date
CndnTermRateFixationDate Rate Fixation Date
CndnTermRateFixationTime Rate Fixation Time
CndnTermExchRateFixationDate FX Fixation Date
CndnTermExchRateFixationTime FX Fixation Time
Column Name Description
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
PnlEventGroup Profit and Loss Event Group 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
ComparativePricingStatus 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
Column Name Description Domain name
PriceSetValue null
PriceRemoveValue null
OldQuantityPriceSetValue null
OldQuantityPriceRemoveValue null
PriceSetMktAdjmtValue null
FXSetMktAdjmtValue null
PriceRemoveMktAdjmtValue null
FXRemoveMktAdjmtValue null
OldQtyPriceSetMktAdjmtValue null
OldQtyFXSetMktAdjmtValue null
OldQtyPriceRemoveMktAdjmtValue null
OldQtyFXRemoveMktAdjmtValue null
MarketToStstcFXSetValue null
MarketToStstcFXRemoveValue null
OldQtyMktToStstcFXSetValue null
OldQtyMktToStstcFXRemoveValue null
DocumentToStstcFXSetValue null
DocumentToStstcFXRemoveValue null
OldQtyDocToStstcFXSetValue null
OldQtyDocToStstcFXRemoveValue null
PriceSetMarketSpreadValue null
PriceSetDocumentSpreadValue null
PriceRemoveMarketSpreadValue null
PriceRemoveDocumentSpreadValue null
ContractConditionType Condition Type KSCHL
ContractConditionTermRate null
ComparContrCndnTermRate null
MarketConditionTermRate null
CalcRelContrConditionTermRate null
CalcRelComparContrCndnTermRate null
MarketAdjustmentValueRate null
MktAdjmtValueCndnTermValue null
ContrSpreadCndnTermRate null
FloatingMktSpreadCndnTermRate null
FixedMktSpreadCndnTermRate null
MktMarketToStstcExchRate null
MktMarketToDocExchRate null
SpreadMarketToDocExchRate null
MktDocToStstcExchRate null
ContractMktToDocExchRate null
ComparContrMktToDocExchRate null
ContrDocToStstcExchRate null
ContrMarketToStstcExchRate null
ComparContrDocToStstcExchRate null
SourceTransactionEventDateTime Valid-From Timestamp TZNTSTMPS
SourceTransacEventEndDateTime Valid-To Timestamp TZNTSTMPS
EndOfDayBusinessEntityKey Key of an Business Entity requiring an End-of-day snapshot
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
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 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
ComparativeMarketDCS null
ComparMktMarketIdentifierCode null
ComparMktDrvtvContrCode null
ComparMarketBasisID null
ComparMarketBasisType null
ComparMktQuotationPriceType null
ContractDCS Derivative Contract Specification ID TBA_DCSID
ContractMarketIdentifierCode Market Identifier Code TBA_MIC
ContrDrvtvContrMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
ContractBasisID Basis ID TBAC_BASIS_ID
ContractBasisType Basis Type TBAC_BASIS_TYPE
ContractQuotationPriceType Type of Price Quotation VVSKURSART
QuotationGroup Quotation Group (Technical Key Field) CHAR40
ConditionTermRateFixation CPE Term - Number in Formula NUMC5
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
VersStockRecordUUID null
PnLEventType Profit and Loss Event Type CMM_EVENT
MtMDataSourceGroup null
HasError null
SystemMessageNumber System Message Number
Master Data Relations Join Conditions
Profit and Loss Elementary Event Type
  • Client
  • Profit and Loss Elementary Event Type