MCADV SAP (Material Master Record Table: CAD Integration) Structure details
Description: Material Master Record Table: CAD Integration
Structure field list including key, data, relationships and ABAP select examples
MCADV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Material Master Record Table: CAD Integration" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MCADV TYPE MCADV.
The MCADV table consists of various fields, each holding specific information or linking keys about Material Master Record Table: CAD Integration data available in SAP. These include ERSDA (Created On), ERNAM (Name of Person who Created the Object), LAEDA (Date of Last Change), AENAM (Name of Person Who Changed Object).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP MCADV structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
ERSDA | Created On | ERSDA | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
LAEDA | Date of Last Change | LAEDA | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
VPSTA | Maintenance status of complete material | VPSTA | CHAR | 15 | PSTAT | ||||
PSTAT | Maintenance status | PSTAT_D | CHAR | 15 | PSTAT | ||||
LVORM | Deletion Indicator | LVORM | CHAR | 1 | XFELD | ||||
MTART | Material Type | MTART | CHAR | 4 | Assigned to domain | MTART | MTA | ||
MBRSH | Industry sector | MBRSH | CHAR | 1 | Assigned to domain | MBRSH | MTP | ||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
BISMT | Old material number | BISMT | CHAR | 18 | BISMT | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BSTME | Purchase Order Unit of Measure | BSTME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ZEINR | Document number (without document management system) | DZEINR | CHAR | 22 | CHAR22 | ||||
ZEIAR | Document type (without Document Management system) | DZEIAR | CHAR | 3 | ZEIAR | ||||
ZEIVR | Document version (without Document Management system) | DZEIVR | CHAR | 2 | VERSI | ||||
ZEIFO | Page format of document (without Document Management system) | DZEIFO | CHAR | 4 | DINFO | ||||
AESZN | Document change number (without document management system) | AESZN | CHAR | 6 | AENUM | ||||
BLATT | Page number of document (without Document Management system) | BLATT | CHAR | 3 | BLATT | ||||
BLANZ | Number of sheets (without Document Management system) | BLANZ | NUMC | 3 | NUM3 | ||||
FERTH | Production/inspection memo | FERTH | CHAR | 18 | FERTH | ||||
FORMT | Page Format of Production Memo | FORMT | CHAR | 4 | DINFO | ||||
GROES | Size/dimensions | GROES | CHAR | 32 | CHAR32 | ||||
WRKST | Basic Material | WRKST | CHAR | 48 | Assigned to domain | WRKST | |||
NORMT | Industry Standard Description (such as ANSI or ISO) | NORMT | CHAR | 18 | NORMT | ||||
LABOR | Laboratory/design office | LABOR | CHAR | 3 | Assigned to domain | LABOR | |||
EKWSL | Purchasing Value Key | EKWSL | CHAR | 4 | Assigned to domain | EKWSL | |||
BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
NTGEW | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VOLUM | Volume | VOLUM | QUAN | 13(3) | MENG13 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BEHVO | Container requirements | BEHVO | CHAR | 2 | Assigned to domain | BEHVO | |||
RAUBE | Storage conditions | RAUBE | CHAR | 2 | Assigned to domain | RAUBE | |||
TEMPB | Temperature conditions indicator | TEMPB | CHAR | 2 | Assigned to domain | TEMPB | |||
DISST | Low-Level Code | DISST | CHAR | 3 | DISST | ||||
TRAGR | Transportation Group | TRAGR | CHAR | 4 | Assigned to domain | TRAGR | |||
STOFF | Hazardous material number | STOFF | CHAR | 18 | Assigned to domain | MATN1 | STOFF | STO | |
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
SPRAS | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
MEINH | Alternative Unit of Measure for Stockkeeping Unit | LRMEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | Assigned to domain | BWTTY | |||
XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1 | XFELD | ||||
MMSTA | Plant-Specific Material Status | MMSTA | CHAR | 2 | Assigned to domain | MMSTA | |||
MMSTD | Date from which the plant-specific material status is valid | MMSTD | DATS | 8 | DATUM | ||||
MAABC | ABC Indicator | MAABC | CHAR | 1 | TMABC | MAABC | |||
KZKRI | Indicator: Critical part | KZKRI | CHAR | 1 | XFELD | ||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | Assigned to domain | EKGRP | EKG | ||
AUSME | Unit of issue | AUSME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DISPR | Material: MRP profile | DISPR | CHAR | 4 | Assigned to domain | DISPR | DPR | ||
DISMM | MRP Type | DISMM | CHAR | 2 | Assigned to domain | DISMM | |||
DISPO | MRP Controller (Materials Planner) | DISPO | CHAR | 3 | Assigned to domain | DISPO | DGR | HS_T024D | |
KZDIE | Indicator: MRP controller is buyer (deactivated) | KZDIE | CHAR | 1 | XFELD | ||||
PLIFZ | Planned Delivery Time in Days | PLIFZ | DEC | 3 | DEC3 | ||||
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
PERKZ | Period Indicator | PERKZ | CHAR | 1 | PERKZ | PKZ | |||
AUSSS | Assembly scrap in percent | AUSSS | DEC | 5(2) | DEC3_2 | ||||
DISLS | Lot size (materials planning) | DISLS | CHAR | 2 | Assigned to domain | DISLS | |||
BESKZ | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
SOBSL | Special procurement type | SOBSL | CHAR | 2 | Assigned to domain | SOBSL | |||
MINBE | Reorder Point | MINBE | QUAN | 13(3) | MENG13 | ||||
EISBE | Safety Stock | EISBE | QUAN | 13(3) | MENG13 | ||||
BSTMI | Minimum Lot Size | BSTMI | QUAN | 13(3) | MENG13 | ||||
BSTMA | Maximum Lot Size | BSTMA | QUAN | 13(3) | MENG13 | ||||
BSTFE | Fixed lot size | BSTFE | QUAN | 13(3) | MENG13 | ||||
BSTRF | Rounding value for purchase order quantity | BSTRF | QUAN | 13(3) | MENG13 | ||||
MABST | Maximum stock level | MABST | QUAN | 13(3) | MENG13 | ||||
LOSFX | Ordering costs | LOSFX | CURR | 11(2) | WERT11 | ||||
NFMAT | Follow-Up Material | NFMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
RGEKZ | Indicator: Backflush | RGEKZ | CHAR | 1 | XFELD | ||||
FEVOR | Responsible planner group/department | VAGRP | CHAR | 3 | Assigned to domain | VAGRP | H_T024A | ||
BEARZ | Processing time | BEARZ | DEC | 5(2) | DEC3_2 | ||||
RUEZT | Setup and teardown time | RUEZT | DEC | 5(2) | DEC3_2 | ||||
TRANZ | Interoperation time | TRANZ | DEC | 5(2) | DEC3_2 | ||||
BASMG | Base quantity | BASMG | QUAN | 13(3) | MENG13 | ||||
DZEIT | In-house production time | DZEIT | DEC | 3 | DEC3 | ||||
MAXLZ | Maximum Storage Period | MAXLZ | DEC | 5 | DEC5 | ||||
LZEIH | Unit for maximum storage period | LZEIH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KZPRO | Indicator: withdrawal of stock from production bin | KZPRO | CHAR | 1 | XFELD | ||||
GPMKZ | Indicator: Material Included in Rough-Cut Planning | GPMKZ | CHAR | 1 | XFELD | ||||
UEETO | Overdelivery tolerance limit | UEETO | DEC | 3(1) | DEC2_1 | ||||
UEETK | Indicator: Unlimited Overdelivery Allowed | UEETK | CHAR | 1 | XFELD | ||||
ATPKZ | Replacement part | ATPKZ | CHAR | 1 | ATPKZ | ||||
MPDAU | Mean inspection duration (deactivated) | MPDAU | DEC | 5 | DEC5 | ||||
WSTGH | Active substance content (deactivated) | WSTGH | DEC | 9 | DEC9 |
Key field | Non-key field |
How do I retrieve data from SAP structure MCADV using ABAP code?
As MCADV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCADV as there is no data to select.How to access SAP table MCADV
Within an ECC or HANA version of SAP you can also view further information about MCADV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects