SAP Table EXPO_BOM_2_MAT
Generated Table for View
EXPO_BOM_2_MAT (Generated Table for View) 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 EXPO_BOM_2_MAT to other SAP tables.
EXPO_BOM_2_MAT table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||
CAPID | Application | CAPID | CHAR | 4 | 0 | |||||||||||||||||
CSLID | CIM selection indicator for alternatives | CSLID | CHAR | 2 | 0 | |||||||||||||||||
CSLPR | CIM priority for selection ID | CSLPR | NUMC | 2 | 0 | |||||||||||||||||
MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||||||||
WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||||||
STLAN | BOM Usage | STLAN | T416 | CHAR | 1 | 0 | ||||||||||||||||
STLNR | Bill of material | STNUM | CHAR | 8 | 0 | |||||||||||||||||
STLAL | Alternative BOM | STALT | CHAR | 2 | 0 | |||||||||||||||||
STLTY | BOM category | STLTY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
STKOZ | Internal counter | CIM_COUNT | NUMC | 8 | 0 | |||||||||||||||||
STLST | BOM status | STLST | NUMC | 2 | 0 | |||||||||||||||||
X415A | Indicator: alternative determination for multiple BOMs | X415A | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
XZBDP | Indicator: explosion in MRP required | XZBDP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
XZPAF | Indicator: release for planned orders required | XZPAF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
XZKLF | Indicator: release for costing required | XZKLF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
XZAPF | Indicator: release for work scheduling required | XZAPF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
XZAUF | Indicator: release for orders required | XZAUF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
XZSME | Indicator: collective issue must be allowed | XZSME | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
XZRVA | Indicator: explosion in sales order required | XZRVA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
XFVRS | Indicator: check production process versions | XFVRS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
XVWPR | Indicator: BOM usage has high priority in alt. determination | XVWPR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
KZBDP | Indicator: explosion in material requirements planning (MRP) | KZBDP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
KZPAF | Indicator: released for planned orders | KZPAF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
KZKLF | Indicator: released for costing | KZKLF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
KZAPF | Indicator: released for work scheduling | KZAPF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
KZAUF | Indicator: released for production orders | KZAUF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
KZSME | Indicator: collective issue allowed | KZSME | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
KZRVA | Indicator: sales order explosion | KZRVA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
KZAMS | MRP exception message ID (T458A) | KZAMS | T458A | CHAR | 2 | 0 | ||||||||||||||||
AENNR | Change Number | AENNR | AENR | CHAR | 12 | 0 |
EXPO_BOM_2_MAT foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
EXPO_BOM_2_MAT | AENNR | EXPO_BOM_2_MAT | MANDT | AENR | Change Master | MANDT |
EXPO_BOM_2_MAT | AENNR | EXPO_BOM_2_MAT | AENNR | AENR | Change Master | AENNR |
EXPO_BOM_2_MAT | KZAMS | EXPO_BOM_2_MAT | MANDT | T458A | Exception Messages in Material Requirements Planning | MANDT |
EXPO_BOM_2_MAT | KZAMS | EXPO_BOM_2_MAT | KZAMS | T458A | Exception Messages in Material Requirements Planning | AUSSL |
EXPO_BOM_2_MAT | MANDT | EXPO_BOM_2_MAT | MANDT | T000 | Clients | MANDT |
EXPO_BOM_2_MAT | MATNR | EXPO_BOM_2_MAT | MANDT | MARA | General Material Data | MANDT |
EXPO_BOM_2_MAT | MATNR | EXPO_BOM_2_MAT | MATNR | MARA | General Material Data | MATNR |
EXPO_BOM_2_MAT | STLAN | EXPO_BOM_2_MAT | MANDT | T416 | BOM Usage - Item Statuses | MANDT |
EXPO_BOM_2_MAT | STLAN | EXPO_BOM_2_MAT | STLAN | T416 | BOM Usage - Item Statuses | STLAN |
EXPO_BOM_2_MAT | WERKS | EXPO_BOM_2_MAT | WERKS | T001W | Plants/Branches | WERKS |
EXPO_BOM_2_MAT | WERKS | EXPO_BOM_2_MAT | MANDT | T001W | Plants/Branches | MANDT |