| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | RELID | Version Number Component | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CHAR2 | Allow NULL? |
| 3 | MEMORY_ID | Buffer ID for Access to EH&S Expert | nvarchar | 22 | 0 | CHAR | (N' ') | No | | EHSBE_RC_BUFFER_ID | Allow NULL? |
| 4 | SRTF2 | Natural Number | int | 10 | 0 | INT4 | ((0)) | No | | INT4 | Allow NULL? |
| 5 | COMP_TYPE | ID of Composition Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | EHSBE_RC_COMPTYP | Allow NULL? |
| 6 | RECNCMP | Internal Key of Substance Group with Constraints (RECN) | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | EHSBE_RC_RECN_GROUP | Allow NULL? |
| 7 | SUBIDCMP | SUBID of Substance Group with Constraints | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | EHSBE_RC_SUBID_GROUP | Allow NULL? |
| 8 | WEIGHTING_FACTOR | Weighting Factor of a Substance in a Group | decimal | 10 | 4 | DEC | ((0)) | Yes | | EHSBE_RC_GRP_WEIGHT_FACTOR | |
| 9 | RECNSUB | Internal Key of Substance with Constraints (RECN) | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | EHSBE_RC_RECN_REG_SUB | Allow NULL? |
| 10 | SUBIDSUB | SUBID of Substance with Constraints | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | EHSBE_RC_SUBID_REG_SUB | Allow NULL? |
| 11 | CLUSTR | 2 byte integer (signed) | smallint | 5 | 0 | INT2 | ((0)) | Yes | | INT2 | |
| 12 | CLUSTD | Data cluster, maximum length 300 | varbinary | 300 | 0 | LRAW | | Yes | | LRAW0300 | |