SAP IACMMTMVALCUBE Table in S/4 HANA - Generated Table for View
IACMMTMVALCUBE is a standard SAP Table which is used to store Generated Table for View data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP IACMMTMVALCUBE table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: IACMMTMVALCUBE
IACMMTMVALCUBE table structure field list
Below is the full IACMMTMVALCUBE field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | CLNT | 3(0) | ||||||||
PRICINGKEY | A key required to access versioned pricing data | CMM_VLOGP_PRICING_KEY | CHAR | 40(0) | CMM_VLOGP_PRICING_KEY | |||||
VERSION | Version of an MtM Valuation Record | CMM_MTM_VERSION | NUMC | 10(0) | CMM_MTM_VERSION | |||||
PRICINGDOCUMENTITEM | Condition item number | KPOSN | NUMC | 6(0) | NUM6 | |||||
CONDITIONTYPE | Condition type | KSCHL | CHAR | 4(0) | KSCHL | VKS | ||||
SUBCONDITIONTYPE | The key of a sub-condition type | CMM_VLOGP_SUBKEY | NUMC | 6(0) | CMM_VLOGP_SUBKEY | |||||
ENDOFDAYSNAPSHOTDATETIMETO | Timestamp defining a End-of-day snapshot | CMM_DEND_TMSTMP | DEC | 15(0) | TZNTSTMPS | |||||
ENDOFDAYSNAPSHOTDATETIMEFROM | Timestamp defining a End-of-day snapshot | CMM_DEND_TMSTMP | DEC | 15(0) | TZNTSTMPS | |||||
COMPANYCODENAME | Name of Company Code or Company | BUTXT | CHAR | 25(0) | TEXT25 | |||||
PROFITCENTER | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
PLANTNAME | Plant Name | WERKS_NAME | CHAR | 30(0) | TEXT30 | |||||
COMMODITYNAME | Commodity Description | TBA_STOEFFCHEN_TXT | CHAR | 40(0) | TEXT40 | |||||
MATERIALNAME | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
ORIGINREFERENCEDOCUMENT | Root Document | CMM_VLOGP_ROOT | CHAR | 20(0) | ALPHA | CMM_MTM_OBJID | ||||
SOURCEDOCUMENT | Source Document | CDS_SOURCE_DOCUMENT | CHAR | 20(0) | ALPHA | CMM_MTM_OBJID | ||||
SOURCEDOCUMENTITEM | Source Document Item | CDS_SOURCE_DOCUMENT_ITEM | NUMC | 6(0) | ||||||
SOURCEDOCUMENTBUSOBJTYPENAME | Name | OJ_STEXT | CHAR | 20(0) | TEXT20 | |||||
VALIDITYSTARTDATE | Last Changed Date | CDS_LASTCHANGED_DATE | DATS | 8(0) | ||||||
INCOTERMSCLASSIFICATIONNAME | Description | BEZEI30 | CHAR | 30(0) | TEXT30 | |||||
INCOTERMSTRANSFERLOCATION | Incoterms (Part 2) | INCO2 | CHAR | 28(0) | INCO2 | |||||
CONDITIONAPPLICATION | Application | KAPPL | CHAR | 2(0) | KAPPL | KAP | ||||
PRICINGPROCEDURE | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6(0) | KALSM | |||||
STATISTICSCURRENCY | Statistics Currency | CDS_STATISTICS_CURRENCY | CUKY | 5(0) | ||||||
MTMCALCULATIONGROUPNAME | Condition Group - Description | CMM_MTM_CGROUPTXT | CHAR | 20(0) | TEXT20 | |||||
MTMCONDITIONGROUPCATEGORYNAME | Short Text for Fixed Values | VAL_TEXT | CHAR | 60(0) | DDTEXT | |||||
DERIVATIVECONTRACTMATURITYCODE | Contract Maturity Code | TBA_CONTRACT_CODE | CHAR | 13(0) | ALPHA | TBA_CONTRACT_CODE | ||||
MATURITYKEYDATE | Maturity Key Date | TBA_KEYDATE | DATS | 8(0) | DATE | |||||
BASISIDNAME | Basis ID Description | TBAC_BASIS_ID_TEXT | CHAR | 40(0) | TBAC_BASIS_ID_TEXT | |||||
DERIVATIVECONTRSPECNAME | Derivative Contract Specification Description | TBA_DCSID_TXT | CHAR | 40(0) | TEXT40 | |||||
MARKETIDENTIFIERCODENAME | Market Identifier Code Description | TBA_MIC_TXT | CHAR | 40(0) | TEXT40 | |||||
PRICINGSTATUSNAME | Future/Basis Price Fixation Status - Long Text | CMM_FBFIX_ST_LTXT | CHAR | 50(0) | TEXT50 | |||||
MTMADJUSTMENTTYPENAME | Short Text for Fixed Values | VAL_TEXT | CHAR | 60(0) | DDTEXT | |||||
CONDITIONTERMRATEFIXATION | Fixation ID | CDS_FIXATION_ID | NUMC | 5(0) | ||||||
QUOTATIONPERIODREFERENCEDATE | Reference Date | CMM_VLOGP_REFERENCE_DATE | DATS | 8(0) | DATUM | |||||
COMMODITYQUANTITY | Commodity Quantity | CMM_MTM_QUAN_COMM | QUAN | 17(3) | CMM_MTM_KYFIG_QUAN | |||||
COMMODITYQUANTITYINTERMUNIT | Commodity Quantity in Price Unit | CDS_CMMDTYQTY_IN_TERMUOM | QUAN | 17(3) | CMM_MTM_KYFIG_QUAN | |||||
CONDITIONTERMRATE | Price | CMM_REPORTING_PRICE | DEC | 31(8) | ||||||
MARKETTODOCEXCHRATE | Exchange Rate: Market to Document Currency | CMM_REPORTING_EXCHRATE_MARKET | DEC | 20(8) | ||||||
DOCTOSTATISTICALEXCHRATE | Exchange Rate: Document to Statistics Currency | CMM_REPORTING_EXCHRATE_FUNC | DEC | 20(8) | ||||||
CONDITIONTERMVALUEINSTSTCCRCY | Value in Statistical Currency | CDS_VALUE_IN_STATCUR | DEC | 31(11) | ||||||
CONDITIONTERMVALUEINDOCCRCY | Value in Document Currency | CDS_VALUE_IN_DOCCUR | DEC | 31(11) | ||||||
COMPANYCODE | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
COMMODITY | Commodity | TBA_STOEFFCHEN | CHAR | 18(0) | TBA_STOEFFCHEN | TBAH_STOEFFCHEN | COMMODITY | |||
CREDITOR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
SOLDTOPARTY | Customer Number | KUNNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR | |
ORIGINREFDOCBUSOBJTYPENAME | Name | OJ_STEXT | CHAR | 20(0) | TEXT20 | |||||
ORIGINREFERENCEDOCBUSOBJTYPE | Root Document (BOR) Object Type | CMM_VLOGP_ROOT_DOCTYP | CHAR | 10(0) | OJ_NAME | |||||
ORIGINREFERENCEDOCUMENTITEM | Root Document Item | CMM_VLOGP_ROOT_ITEM | NUMC | 6(0) | CMM_VLOGP_ROOT_ITEM | |||||
REFERENCEDOCUMENT | Predecessor Document | CMM_VLOGP_PREDECESSOR | CHAR | 20(0) | ALPHA | CMM_MTM_OBJID | ||||
REFERENCEDOCBUSOBJTYPENAME | Name | OJ_STEXT | CHAR | 20(0) | TEXT20 | |||||
REFERENCEDOCBUSOBJTYPE | Ref (BOR) Object Type | CMM_VLOGP_PREDECESSOR_DOCTYP | CHAR | 10(0) | OJ_NAME | |||||
REFERENCEDOCUMENTITEM | Predecessor Document Item | CMM_VLOGP_PREDECESSOR_ITEM | NUMC | 6(0) | CMM_VLOGP_REF_ITEM | |||||
DELIVERYYEAR | Abjusted Reporting Year | CDS_ADJUSTED_REPORTING_YEAR | CHAR | 4(0) | ||||||
DELIVERYDATE | Delivery Date | CMM_VLOGP_DELIVERY_DATE | DATS | 8(0) | DATUM | |||||
DELIVERYMONTH | Adjusted Reporting Month | CDS_ADJUSTED_REPORTING_MONTH | CHAR | 3(0) | CHAR3 | |||||
EXPECTEDPAYMENTDATE | Payment Date | CMM_MTM_DATE_PYMNT | DATS | 8(0) | DATUM | |||||
EXCHRATEEVALUATIONDATE | Exchange Rate Evaluation Date | CMM_REPORTING_FXEVALDATE | DATS | 8(0) | DATS | |||||
DOCTOSTSTCCRCYEXCHRATEEVALDATE | Document to Statistics Currency Evaluation Date | CDS_DOC_TO_STAT_FX_EVAL_DATE | DATS | 8(0) | DATE | |||||
DOCUMENTCURRENCY | SD document currency | WAERK | CUKY | 5(0) | WAERS | FWS | ||||
ISINTERCOMPANYTRANSFER | Intercompany Transfer | CMM_VLOGP_INTERCOMPANY | CHAR | 1(0) | XFELD | |||||
CNDNTERMRATEFIXATIONDATE | Rate Fixation Date | CMM_VLOGP_RATE_FIX_DATE | DATS | 8(0) | DATS | |||||
CNDNTERMRATEFIXATIONTIME | Rate Fixation Time | CMM_VLOGP_RATE_FIX_TIME | TIMS | 6(0) | TIME | |||||
CNDNTERMEXCHRATEFIXATIONDATE | FX Fixation Date | CMM_VLOGP_FX_FIX_DATE | DATS | 8(0) | DATS | |||||
CNDNTERMEXCHRATEFIXATIONTIME | FX Fixation Time | CMM_VLOGP_FX_FIX_TIME | TIMS | 6(0) | TIME | |||||
EXCHRATEMATURITYDATE | Maturity Date | CMM_MATURITY_DATE | DATS | 8(0) | ||||||
BSMKTREFDRVTVCONTRMATURITYCODE | Basis Market Reference Contract Maturity Code | CMM_BAS_MKT_REF_CONTRACT_CODE | CHAR | 13(0) | ALPHA | CMM_BAS_MKT_REF_CONTRACT_CODE | ||||
BASISMARKETREFRATE | Original Basis Market reference rate | CMM_BAS_MKT_REF_RATE | DEC | 20(8) | CMM_GMDA_PRICE | |||||
BASISMARKETREFADJUSTMENTSPREAD | Adjustment Value | CMM_BAS_MKT_REF_ADJ_SPREAD | DEC | 20(8) | CMM_GMDA_PRICE | |||||
MARKETTODOCFROZENEXCHRATE | Exchange Rate: Market to Document Currency at a Key Date | CDS_MARKTODOC_FROZEN_EXCHRATE | DEC | 20(8) | ||||||
CONDITIONTERMRATECURRENCY | Price Currency | CDS_PRICECURRENCY | CUKY | 5(0) | ||||||
CONDITIONTERMRATEQUANTITY | Price Unit | CMM_REPORTING_PRICEUNIT | DEC | 5(0) | ||||||
CONDITIONTERMRATEQUANTITYUNIT | Price UoM | CDS_PRICEUOM | UNIT | 3(0) | ||||||
MARKETPRICECURRENCY | Marketprice Currency | CDS_MARKETPRICE_CURRENCY | CUKY | 5(0) | ||||||
OLDESTQUOTATIONDATE | Oldest Quotation Date | CDS_OLDESTQUOTDATE | DATS | 8(0) | ||||||
COMMODITYUNIT | Unit of Measure for Commodity | CMM_MTM_QUAN_COMMUOM | UNIT | 3(0) | CUNIT | MEINS | ||||
SYSTEMMESSAGETEXT | Message Text | NATXT | CHAR | 73(0) | NATXT | |||||
HASERROR | Flag: Error occured | CMM_ERROR_OCCURED | CHAR | 1(0) | XFELD | |||||
MTMDATASOURCETYPE | Type of Data Record | CMM_VLOGP_REC_TYPE | CHAR | 2(0) | CMM_VLOGP_REC_TYPE | |||||
PHYSICALCOMMODITY | Physical Commodity | CDS_PHYSICAL_COMMODITY | CHAR | 18(0) | TBA_STOEFFCHEN | TBAH_STOEFFCHEN | COMMODITY |
Search for further information about these or an SAP related objects