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,          -- Bus. 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,        -- Transported Abroad [EHEWA_TRANSPDOC_IS_TRANSP_ABRD]
    EHSWASTETRANSPDOCISRECYCLABLE,   -- Recyclable [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]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, ENVRMTWASTETRANSPDOCUUID)
);