EHFNDW_CCMPS_CMP - I_CHMLCOMPOSITIONTP I_CHMLCOMPONENTTP
I_CHMLCOMPOSITIONTP I_CHMLCOMPONENTTP information is stored in SAP table EHFNDW_CCMPS_CMP.
It is part of development package EHFND_BO_CCI in software component EHS-SUS-FND. This development package consists of objects that can be grouped under "Business Object Chemical Compliance Info".
It is part of development package EHFND_BO_CCI in software component EHS-SUS-FND. This development package consists of objects that can be grouped under "Business Object Chemical Compliance Info".
Fields for table EHFNDW_CCMPS_CMP
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| CHMLCOMPUUID | Chemical Component | X | EHFND_CCI_CCOMP_UUID | RAW | 16 | |
| ACTIVECHMLCOMPUUID | Chemical Component | EHFND_CCI_CCOMP_UUID | RAW | 16 | ||
| CHMLCMPLNCINFOUUID | Chemical Compliance Information | EHFND_CCI_UUID | RAW | 16 | ||
| CHMLCOMPOSITIONUUID | Chemical Composition | EHFND_CCI_CCMPS_UUID | RAW | 16 | ||
| CREATIONUTCDATETIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
| CREATEDBYUSER | User Name | UNAME | CHAR | 24 | ||
| LASTCHANGEUTCDATETIME | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC | 11 | ||
| LASTCHANGEDBYUSER | User Name | UNAME | CHAR | 24 | ||
| SUBSTANCEUUID | Substance | EHFND_SUB_UUID | RAW | 16 | ||
| CHMLCOMPTYPE | Role of Ingredient in Composition | EHFND_CCI_CCOMP_TYPE_NCE | CHAR | 20 | ||
| CHMLCOMPQTY | Concentration Value of Chemical Component | EHFND_CCI_CCOMP_QTY | QUAN | 7 | ||
| CHMLCOMPQTYASTEXT | Concentration Value of a Chemical Component | EHFND_CCI_CCOMP_QTY_CH | CHAR | 160 | ||
| CHMLCOMPQTYUNIT | Concentration Unit of Measure | EHFND_UNIT_CODE_MEINS | UNIT | 6 | ||
| CHMLCOMPOPERATORLOWERLIMIT | Operator for Lower Limit | EHFND_CCI_CCOMP_LOWER_OPERATOR | CHAR | 10 | ||
| CHMLCOMPQTYLOWERLIMIT | Lower Limit of Chemical Component | EHFND_CCI_CCOMP_LOWER_LIMIT | QUAN | 7 | ||
| CHMLCOMPQTYLOWERLIMITASTEXT | Lower Limit of the Concentration for a Chemical Component | EHFND_CCI_CCOMP_LOWER_LIMIT_CH | CHAR | 160 | ||
| CHMLCOMPOPERATORUPPERLIMIT | Operator for Upper Limit | EHFND_CCI_CCOMP_UPPER_OPERATOR | CHAR | 10 | ||
| CHMLCOMPQTYUPPERLIMIT | Upper Limit of Chemical Component | EHFND_CCI_CCOMP_UPPER_LIMIT | QUAN | 7 | ||
| CHMLCOMPQTYUPPERLIMITASTEXT | Upper Limit of the Concentration for a Chemical Component | EHFND_CCI_CCOMP_UPPER_LIMIT_CH | CHAR | 160 | ||
| CHMLCOMPISREMOVED | Removed Indicator for Chemical Component | EHFND_CCI_CCOMP_IS_REMOVED | CHAR | 2 | ||
| ACTIVEUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW | 16 | ||
| HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 2 | ||
| .INCLUDE | SDRAFT_WRITE_DRAFT_ADMIN | 0 | ||||
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 11 | ||
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 11 | ||
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16 | ||
| DRAFTENTITYCONSISTENCYSTATUS | Draft - Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 2 | ||
| DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 2 |