SAP /SAPAPO/MSNP_MATERIAL Table in S/4 HANA - Get: Material characteristics
/SAPAPO/MSNP_MATERIAL is a standard SAP Table which is used to store Get: Material characteristics 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 /SAPAPO/MSNP_MATERIAL 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: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: /SAPAPO/MSNP_MATERIAL
/SAPAPO/MSNP_MATERIAL table structure field list
Below is the full /SAPAPO/MSNP_MATERIAL 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 (APO Conversion to Client-Dependency) | /SAPAPO/CLNTAPO_MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| MATID | Internal Number (UID) for Product | /SAPAPO/MATID | CHAR | 22(0) | /SAPAPO/MATID | /SAPAPO/MATID | /SAPAPO/MATID | MATID | ||
| MATNR | Product Number | /SAPAPO/MATNR | CHAR | 40(0) | PRODU | /SAPAPO/MATNR | /SAPAPO/MAT | /SAPAPO/MAT | MATNR | |
| PRODUCT_TYPE | Product Type | /SAPAPO/PRODUCT_TYPE | CHAR | 2(0) | /SAPAPO/PRODUCT_TYPE | |||||
| LVORM | Deletion flag | /SAPAPO/LVORM | CHAR | 1(0) | XFELD | |||||
| FLAGCLASS | Configuration Relevance of Product | /SAPAPO/FLGCLASS | CHAR | 1(0) | /SAPAPO/FLGCLASS | |||||
| FLAGPACK | Packing Data for a Product | /SAPAPO/FLGPACK | CHAR | 1(0) | /SAPAPO/FLGPACK | |||||
| DISST | Low-Level Code | /SAPAPO/DISST | CHAR | 3(0) | /SAPAPO/DISST | |||||
| MEINS | Base Unit of Measure | /SAPAPO/MEINS | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
| ATTYP | Trading Goods Category | /SAPAPO/ATTYP | CHAR | 2(0) | /SAPAPO/ATTYP | |||||
| LOGUNIT | Logistic Unit of Measure | /SCMB/DE_LOGUNIT | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
| CWREL | Catch weight product | /SCMB/DE_CWREL | CHAR | 1(0) | XFELD | |||||
| TY2TQ | Category of Unit of Measure | /SCMB/MDL_TY2TQ | CHAR | 1(0) | /SCMB/MDL_TY2TQ | |||||
| BRGEW | Gross Weight | /SAPAPO/BRGEW | QUAN | 13(3) | MENG13 | |||||
| NTGEW | Net weight | NTGEW | QUAN | 13(3) | MENG13 | |||||
| GEWEI | Unit of Weight | /SAPAPO/GEWEI | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
| VOLUM | Volume | /SAPAPO/VOLUM | QUAN | 13(3) | MENG13 | |||||
| VOLEH | Unit of Volume | /SAPAPO/VOLEH | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
| SHELF_LIFE_FLAG | Planning with Reference to Product Shelf Life | /SAPAPO/SHELF_LIFE_FLAG | CHAR | 1(0) | XFELD | |||||
| SHELF_LIFE_DUR | Shelf Life | /SAPAPO/SHELF_LIFE_DUR | DEC | 11(0) | TSTRG | TSTRDURAG | ||||
| MATURITY_DUR | Maturation Time | /SAPAPO/MATURITY_DUR | DEC | 11(0) | TSTRG | TSTRDURAG | ||||
| SHLF_LFE_REQ_MIN | Required Minimum Shelf Life | /SAPAPO/SHELF_LIFE_REQ_MIN | DEC | 11(0) | TSTRG | TSTRDURAG | ||||
| SHLF_LFE_REQ_MAX | Required Maximum Shelf Life | /SAPAPO/SHELF_LIFE_REQ_MAX | DEC | 11(0) | TSTRG | TSTRDURAG | ||||
| MHDLP | Remaining Shelf Life (Percentage) | /SAPAPO/MHDLP | DEC | 3(0) | DEC3 | |||||
| IPRKZ | Period Indicator for Shelf Life | /SAPAPO/SHELF_LIFE_IPRKZ | CHAR | 1(0) | /SAPAPO/SHELF_LIFE_IPRKZ | |||||
| SLED_BBD | Shelf Life Expiration Date or Best-Before Date | /SCMB/MDL_SLED_BBD | CHAR | 1(0) | /SCMB/MDL_SLED_BBD | |||||
| SLDRND | Rounding Rule for Calculation of Shelf Life Expiration Date | /SCMB/MDL_SLDRND | CHAR | 1(0) | /SCMB/MDL_SLDRND | |||||
| ATT01 | Free Attribute 1 | /SAPAPO/MAT_CHAR40 | CHAR | 40(0) | CHAR40 | |||||
| ATT02 | Free Attribute 2 | /SAPAPO/MAT_CHAR30 | CHAR | 30(0) | CHAR30 | |||||
| ATT03 | Free Attribute 3 | /SAPAPO/MAT_CHAR20 | CHAR | 20(0) | CHAR20 | |||||
| ATT04 | Free Attribute | /SAPAPO/MAT_CHAR10 | CHAR | 10(0) | CHAR10 | |||||
| ATT05 | Free Attribute | /SAPAPO/MAT_CHAR10 | CHAR | 10(0) | CHAR10 | |||||
| BOD_DEPLVL | Carry Out Push Deployment from Supplier | /SAPAPO/BODDEPLVL | CHAR | 1(0) | XFELD | |||||
| EXCL_EXPEDITE | Exclude from Express Shipment | /SAPAPO/EXCLEXP | CHAR | 1(0) | XFELD | |||||
| PROD_PAOOPT | Product Can Be Procure-to-Order | /SAPAPO/PAOOPT | CHAR | 1(0) | XFELD | |||||
| RESTRICT_INVBAL | Inventory Balancing Not Allowed | /SAPAPO/RESTRICT_INVBAL | CHAR | 1(0) | XFELD | |||||
| DRP_GL_STOCK | DRP: Global Stock on Entry Location | /SAPAPO/DRP_GL_STOCK | CHAR | 1(0) | XFELD | |||||
| MATKL | Material Group | /SAPAPO/MATKL_P | CHAR | 9(0) | /SAPAPO/MATKL | /SAPAPO/MKL | ||||
| COMPL | CTM: Product Completion Level | /SAPAPO/CTM_COMP_LVL | NUMC | 2(0) | /SAPAPO/CTM_COMP_LVL | |||||
| STFAC | Stacking Factor | /SAPAPO/STFAC | NUMC | 2(0) | NUMC2 | |||||
| TRAGR | Transportation Group | /SAPAPO/TRAGR | CHAR | 4(0) | /SAPAPO/TTGR | /SAPAPO/TRAGR | ||||
| TS_SDP_USE | Usage in Demand Planning and Supply Network Planning | /SAPAPO/TS_SDP_USE | CHAR | 1(0) | /SAPAPO/TS_SDP_USE | |||||
| PRDHA | Product Hierarchy | /SAPAPO/PRDHA | CHAR | 18(0) | ||||||
| GTIN_IND | Product Determination | /SAPAPO/PRD_DET | CHAR | 1(0) | /SAPAPO/PRD_DET | |||||
| DISPLAY | Promotion Display | /SAPAPO/DISP | CHAR | 1(0) | /SAPAPO/DISP | |||||
| HERKL | Country of Origin of the Material (Content Component Origin) | /SCMB/MDL_HERKL | CHAR | 3(0) | T005 | LAND1 | ||||
| BATCH_REQ | Batch Management Requirement Indicator | /SCMB/DE_BATCH_REQ | CHAR | 1(0) | XFELD | |||||
| KITCOMP | Product for Kit-to-Order | /SAPAPO/CMPKIT | CHAR | 1(0) | XFELD | |||||
| PRDSET_IND | Product Set | /SAPAPO/PRDSET_IND | CHAR | 1(0) | XFELD | |||||
| SERIAL | Serial Number Profile | /SCWM/DE_SERIAL | CHAR | 4(0) | /SCWM/TSERIAL | /SCWM/DO_SERIAL | ||||
| DATA_CHECK_BY | Name of Person Who Checked the Product | /SCMB/MDL_DATA_CHECKED_BY | CHAR | 12(0) | USR02 | XUBNAME | ||||
| DATA_CHECK_AT | Date on Which the Product Was Checked | /SCMB/MDL_DATA_CHECKED_AT | DEC | 15(0) | TSTLC | /SCMB/TZNTSTMPS | ||||
| KOSCH | Allocations: Product Allocation Procedure | /SAPAPO/KOSCH | CHAR | 18(0) | Assigned to domain | /SAPAPO/KOSCH | /SAPAPO/KOSCH | |||
| KOSCH_GRP | Prod. Allocations: Sequence of Product Allocation Procedures | /SAPAPO/KOSCH_GRP | CHAR | 18(0) | Assigned to domain | /SAPAPO/KOSCH_GRP | ||||
| VMIKOSCH | Allocations: Product Allocation Procedure | /SAPAPO/VMIKOSCH | CHAR | 18(0) | Assigned to domain | /SAPAPO/KOSCH | /SAPAPO/KOSCH | |||
| VMIKOSCH_GRP | Prod. Allocations: Sequence of Product Allocation Procedures | /SAPAPO/VMIKOSCH_GRP | CHAR | 18(0) | Assigned to domain | /SAPAPO/KOSCH_GRP | ||||
| PACKGR | Packing Group | /SCWM/DE_PACKGR | CHAR | 4(0) | /SCWM/TPACKGR | /SCWM/DO_PACKGR | ||||
| RMATP | Ref. Prod. GUID for Products That Can Be Packed The Same Way | /SAPAPO/RMATID | CHAR | 22(0) | /SAPAPO/MATKEY | /SAPAPO/MATID | /SAPAPO/MATID | |||
| HUTYP_DFLT | Standard HU Type | /SCWM/DE_HUTYP_DFLT | CHAR | 4(0) | /SCWM/THUTYP | /SCWM/DO_HUTYP | ||||
| RMATID_PB | Reference Product ID for Package Building | /SAPAPO/RMATID_PB | CHAR | 22(0) | Assigned to domain | /SAPAPO/MATID | ||||
| PROD_SHAPE | Product Shape | /SAPAPO/PROD_SHAPE | CHAR | 2(0) | /SAPAPO/PROD_SHAPE | |||||
| MO_PROFILE_ID | Product Orientation Profile | /SCMB/MO_PROFILE_ID | CHAR | 20(0) | /SCMB/DO_PB_PROFILE_ID | /SCMB/SH_MO_PROFILE_ID | PROFILE_ID | |||
| OVERHANG_TRESH | Overhang Threshold [%] | /SAPAPO/OVERHANG_TRESH | DEC | 5(2) | DEC03_2 | |||||
| BRIDGE_TRESH | Bridge Threshold [%] | /SAPAPO/BRIDGE_TRESH | DEC | 5(2) | DEC03_2 | |||||
| BRIDGE_MAX_SLOPE | Maximum Slope for Bridges [°] | /SAPAPO/BRIDGE_MAX_SLOPE | DEC | 5(2) | DEC03_2 | |||||
| HEIGHT_NONFLAT | Absolute Height Threshold for Stacking on Non-Flat Surface | /SAPAPO/HEIGHT_NONFLAT | QUAN | 13(3) | MENG13 | |||||
| HEIGHT_NONFLAT_UOM | UoM of Abs. Height Threshold (Stacking on Non-Flat Surface) | /SAPAPO/HEIGHT_NONFLAT_UOM | UNIT | 3(0) | Assigned to domain | CUNIT | MEINS | |||
| CUOBJ | Configuration (Internal Object Number) | /SAPAPO/CUOBJ_PR | NUMC | 18(0) | ||||||
| SATID | Internal Number (UID) for Configurable Product | /SAPAPO/SATID | CHAR | 22(0) | Assigned to domain | /SAPAPO/MATID | ||||
| KZKFG | Indicator: Configurable material | /SAPAPO/KZKFG | CHAR | 1(0) | XFELD | |||||
| MATVERS_HEAD | Header Product for Version | /SAPAPO/MATVERS_HEAD | CHAR | 22(0) | Assigned to domain | /SAPAPO/MATID | ||||
| MATVERS_TYPE | Product Version Category | /SAPAPO/MATVERS_TYPE | CHAR | 1(0) | /SAPAPO/MATVERS_TYPE | |||||
| MATVERS_CHNR | Change Number | /SAPAPO/AENNR | CHAR | 12(0) | ALPHA | /SAPAPO/AENNR | /SAPAPO/AEN | |||
| TEMPRPBLOCK | Temporary Replenishment Blocking | /SAPAPO/TEMPRPBLOCK | CHAR | 2(0) | /SAPAPO/TEMPRPBLOCK | |||||
| TEMPRPFROM | Start Date/Time for Temporary Replenishment Blocking | /SAPAPO/TEMPRPFROM | DEC | 15(0) | TZNTSTMPS | |||||
| TEMPRPTO | End Date/Time for Temporary Replenishment Blocking | /SAPAPO/TEMPRPTO | DEC | 15(0) | TZNTSTMPS | |||||
| DUMMY_PRD_INCL_EEW_PS | Dummy Field | PRD_INCL_EEW | CHAR | 1(0) | PRD_INCL_EEW | |||||
| LIKEID | /SAPAPO/LIKEID | CHAR | 22(0) | |||||||
| PHIN_FROM | Start Date for Phase-In | DATS | 8(0) | |||||||
| PHIN_TO | End Date for Phase-In | DATS | 8(0) | |||||||
| PHIN_TSID | Time Series ID for Phase-In | CHAR | 22(0) | |||||||
| PHOUT_FROM | Start Date for Phase-Out | DATS | 8(0) | |||||||
| PHOUT_TO | End Date for Phase-Out | DATS | 8(0) | |||||||
| PHOUT_TSID | Time Series ID for Phase-Out | CHAR | 22(0) | |||||||
| LIFE_CYCLE_LOCID | Internal Location Number (Customer, Supplier, or Plant) | CHAR | 22(0) | |||||||
| CREATEUSER | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
| CREATEUTC | Date and Time at Which Object Was Created | /SAPAPO/TSUCR | DEC | 15(0) | TSTLC | /SAPAPO/U_TZNTSTMPS | ||||
| CHANGEUSER | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
| CHANGEUTC | Date and Time at Which Object Was Last Changed | /SAPAPO/TSUUP | DEC | 15(0) | TSTLC | /SAPAPO/U_TZNTSTMPS | ||||
| FLAG_FS | Is a Fair/Share Product | /SAPAPO/FLG_FS | CHAR | 1(0) | XFLAG | |||||
| MAKTX | Product Short Description | /SAPAPO/MAKTX | CHAR | 40(0) | /SAPAPO/C_CHAR40K |
Search for further information about these or an SAP related objects