EHEWAW_WA_TRADOC

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.

-- Draft table for entity I_ENVRMTWASTETRANSPDOC
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHEWAW_WA_TRADOC (
    MANDT,                           -- Client [mandt]
    ENVRMTWASTETRANSPDOCUUID,        -- Transp Doc UUID [ehewa_transpdoc_uuid]
    WASTETRANSPDOCID,                -- Trans Doc ID [ehewa_transpdoc_id]
    ENVRMTWASTETRANSPDOCNUMBER,      -- Trans Doc Number [ehewa_transpdoc_number]
    ENVRMTWASTETRANSPDOCTYPE,        -- Trans Doc Ty ID [ehewa_transpdoc_type]
    ENVRMTWASTETRANSPDOCSTATUS,      -- Trans Doc Status [ehewa_transpdoc_status]
    ENVRMTWASTEGNRTRUUID,            -- Waste Generator UUID [ehewa_waste_generator_uuid]
    ENVRMTWASTEPARTNERNMBR,          -- Busn. Partner [bu_partner]
    ENVRMTWASTEGNRTRID,              -- Waste Generator ID [ehewa_waste_generator_id]
    CMPLRQVERSUUID,                  -- Compl Req UUID [ehfnd_crv_uuid]
    CMPLRQVERSPERMITNUMBER,          -- Permit Number [ehfnd_req_number]
    CHMLCMPLNCWASTECODEUUID,         -- Chml Cmplnc Wst Code [ehewa_ccw_wcode_uuid]
    WASTESTREAMDSPLCHNLUUID,         -- Dispsl Channel UUI [ehewa_wst_strm_disp_chnl_uuid]
    ENVRMTWASTETOTCONFIRMEDQTY,      -- Confirmed Qty [ehewa_total_confirmed_qty]
    ENVRMTWASTEDCMLTOTCONFIRMEDQTY,  -- Confirmed Qty [ehewa_total_confirmed_qty_d]
    ENVRMTWASTETOTCONFIRMEDQTYCODE,  -- Unit of Measurement [ehfnd_unit_code_meins]
    ENVRMTWASTETOTOUTGOINGQTY,       -- Total Out Qty [ehewa_total_outgoing_qty]
    ENVRMTWASTETOTOUTGOINGQTYCODE,   -- Unit of Measurement [ehfnd_unit_code_meins]
    ENVWSTTRANSPDOCRETURNBYDATE,     -- Trans Doc Ret Date [ehewa_transpdoc_return_date]
    ENVWSTTRANSPDOCPRINTEDDATE,      -- Trans Doc Print Date [ehewa_transpdoc_print_date]
    ENVWSTTRANSPDOCHANDOVERDATE,     -- Trans Doc HndovrDate [ehewa_transpdoc_hndovr_date]
    ENVWSTTRANSPDOCDESCRIPTION,      -- Trans Doc Desc [ehewa_transpdoc_desc]
    ENVWSTTRANSPDOCREMARKTXT,        -- Transp Doc Remark [ehewa_transpdoc_rem]
    WASTETRANSPDOCMATLISTRANSFREQ,   -- Created from WTR [ehewa_transpdocmatl_is_wtr]
    WASTEDISPOSALCHANNELNUMBER,      -- Number [ehewa_wdc_number]
    DNGRSGOODSMODEOFTRANSPORT,       -- Mode of Transport [ehfnd_req_mot_nd]
    WASTEISTRANSPORTEDABROAD,        -- ehewa_transpdoc_is_transp_abrd
    EHSWASTETRANSPDOCISRECYCLABLE,   -- ehewa_product_is_recyclable
    COUNTRY,                         -- Country / Region [ehfnd_country_id]
    EHSAUTHORIZATIONCHECKHASFAILED,  -- Select [ehfnd_boolean]
    ENVWSTTRANSPDOCDISPOSERDATE,     -- Take/Accept Date [ehewa_transpdoc_takeacc_date]
    WASTEPARTNERDISPOSERSGNTRDATE,   -- WastePrtn Sgntr Date [ehewa_wasteprtn_sig_date]
    WASTEDISPOSERCNTCTPERSNNAME,     -- WastePrtn CntctPersn [ehewa_wasteprtn_cntctpers_name]
    CMPLRQPERMITTYPE,                -- abap.char
    ENVRMTWASTEGNRTRNAME,            -- Location [ehfnd_loc_name]
    CREATIONDATETIME,                -- Created On [/bobf/creationdatetime]
    CREATEDBYUSER,                   -- Created By [/bobf/createdbyuser]
    LASTCHANGEDATETIME,              -- Last Changed On [/bobf/lastchangedatetime]
    LASTCHANGEDBYUSER,               -- Last Changed By [/bobf/lastchangedbyuser]
    PRIMARY KEY (MANDT, ENVRMTWASTETRANSPDOCUUID)
);