P_EWM_HandlingUnitHeader03

DDL: P_EWM_HANDLINGUNITHEADER03 SQL: PEWMHUHDR03 Type: view COMPOSITE

P_EWM_HandlingUnitHeader03 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_EWM_HandlingUnitHeader02, P_EWM_HandlingUnitHeaderLog04) and exposes 4 fields with key fields HandlingUnitExternalID, Warehouse, Warehouse.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
P_EWM_HandlingUnitHeader02 P_EWM_HandlingUnitHeader02 union_all
P_EWM_HandlingUnitHeaderLog04 P_EWM_HandlingUnitHeaderLog04 from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PEWMHUHDR03 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor P_EWM_HandlingUnitHeader03_2 view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitExternalID HandlingUnitExternalID
KEY Warehouse Warehouse
KEY Warehouse Warehouse
IsActive 
@AbapCatalog.sqlViewName: 'PEWMHUHDR03'
@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_HandlingUnitHeader03_2'
// P_EWM_HandlingUnitHeaderLog04 --> Returns lates snapshot with all Handling Unit information

// P_EWM_HandlingUnitHeader02    --> Returns active Handling Unit with all required information

define view P_EWM_HandlingUnitHeader03 as select from P_EWM_HandlingUnitHeaderLog04{
  // Snapshot

  key HandlingUnitExternalID,
  key Warehouse,
  cast( '' as abap_boolean preserving type ) as IsActive
} union all select from P_EWM_HandlingUnitHeader02{
  //Active

  key HandlingUnitExternalID,
  key Warehouse,
  cast( 'X' as abap_boolean preserving type ) as IsActive
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_EWM_HANDLINGUNITHEADER02",
"P_EWM_HANDLINGUNITHEADERLOG04"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More