SAP ABAP View /SAPCEM/V_STL (BOM Header with Items)
Hierarchy
☛
ECC-DIMP (Software Component) DIMP
⤷
IS-EC-CEM (Application Component) Construction Equipment Management
⤷
/SAPCEM/DDIC (Package) CEM Dictionary Objects
⤷
⤷
Basic Data
| View Type | D | Database View |
| Database View | /SAPCEM/V_STL | |
| Short Description | BOM Header with Items | |
| Root table | J_3GSTLKOPF | Header Data for Equipment BOMs |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | J_3GSTLKOPF | |||
| 2 |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | MANDT | JL | EQ | 0 | 0 | |||||
| 2 | MANDT | JR | EQ | AND | 0 | 0 | ||||
| 3 | J_3GSTLNR | JL | EQ | 0 | 0 | |||||
| 4 | J_3GSTLNR | JR | EQ | 0 | 0 | |||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 | MANDT | MANDT | Client | |||||
| 2 | EQUNR | EQUNR | Equipment Number | |||||
| 3 | KATKZ | J_3GTPLKZ | Catalog Code | |||||
| 4 | KATNR | J_3GKATNRC | Number in Catalog | |||||
| 5 | LFDNR | /SAPCEM/NR4 | 4-digit Number | |||||
| 6 | J_3GPOSNRI | J_3GPOSNRI | Internal Item Number | |||||
| 7 | KATBEZ | J_3GKURZB | Short Description | |||||
| 8 | J_3GSTLNR | /SAPCEM/STLNRI | CEM BOM Number (Internal) | |||||
| 9 | POSMAX | J_3GPOSMAX | Last Assigned Item Number for Catalog BOM | |||||
| 10 | ERSDA | ERSDA | Created On | |||||
| 11 | ERNAM | ERNAM | Name of Person who Created the Object | |||||
| 12 | LAEDA | LAEDA | Date of Last Change | |||||
| 13 | AENAM | AENAM | Name of Person Who Changed Object | |||||
| 14 | LVORM | LVORM | Deletion Indicator | |||||
| 15 | AKTKZ | AKTKZ | Indicator: Active | |||||
| 16 | POSNRE | J_3GPOSNRE | External Item Number | |||||
| 17 | KATNR | J_3GKATNRC | Number in Catalog | |||||
| 18 | OBJEK | CUOBN | Key of Object to be Classified | |||||
| 19 | OBTAB | TABELLE | Name of database table for object | |||||
| 20 | KATBEZ | J_3GKURZB | Short Description | |||||
| 21 | MENGE | MENGE_D | Quantity | |||||
| 22 | MEINS | MEINS | Base Unit of Measure | |||||
| 23 | DATVON | DATAB | Valid-From Date | |||||
| 24 | ERNAM | ERNAM | Name of Person who Created the Object | |||||
| 25 | DATBIS | DATBI | Valid To Date | |||||
| 26 | KALART | J_3GKALART | Costing Type of Number in Catalog | |||||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
| Last changed by/on | SAP | 20050301 |
| SAP Release Created in | 46C1 |