SAP ABAP Table S086E (S086 - Structural Information)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
BBPCRM (Software Component) BBPCRM⤷
CRM (Application Component) Customer Relationship Management⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages⤷
MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | S086E |
Table Relationship Diagram 
|
| Short Description | S086 - Structural Information |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | SSOUR |
SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
| 3 | AKTNR |
WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | WAKH | |
| 4 | WERKS |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 5 | BTRKZ |
VLFKZ | VLFKZ | CHAR | 1 | 0 | Plant category | ||
| 6 | WGRU2 |
MCW_WGRU2 | KLASSE | CHAR | 18 | 0 | Material group hierarchy 2 | ||
| 7 | WGRU1 |
MCW_WGRU1 | KLASSE | CHAR | 18 | 0 | Material group hierarchy 1 | ||
| 8 | MATKL |
MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
| 9 | MATNR |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 10 | AKTYP |
W_AKTYP | AKTTY | CHAR | 4 | 0 | Promotion Category | TWTY | |
| 11 | AKTHE |
W_AKTHE | THEMA | CHAR | 4 | 0 | Promotion theme | TWAT | |
| 12 | BASME |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
| 13 | HWAER |
HWAER | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
| 14 | UBASME |
UMREFF | FLTP | FLTP | 16 | 16 | Conversion factor: quantities | ||
| 15 | UHWAER |
UMREFF | FLTP | FLTP | 16 | 16 | Conversion factor: quantities | ||
| 16 | PLOBJ |
PLOBJ | CHAR18 | CHAR | 18 | 0 | Planning object | ||
| 17 | PERKZ |
PERVR | PERVR | CHAR | 1 | 0 | Period indicator | ||
| 18 | PERIV |
PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | T009 | |
| 19 | PLTKZ |
PLTKZ | CHAR01 | CHAR | 1 | 0 | Indicator: element used in planning | ||
| 20 | ANTEI |
DANTEF | FLTP | FLTP | 16 | 16 | Proportional factor (%) for disaggregation of product group |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | S086E | AKTHE |  TWAT |
AKTHE |
|||
| 2 | S086E | AKTNR | WAKH |
AKTNR |
|||
| 3 | S086E | AKTYP | TWTY |
AKTYP |
|||
| 4 | S086E | BASME | T006 |
MSEHI |
|||
| 5 | S086E | HWAER | TCURC |
WAERS |
|||
| 6 | S086E | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 7 | S086E | MATKL | T023 |
MATKL |
|||
| 8 | S086E | MATNR | MARA |
MATNR |
|||
| 9 | S086E | PERIV | T009 |
PERIV |
KEY | 1 | CN |
| 10 | S086E | WERKS | T001W |
WERKS |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |
