- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- ANSI/ISA S95 Interface (LO-S95)
- Advanced Returns Management (LO-ARM)
- Batches (LO-BM)
- Bulk Processess in Logistics (LO-BLK)
- Commodity Management in Logistics (LO-CMM)
- Configuration management (LO-CM)
- ERP Logistik Integration (LO-INT)
- Electronic Data Records (LO-ELR)
- Engineering Change Management (LO-ECH)
- Forecast (LO-PR)
- Generic Cross Application Components (LO-GEN)
- Global Trade (LO-GT)
- Handling Unit Management (LO-HU)
- Logistics Basic Data (LO-MD)
- Logistics Information System (LIS) (LO-LIS)
- Product Data Management (LO-PDM)
- Project Manufacturing Management and Optimization (LO-PMM)
- Retail & Fashion Management in S/4HANA (LO-RFM)
- SAP Agricultural Contract Management (LO-AGR)
- Service Parts Management (LO-SPM)
- Settlement Management (LO-AB)
- Supply Chain Planning Interfaces (SCPI) (LO-SCI)
- Variant Configuration (LO-VC)
- Variant configuration on HANA (LO-VCH)
- Warranty Claim Processing (LO-WTY)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
CMM_VLOGP
Version Table
|
#masterdata
|
Component: Basic Functions
- 🔑 Keys (6)
- 💰 Amounts (9)
- ∑ Quantities (16)
- 📅 Dates (31)
- ☰ Categorical (34)
- Other (149)
- 🔗 Relations (2)
| Column Name | Description | |
|---|---|---|
| MANDT | Client | |
| PRICING_KEY | A key required to access versioned pricing data | |
| VERSION | Version of an MtM Valuation Record | |
| KPOSN | Condition item number | |
| KSCHL | Condition Type | |
| KSCHL_SUBKEY | The key of a sub-condition type |
| Column Name | Description | |
|---|---|---|
| 💲 Condition Unit (Currency, Sales Unit, or %) (KOEIN): | ||
| KAWRT | Condition Basis | |
| 💲 Currency Key (WAERS): | ||
| KBETR | Condition Amount or Percentage | |
| PREVIOUS_KBETR | Condition Amount or Percentage | |
| KWERT | Condition Value | |
| KWERT_ADJ | Adjusted Condition Amount | |
| 💲 CPE Term - Currency (TERMCURR): | ||
| TERMVAL | CPE Term - Value | |
| 💲 Statistics Currency (STWAE): | ||
| KWERT_ADJ_STWAE | Condition Value in Statistics Currency | |
| KBETR_STWAE | Rate | |
| 💲 CPE Term - Currency (PREVIOUS_TERMCURR): | ||
| PREVIOUS_TERMVAL | CPE Term - Value | |
| Column Name | Description | |
|---|---|---|
| 📏 Base Unit of Measure (LAGME): | ||
| MGLME | Quantity in Base Unit | |
| 📏 Sales unit (VRKME): | ||
| MGAME | Quantity | |
| MGLME_ADJ | Open Quantity in Base Unit | |
| MGAME_ADJ | Open Quantity | |
| 📏 CPE Formula - Unit of Measure of Commodity Used in Formula (FORMCOMMUOM): | ||
| FORMCOMMQUAN | CPE Formula - Total Quantity of Commodity in Document Item | |
| FORMCOMMQUAN_ADJ | CPE Formula - Total Quantity of Commodity in Document Item | |
| 📏 CPE Term - UoM for Risk Calculation (RISKUOM): | ||
| RISKQUANTITY | CPE Term - Quantity for Risk Calculation | |
| 📏 Mass Unit of Measure (RISK_MASS_UOM): | ||
| RISK_MASS_QTY | Exposure Mass Quantity | |
| COMMODITY_MASS_ADJ | Open Commodity Quantity In MASS | |
| 📏 QuantityVolume UoM (RISK_VOLUME_UOM): | ||
| RISK_VOLUME_QUANTITY | Quantity/Volume of Exposure | |
| COMMODITY_VOLUME_ADJ | Open Commodity Quantity In Volume | |
| 📏 CPE Term - Unit of Measure (TERMUOM): | ||
| COMMODITY_ADJ_IN_TERMUOM | Commodity Quantity in Price Unit | |
| PREVIOUS_COMM_ADJ_IN_TERMUOM | Commodity Quantity in Price Unit | |
| 📏 Unit of Measure for Commodity (COMMODITY_UOM): | ||
| COMMODITY_QUAN | Commodity Quantity | |
| COMMODITY_ADJ | Open Commodity Quantity | |
| PREVIOUS_COMMODITY_ADJ | Open Commodity Quantity | |
| Column Name | Description | |
|---|---|---|
| VALID_FROM_DATE | Valid-From Date | |
| VALID_FROM_TIME | Valid-From Time | |
| VALID_TO_DATE | Valid-To Date | |
| VALID_TO_TIME | Valid-To Time | |
| ERDAT | Date on which the record was created | |
| KDATU | Condition Pricing Date | |
| LATEST_EVALUATION_DATE | Latest Evaluation Date | |
| QUOTPERIOD_BEGIN | Start Date of Quotation Period | |
| QUOTPERIOD_END | End Date of Quotation Period | |
| KEYDATE | Maturity Key Date | |
| DATE_DELIVERY | Delivery Date | |
| DATE_REFERENCE | Reference Date | |
| CURVE_READING_DATE | Commodity Curve Reading Date | |
| RATE_FIX_DATE | Rate Fixation Date | |
| RATE_FIX_TIME | Rate Fixation Time | |
| FX_FIX_DATE | FX Fixation Date | |
| FX_FIX_TIME | FX Fixation Time | |
| DATE_FWD_FX_FREEZE | Date when forward FX rate is frozen | |
| DATE_FWD_FX_MATURITY | Maturity Date | |
| DCS_REPORTING_DATE | Reporting Date | |
| DATE_DISCOUNTING | Date on which a value relevant for MtM becomes effective | |
| DATE_PYMNT | Payment Date | |
| PERIOD_START_MKT | Start of Delivery Period for which the Market Norm applies | |
| PERIOD_END_MKT | End of Delivery Period for which the Market Norm applies | |
| KEYDATE1_SPRD | Maturity Key Date | |
| KEYDATE2_SPRD | Second Maturity Key Date in a Spread Pair | |
| BP_EVAL_PRD_START | Reference Evaluation Key Date | |
| PREVIOUS_KEYDATE | Maturity Key Date | |
| PREVIOUS_QUOT_PER_BEG | Start Date of Quotation Period | |
| PREVIOUS_QUOT_PER_END | End Date of Quotation Period | |
| FX_EXCH_RATE_MATURITY_DATE | Maturity Date of Exchange Rate |
| Column Name | Description | |
|---|---|---|
| MIRROR_VALUE | Value Is Mirrored | Show values |
| RECORD_TYPE | Type of Data Record | Show values |
| REALIZED | Indicates that the MtM value is realized | Show values |
| EXECUTED | Indicates that the goods movement has been executed | Show values |
| COMPLETED | Indicates that the remaining item qty was set to completed | Show values |
| INTER_COMPANY | Intercompany Transfer | Show values |
| KRECH | Calculation Type for Condition | Show values |
| TERM_EXTENSION_USAGE | CPE Extension Usage | Show values |
| QUOTGROUP_OP | Quotation Group Operation | Show values |
| TIMING | Timing/Periodicity of Commodity Forward Indexes | Show values |
| DCS_SELECTION_TYPE | Maturity Selection Type | Show values |
| QUOTKEY | Quotation Key Type in Document UI (all values) | Show values |
| DCS_TYPE | Derivative Category | Show values |
| FIXGROUP_STATUS | Future/Basis Price Fixation Status | Show values |
| DCS_PERIOD_TYPE | Period Type | Show values |
| IMPLICIT_FIXATION_REL | Implicit Fixation Relevant | Show values |
| CGROUP_CAT | Categorization of Condition Group | Show values |
| FIXED | Indicates that the term is fixed | Show values |
| FIXED_FX | Indicates that the Foreign Exchange Rate is fixed | Show values |
| ROUND_RATE | Indicates whether the term rate is rounded | Show values |
| ADJUSTMENT_TYPE | Type of adjustment for the MtM or TPL calculation | Show values |
| INVERSE_FIX_SPRD | Fixed Spread needs to be inversed | Show values |
| SKIP_REPORTING | Skip reporting | Show values |
| RANTYP | Contract Type | Show values |
| SSHLNG | Short/Long Indicator | Show values |
| BP_EVAL_PERIOD | PnL Evaluation Period | Show values |
| PREVIOUS_FIXED | Indicates that the term is fixed | Show values |
| PREVIOUS_IMPLC_FIXED | Implicit Fixation Relevant | Show values |
| PREVIOUS_FIXED_FX | Indicates that the Foreign Exchange Rate is fixed | Show values |
| PREVIOUS_FIXGROUP_STATUS | Future/Basis Price Fixation Status | Show values |
| PREVIOUS_DCS_PERIOD | Period Type | Show values |
| PREVIOUS_DCS_SEL | Maturity Selection Type | Show values |
| FX_FIX_CALCTYPE_TERM_TO_DOC | FX Fixation Calculation Type Term to Document Currency Conv | Show values |
| SDM_VERSION | VLOGP SDM Version | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| DOCUMENT_CHAR10 | Document | CMM_DOCUMENT_CHAR10 | |
| DOCUMENT | Document | CMM_MTM_OBJID | |
| DOCUMENT_TYPE | Document (BOR) Object Type | OJ_NAME | |
| VALID_FROM_TST | Valid-From Timestamp | TZNTSTMPS | |
| VALID_TO_TST | Valid-To Timestamp | TZNTSTMPS | |
| VERSION_MAX | Highest Version Number | CMM_MTM_VERSION | |
| BELNR | Sales and Distribution Document Number | VBELN | |
| VKORG | Sales Organization | VKORG | |
| VTWEG | Distribution Channel | VTWEG | |
| BZIRK | Sales District | BZIRK | |
| VKGRP | Sales group | VKGRP | |
| BRSCH | Industry key | BRSCH | |
| VKBUR | Sales office | VKBUR | |
| ALAND | Departure Country/Region (from which the goods are sent) | LAND1 | |
| BUKRS | Company Code | BUKRS | |
| GSBER | Business Area | GSBER | |
| KUNNR | Sold-to Party | KUNNR | |
| KUNWE | Ship-to Party | KUNNR | |
| LIFNR | Vendor's account number | LIFNR | |
| KAPPL | Application | KAPPL | |
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM | |
| INCO1 | Incoterms (Part 1) | INCO1 | |
| INCO2 | Incoterms (Part 2) | INCO2 | |
| LAND1 | Destination Country/Region | LAND1 | |
| EKORG | Purchasing organization | EKORG | |
| EXT_NUMBER | External Number of Document | CMM_VLOGP_SOURCE_DOC_EX | |
| ENTITY_KEY | Key of an Business Entity requiring an End-of-day snapshot | ||
| PRICING_KEY_XML | CMM VlogP Stock and Pricing Key in readable XML Format | STRING | |
| ROOT_DOC_CHAR10 | Root Document | CMM_DOCUMENT_CHAR10 | |
| ROOT_DOC | Root Document | CMM_MTM_OBJID | |
| ROOT_DOC_TYPE | Root Document (BOR) Object Type | OJ_NAME | |
| ROOT_DOC_ITM | Root Document Item | CMM_VLOGP_ROOT_ITEM | |
| PREDECESSOR_DOC | Predecessor Document | CMM_MTM_OBJID | |
| PREDECESSOR_DOC_TYPE | Ref (BOR) Object Type | OJ_NAME | |
| PREDECESSOR_DOC_ITM | Predecessor Document Item | CMM_VLOGP_REF_ITEM | |
| DOCUMENT_ITEM | Item Number of Document | NUMC10 | |
| MATNR | Material Number | MATNR | |
| CHARG | Batch Number | CHARG | |
| WERKS | Plant | WERKS | |
| SPART | Division | SPART | |
| PRCTR | Profit Center | PRCTR | |
| MATKL | Material Group | MATKL | |
| BWTAR | Valuation Type | BWTAR | |
| ROOT_EXT_NUMBER | External Number of Root Document | CMM_VLOGP_ROOT_DOC_EX | |
| PREDECESSOR_EXT_NUMBER | External Number of Predecessor Document | CMM_VLOGP_REF_DOC_EX | |
| LGORT | Storage location | LGORT | |
| STOCK_KEY_XML | CMM VlogP Stock Key in readable XML Format | STRING | |
| STOCK_KEY | Stock Key for Stock Key XML | CHAR40 | |
| ZAEHK | Condition Counter | ZAEHK | |
| KPEIN | Condition Pricing Unit | KPEIN | |
| KUMZA | Numerator for converting condition units to base units | UMBSZ | |
| KUMNE | Denominator for converting condition units to base units | UMBSN | |
| FORMID | CPE Formula - Key | CPE_FORMID | |
| FORMPRUN | CPE Formula - Price Unit | CPE_PRUN | |
| FORMCOMBROUT | CPE Formula - Routine for Combining Terms | CPE_ROUTINE | |
| FORMSTATUS | CPE Formula - Status of Evaluation | CPE_FORMSTATUS | |
| TERMNO | CPE Term - Number in Formula | NUMC5 | |
| ROOT_TERMNO | CPE Term - Number in Formula | NUMC5 | |
| TERMID | CPE Term - Key | CPE_TERMID | |
| TERMRATE | Term Rate | ||
| TERMPRUN | CPE Term - Price Unit | CPE_PRUN | |
| TERMTEXT | Description | TEXT40 | |
| TERMSTATUS | CPE Term - Status | CPE_TERMSTATUS | |
| TERMFACTOR_COMBROUT_NUM | Term Factor num for quantity based on the comb rout | ||
| TERMFACTOR_COMBROUT_DENO | Term Factor deno for quantity based on the comb rout | ||
| LATEST_EVAL_KEYDATE | Latest Evaluation Key Date | CPE_TIMESTAMP | |
| QUOT_TIMESERIES_KEY | The key of a date list | CHAR40 | |
| QUOTGROUP | Quotation Group (Technical Key Field) | CHAR40 | |
| DCSID | Derivative Contract Specification ID | TBA_DCSID | |
| MIC | Market Identifier Code | TBA_MIC | |
| TENOR | Time to Maturity | TBA_TENOR | |
| CONTRACT_CODE | Contract Maturity Code | TBA_CONTRACT_CODE | |
| INSTRUMENT | A key required to access market data | CHAR40 | |
| PRICETYPE | Type of Price Quotation | VVSKURSART | |
| BASIS_TYPE | Basis Type | TBAC_BASIS_TYPE | |
| BASIS_ID | Basis ID | TBAC_BASIS_ID | |
| CURVE_DCSID | Derivative Contract Specification ID | TBA_DCSID | |
| CURVE_MIC | Market Identifier Code | TBA_MIC | |
| CURVE_TYPE | Commodity Curve Type | TBA_CTY_CURVE_TYPE | |
| CURVE_COMMODITY_ID | Commodity | TBA_CTY_ID | |
| CURVE | GMDACC Key | CHAR40 | |
| FIXATION_ID | CPE Term - Number in Formula | NUMC5 | |
| KEYDATE_SELECTION_ROUT | Maturity Selection Routine | CPE_ROUTINE | |
| PROVIS | CPE Term - Term Is Used only for Provisional Pricing | CHAR1 | |
| PROVTERMNO | CPE Term - Number of the Corresponding Provisional Term | NUMC5 | |
| CALCMIN | Minimum of Commodity Rate Calculation | ||
| CALCMAX | Maximum of Commodity Rate Calculation | ||
| CALCMMPRUN | CPE Term - Price Unit of Rate Calculation Limits | CPE_PRUN | |
| PSMGUID | PSM GUID | SYSUUID_22 | |
| PSMETHOD | Price Setting Method | CPE_PSMETHOD | |
| PSMSTATUS | Price Setting Method Status | CPE_PSMSTATUS | |
| COMMODITYSUBACCOUNT | Commodity Subaccount ID | CMMFSA_SUBACCOUNTID | |
| NUMBER_OF_LOTS | Number of Lots | CPET_NUMBER_OF_LOTS | |
| FILLPACKETUUID | Commodity Derivative Order Fill Packet UUID | /BOBF/CONF_KEY | |
| CGROUP | MtM Condition Group | CMM_MTM_CGROUP | |
| CALC_GROUP | MtM Calculation Group | CMM_MTM_CGROUP | |
| KSCHL_M | Market Price Condition within a calculation group | KSCHL | |
| COMMODITY | Commodity | TBA_STOEFFCHEN | |
| STWAE_KURST | Exchange Rate Type | KURST | |
| SIGNAGE_QTY | Sign of Quantity | CMM_VLOGP_SIGNAGE_QTY | |
| SIGNAGE_VAL | Sign of Amount | CMM_VLOGP_SIGNAGE_VAL | |
| NUMDEC_RATE | Decimals of Calculated Term/Formula Rate | INT1 | |
| FACTOR_NUM | Rate factor numerator | ||
| FACTOR_DENOM | Rate factor denominator | ||
| TERMNO_L | CPE Term - Number in Formula | NUMC5 | |
| ENTITY_KEY_MKT | Entity Key determining the Market Norm | ||
| KEY_STRUCT_MKT | DDIC Struc. cont. business entity keys of Mkt Norm Ent.Key | TABNAME | |
| ENTITY_KEY_SPRD | Business Entity Key for Spreads | ||
| FUTURES_REF_TIMESERIES | The key of a date list | CHAR40 | |
| QUOTPERDAYS | null | ||
| SGSART | Product Type | VVSART | |
| SFHAART | Financial Transaction Type | T_SFHAART | |
| KONTRH | Business Partner Number | BU_PARTNER | |
| RANL | Security Class ID Number | WP_RANL | |
| ASTUECK | No. of Units for Financial Instruments | ASTUECK | |
| POSACC | Futures Account for Listed Options and Futures | CMM_POS_ACCOUNT_FUT | |
| SV_STATE_ID | RM: ID of a Saved Data Status | CMM_VLOGP_JBRSVSTATEID | |
| PREVIOUS_VERSION | Version of an MtM Valuation Record | CMM_MTM_VERSION | |
| PREVIOUS_SUBKEY | The key of a sub-condition type | CMM_VLOGP_SUBKEY | |
| PREVIOUS_SIGNAGE_QTY | Sign of Quantity | CMM_VLOGP_SIGNAGE_QTY | |
| PREVIOUS_TERMRATE | Term Rate | ||
| PREVIOUS_MD_FACTOR_FROM | CPE - From-Factor for Conversion | CPE_CONVFACTOR | |
| PREVIOUS_MD_FACTOR_TO | CPE - To-Factor for Conversion | CPE_CONVFACTOR | |
| PREVIOUS_DS_FACTOR_FROM | CPE - From-Factor for Conversion | CPE_CONVFACTOR | |
| PREVIOUS_DS_FACTOR_TO | CPE - To-Factor for Conversion | CPE_CONVFACTOR | |
| PREVIOUS_DCSID | Derivative Contract Specification ID | TBA_DCSID | |
| PREVIOUS_MIC | Market Identifier Code | TBA_MIC | |
| PREVIOUS_CONTRACT_CODE | Contract Maturity Code | TBA_CONTRACT_CODE | |
| PREVIOUS_TERMFACT_COMB_NUM | Term Factor num for quantity based on the comb rout | ||
| PREVIOUS_TERMFACT_COMB_DENO | Term Factor deno for quantity based on the comb rout | ||
| PREVIOUS_CALCMIN | Minimum of Commodity Rate Calculation | ||
| PREVIOUS_CALCMAX | Maximum of Commodity Rate Calculation | ||
| PREVIOUS_PRICETYPE | Type of Price Quotation | VVSKURSART | |
| PREVIOUS_CURVE | GMDACC Key | CHAR40 | |
| PREVIOUS_QUOTGROUP | Quotation Group (Technical Key Field) | CHAR40 | |
| PREVIOUS_KEYDT_SEL_ROUT | Maturity Selection Routine | CPE_ROUTINE | |
| PREVIOUS_QUOT_TIMESERIES | The key of a date list | CHAR40 | |
| PREVIOUS_ROOT_DOC | Previous Root Document | CMM_MTM_OBJID | |
| PREVIOUS_ROOT_DOC_ITM | Previous Root Document Item | CMM_VLOGP_REF_ITEM | |
| FX_FIX_FACTOR_FROM_TERM_TO_DOC | FX Fixation From-Factor Term to Document Currency Conv | CPE_CONVFACTOR | |
| FX_FIX_FACTOR_TO_TERM_TO_DOC | FX Fixation To-Factor Term to Document Currency Conv | CPE_CONVFACTOR | |
| FX_MRKT_TO_TERM_FX_RATETYPE | Exch. Rate Type for Conversion from Market to Term Currency | KURST | |
| FX_COND_TO_DOC_FXRATETYPE | Exch. Rate Type for Conv. from Condition to Document Crcy | KURST | |
| FX_DOC_TO_STAT_FXRATETYPE | Exch Rate Type for Conv. from Document to Statistics Crcy | KURST | |
| FX_COND_TO_STAT_FXRATETYPE | Exch. Rate Type for Conv. from Condition to Stat. Crcy | KURST | |
| UOM_QUOT_TO_TERM_FACTOR_FROM | Factor From: Quotation UoM to Term UoM | CPE_CONVFACTOR | |
| UOM_QUOT_TO_TERM_FACTOR_TO | Factor To: Quotation UoM to Term UoM | CPE_CONVFACTOR | |
| UOM_COMM_TO_TERM_FACTOR_NUM | Factor From: Commodity UoM to Term UoM | CPE_CONVFACTOR | |
| UOM_COMM_TO_TERM_FACTOR_DEN | Factor To: Commodity UoM to Term UoM | CPE_CONVFACTOR |
| Master Data Relations | Join Conditions |
|---|---|
| Profit and Loss Event Type |
|
| Market Identifier Code |