1. Home
  2. Resources
  3. SAP Tables
  4. BAPIMATDOA - Material Get Detail - Material Data at Client Level

SAP Table BAPIMATDOA

Material Get Detail - Material Data at Client Level

BAPIMATDOA (Material Get Detail - Material Data at Client Level) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPIMATDOA to other SAP tables.

BAPIMATDOA table fields

Field Data element Checktable Datatype Length Decimals
MATL_DESC Material Description (Short Text) MAKTX CHAR 40 0
OLD_MAT_NO Old material number BISMT CHAR 18 0
MATL_TYPE Material Type MTART T134 CHAR 4 0
IND_SECTOR Industry sector MBRSH T137 CHAR 1 0
DIVISION Division SPART TSPA CHAR 2 0
MATL_GROUP Material Group MATKL T023 CHAR 9 0
PROD_HIER Product hierarchy PRODH_D T179 CHAR 18 0
BASIC_MATL Basic material (basic constituent of a material) - obsolete WRKST_OLD CHAR 14 0
STD_DESCR Industry Standard Description (such as ANSI or ISO) NORMT CHAR 18 0
LAB_DESIGN Laboratory/design office LABOR T024L CHAR 3 0
PROD_MEMO Production/inspection memo FERTH CHAR 18 0
PAGEFORMAT Page Format of Production Memo FORMT CHAR 4 0
CONTAINER Container requirements BEHVO T144 CHAR 2 0
STOR_CONDS Storage conditions RAUBE T142 CHAR 2 0
TEMP_CONDS Temperature conditions indicator TEMPB T143 CHAR 2 0
BASE_UOM Base Unit of Measure MEINS T006 UNIT 3 0
EAN_UPC International Article Number (EAN/UPC) EAN11 CHAR 18 0
EAN_CAT Category of International Article Number (EAN) NUMTP TNTP CHAR 2 0
SIZE_DIM Size/dimensions GROES CHAR 32 0
GROSS_WT Gross Weight BRGEW QUAN 13 3
NET_WEIGHT Net Weight NTGEW QUAN 13 3
UNIT_OF_WT Weight Unit GEWEI T006 UNIT 3 0
VOLUME Volume VOLUM QUAN 13 3
VOLUMEUNIT Volume unit VOLEH T006 UNIT 3 0
LENGTH Length LAENG QUAN 13 3
WIDTH Width BREIT QUAN 13 3
HEIGHT Height HOEHE QUAN 13 3
UNIT_DIM Unit of Dimension for Length/Width/Height MEABM T006 UNIT 3 0
MANU_MAT Manufacturer Part Number MFRPN CHAR 40 0
MFR_NO Number of a Manufacturer MFRNR LFA1 CHAR 10 0
BASE_UOM_ISO Base unit of measure in ISO code MEINS_ISO T006I CHAR 3 0
UNIT_OF_WT_ISO Unit of weight in ISO code GEWEI_ISO T006I CHAR 3 0
VOLUMEUNIT_ISO Volume unit in ISO code VOLEH_ISO T006I CHAR 3 0
UNIT_DIM_ISO Unit for length/breadth/height in ISO code MEABM_ISO T006I CHAR 3 0
CREATED_ON Created On ERSDA DATS 8 0
CREATED_BY Name of Person who Created the Object ERNAM CHAR 12 0
LAST_CHNGE Date of Last Change LAEDA DATS 8 0
CHANGED_BY Name of Person Who Changed Object AENAM CHAR 12 0
MATL_CAT Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
EMPTIESBOM Empties Bill of Material W_MITLEERG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
BASIC_MATL_NEW Basic Material WRKST TWSPR CHAR 48 0

