P_EWM_HANDLINGUNITITEM05

CDS View

P_EWM_HANDLINGUNITITEM05 is a CDS View in S/4HANA. It contains 15 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 15 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EWMHandlingUnitItemHierNode view_entity from COMPOSITE EWM HU Item Hierarchy
I_HandlingUnitItemCombined view union_all COMPOSITE Handling Unit Items data from LO and EWM

Fields (15)

KeyField CDS FieldsUsed in Views
KEY EWMWarehouse Warehouse 1
KEY StockItemUUID StockItemUUID 1
Batch Batch 2
CountryOfOrigin CountryOfOrigin 1
EWMDocumentCategory EWMDocumentCategory 1
EWMRefDeliveryDocumentItem EWMRefDeliveryDocumentItem 1
EWMRefDeliveryDocumentNumber EWMRefDeliveryDocumentNumber 1
HandlingUnitAltUnitOfMeasure HandlingUnitAltUnitOfMeasure 1
HandlingUnitBaseUnitOfMeasure HandlingUnitQuantityUnit 2
HandlingUnitQuantity HandlingUnitQuantity 2
Plant Plant 2
Product Material,Product 2
ProductName MaterialName,ProductName 2
ShelfLifeExpirationDate ShelfLifeExpirationDate 1
StorageLocation StorageLocation 2 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK", "KEY_CHECK" ]  } */
define view entity P_EWM_HandlingUnitItem05
  as select from P_EWM_HandlingUnitItem04_2

  association [1..1] to I_EWM_PlantStorLocMapToWhse   as _PlantMapping  on  $projection.EWMWarehouse         = _PlantMapping.EWMWarehouse
                                                                        and $projection.Plant                = _PlantMapping.Plant
                                                                        and $projection.LogicalSystem        = _PlantMapping.ERPLogicalSystem
                                                                        and $projection.EWMAvailabilityGroup = _PlantMapping.EWMAvailabilityGroup

  association [1..1] to P_EWM_HandlingUnitItemSrlNo02 as _CountSerialNo on  $projection.ParentHandlingUnitUUID = _CountSerialNo.ParentHandlingUnitUUID
                                                                        and $projection.StockItemUUID          = _CountSerialNo.StockItemUUID

{
  key EWMWarehouse,
  key HandlingUnitNumber,
  key StockItemUUID,
      CurrentNumberOfKeyTable,
      EWMStockType,
      EWMAvailabilityGroup,
      EWMLocIndepStockType,
      StockType,
      DeliveryCategory,
      EWMDocumentCategory,
      DeliveryUUID,
      EWMRefDeliveryDocumentNumber,
      DeliveryItemUUID,
      EWMRefDeliveryDocumentItem,
      ProductUUID,
      Product,
      ProductName,
      BatchUUID,
      Batch,
      EntitledToDisposeParty,
      EWMStockOwner,
      BusinessPartnerUUID,
      Supplier,
      Plant,
      _PlantMapping.StorageLocation,
      LogicalSystem,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitBaseUnitOfMeasure'
      HandlingUnitQuantity,
      HandlingUnitBaseUnitOfMeasure,
      HandlingUnitAltUnitOfMeasure,
      ShelfLifeExpirationDate,
      GoodsReceiptUTCDateTime,
      CountryOfOrigin,
      _CountSerialNo.HandlingUnitNumberOfSerialNumb,
      SerialNumberProfile,
      ParentHandlingUnitUUID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EWM_PLANTSTORLOCMAPTOWHSE",
"P_EWM_HANDLINGUNITITEM04_2",
"P_EWM_HANDLINGUNITITEMSRLNO02"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More