P_HndlgUnitItmCmptblty_F4674

DDL: P_HNDLGUNITITMCMPTBLTY_F4674 SQL: PHUITMCOMPTF4674 Type: view COMPOSITE

P_HndlgUnitItmCmptblty_F4674 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_DeliveryDocumentItem, I_HandlingUnitItem) and exposes 4 fields with key fields HandlingUnitInternalID, HandlingUnitItem.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_DeliveryDocumentItem DeliveryItem inner
I_HandlingUnitItem HandlingUnitItem from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PHUITMCOMPTF4674 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitInternalID HandlingUnitInternalID
KEY HandlingUnitItem
PurchaseOrderItem
HandlingUnitQuantity HandlingUnitQuantity 
@AbapCatalog.sqlViewName: 'PHUITMCOMPTF4674'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_HndlgUnitItmCmptblty_F4674
  as select from I_HandlingUnitItem     as HandlingUnitItem
    inner join   I_DeliveryDocumentItem as DeliveryItem on  DeliveryItem.DeliveryDocument     = HandlingUnitItem.HandlingUnitReferenceDocument
                                                        and DeliveryItem.DeliveryDocumentItem = HandlingUnitItem.HandlingUnitRefDocumentItem
{
  key HandlingUnitInternalID,
  key cast(HandlingUnitItem as abap.int4)                           as HandlingUnitItem,

      cast(right(DeliveryItem.ReferenceSDDocumentItem, 5) as ebelp) as PurchaseOrderItem,

      HandlingUnitQuantity
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENTITEM",
"I_HANDLINGUNITITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More