P_EWM_HANDLINGUNITHEADER05

CDS View

P_EWM_HANDLINGUNITHEADER05 is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EWM_HandlingUnitHeaderC view from COMPOSITE Handling Unit Header - Cube 
@AbapCatalog.sqlViewName: 'PEWMHUHDR05'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'P_EWM_HandlingUnitHeader05_2'
// P_EWM_HandlingUnitHeader03 --> Returns the union of snap and active HUs

// P_EWM_HandlingUnitHeader04 --> Count Active HUs

define view P_EWM_HandlingUnitHeader05
  as select from P_EWM_HandlingUnitHeader03 as _HandlingUnitUnion
  association [0..1] to P_EWM_HandlingUnitHeader04 as _CountHandlingUnits on  $projection.HandlingUnitExternalID = _CountHandlingUnits.HandlingUnitExternalID
                                                                          and $projection.Warehouse              = _CountHandlingUnits.Warehouse
{
  key HandlingUnitExternalID,
  key Warehouse,
      case
        when _CountHandlingUnits.ActiveEntries is null then cast( 0 as int1 preserving type ) // Snapshot from /SCWM/GMHUHDR

        else _CountHandlingUnits.ActiveEntries end as ActiveEntries                           // Active & planned HUs from /SCWM/HUHDR

}

Learn More