- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
ESH_N_STREAMSUB
Anchor view -STREAMSUB
| view: ESH_L_STREAMSUB
| Extraction:
Not supported
| Component: Specification
Tables used:
/PLMB/AUTH_OBSID, /PLMB/AUTH_UGUSR, /PLMB/AUTH_UGSID, /PLMB/SAM_OBJST, ESH_SR_LTXT, DRAD, UST10S, UST12, MAKT, ESTMJ, TCG36, TCG37, /PLMB/SAM_NODE_T, ESTRI, /PLMB/SEA_OBJMAP, ESTRH, TCG31, TCG32, USR21, /PLMB/SEA_OBJMAP, DRAD_LAST_CHANGE, AGR_1016, /PLMB/AUTH_OT_AC, /PLMB/AUTH_ACT_E, /PLMI/SPC_TYPVAL, TCG31OBJ
- 🔑 Keys (1)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (3)
- ☰ Categorical (1)
- Other (11)
- 🔗 Relations (7)
| Column Name | Description | |
|---|---|---|
| STREAMSUBSTANCEINTERNALID | Sequential Number of Data Record |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| SPECIFICATIONVALIDITYENDDATE | Valid-To Date | |
| SPECIFICATIONVALIDITYSTARTDATE | Valid-From Date | |
| STREAMSUBSTANCECREATIONDATE | Created On |
| Column Name | Description | |
|---|---|---|
| LOGACCMOBJECTTYPEISACTIVE | Access Control Activated for Object Type | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| LOGACCMOBJECTTYPE | Object Type | /PLMB/GOS_OBJECT_TYPE | |
| PLAINLONGTEXT | Long Text | ||
| PRODUCTNAME | Product Description | TEXT40 | |
| SPECIDFGDESCTEXT | Identifier | TEXT132 | |
| SPECIFICATIONAUTHZNGROUPDESC | Authorization Group Description | TEXT40 | |
| SPECIFICATIONHEADERSTATUS | Status Identification | /PLMB/SAM_STATUS_ID_D | |
| SPECIFICATIONHEADERSTATUSDESC | Status Description | /PLMB/SAM_ACTION_DESCRIPTION_D | |
| SPECIFICATIONTYPEDESCRIPTION | Specification Type Description | TEXT40 | |
| STREAMSUBSTANCE | Stream Substance | CHAR12 | |
| STREAMSUBSTANCECREATEDBYUSER | Created By | USNAM | |
| USERDESCRIPTION | User Description | SUIDTECHDESC |
| Master Data Relations | Join Conditions |
|---|---|
Document number
| |
Foreign key for material
| |
| Specification Category | ESH_N_STREAMSUB.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE |
Foreign Key for Change Number
| |
Foreign Key for Substance Nature
| |
Description of Authorization Group
| |
Foreign key for substance type
|