A_HandlingUnitItemDelivery

DDL: A_HANDLINGUNITITEMDELIVERY SQL: AHUITMDLV Type: view BASIC

Handling Unit Item for Delivery

A_HandlingUnitItemDelivery is a Basic CDS View that provides data about "Handling Unit Item for Delivery" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitItem) and exposes 19 fields with key fields HandlingUnitInternalID, HandlingUnitItem. It has 2 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_HandlingUnitItem I_HandlingUnitItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_OutbDeliveryHeader_1 _DeliveryDocument $projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument
[1..1] A_OutbDeliveryItem_1 _DeliveryDocumentItem $projection.DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument and $projection.DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName AHUITMDLV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
EndUserText.label Handling Unit Item for Delivery view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitInternalID HandlingUnitInternalID
KEY HandlingUnitItem HandlingUnitItem
HandlingUnitExternalID HandlingUnitExternalID
HandlingUnitTypeOfContent HandlingUnitTypeOfContent
DeliveryDocument HandlingUnitReferenceDocument
DeliveryDocumentItem HandlingUnitRefDocumentItem
HandlingUnitNestedInternalID HandlingUnitNestedInternalID
HandlingUnitQuantity HandlingUnitQuantity
HandlingUnitQuantityUnit HandlingUnitQuantityUnit
HandlingUnitNrOfAuxPackgMat HandlingUnitNrOfAuxPackgMat
Material Material
MaterialName
Batch Batch
HandlingUnitNumberOfSerialNumb HandlingUnitNumberOfSerialNumb
SerialNumberProfile SerialNumberProfile
MaterialByCustomer MaterialByCustomer
_DeliveryDocument _DeliveryDocument
_DeliveryDocumentItem _DeliveryDocumentItem
_HandlingUnitHeader _HandlingUnitHeader 
@AbapCatalog.sqlViewName: 'AHUITMDLV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {
  usageType.dataClass: #TRANSACTIONAL,
  usageType.serviceQuality: #B,
  usageType.sizeCategory: #L
}
@VDM.viewType: #BASIC

@EndUserText.label: 'Handling Unit Item for Delivery'

define view A_HandlingUnitItemDelivery 
  as select from I_HandlingUnitItem
  
  association [1..1] to A_OutbDeliveryHeader_1       as _DeliveryDocument     on  $projection.DeliveryDocument     = _DeliveryDocument.DeliveryDocument

  association [1..1] to A_OutbDeliveryItem_1         as _DeliveryDocumentItem on  $projection.DeliveryDocument     = _DeliveryDocumentItem.DeliveryDocument
                                                                              and $projection.DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem
  
  association to parent A_HandlingUnitHeaderDelivery as _HandlingUnitHeader   on  $projection.HandlingUnitInternalID = _HandlingUnitHeader.HandlingUnitInternalID

{
      //I_HandlingUnitItem

  key HandlingUnitInternalID,
  key HandlingUnitItem,
      HandlingUnitExternalID,
      HandlingUnitTypeOfContent,
      HandlingUnitReferenceDocument as DeliveryDocument,
      HandlingUnitRefDocumentItem   as DeliveryDocumentItem,
      HandlingUnitNestedInternalID,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitQuantityUnit'
      HandlingUnitQuantity,
      @Semantics.unitOfMeasure:true    
      HandlingUnitQuantityUnit,
      HandlingUnitNrOfAuxPackgMat,
      Material,
      _Material._Text[1: Language=$session.system_language].MaterialName,
      Batch,
      HandlingUnitNumberOfSerialNumb,
      SerialNumberProfile,
      MaterialByCustomer,
      
      /* Associations not needed for API */
      //I_HandlingUnitItem

//      _AlternativeUnitOfMeasure,

//      _BaseUnitOfMeasure,

//      _Batch,

//      _Material,

//      _Plant,

//      _SalesDocumentItemCategory,

//      _StorageLocation,


      @ObjectModel.association.type:  [#TO_COMPOSITION_ROOT]
      _DeliveryDocument,
      _DeliveryDocumentItem,

      @ObjectModel.association.type:  [#TO_COMPOSITION_PARENT]
      _HandlingUnitHeader
     
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_HANDLINGUNITITEM",
"I_MATERIAL",
"I_MATERIALTEXT"
],
"ASSOCIATED":
[
"A_HANDLINGUNITHEADERDELIVERY",
"A_OUTBDELIVERYHEADER_1",
"A_OUTBDELIVERYITEM_1"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More