R_EWM_StorageBinTP

DDL: R_EWM_STORAGEBINTP Type: view_entity TRANSACTIONAL
49 Fields 1 Data Sources

Warehouse Storage Bin

R_EWM_StorageBinTP is a Transactional CDS View that provides data about "Warehouse Storage Bin" in SAP S/4HANA. It reads from 1 data source (I_EWM_StorageBin_2) and exposes 49 fields with key fields EWMWarehouse, EWMStorageBin.

Data Sources (1)

SourceAliasJoin Type
I_EWM_StorageBin_2 I_EWM_StorageBin_2 from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name WarehouseStorageBin view
EndUserText.label Warehouse Storage Bin view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY EWMWarehouse EWMWarehouse Warehouse No.
KEY EWMStorageBin EWMStorageBin Storage Bin
EWMStorageType EWMStorageType Storage Type
EWMStorageSection EWMStorageSection Storage Section
EWMStorageBinType EWMStorageBinType Stor. Bin Type
EWMStorageBinAccessType EWMStorageBinAccessType Bin Access Type
EWMStorageBinSection EWMStorageBinSection Explosion Date
EWMStorageBinPosition EWMStorageBinPosition Bin position
EWMStorageBinSubdivision EWMStorageBinSubdivision Division
EWMStorageBinMaximumWeight EWMStorageBinMaximumWeight Maximum Weight
WeightUnit WeightUnit Weight unit
EWMStorageBinUsedWeight EWMStorageBinUsedWeight Weight Used
EWMStorageBinMaximumVolume EWMStorageBinMaximumVolume Max. Volume
VolumeUnit VolumeUnit Volume Unit
EWMStorageBinOccupiedVolume EWMStorageBinOccupiedVolume Volume
EWMStorBinTotalCapacityValue EWMStorBinTotalCapacityValue Total Capacity
EWMStorBinAvailCapacityValue EWMStorBinAvailCapacityValue Remain.Capacity
EWMStorBinFreeDefinedAisleText EWMStorBinFreeDefinedAisleText Bin Aisle
EWMStorBinFreeDefinedStackText EWMStorBinFreeDefinedStackText Bin Stack
EWMStorBinFreeDefinedLevelText EWMStorBinFreeDefinedLevelText Bin Level
EWMStorBinIsBlockedForRemoval EWMStorBinIsBlockedForRemoval Removal Block
EWMStorBinIsBlockedForPutaway EWMStorBinIsBlockedForPutaway Putaway Block
EWMStorBinIsBlockedDueToPInv EWMStorBinIsBlockedDueToPInv Inventory Act.
EWMStorageBinIsEmpty EWMStorageBinIsEmpty Empty indicator
EWMStorageBinIsFull EWMStorageBinIsFull Full Indicator
EWMStorBinFreeDfndSectionText EWMStorBinFreeDfndSectionText Bin Section
EWMStorageBinFreeDfndDepthText EWMStorageBinFreeDfndDepthText Draught
EWMStorageBinRemainDepthValue EWMStorageBinRemainDepthValue
EWMStorageBinMaxDepthValue EWMStorageBinMaxDepthValue
EWMStorBinWidthCoordinateValue EWMStorBinWidthCoordinateValue X Coordinate
EWMStorBinLengthCoordinateVal EWMStorBinLengthCoordinateVal Y Coordinate
EWMStorBinHeightCoordinateVal EWMStorBinHeightCoordinateVal Z Coordinate
EWMStorBinVerifiedByMobileID EWMStorBinVerifiedByMobileID Verification
EWMStorageBinVerifiedByVoiceID EWMStorageBinVerifiedByVoiceID PbV Verification
EWMPhysicalInventoryType EWMPhysicalInventoryType PI Type
PhysicalInventoryDocNumber PhysicalInventoryDocNumber PI Document No.
PhysicalInventoryItemNumber PhysicalInventoryItemNumber Item
PInvCountedUTCDateTime PInvCountedUTCDateTime Start-up date
EWMStorageBinLastChangedByUser EWMStorageBinLastChangedByUser User Name
EWMStorageBinLastChgDateTime EWMStorageBinLastChgDateTime
EWMStorageBinLastWarehouseTask EWMStorageBinLastWarehouseTask
EWMStorageBinFirstPutawayDate EWMStorageBinFirstPutawayDate First Putaway
EWMStorageBinLastMvtDateTime EWMStorageBinLastMvtDateTime Last Movement
EWMStorageBinLastClrgDateTime EWMStorageBinLastClrgDateTime Last Clearing
EWMStorageBinFixedBinType EWMStorageBinFixedBinType Fixed Bin Type
EWMStorageBinAngleValue EWMStorageBinAngleValue Bin Angle
EWMStorBinNumberOfHndlgUnits EWMStorBinNumberOfHndlgUnits No.stor.units
EWMStorBinMaxNmbrOfHndlgUnits EWMStorBinMaxNmbrOfHndlgUnits Max.no.SUs
EWMStorageGroup EWMStorageGroup Storage Group

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_EWM_StorageBinTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_EWM_StorageBinTP AS
SELECT
  EWMWarehouse,
  EWMStorageBin,
  EWMStorageType,
  EWMStorageSection,
  EWMStorageBinType,
  EWMStorageBinAccessType,
  EWMStorageBinSection,
  EWMStorageBinPosition,
  EWMStorageBinSubdivision,
  EWMStorageBinMaximumWeight,
  WeightUnit,
  EWMStorageBinUsedWeight,
  EWMStorageBinMaximumVolume,
  VolumeUnit,
  EWMStorageBinOccupiedVolume,
  EWMStorBinTotalCapacityValue,
  EWMStorBinAvailCapacityValue,
  EWMStorBinFreeDefinedAisleText,
  EWMStorBinFreeDefinedStackText,
  EWMStorBinFreeDefinedLevelText,
  EWMStorBinIsBlockedForRemoval,
  EWMStorBinIsBlockedForPutaway,
  EWMStorBinIsBlockedDueToPInv,
  EWMStorageBinIsEmpty,
  EWMStorageBinIsFull,
  EWMStorBinFreeDfndSectionText,
  EWMStorageBinFreeDfndDepthText,
  EWMStorageBinRemainDepthValue,
  EWMStorageBinMaxDepthValue,
  EWMStorBinWidthCoordinateValue,
  EWMStorBinLengthCoordinateVal,
  EWMStorBinHeightCoordinateVal,
  EWMStorBinVerifiedByMobileID,
  EWMStorageBinVerifiedByVoiceID,
  EWMPhysicalInventoryType,
  PhysicalInventoryDocNumber,
  PhysicalInventoryItemNumber,
  PInvCountedUTCDateTime,
  EWMStorageBinLastChangedByUser,
  EWMStorageBinLastChgDateTime,
  EWMStorageBinLastWarehouseTask,
  EWMStorageBinFirstPutawayDate,
  EWMStorageBinLastMvtDateTime,
  EWMStorageBinLastClrgDateTime,
  EWMStorageBinFixedBinType,
  EWMStorageBinAngleValue,
  EWMStorBinNumberOfHndlgUnits,
  EWMStorBinMaxNmbrOfHndlgUnits,
  EWMStorageGroup
FROM I_EWM_StorageBin_2
;

Learn More