SAP CMATLVALNMANAGE Table in S/4 HANA - Generated Table for View
CMATLVALNMANAGE 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 CMATLVALNMANAGE 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: CMATLVALNMANAGE
CMATLVALNMANAGE table structure field list
Below is the full CMATLVALNMANAGE 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 | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
COSTESTIMATE | Cost Estimate Number - Product Costing | CK_KALNR1 | NUMC | 12(0) | CK_KALNR | KNE | ||||
CURRENCYROLE | Currency Type specific to ML | FML_EXT_CURTYPE | CHAR | 2(0) | FINS_CURTYPE | |||||
CURRENCYROLENAME | Currency Type Name | FIS_CURTP_TEXT | CHAR | 60(0) | DDTEXT | |||||
MATERIAL | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
VALUATIONAREA | Valuation area | BWKEY | CHAR | 4(0) | T001K | BWKEY | BWK | |||
PLANT | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
PLANTNAME | Plant Name | WERKS_NAME | CHAR | 30(0) | TEXT30 | |||||
INVENTORYVALUATIONTYPE | Valuation Type | BWTAR_D | CHAR | 10(0) | BWTAR | BWT | ||||
INVTRYVALNSPECIALSTOCKTYPE | Special Stock Indicator | SOBKZ | CHAR | 1(0) | SOBKZ | |||||
SALESORDER | Sales and Distribution Document Number | VBELN | CHAR | 10(0) | ALPHA | VBELN | AUN | |||
SALESORDERITEM | Item number of the SD document | POSNR | NUMC | 6(0) | POSNR | |||||
SUPPLIER | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
WBSELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24(0) | ABPSN | PS_POSID | PRO | |||
WBSELEMENTINTERNALID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8(0) | ABPSP | PS_POSNR | ||||
CONTROLLINGAREA | Controlling Area | KOKRS | CHAR | 4(0) | TKA01 | CACCD | CAC | |||
INVENTORYVALUATIONCATEGORY | Valuation Category | BWTTY_D | CHAR | 1(0) | T149 | BWTTY | ||||
MATERIALVALUATIONCLASS | Valuation Class | BKLAS | CHAR | 4(0) | T025 | BKLAS | ||||
VALUATIONCLASSSALESORDERSTOCK | Valuation Class for Sales Order Stock | EKLAS | CHAR | 4(0) | T025 | BKLAS | ||||
PROJECTSTOCKVALUATIONCLASS | Valuation Class for Project Stock | QKLAS | CHAR | 4(0) | T025 | BKLAS | ||||
PRICEDETERMINATIONCONTROL | Price Determination | FML_ABST | CHAR | 1(0) | CK_ML_ABST | |||||
PROFITCENTER | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
CURRENTFISCALYEAR | Posting Date YYYY | BDATJ | NUMC | 4(0) | GJAHR | GJAHR | BDTJ | |||
CURRENTFISCALPERIOD | Posting period | POPER | NUMC | 3(0) | POPER | POPR | ||||
MATERIALNAME | Material description | MAKTX | CHAR | 40(0) | TEXT40 | |||||
PRODUCTIMAGEURL | Image URL | PRODUCTIMAGEURL | SSTR | 1333(0) | ||||||
BASEUNIT | Base Unit of Measure | MEINS | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
VALUATIONQUANTITYUNIT | Valuation Unit of Measure | /CWM/VALUM | UNIT | 3(0) | CUNIT | MEINS | ||||
COMPANYCODE | Company Code | FIS_BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
COMPANYCODENAME | Name of Company Code or Company | BUTXT | CHAR | 25(0) | TEXT25 | |||||
CURRENTSTOCKVALUE | Value of Total Valuated Stock | SALK3 | CURR | 13(2) | WERT13N | |||||
TOTALVLTDSTOCKQUANTITY | Valuation Quantity | FIN_QTYVAL | QUAN | 23(3) | FIN_QUANTITY | |||||
AMOUNTINCOMPANYCODECURRENCY | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 23(2) | WERTV12 | |||||
COMPANYCODECURRENCY | Company Code Currency | FIS_HWAER | CUKY | 5(0) | WAERS | |||||
INVENTORYPRICE | Inventory Price | FML_INVENTORY_PRICE | CURR | 11(2) | WERT11 | |||||
CURRENCY | Currency Key | WAERS | CUKY | 5(0) | WAERS | FWS | ||||
MATERIALPRICEUNITQTY | Price Unit | CK_PEINH_1 | DEC | 5(0) | PACK3 | |||||
VALUATIONCLASSINPREVPERIOD | Valuation Class in Previous Period | FML_VMBKL | CHAR | 4(0) | T025 | BKLAS | ||||
VALUATIONCLASSINPREVYEAR | Valuation Class in Previous Year | FML_VJBKL | CHAR | 4(0) | T025 | BKLAS | ||||
FUTUREPRICE | Future Price | FML_DZKPRS | CURR | 23(2) | AU112 | AFLE11D2O14N_TO_23D2O30N | ||||
FUTUREPRICEVALIDITYSTARTDATE | Date from Which a Future Valuation Price Is to Be Valid | FML_ZPRSDAT | DATS | 8(0) | SYDATS | |||||
TAXPRICEL1INCOCODECRCY | Valuation price based on tax law: level 1 | FML_BWPRS | CURR | 23(2) | AU112 | AFLE11D2O14N_TO_23D2O30N | ||||
TAXPRICE2INCOCODECRCY | Valuation price based on tax law: level 2 | FML_BWPS1 | CURR | 23(2) | AU112 | AFLE11D2O14N_TO_23D2O30N | ||||
TAXPRICE3INCOCODECRCY | Valuation price based on tax law: level 3 | FML_VJBWS | CURR | 23(2) | AU112 | AFLE11D2O14N_TO_23D2O30N | ||||
TAXBASEDPRICESPRICEUNITQTY | Price unit for valuation prices based on tax/commercial law | FML_BWPEI | DEC | 5(0) | PACK3 | |||||
COMMERCIALPRICE1INCOCODECRCY | Valuation price based on commercial law: level 1 | FML_BWPRH | CURR | 23(2) | AU112 | AFLE11D2O14N_TO_23D2O30N | ||||
COMMERCIALPRICE2INCOCODECRCY | Valuation price based on commercial law: level 2 | FML_BWPH1 | CURR | 23(2) | AU112 | AFLE11D2O14N_TO_23D2O30N | ||||
COMMERCIALPRICE3INCOCODECRCY | Valuation price based on commercial law: level 3 | FML_VJBWH | CURR | 23(2) | AU112 | AFLE11D2O14N_TO_23D2O30N | ||||
PLANNEDPRICE1INCOCODECRCY | Future Planned Price 1 | FML_DZPLP1 | CURR | 23(2) | AU112 | AFLE11D2O14N_TO_23D2O30N | ||||
FUTUREPLNDPRICE1VALDTYDATE | Date from Which Future Planned Price 1 Is Valid | FML_DZPLD1 | DATS | 8(0) | DATUM | |||||
PLANNEDPRICE2INCOCODECRCY | Future Planned Price 2 | FML_DZPLP2 | CURR | 23(2) | AU112 | AFLE11D2O14N_TO_23D2O30N | ||||
FUTUREPLNDPRICE2VALDTYDATE | Date from Which Future Planned Price 2 Is Valid | FML_DZPLD2 | DATS | 8(0) | DATUM | |||||
PLANNEDPRICE3INCOCODECRCY | Future Planned Price 3 | FML_DZPLP3 | CURR | 23(2) | AU112 | AFLE11D2O14N_TO_23D2O30N | ||||
FUTUREPLNDPRICE3VALDTYDATE | Date from Which Future Planned Price 3 Is Valid | FML_DZPLD3 | DATS | 8(0) | DATUM | |||||
ISBLOCKEDFORCOSTING | Do Not Cost | CK_NO_COSTING | CHAR | 1(0) | CK_NO_COSTING | |||||
COSTINGLOTSIZE | Lot Size for Product Costing | CK_LOSGR | QUAN | 13(3) | MENG13 | |||||
ISMATERIALCOSTEDWITHQTYSTRUC | Material Is Costed with Quantity Structure | CK_EKALREL | CHAR | 1(0) | XFELD | |||||
ISMATERIALRELATEDORIGIN | Is Material Related Origin | FML_IS_MAT_REL_ORIGIN | CHAR | 1(0) | BOOLE | |||||
COSTORIGINGROUP | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4(0) | TKKH1 | HRKFT | ||||
COSTINGOVERHEADGROUP | Costing Overhead Group | CK_KOSGR | CHAR | 10(0) | TCK14 | CK_KOSGR | ||||
MATERIALUSABILITYPROFILE | Plant-Specific Material Status | MMSTA | CHAR | 2(0) | T141 | MMSTA | ||||
ISCOPRODUCT | Indicator: Material can be co-product | KZKUPMAT | CHAR | 1(0) | FLAG | |||||
ISFIXEDPRICECOPRODUCT | Fixed-Price Co-Product | CK_FIXPRKU | CHAR | 1(0) | XFELD | |||||
ALTERNATIVEBILLOFMATERIAL | Alternative BOM | STALT | CHAR | 2(0) | ALPHA | ALTNR | ||||
BILLOFMATERIALVARIANTUSAGE | BOM Usage | STLAN | CHAR | 1(0) | T416 | STLAN | CSV | |||
TASKLISTGROUP | Key for Task List Group | PLNNR | CHAR | 8(0) | ALPHA | PLNNR | PLN | PLKS | PLNNR | |
TASKLISTGROUPCOUNTER | Group Counter | PLNAL | CHAR | 2(0) | ALPHA | ALTNR | PAL | |||
BILLOFOPERATIONSTYPE | Task List Type | PLNTY | CHAR | 1(0) | TCA01 | PLNTY | PTY | H_TCA01 | PLNTY | |
HASPRODUCTIONVERSION | Version Indicator | CK_VERK1 | CHAR | 1(0) | XFELD | |||||
COSTINGPRODUCTIONVERSION | Production Version To Be Costed | CK_VERID | CHAR | 4(0) | VERID | |||||
TOTSTKVALATSLSPRCINCOCODECRCY | Value of Total Valuated Stock at Sales Price | VKSAL | CURR | 13(2) | WERT13N | |||||
PHYSICALINVENTORYBLOCKIND | Physical Inventory Blocking Indicator | SPERR | CHAR | 1(0) | SPERR | |||||
DATEOFLASTPOSTEDCNTUNRSTRCDSTK | Date of Last Posted Count | DLINL | DATS | 8(0) | DATS | |||||
INVENTORYFORCYCLECOUNTIND | Physical Inventory Indicator for Cycle Counting | ABCIN | CHAR | 1(0) | ABCIN | |||||
VALUATIONMARGIN | Valuation margin | BWSPA | DEC | 6(2) | PRZ32V | |||||
FXDPORTNOFPLANPRCINCOCODECRCY | Fixed Portion of Current Planned Price | CK_LPLPX | CURR | 11(2) | WERT11V | |||||
PRODUCTUSAGETYPE | Usage of the material | J_1BMATUSE | CHAR | 1(0) | J_1BMATUSE | |||||
PRODUCTORIGINTYPE | Origin of the material | J_1BMATORG | CHAR | 1(0) | J_1BMATORG | |||||
ISPRODUCEDINHOUSE | Produced in-house | J_1BOWNPRO | CHAR | 1(0) | XFELD | |||||
VALNCLSFORSPCLSTKATVNDR | Valuation Class for Special Stock at the Vendor | OKLAS | CHAR | 4(0) | T025 | BKLAS | ||||
MATERIALPRICECONTROL | Price Control | INVENTORYVALUATIONPROCEDURE | CHAR | 1(0) | VPRSV | |||||
LEDGER | Ledger in General Ledger Accounting | FINS_LEDGER | CHAR | 2(0) | ALPHA | FINS_LEDGER | GLN_FLEX | FAGL_RLDNR | RLDNR | |
ISLIFOANDFIFORELEVANT | Is LIFO/FIFO Relevant | FML_IS_LIFO_FIFO_RELEVANT | CHAR | 1(0) | BOOLE | |||||
LIFOVALUATIONPOOLNUMBER | Pool number for LIFO valuation | MYPOOL | CHAR | 4(0) | TPOOL | LIFO_POOL | POL | |||
DEVALUATIONYEARCOUNT | Lowest value: devaluation indicator | ABWKZ | NUMC | 2(0) | NUMC2 | |||||
CONTROLLINGVALUATIONTYPE | Valuation View | VALUTYP | NUMC | 1(0) | VALUTYP | VTP | ||||
FISCALPERIODENDDATE | End Date of Fiscal Period | FINS_FPERIOD_ENDDATE | DATS | 8(0) | DATUM | |||||
NEXTFISCALPERIODSTARTDATE | Start Date of Fiscal Period | FINS_FPERIOD_STARTDATE | DATS | 8(0) | DATUM | |||||
PRICETRANSLATIONSOURCE | Price Translation Source Name | FML_PRICE_TRANS_SRC_NAME | CHAR | 50(0) | FML_PRICE_TRANS_SRC_NAME |
Search for further information about these or an SAP related objects