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
    PRIMARY KEY (MANDT, EWMOUTBOUNDDELIVERYORDER, EWMOUTBOUNDDELIVERYORDERITEM)
);