EHFNDD_REQ_WCODE
Waste Code
EHFNDD_REQ_WCODE is an SAP database table in S/4HANA. Waste Code. It contains 18 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CmplRqVersWasteCode | view | from | BASIC | Compl. Req. Version Waste Code Reg list |
Fields (18)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bco_id | EHFND_BCO_ID | BCO ID | |||
| KEY | bco_key | EHFND_BCO_KEY | BCO KEY | |||
| KEY | db_key | /BOBF/CONF_KEY | NodeID | |||
| root_key | /BOBF/CONF_KEY | NodeID | ||||
| parent_key | /BOBF/CONF_KEY | NodeID | ||||
| datetime_cr | /BOBF/DATETIME_CR | Created On/At | ||||
| user_id_cr | /BOBF/USER_ID_CR | Created By | ||||
| datetime_ch | /BOBF/DATETIME_CH | Changed On/At | ||||
| user_id_ch | /BOBF/USER_ID_CH | Changed By | ||||
| waste_code | EHFND_WASTE_CODE | Waste Code | ||||
| listsub_id | EHFND_REGBASLST_SUB | Listed Substance | ||||
| regulatory_level | EHFND_REG_LEVEL | Regulatory Level | ||||
| reglevel_unit | EHFND_REGLEVEL_UNIT | Reg. Level Unit | ||||
| hazard_code | EHFND_HAZ_CODE | Hazard Code | ||||
| record_id | EHFND_REQ_REGLIST_RECORD_ID | Record ID | ||||
| short_waste_code | EHFND_WASTE_CODE | Waste Code | ||||
| eew_req_wastecode_d | DUMMY | Dummy function in length 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Waste Code
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_REQ_WCODE (
MANDT, -- Client [MANDT]
BCO_ID, -- BCO ID [EHFND_BCO_ID]
BCO_KEY, -- BCO KEY [EHFND_BCO_KEY]
DB_KEY, -- NodeID [/BOBF/CONF_KEY]
ROOT_KEY, -- NodeID [/BOBF/CONF_KEY]
PARENT_KEY, -- NodeID [/BOBF/CONF_KEY]
DATETIME_CR, -- Created On/At [/BOBF/DATETIME_CR]
USER_ID_CR, -- Created By [/BOBF/USER_ID_CR]
DATETIME_CH, -- Changed On/At [/BOBF/DATETIME_CH]
USER_ID_CH, -- Changed By [/BOBF/USER_ID_CH]
WASTE_CODE, -- Waste Code [EHFND_WASTE_CODE]
LISTSUB_ID, -- Listed Substance [EHFND_REGBASLST_SUB]
REGULATORY_LEVEL, -- Regulatory Level [EHFND_REG_LEVEL]
REGLEVEL_UNIT, -- Reg. Level Unit [EHFND_REGLEVEL_UNIT]
HAZARD_CODE, -- Hazard Code [EHFND_HAZ_CODE]
RECORD_ID, -- Record ID [EHFND_REQ_REGLIST_RECORD_ID]
SHORT_WASTE_CODE, -- Waste Code [EHFND_WASTE_CODE]
EEW_REQ_WASTECODE_D, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (MANDT, BCO_ID, BCO_KEY, DB_KEY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA