EHEWAD_WA_TRRQ

Transparent Table Application Table
20 Fields 2 CDS Views

Waste Transfer Request Header Information

EHEWAD_WA_TRRQ is an SAP database table in S/4HANA. Waste Transfer Request Header Information. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WasteTransferRequest view_entity from EXTENSION WTR - Extension
I_WasteTransferRequest view from BASIC Waste Transfer Request Header

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY wastetransfrequuid EHEWA_WST_TRF_REQ_UUID WTR UUID
creationdatetime /BOBF/CREATIONDATETIME Created On
createdbyuser /BOBF/CREATEDBYUSER Created By
lastchangedatetime /BOBF/LASTCHANGEDATETIME Last Changed On
lastchangedbyuser /BOBF/LASTCHANGEDBYUSER Last Changed By
wastetransferrequestnumber EHEWA_WST_TRF_REQ_NUMBER Document Number ID
wastetransfreqdate EHEWA_WST_TRF_REQ_DATE Date of WTR
wastetransfreqstatus EHEWA_WST_TRF_REQ_STATUS Status
wastestreamptofgnrtnlocuuid EHEWA_WST_STRM_PNT_GNRTN_UUID Pnt of Gnrtn UUID
ehsoutgoingamountuuid /BOBF/UUID Key
wastestreamuuid EHEWA_WASTESTREAM_UUID Waste Stream UUID
country EHFND_COUNTRY_ID Country / Region
region EHFND_REGION_ID Region
wastetransfreqpostdate EHEWA_WST_TRF_REQ_DATE Date of WTR
wastestreamdsplchnluuid EHEWA_WST_STRM_DISP_CHNL_UUID Dispsl Channel UUI
envrmtwasteunitofmeasure MEINS Base Unit
envrmtwasteoutgoingquantity EHEWA_WST_TRF_REQ_QUANTITY Quantity
envwsttransfreqremarktxt EHEWA_TRANSFREQ_REM Transf Req Remark
dummy_wtr_ps CFD_DUMMY Dummy

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 Transfer Request Header Information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHEWAD_WA_TRRQ (
    MANDT,                        -- Client [MANDT]
    WASTETRANSFREQUUID,           -- WTR UUID [EHEWA_WST_TRF_REQ_UUID]
    CREATIONDATETIME,             -- Created On [/BOBF/CREATIONDATETIME]
    CREATEDBYUSER,                -- Created By [/BOBF/CREATEDBYUSER]
    LASTCHANGEDATETIME,           -- Last Changed On [/BOBF/LASTCHANGEDATETIME]
    LASTCHANGEDBYUSER,            -- Last Changed By [/BOBF/LASTCHANGEDBYUSER]
    WASTETRANSFERREQUESTNUMBER,   -- Document Number ID [EHEWA_WST_TRF_REQ_NUMBER]
    WASTETRANSFREQDATE,           -- Date of WTR [EHEWA_WST_TRF_REQ_DATE]
    WASTETRANSFREQSTATUS,         -- Status [EHEWA_WST_TRF_REQ_STATUS]
    WASTESTREAMPTOFGNRTNLOCUUID,  -- Pnt of Gnrtn UUID [EHEWA_WST_STRM_PNT_GNRTN_UUID]
    EHSOUTGOINGAMOUNTUUID,        -- Key [/BOBF/UUID]
    WASTESTREAMUUID,              -- Waste Stream UUID [EHEWA_WASTESTREAM_UUID]
    COUNTRY,                      -- Country / Region [EHFND_COUNTRY_ID]
    REGION,                       -- Region [EHFND_REGION_ID]
    WASTETRANSFREQPOSTDATE,       -- Date of WTR [EHEWA_WST_TRF_REQ_DATE]
    WASTESTREAMDSPLCHNLUUID,      -- Dispsl Channel UUI [EHEWA_WST_STRM_DISP_CHNL_UUID]
    ENVRMTWASTEUNITOFMEASURE,     -- Base Unit [MEINS]
    ENVRMTWASTEOUTGOINGQUANTITY,  -- Quantity [EHEWA_WST_TRF_REQ_QUANTITY]
    ENVWSTTRANSFREQREMARKTXT,     -- Transf Req Remark [EHEWA_TRANSFREQ_REM]
    DUMMY_WTR_PS,                 -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, WASTETRANSFREQUUID)
);

Learn More