BAPIMATDOA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BAPIMATDOA BASE_UOM SYST MANDT T006 Units of Measurement MANDT
BAPIMATDOA BASE_UOM BAPIMATDOA BASE_UOM T006 Units of Measurement MSEHI
BAPIMATDOA BASE_UOM_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
BAPIMATDOA BASE_UOM_ISO BAPIMATDOA BASE_UOM_ISO T006I ISO codes for units of measurement ISOCODE
BAPIMATDOA BASIC_MATL_NEW SYST MANDT TWSPR Check Table for Basic Material Field MANDT
BAPIMATDOA BASIC_MATL_NEW BAPIMATDOA BASIC_MATL_NEW TWSPR Check Table for Basic Material Field WRKST
BAPIMATDOA CONTAINER BAPIMATDOA CONTAINER T144 Container Requirements for Storing Materials BEHVO
BAPIMATDOA CONTAINER SYST MANDT T144 Container Requirements for Storing Materials MANDT
BAPIMATDOA DIVISION SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
BAPIMATDOA DIVISION BAPIMATDOA DIVISION TSPA Organizational Unit: Sales Divisions SPART
BAPIMATDOA EAN_CAT SYST MANDT TNTP International Article Number (EAN) Categories MANDT
BAPIMATDOA EAN_CAT BAPIMATDOA EAN_CAT TNTP International Article Number (EAN) Categories NUMTP
BAPIMATDOA IND_SECTOR SYST MANDT T137 Industries for materials MANDT
BAPIMATDOA IND_SECTOR BAPIMATDOA IND_SECTOR T137 Industries for materials MBRSH
BAPIMATDOA LAB_DESIGN SYST MANDT T024L Laboratory/office for material MANDT
BAPIMATDOA LAB_DESIGN BAPIMATDOA LAB_DESIGN T024L Laboratory/office for material LABOR
BAPIMATDOA MATL_GROUP SYST MANDT T023 Material Groups MANDT
BAPIMATDOA MATL_GROUP BAPIMATDOA MATL_GROUP T023 Material Groups MATKL
BAPIMATDOA MATL_TYPE SYST MANDT T134 Material Types MANDT
BAPIMATDOA MATL_TYPE BAPIMATDOA MATL_TYPE T134 Material Types MTART
BAPIMATDOA MFR_NO SYST MANDT LFA1 Vendor Master (General Section) MANDT
BAPIMATDOA MFR_NO BAPIMATDOA MFR_NO LFA1 Vendor Master (General Section) LIFNR
BAPIMATDOA PROD_HIER SYST MANDT T179 Materials: Product Hierarchies MANDT
BAPIMATDOA PROD_HIER BAPIMATDOA PROD_HIER T179 Materials: Product Hierarchies PRODH
BAPIMATDOA STOR_CONDS SYST MANDT T142 Storage Conditions for Materials MANDT
BAPIMATDOA STOR_CONDS BAPIMATDOA STOR_CONDS T142 Storage Conditions for Materials RAUBE
BAPIMATDOA TEMP_CONDS SYST MANDT T143 Temperature Conditions for Storing Materials MANDT
BAPIMATDOA TEMP_CONDS BAPIMATDOA TEMP_CONDS T143 Temperature Conditions for Storing Materials TEMPB
BAPIMATDOA UNIT_DIM SYST MANDT T006 Units of Measurement MANDT
BAPIMATDOA UNIT_DIM BAPIMATDOA UNIT_DIM T006 Units of Measurement MSEHI
BAPIMATDOA UNIT_DIM_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
BAPIMATDOA UNIT_DIM_ISO BAPIMATDOA UNIT_DIM_ISO T006I ISO codes for units of measurement ISOCODE
BAPIMATDOA UNIT_OF_WT SYST MANDT T006 Units of Measurement MANDT
BAPIMATDOA UNIT_OF_WT BAPIMATDOA UNIT_OF_WT T006 Units of Measurement MSEHI
BAPIMATDOA UNIT_OF_WT_ISO BAPIMATDOA UNIT_OF_WT_ISO T006I ISO codes for units of measurement ISOCODE
BAPIMATDOA UNIT_OF_WT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
BAPIMATDOA VOLUMEUNIT SYST MANDT T006 Units of Measurement MANDT
BAPIMATDOA VOLUMEUNIT BAPIMATDOA VOLUMEUNIT T006 Units of Measurement MSEHI
BAPIMATDOA VOLUMEUNIT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
BAPIMATDOA VOLUMEUNIT_ISO BAPIMATDOA VOLUMEUNIT_ISO T006I ISO codes for units of measurement ISOCODE