I_EWM_CONFIRMEDWAREHOUSETASK_2

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.

-- Confirmed Warehouse Task
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EWM_CONFIRMEDWAREHOUSETASK_2 (
    EWMWAREHOUSE,
    SOURCEHANDLINGUNIT,
    WAREHOUSETASK,
    WAREHOUSETASKITEM,
    _MATERIAL,
    ACTIVITYAREA,
    ACTUALQUANTITYINALTVUNIT,
    ACTUALQUANTITYINBASEUNIT,
    ALTERNATIVEUNIT,
    BASEUNIT,
    BATCH,
    BATCHCHANGEISNOTALLOWED,
    BATCHUUID,
    BUSINESSCONTEXT,
    BUSINESSCONTEXTEXECUTIONSTEP,
    CERTIFICATETEXT,
    CONFIRMATIONUTCDATETIME,
    CONFIRMEDBYUSER,
    CONVEYORTECHNIQUESEGMENT,
    COUNTERFORSTOCKSEPARATION,
    COUNTRYOFORIGIN,
    CREATEDBYUSER,
    CURRENTNUMBEROFKEYTABLE,
    DESTHNDLGUNITLOGICALPOSITION,
    DESTINATIONHANDLINGUNIT,
    DESTINATIONHANDLINGUNITUUID,
    DESTINATIONRESOURCE,
    DESTINATIONSTORAGEBIN,
    DESTINATIONSTORAGESECTION,
    DESTINATIONSTORAGETYPE,
    DESTINATIONTRANSPORTATIONUNIT,
    DIFFERENCEQUANTITYINALTVUNIT,
    DIFFERENCEQUANTITYINBASEUNIT,
    DOCUMENTRELTDSTOCKDOCCAT,
    DOCUMENTRELTDSTOCKDOCITEMUUID,
    DOCUMENTRELTDSTOCKDOCUUID,
    ENTITLEDTODISPOSEPARTNERROLE,
    ENTITLEDTODISPOSEPARTY,
    EWMCANCELEDWAREHOUSETASK,
    EWMCONSOLIDATIONGROUP,
    EWMDESTINATIONLOCATIONTYPE,
    EWMDOCUMENTCATEGORY,
    EWMDUMMYFUNCFORSTRUCTUREEXTN,
    EWMPRODUCTIONSUPPLYAREA,
    EWMPUTAWAYPHYSINVTRYEXECSTS,
    EWMPUTAWAYPHYSINVTRYPLNSTS,
    EWMREFERENCEDOCUMENTCATEGORY,
    EWMSOURCELOCATIONTYPE,
    EWMSTOCKOWNER,
    EWMSTOCKTYPE,
    EWMSTOCKUSAGE,
    EWMWAREHOUSETASKPRIORITY,
    EWMWHSETSKLOWSTKCHKEXECSTS,
    EWMWHSETSKLOWSTKCHKPLNSTS,
    EXECUTINGRESOURCE,
    EXTERNALSTORAGEPROCESSSTEP,
    HANDLINGUNITTYPE,
    HAZARDOUSSUBSTANCEINDICATOR,
    ISHANDLINGUNITWAREHOUSETASK,
    KANBAN,
    KITITEMISCREATEDAUTOMATICALLY,
    LOGICALRECORDPROGRAMNAME,
    LOGICALRECORDTRANSACTIONCODE,
    NETWEIGHT,
    PROCESSOR,
    PRODUCTIONORDER,
    PRODUCTNAME,
    PRODUCTUUID,
    QUALITYINSPECTIONDOCUUID,
    QUEUE,
    REFERENCEDOCUMENTITEMUUID,
    REFERENCEDOCUMENTUUID,
    REQUIREMENTSEGMENT,
    SHELFLIFEEXPIRATIONDATE,
    SOURCEHANDLINGUNITUUID,
    SOURCEHNDLGUNITLOGICALPOSITION,
    SOURCERESOURCE,
    SOURCESTORAGEBIN,
    SOURCESTORAGESECTION,
    SOURCESTORAGETYPE,
    SOURCETRANSPORTATIONUNIT,
    STOCKDOCUMENTCATEGORY,
    STOCKIDENTIFICATIONNUMBER,
    STOCKIDENTIFICATIONOFWHSETASK,
    STOCKITEMNUMBER,
    STOCKITEMUUID,
    STOCKKEEPINGALTERNATIVEUOM,
    STOCKOWNERPARTNERROLE,
    STOCKSEGMENT,
    STORAGEPROCESS,
    TARGETQUANTITYINALTVUNIT,
    TARGETQUANTITYINBASEUNIT,
    WAREHOUSEMOVEMENTSREASON,
    WAREHOUSEORDER,
    WAREHOUSEPROCESSCATEGORY,
    WAREHOUSEPROCESSTYPE,
    WAREHOUSETASKCODES,
    WAREHOUSETASKEXCEPTIONCODE,
    WAREHOUSETASKSTATUS,
    WAREHOUSETASKUUID,
    WAVE,
    WAVEITEM,
    WHSETASKCAPACITYCONSUMPTION,
    WHSETASKCHGWHSETMZNDATETIME,
    WHSETASKCONFWHSETMZNDATETIME,
    WHSETASKCRTNUTCDATETIME,
    WHSETASKCRTNWHSETMZNDATETIME,
    WHSETASKDESTSTORAGEBINDTMNDBY,
    WHSETASKGOODSRECEIPTDATETIME,
    WHSETASKLASTCHGUTCDATETIME,
    WHSETASKNETVOLUME,
    WHSETASKNETVOLUMEUNITOFMEASURE,
    WHSETASKNETWEIGHTUNITOFMEASURE,
    WHSETASKPLANNEDPROCESSINGTIME,
    WHSETASKPROCGTIMEDETNTIMEUNIT,
    WHSETASKQUALITYINSPECTIONTYPE,
    WHSETASKREFTOVALUEADDEDSERVICE,
    WHSETASKRETENTIONQUANTITY,
    WHSETASKTWOSTEPPICKINGRLVNCE,
    WHSETASKTWOSTEPPICKINGTYPE,
    WRHSTASKSUBSYSTEMTRANSMN,
    PRIMARY KEY (EWMWAREHOUSE, SOURCEHANDLINGUNIT, WAREHOUSETASK, WAREHOUSETASKITEM)
);