- 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)
- Product Safety (EHS-SAF)
- SAP EHS Management (EHS-MGM)
- Sustainability (EHS-SUS)
- Dangerous Goods (EHS-SUS-DG)
- Environment Management (EHS-SUS-EM)
- Health & Safety Management (EHS-SUS-HS)
- Incident Management (EHS-SUS-IM)
- Product Marketability (EHS-SUS-PMA)
- Safety Data Sheets (EHS-SUS-SDS)
- Sustainability Content Infrastructure (EHS-SUS-CI)
- Sustainability Foundation (EHS-SUS-FND)
- Waste Management (EHS-SUS-WA)
- 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)
C_SubstanceQryTP
Manage Substances Compliance
| view: CSUBQRYTP
| Extraction:
Not supported
| Component: Sustainability Foundation
Tables used:
EHFNDW_SUB, EHFNDD_LISU_RT, EHFNDD_LISU_NAME, USR21, EHFNDD_LISU_NAME, EHFNDI_LISU_NAME, EHFNDI_LISU_RT, EHFNDI_LISU_RT
- 🔑 Keys (1)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates
- ☰ Categorical (1)
- Other (39)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| SubstanceUUID | Substance |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| SubstGrpAssgmtRankingIsVisible | Select Boolean | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| ActiveSubstanceUUID | Substance | SYSUUID | |
| SubstanceName | Substance Name | TEXT255 | |
| SubstanceInternalName | Internal Substance Name | TEXT255 | |
| ListedSubstanceName | Listed Substance Name | EHFND_TEXT1333 | |
| CntntListedSubstanceDfltName | Listed Substance Name | EHFND_TEXT1333 | |
| CustListedSubstanceDfltName | Listed Substance Name | EHFND_TEXT1333 | |
| CompanySubstanceName | Substance Name | EHFND_TEXT1333 | |
| ListedSubstanceUUID | Listed Substance UUID | SYSUUID | |
| ListedSubstance | Listed Substance | EHFND_LISTEDSUBSTANCE_ID | |
| CntntListedSubstance | Listed Substance | EHFND_LISTEDSUBSTANCE_ID | |
| CustListedSubstance | Listed Substance | EHFND_LISTEDSUBSTANCE_ID | |
| CASNumber | CAS Number | TEXT20 | |
| CntntCASNumber | CAS Number | TEXT20 | |
| CustCASNumber | CAS Number | TEXT20 | |
| ECNumber | EC Number | EHFND_LISU_EC_NUMBER | |
| CntntECNumber | Listed Substance EC Number | EHFND_LISU_EC_NUMBER | |
| CustECNumber | Listed Substance EC Number | EHFND_LISU_EC_NUMBER | |
| MolecularFormula | Molecular Formula | EHFND_DESCRIPTION_S | |
| CntntMolecularFormula | Molecular Formula | EHFND_DESCRIPTION_S | |
| CustMolecularFormula | Molecular Formula | EHFND_DESCRIPTION_S | |
| ResponsibleUnit | Responsible Unit | EHFND_CCI_RESPONSIBLE_UNIT | |
| CreationUTCDateTime | Created On | TZNTSTMPL | |
| CreatedByUser | Created By | UNAME | |
| LastChangeUTCDateTime | Last Changed On | TZNTSTMPL | |
| LastChangedByUser | Last Change By | UNAME | |
| UserDescription | User Description | SUIDTECHDESC | |
| IsCloudSystem | Single-Character Flag | CHAR1 | |
| SpecificationNavgnLink | Internal Number | ESDSUBID | |
| Specification | Internal Number | ESDSUBID | |
| NmbrOfAvailLstdSubstVariants | null | ||
| NmbrOfAssgdLstdSubstVariants | null | ||
| PCEctxPrptyNavgnLinkUUID | 16 Byte UUID in 16 Bytes (Raw Format) | SYSUUID_X16 | |
| PCEctxPrptyIsActive | Single-Character Flag | CHAR1 | |
| PCPhysPrptyNavgnLinkUUID | 16 Byte UUID in 16 Bytes (Raw Format) | SYSUUID_X16 | |
| PCPhysPrptyIsActive | Single-Character Flag | CHAR1 | |
| PCPrptyNavgnLinkUUID | 16 Byte UUID in 16 Bytes (Raw Format) | SYSUUID_X16 | |
| PCPrptyIsActive | Single-Character Flag | CHAR1 | |
| PCSftyPrptyNavgnLinkUUID | 16 Byte UUID in 16 Bytes (Raw Format) | SYSUUID_X16 | |
| PCSftyPrptyIsActive | Single-Character Flag | CHAR1 |