REWM_IDI_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_InbDeliveryItemTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE REWM_IDI_D (
    MANDT,                           -- Client [mandt]
    EWMINBOUNDDELIVERY,              -- Document Number [/scdl/dl_docno_int]
    EWMINBOUNDDELIVERYITEM,          -- Item Number [/scdl/dl_itemno]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    INBOUNDDELIVERYUUID,             -- Document ID [/scdl/dl_docid]
    INBOUNDDELIVERYITEMUUID,         -- Item ID [/scdl/dl_itemid]
    EWMWAREHOUSE,                    -- Warehouse No. [/scwm/lgnum]
    WAREHOUSETIMEZONE,               -- Time Zone [tznzone]
    EWMDELIVERYDOCUMENTCATEGORY,     -- Doc. Category [/scdl/dl_doccat]
    EWMINBOUNDDELIVERYITEMCATEGORY,  -- Item Category [/scdl/dl_itemcat]
    EWMINBOUNDDELIVERYITEMTYPE,      -- Item Type [/scdl/dl_itemtype]
    PRODUCT,                         -- Char [char40]
    PRODUCTEXTERNALID,               -- Char [char40]
    BATCH,                           -- Batch [charg_d]
    EWMWHSEREQITMBATCHISCREATED,     -- ewm_de_whsereqitmbatchiscrted
    EWMBATCHBYSUPPLIERPLANNED,       -- Supplier Batch [lichn]
    EWMPRODUCTBYSUPPLIER,            -- ewm_de_supplier_product
    COUNTRYOFORIGIN,                 -- C/R of Orig. [/scwm/de_coo]
    PRODUCTQUANTITY,                 -- Quantity [/scdl/dl_quantity]
    EWMWHSEREQITMPRODUCTUIQUANTITY,  -- ewm_de_whsereqitmproductuiquan
    QUANTITYUNIT,                    -- Base Unit [/scwm/de_base_uom]
    EWMINBDELIVITMQUANTITYSAPCODE,   -- Internal SAP Code [meinsint]
    EWMINBDELIVITMQUANTITYISOCODE,   -- ISO Code [isocd_unit]
    EWMWHSEREQITMBATSPLTPARENTITEM,  -- Higher Level Batch Item [ewm_de_whsereqitmbatspltparitm]
    EWMWHSEREQITMHIERPARENTITEM,     -- Higher Level Item [ewm_de_whsereqitmhierparitm]
    SERIALNUMBERREQUIREDLEVEL,       -- Serial No. Reqm [/scwm/de_ser_stock]
    EWMWHSEREQITMBBDSLEDUTCDTETME,   -- BBD / SLED [ewm_de_whsereqitm_bbdsled_tst]
    EWMWHSEREQITMPRODNDTETME,        -- ewm_de_whsereqitm_prod_tst
    STAGINGAREAGROUP,                -- Stg. Area Group [/scwm/de_starea_gr]
    STAGINGAREA,                     -- Stag. Area [/scwm/de_starea]
    STAGINGBAY,                      -- Staging Bay [/scwm/de_stabay]
    GOODSRECEIPTSTATUS,              -- Status Value [/scdl/dl_status_value]
    EWMGOODSRECEIPTANDDISTRSTATUS,   -- Status Value [/scdl/dl_status_value]
    PLANNINGPUTAWAYSTATUS,           -- Status Value [/scdl/dl_status_value]
    EWMPLNDPUTAWAYANDDISTRSTATUS,    -- Status Value [/scdl/dl_status_value]
    PUTAWAYSTATUS,                   -- Status Value [/scdl/dl_status_value]
    EWMPUTAWAYANDDISTRSTATUS,        -- Status Value [/scdl/dl_status_value]
    COMPLETIONSTATUS,                -- Status Value [/scdl/dl_status_value]
    OVERALLBLOCKSTATUS,              -- Status Value [/scdl/dl_status_value]
    FLDLOGSSTATUS,                   -- FL Process Status [/scwm/de_flp_status]
    WAREHOUSEPROCESSTYPE,            -- Whse Proc. Type [/scwm/de_procty]
    GOODSMOVEMENTBIN,                -- Goods Mvt Bin [/scwm/dl_gmbin]
    EWMPRODUCTIONSUPPLYAREA,         -- PSA [/scwm/dl_psa]
    EWMDELIVLASTCHANGEUTCDATETIME,   -- Time Stamp [tzntstmps]
    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
    EWMGOODSRECIPIENT,               -- Goods Recipient [/scwm/de_goods_recipient]
    EWMRECIPIENTLOCATIONNAME,        -- Recipient Location [/scwm/de_rcloc]
    DELIVERYITEMSTOCKTYPEDETNCODE,   -- Determin. Ind. [/scdl/dl_indicator]
    EXTERNALSTOCKDOCUMENTNUMBER,     -- Special Ref. Stk Doc [ewm_de_stockdocumentnumber]
    STOCKDOCUMENTCATEGORY,           -- Special Reference Stock Type [ewm_de_stockdocumentcat]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [ps_s4_pspnr]
    WBSELEMENTEXTERNALID,            -- WBS Element [ps_posid_edit]
    SPECIALSTOCKIDFGSALESORDER,      -- Stock Ident Header [ewm_de_special_stock_idfg_hdr]
    SPECIALSTOCKIDFGSALESORDERITEM,  -- Stock Ident Item [ewm_de_special_stock_idfg_item]
    PURCHASINGDOCUMENT,              -- Purchasing Document [fis_ebeln]
    PURCHASINGDOCUMENTITEM,          -- Purchase Order Item [ewm_de_purchase_order_item]
    PURCHASEORDER,                   -- Purchase Order [vdm_purchaseorder]
    PURCHASEORDERITEM,               -- Purchase Order Item [vdm_purchaseorderitem]
    MANUFACTURINGORDER,              -- Manufacturing Order [manufacturingorder]
    RESERVATION,                     -- Reservation [rsnum]
    MAINTENANCEORDEROPERATION,       -- Maintenance Order Operation [ewm_de_maintenance_order_op]
    MAINTENANCEORDER,                -- Maintenance Order [ewm_de_maintenance_order]
    INBOUNDDELIVERY,                 -- LE Delivery [/scwm/sp_docno_erp]
    INBOUNDDELIVERYITEM,             -- ewm_de_inb_deliv_item_aconv
    PRIMARY KEY (MANDT, EWMINBOUNDDELIVERY, EWMINBOUNDDELIVERYITEM, DRAFTUUID)
);