I_EWM_CONFIRMEDWAREHOUSETASK

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 (
    WAREHOUSETASK,
    WAREHOUSETASKITEM,
    ACTIVITYAREA,
    ACTUALQUANTITYINALTVUNIT,
    ACTUALQUANTITYINBASEUNIT,
    ALTERNATIVEUNIT,
    BASEUNIT,
    BATCH,
    BATCHCHANGEISNOTALLOWED,
    BUSINESSCONTEXT,
    BUSINESSCONTEXTEXECUTIONSTEP,
    CERTIFICATETEXT,
    CONFIRMATIONUTCDATETIME,
    CONFIRMEDBYUSER,
    CONSOLIDATIONGROUP,
    CONVEYORTECHNIQUESEGMENT,
    COUNTERFORSTOCKSEPARATION,
    COUNTRYOFORIGIN,
    CREATEDBYUSER,
    CREATIONDATETIME,
    CURRENTNUMBEROFKEYTABLE,
    DESTHNDLGUNITLOGICALPOSITION,
    DESTINATIONHANDLINGUNIT,
    DESTINATIONHANDLINGUNITUUID,
    DESTINATIONLOCATIONTYPE,
    DESTINATIONRESOURCE,
    DESTINATIONSTORAGEBIN,
    DESTINATIONSTORAGESECTION,
    DESTINATIONSTORAGETYPE,
    DESTINATIONTRANSPORTATIONUNIT,
    DIFFERENCEQUANTITYINALTVUNIT,
    DOCUMENTCATEGORY,
    DOCUMENTRELTDSTOCKDOCCAT,
    DOCUMENTRELTDSTOCKDOCITEMUUID,
    DOCUMENTRELTDSTOCKDOCUUID,
    ENTITLEDTODISPOSEPARTNERROLE,
    ENTITLEDTODISPOSEPARTY,
    EWMDUMMYFUNCFORSTRUCTUREEXTN,
    EXECUTINGRESOURCE,
    EXTERNALSTORAGEPROCESSSTEP,
    HANDLINGUNITTYPE,
    HAZARDOUSSUBSTANCEINDICATOR,
    ISHANDLINGUNITWAREHOUSETASK,
    KANBAN,
    KITITEMISCREATEDAUTOMATICALLY,
    LASTCHANGEDATETIME,
    LOGICALRECORDPROGRAMNAME,
    LOGICALRECORDTRANSACTIONCODE,
    NETWEIGHT,
    PRIORITYCODE,
    PROCESSOR,
    PRODUCTBATCH,
    PRODUCTIONORDER,
    PRODUCTIONSUPPLYAREA,
    PRODUCTNAME,
    PRODUCTUUID,
    QUALITYINSPECTIONDOCUUID,
    QUEUE,
    REFERENCEDOCUMENTCATEGORY,
    REFERENCEDOCUMENTITEMUUID,
    REFERENCEDOCUMENTUUID,
    SHELFLIFEEXPIRATIONDATE,
    SOURCEHANDLINGUNIT,
    SOURCEHANDLINGUNITUUID,
    SOURCEHNDLGUNITLOGICALPOSITION,
    SOURCELOCATIONTYPE,
    SOURCERESOURCE,
    SOURCESTORAGEBIN,
    SOURCESTORAGESECTION,
    SOURCESTORAGETYPE,
    SOURCETRANSPORTATIONUNIT,
    STOCKDOCUMENTCATEGORY,
    STOCKIDENTIFICATIONNUMBER,
    STOCKIDENTIFICATIONOFWHSETASK,
    STOCKITEMNUMBER,
    STOCKITEMUUID,
    STOCKKEEPINGALTERNATIVEUOM,
    STOCKOWNER,
    STOCKOWNERPARTNERROLE,
    STOCKTYPE,
    STOCKUSAGE,
    STORAGEPROCESS,
    TARGETQUANTITYINALTVUNIT,
    TARGETQUANTITYINBASEUNIT,
    WAREHOUSEMOVEMENTSREASON,
    WAREHOUSEORDER,
    WAREHOUSEPROCESSCATEGORY,
    WAREHOUSEPROCESSTYPE,
    WAREHOUSETASKCODES,
    WAREHOUSETASKEXCEPTIONCODE,
    WAREHOUSETASKSTATUS,
    WAREHOUSETASKUUID,
    WAVE,
    WAVEITEM,
    WHSETASKCAPACITYCONSUMPTION,
    WHSETASKCHGWHSETMZNDATETIME,
    WHSETASKCONFWHSETMZNDATETIME,
    WHSETASKCRTNWHSETMZNDATETIME,
    WHSETASKDESTSTORAGEBINDTMNDBY,
    WHSETASKGOODSRECEIPTDATETIME,
    WHSETASKNETVOLUME,
    WHSETASKNETVOLUMEUNITOFMEASURE,
    WHSETASKNETWEIGHTUNITOFMEASURE,
    WHSETASKPLANNEDPROCESSINGTIME,
    WHSETASKPROCGTIMEDETNTIMEUNIT,
    WHSETASKQUALITYINSPECTIONTYPE,
    WHSETASKREFTOVALUEADDEDSERVICE,
    WHSETASKRETENTIONQUANTITY,
    WHSETASKTWOSTEPPICKINGRLVNCE,
    WHSETASKTWOSTEPPICKINGTYPE,
    WRHSTASKSUBSYSTEMTRANSMN,
    PRIMARY KEY (WAREHOUSETASK, WAREHOUSETASKITEM)
);