REWM_ODOI_D

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 R_EWM_OUTBDELIVORDERITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE REWM_ODOI_D (
    MANDT,                           -- Client [MANDT]
    EWMOUTBOUNDDELIVERYORDER,        -- Document Number [/SCDL/DL_DOCNO_INT]
    EWMOUTBOUNDDELIVERYORDERITEM,    -- Item Number [/SCDL/DL_ITEMNO]
    OUTBOUNDDELIVERYORDERUUID,       -- Document ID [/SCDL/DL_DOCID]
    OUTBOUNDDELIVERYORDERITEMUUID,   -- Item ID [/SCDL/DL_ITEMID]
    EWMWAREHOUSE,                    -- Warehouse No. [/SCWM/LGNUM]
    EWMDELIVERYDOCUMENTCATEGORY,     -- Doc. Category [/SCDL/DL_DOCCAT]
    EWMOUTBDELIVORDERITEMCATEGORY,   -- Item Category [/SCDL/DL_ITEMCAT]
    EWMOUTBDELIVERYORDERITEMTYPE,    -- Item Type [/SCDL/DL_ITEMTYPE]
    PRODUCT,                         -- Product [/SCDL/DL_PRODUCTNO]
    PRODUCTEXTERNALID,               -- Char [CHAR40]
    BATCH,                           -- Batch [CHARG_D]
    PRODUCTQUANTITY,                 -- Quantity [/SCDL/DL_QUANTITY]
    QUANTITYUNIT,                    -- Base Unit [/SCWM/DE_BASE_UOM]
    EWMODOITEMQUANTITYUNITISOCODE,   -- ISO Code [ISOCD_UNIT]
    EWMODOITEMQUANTITYUNITSAPCODE,   -- Internal SAP Code [MEINSINT]
    SERIALNUMBERREQUIREDLEVEL,       -- Serial No. Reqm [/SCWM/DE_SER_STOCK]
    STAGINGAREA,                     -- Stag. Area [/SCWM/DE_STAREA]
    STAGINGAREAGROUP,                -- Stg. Area Group [/SCWM/DE_STAREA_GR]
    STAGINGBAY,                      -- Staging Bay [/SCWM/DE_STABAY]
    GOODSISSUESTATUS,                -- Status Value [/SCDL/DL_STATUS_VALUE]
    PLANNEDPICKINGSTATUS,            -- Status Value [/SCDL/DL_STATUS_VALUE]
    PICKINGSTATUS,                   -- Status Value [/SCDL/DL_STATUS_VALUE]
    COMPLETIONSTATUS,                -- Status Value [/SCDL/DL_STATUS_VALUE]
    OVERALLBLOCKSTATUS,              -- Status Value [/SCDL/DL_STATUS_VALUE]
    LOADINGSTATUS,                   -- Status Value [/SCDL/DL_STATUS_VALUE]
    EWMWHSEREQITMBATSPLTPARENTITEM,  -- Higher Level Batch Item [EWM_DE_WHSEREQITMBATSPLTPARITM]
    EWMWHSEREQGROSSVOLUME,           -- Gross Volume [EWM_DE_WHSEREQ_GROSS_VOL]
    EWMWHSEREQGROSSVOLUMEUNIT,       -- Volume Unit [EWM_DE_WHSEREQ_GROSS_VOL_UOM]
    EWMWHSEREQGROSSWEIGHT,           -- Gross Weight [EWM_DE_WHSEREQ_GROSS_WGT]
    EWMWHSEREQGROSSWEIGHTUNIT,       -- Weight Unit [EWM_DE_WHSEREQ_GROSS_WGT_UOM]
    WAREHOUSEPROCESSTYPE,            -- Whse Proc. Type [/SCWM/DE_PROCTY]
    SHIPPINGCONDITION,               -- Shipping Cond. [/SCDL/DL_SERVICE_LEVEL_CODE]
    GOODSMOVEMENTBIN,                -- Goods Mvt Bin [/SCWM/DL_GMBIN]
    EWMPRODUCTIONSUPPLYAREA,         -- PSA [/SCWM/DL_PSA]
    EWMDELIVLASTCHANGEUTCDATETIME,   -- Time Stamp [TZNTSTMPS]
    WAREHOUSETIMEZONE,               -- Time Zone [TZNZONE]
    EWMSTORAGETYPE,                  -- Storage Type [/SCWM/LGTYP]
    EWMSTORAGESECTION,               -- Storage Section [/SCWM/LGBER]
    EWMSTORAGEBIN,                   -- Storage Bin [/SCWM/LGPLA]
    EWMGOODSRECIPIENT,               -- Goods Recipient [/SCWM/DE_GOODS_RECIPIENT]
    EWMRECIPIENTLOCATIONNAME,        -- Recipient Location [/SCWM/DE_RCLOC]
    EWMLOADINGPOINT,                 -- Loading Point [/SCWM/DE_LOADING_POINT_OUT]
    EWMUNLOADINGPOINT,               -- Unloading Point [/SCWM/DE_UNLOADING_POINT]
    WAREHOUSEDOOR,                   -- Warehouse Door [/SCWM/DE_DOOR]
    EWMWHSEREQITMHASOPNWHSETSK,      -- Open Warehouse Task [EWM_DE_WHSEREQITM_HAS_OPEN_WT]
    PLNDGOODSISSUESTARTUTCDATETIME,  -- Time Stamp [TZNTSTMPS]
    ACTLGOODSISSUESTARTUTCDATETIME,  -- Time Stamp [TZNTSTMPS]
    EWMWHSEREQITMBBDSLEDUTCDTETME,   -- BBD / SLED [EWM_DE_WHSEREQITM_BBDSLED_TST]
    ROUTESCHEDULE,                   -- Calendar/Sched. [/SCWM/DE_DEPART_SCHED]
    ENTITLEDTODISPOSEPARTY,          -- Disposal Party [/SCWM/DE_ENTITLED]
    ENTITLEDTODISPOSEPARTYNAME,      -- abap.char
    EWMSTOCKUSAGE,                   -- Usage [/SCDL/DL_STOCK_USAGE]
    EWMSTOCKTYPE,                    -- Stock Type [/SCDL/DL_STOCK_CATEGORY]
    EWMSTOCKOWNER,                   -- Character Field with Length 10 [CHAR10]
    EWMSTOCKOWNERNAME,               -- abap.char
    DELIVERYITEMSTOCKTYPEDETNCODE,   -- Determin. Ind. [/SCDL/DL_INDICATOR]
    EXTERNALSTOCKDOCUMENTNUMBER,     -- Special Ref. Stk Doc [EWM_DE_STOCKDOCUMENTNUMBER]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [EWM_DE_PSP_INT]
    WBSELEMENTEXTERNALID,            -- WBS Element [EWM_DE_PSP_EXT]
    SPECIALSTOCKIDFGSALESORDER,      -- Sales order [MAT_KDAUF]
    SPECIALSTOCKIDFGSALESORDERITEM,  -- Sales ord. item [MAT_KDPOS]
    COUNTRYOFORIGIN,                 -- C/R of Orig. [/SCWM/DE_COO]
    SALESORDER,                      -- Sales Order [EWM_DE_SALES_ORDER]
    SALESORDERITEM,                  -- Sales Order Item [EWM_DE_SALES_ORDER_ITEM]
    MANUFACTURINGORDER,              -- Manufacturing Order [EWM_DE_MANUFACTURINGORDER]
    MAINTENANCEORDER,                -- Maintenance Order [EWM_DE_MAINTENANCE_ORDER]
    MAINTENANCEORDEROPERATION,       -- Maintenance Order Operation [EWM_DE_MAINTENANCE_ORDER_OP]
    RESERVATION,                     -- Reservation [RSNUM]
    PURCHASEORDER,                   -- Purchase Order [EWM_DE_PURCHASEORDER]
    OUTBOUNDDELIVERY,                -- LE Delivery [/SCWM/SP_DOCNO_ERP]
    OUTBOUNDDELIVERYITEM,            -- LE Delivery Item [/SCWM/SP_ITEMNO_ERP]
    STOCKDOCUMENTCATEGORY,           -- Special Reference Stock Type [EWM_DE_STOCKDOCUMENTCAT]
    PLANT,                           -- abap.char
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, EWMOUTBOUNDDELIVERYORDER, EWMOUTBOUNDDELIVERYORDERITEM)
);