I_EWM_OPENWAREHOUSETASKS_2
Open Warehouse Task
I_EWM_OPENWAREHOUSETASKS_2 is a CDS View in S/4HANA. Open Warehouse Task. It contains 136 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_EWM_OpenWarehouseTasks_2 | view_entity | from | CONSUMPTION | Form Data Provider for Open Whse Tasks |
| I_EWM_WarehouseTask_2 | view_entity | from | COMPOSITE | Open and Confirmed Warehouse Tasks |
| I_FldLogsWarehouseTask | view | inner | COMPOSITE | Field Logistics Warehouse Tasks |
| P_EWM_DlvItmNmbrOfOpnWhseTask | view_entity | inner | COMPOSITE | |
| P_EWM_OpnWhseTaskWhseReqItem | view_entity | inner | COMPOSITE |
Fields (136)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | EWMWarehouse | EWMWarehouse | 2 |
| KEY | WarehouseTask | WarehouseTask | 2 |
| ActivityArea | ActivityArea | 1 | |
| AlternativeUnit | AlternativeUnit | 1 | |
| BaseUnit | BaseUnit | 1 | |
| Batch | Batch | 1 | |
| BatchChangeIsNotAllowed | BatchChangeIsNotAllowed | 1 | |
| BatchUUID | BatchUUID | 1 | |
| CapacityIsToBeChecked | CapacityIsToBeChecked | 1 | |
| CertificateText | CertificateText | 1 | |
| ConveyorTechniqueSegment | ConveyorTechniqueSegment | 1 | |
| CounterForStockSeparation | CounterForStockSeparation | 1 | |
| CountryOfOrigin | CountryOfOrigin | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CurrentNumberOfKeyTable | CurrentNumberOfKeyTable | 1 | |
| DestHndlgUnitLogicalPosition | DestHndlgUnitLogicalPosition | 1 | |
| DestinationHandlingUnitUUID | DestinationHandlingUnitUUID | 1 | |
| DestinationResource | DestinationResource | 1 | |
| DestinationStorageBin | DestinationStorageBin | 2 | |
| DestinationStorageSection | DestinationStorageSection | 1 | |
| DestinationStorageType | DestinationStorageType | 2 | |
| DestinationTransportationUnit | DestinationTransportationUnit | 1 | |
| DiffsAreOnlyAllowedInSrceBin | DiffsAreOnlyAllowedInSrceBin | 1 | |
| DistributivePutAwayFromGRZone | DistributivePutAwayFromGRZone | 1 | |
| DocumentReltdStockDocCat | DocumentReltdStockDocCat | 1 | |
| DocumentReltdStockDocItemUUID | DocumentReltdStockDocItemUUID | 1 | |
| DocumentReltdStockDocUUID | DocumentReltdStockDocUUID | 1 | |
| EntitledToDisposePartnerRole | EntitledToDisposePartnerRole | 1 | |
| EntitledToDisposeParty | EntitledToDisposeParty | 1 | |
| EWMConsolidationGroup | EWMConsolidationGroup | 1 | |
| EWMDestinationLocationType | EWMDestinationLocationType | 1 | |
| EWMDocumentCategory | EWMDocumentCategory | 1 | |
| EWMDummyFuncForStructureExtn | EWMDummyFuncForStructureExtn | 1 | |
| EWMProductionSupplyArea | EWMProductionSupplyArea | 1 | |
| EWMReferenceDocumentCategory | EWMReferenceDocumentCategory | 1 | |
| EWMRoute | EWMRoute | 1 | |
| EWMSourceLocationType | EWMSourceLocationType | 1 | |
| EWMStockOwner | EWMStockOwner | 1 | |
| EWMStockType | EWMStockType | 1 | |
| EWMStockUsage | EWMStockUsage | 1 | |
| EWMWarehouseTaskPriority | EWMWarehouseTaskPriority | 1 | |
| ExecutingResource | ExecutingResource | 1 | |
| ExternalStorageProcessStep | ExternalStorageProcessStep | 1 | |
| GoodsReceiptIsNotYetPosted | GoodsReceiptIsNotYetPosted | 1 | |
| HandlingUnitIsEmpty | HandlingUnitIsEmpty | 1 | |
| HandlingUnitType | HandlingUnitType | 1 | |
| HandlingUnitTypeGroup | HandlingUnitTypeGroup | 1 | |
| HandlingUnitUUID | HandlingUnitUUID | 1 | |
| HasItemWithReducedOrder | HasItemWithReducedOrder | 1 | |
| HazardousSubstanceIndicator | HazardousSubstanceIndicator | 1 | |
| HomogeneousFullPalletPick | HomogeneousFullPalletPick | 1 | |
| IsDocumentaryBatch | IsDocumentaryBatch | 1 | |
| IsHandlingUnitWarehouseTask | IsHandlingUnitWarehouseTask | 2 | |
| IsWhseTaskConfirmationError | IsWhseTaskConfirmationError | 1 | |
| Kanban | Kanban | 1 | |
| KitItemIsCreatedAutomatically | KitItemIsCreatedAutomatically | 1 | |
| LogicalRecordProgramName | LogicalRecordProgramName | 1 | |
| LogicalRecordTransactionCode | LogicalRecordTransactionCode | 1 | |
| NetWeight | NetWeight | 1 | |
| NumberOfConfdWhseTaskItems | NumberOfConfdWhseTaskItems | 1 | |
| NumberOfHndlgUnitsToBePutAway | NumberOfHndlgUnitsToBePutAway | 1 | |
| NumberOfHndlgUnitsToBeRemoved | NumberOfHndlgUnitsToBeRemoved | 1 | |
| ProductionOrder | ProductionOrder | 1 | |
| ProductIsCatchWeightRelevant | ProductIsCatchWeightRelevant | 1 | |
| ProductName | ProductName | 1 | |
| ProductUUID | ProductUUID | 1 | |
| PutAwayPhysInventoryIsPlanned | PutAwayPhysInventoryIsPlanned | 1 | |
| QualityInspectionDocUUID | QualityInspectionDocUUID | 1 | |
| Queue | Queue | 1 | |
| ReferenceDocumentItemUUID | ReferenceDocumentItemUUID | 2 | |
| ReferenceDocumentUUID | ReferenceDocumentUUID | 2 | |
| ReplenishmentStrategy | ReplenishmentStrategy | 1 | |
| ShelfLifeExpirationDate | ShelfLifeExpirationDate | 1 | |
| ShippingHandlingUnitUUID | ShippingHandlingUnitUUID | 1 | |
| SourceHandlingUnitMovement | SourceHandlingUnitMovement | 1 | |
| SourceHandlingUnitUUID | SourceHandlingUnitUUID | 2 | |
| SourceHndlgUnitLogicalPosition | SourceHndlgUnitLogicalPosition | 1 | |
| SourceQuantityIdnIsPredefined | SourceQuantityIdnIsPredefined | 1 | |
| SourceResource | SourceResource | 1 | |
| SourceStorageBin | SourceStorageBin | 2 | |
| SourceStorageSection | SourceStorageSection | 1 | |
| SourceStorageType | SourceStorageType | 1 | |
| SourceTransportationUnit | SourceTransportationUnit | 1 | |
| StockDocumentCategory | StockDocumentCategory | 1 | |
| StockIdentificationNumber | StockIdentificationNumber | 1 | |
| StockIdentificationOfWhseTask | StockIdentificationOfWhseTask | 1 | |
| StockItem0UUID | StockItem0UUID | 1 | |
| StockItemNumber | StockItemNumber | 1 | |
| StockItemUUID | StockItemUUID | 1 | |
| StockKeepingAlternativeUoM | StockKeepingAlternativeUoM | 1 | |
| StockOwnerPartnerRole | StockOwnerPartnerRole | 1 | |
| StorageProcess | StorageProcess | 1 | |
| TargetQuantityInAltvUnit | TargetQuantityInAltvUnit | 1 | |
| TargetQuantityInBaseUnit | TargetQuantityInBaseUnit | 1 | |
| WarehouseActivityType | WarehouseActivityType | 2 | |
| WarehouseMovementsReason | WarehouseMovementsReason | 1 | |
| WarehouseOrder | WarehouseOrder | 1 | |
| WarehouseOrderActivityArea | WarehouseOrderActivityArea | 1 | |
| WarehouseOrderCreationRule | WarehouseOrderCreationRule | 1 | |
| WarehouseOrderSequenceValue | WarehouseOrderSequenceValue | 1 | |
| WarehouseProcessCategory | WarehouseProcessCategory | 2 | |
| WarehouseProcessType | WarehouseProcessType | 1 | |
| WarehouseRequestDocHasTxt | WarehouseRequestDocHasTxt | 1 | |
| WarehouseTaskCodes | WarehouseTaskCodes | 1 | |
| WarehouseTaskLogNumber | WarehouseTaskLogNumber | 1 | |
| WarehouseTaskStatus | WarehouseTaskStatus | 2 | |
| WarehouseTaskType | WarehouseTaskType | 1 | |
| WarehouseTaskUUID | WarehouseTaskUUID | 1 | |
| Wave | Wave | 1 | |
| WaveCategory | WaveCategory | 1 | |
| WaveItem | WaveItem | 1 | |
| WhseTaskCapacityConsumption | WhseTaskCapacityConsumption | 1 | |
| WhseTaskCountIsRequested | WhseTaskCountIsRequested | 1 | |
| WhseTaskCrtedForStorageControl | WhseTaskCrtedForStorageControl | 1 | |
| WhseTaskCrtnUTCDateTime | WhseTaskCrtnUTCDateTime | 1 | |
| WhseTaskDestStorageBinDtmndBy | WhseTaskDestStorageBinDtmndBy | 1 | |
| WhseTaskGoodsReceiptDateTime | WhseTaskGoodsReceiptDateTime | 1 | |
| WhseTaskHazardRating1 | WhseTaskHazardRating1 | 1 | |
| WhseTaskHazardRating2 | WhseTaskHazardRating2 | 1 | |
| WhseTaskLowStockCheckIsPlanned | WhseTaskLowStockCheckIsPlanned | 1 | |
| WhseTaskNetVolume | WhseTaskNetVolume | 1 | |
| WhseTaskNetVolumeUnitOfMeasure | WhseTaskNetVolumeUnitOfMeasure | 1 | |
| WhseTaskNetWeightUnitOfMeasure | WhseTaskNetWeightUnitOfMeasure | 1 | |
| WhseTaskNgtvStockQuantityCode | WhseTaskNgtvStockQuantityCode | 1 | |
| WhseTaskPlannedClosingDateTime | WhseTaskPlannedClosingDateTime | 1 | |
| WhseTaskPlannedProcessingTime | WhseTaskPlannedProcessingTime | 1 | |
| WhseTaskProcgTimeDetnTimeUnit | WhseTaskProcgTimeDetnTimeUnit | 1 | |
| WhseTaskQualityInspectionType | WhseTaskQualityInspectionType | 1 | |
| WhseTaskRefToValueAddedService | WhseTaskRefToValueAddedService | 1 | |
| WhseTaskRetentionQuantity | WhseTaskRetentionQuantity | 1 | |
| WhseTaskSortingSequenceValue | WhseTaskSortingSequenceValue | 1 | |
| WhseTaskTwoStepPickingRlvnce | WhseTaskTwoStepPickingRlvnce | 1 | |
| WhseTaskTwoStepPickingType | WhseTaskTwoStepPickingType | 1 | |
| WithdrawAllStockFromStorageBin | WithdrawAllStockFromStorageBin | 1 | |
| WorkloadIdentification | WorkloadIdentification | 1 | |
| WrhsTaskSubsystemTransmn | WrhsTaskSubsystemTransmn | 1 |
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.
-- Open Warehouse Task
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EWM_OPENWAREHOUSETASKS_2 (
EWMWAREHOUSE,
WAREHOUSETASK,
ACTIVITYAREA,
ALTERNATIVEUNIT,
BASEUNIT,
BATCH,
BATCHCHANGEISNOTALLOWED,
BATCHUUID,
CAPACITYISTOBECHECKED,
CERTIFICATETEXT,
CONVEYORTECHNIQUESEGMENT,
COUNTERFORSTOCKSEPARATION,
COUNTRYOFORIGIN,
CREATEDBYUSER,
CURRENTNUMBEROFKEYTABLE,
DESTHNDLGUNITLOGICALPOSITION,
DESTINATIONHANDLINGUNITUUID,
DESTINATIONRESOURCE,
DESTINATIONSTORAGEBIN,
DESTINATIONSTORAGESECTION,
DESTINATIONSTORAGETYPE,
DESTINATIONTRANSPORTATIONUNIT,
DIFFSAREONLYALLOWEDINSRCEBIN,
DISTRIBUTIVEPUTAWAYFROMGRZONE,
DOCUMENTRELTDSTOCKDOCCAT,
DOCUMENTRELTDSTOCKDOCITEMUUID,
DOCUMENTRELTDSTOCKDOCUUID,
ENTITLEDTODISPOSEPARTNERROLE,
ENTITLEDTODISPOSEPARTY,
EWMCONSOLIDATIONGROUP,
EWMDESTINATIONLOCATIONTYPE,
EWMDOCUMENTCATEGORY,
EWMDUMMYFUNCFORSTRUCTUREEXTN,
EWMPRODUCTIONSUPPLYAREA,
EWMREFERENCEDOCUMENTCATEGORY,
EWMROUTE,
EWMSOURCELOCATIONTYPE,
EWMSTOCKOWNER,
EWMSTOCKTYPE,
EWMSTOCKUSAGE,
EWMWAREHOUSETASKPRIORITY,
EXECUTINGRESOURCE,
EXTERNALSTORAGEPROCESSSTEP,
GOODSRECEIPTISNOTYETPOSTED,
HANDLINGUNITISEMPTY,
HANDLINGUNITTYPE,
HANDLINGUNITTYPEGROUP,
HANDLINGUNITUUID,
HASITEMWITHREDUCEDORDER,
HAZARDOUSSUBSTANCEINDICATOR,
HOMOGENEOUSFULLPALLETPICK,
ISDOCUMENTARYBATCH,
ISHANDLINGUNITWAREHOUSETASK,
ISWHSETASKCONFIRMATIONERROR,
KANBAN,
KITITEMISCREATEDAUTOMATICALLY,
LOGICALRECORDPROGRAMNAME,
LOGICALRECORDTRANSACTIONCODE,
NETWEIGHT,
NUMBEROFCONFDWHSETASKITEMS,
NUMBEROFHNDLGUNITSTOBEPUTAWAY,
NUMBEROFHNDLGUNITSTOBEREMOVED,
PRODUCTIONORDER,
PRODUCTISCATCHWEIGHTRELEVANT,
PRODUCTNAME,
PRODUCTUUID,
PUTAWAYPHYSINVENTORYISPLANNED,
QUALITYINSPECTIONDOCUUID,
QUEUE,
REFERENCEDOCUMENTITEMUUID,
REFERENCEDOCUMENTUUID,
REPLENISHMENTSTRATEGY,
SHELFLIFEEXPIRATIONDATE,
SHIPPINGHANDLINGUNITUUID,
SOURCEHANDLINGUNITMOVEMENT,
SOURCEHANDLINGUNITUUID,
SOURCEHNDLGUNITLOGICALPOSITION,
SOURCEQUANTITYIDNISPREDEFINED,
SOURCERESOURCE,
SOURCESTORAGEBIN,
SOURCESTORAGESECTION,
SOURCESTORAGETYPE,
SOURCETRANSPORTATIONUNIT,
STOCKDOCUMENTCATEGORY,
STOCKIDENTIFICATIONNUMBER,
STOCKIDENTIFICATIONOFWHSETASK,
STOCKITEM0UUID,
STOCKITEMNUMBER,
STOCKITEMUUID,
STOCKKEEPINGALTERNATIVEUOM,
STOCKOWNERPARTNERROLE,
STORAGEPROCESS,
TARGETQUANTITYINALTVUNIT,
TARGETQUANTITYINBASEUNIT,
WAREHOUSEACTIVITYTYPE,
WAREHOUSEMOVEMENTSREASON,
WAREHOUSEORDER,
WAREHOUSEORDERACTIVITYAREA,
WAREHOUSEORDERCREATIONRULE,
WAREHOUSEORDERSEQUENCEVALUE,
WAREHOUSEPROCESSCATEGORY,
WAREHOUSEPROCESSTYPE,
WAREHOUSEREQUESTDOCHASTXT,
WAREHOUSETASKCODES,
WAREHOUSETASKLOGNUMBER,
WAREHOUSETASKSTATUS,
WAREHOUSETASKTYPE,
WAREHOUSETASKUUID,
WAVE,
WAVECATEGORY,
WAVEITEM,
WHSETASKCAPACITYCONSUMPTION,
WHSETASKCOUNTISREQUESTED,
WHSETASKCRTEDFORSTORAGECONTROL,
WHSETASKCRTNUTCDATETIME,
WHSETASKDESTSTORAGEBINDTMNDBY,
WHSETASKGOODSRECEIPTDATETIME,
WHSETASKHAZARDRATING1,
WHSETASKHAZARDRATING2,
WHSETASKLOWSTOCKCHECKISPLANNED,
WHSETASKNETVOLUME,
WHSETASKNETVOLUMEUNITOFMEASURE,
WHSETASKNETWEIGHTUNITOFMEASURE,
WHSETASKNGTVSTOCKQUANTITYCODE,
WHSETASKPLANNEDCLOSINGDATETIME,
WHSETASKPLANNEDPROCESSINGTIME,
WHSETASKPROCGTIMEDETNTIMEUNIT,
WHSETASKQUALITYINSPECTIONTYPE,
WHSETASKREFTOVALUEADDEDSERVICE,
WHSETASKRETENTIONQUANTITY,
WHSETASKSORTINGSEQUENCEVALUE,
WHSETASKTWOSTEPPICKINGRLVNCE,
WHSETASKTWOSTEPPICKINGTYPE,
WITHDRAWALLSTOCKFROMSTORAGEBIN,
WORKLOADIDENTIFICATION,
WRHSTASKSUBSYSTEMTRANSMN,
PRIMARY KEY (EWMWAREHOUSE, WAREHOUSETASK)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA