A_HandlingUnit

DDL: A_HANDLINGUNIT Type: view CONSUMPTION

Handling Unit (Deprecated)

A_HandlingUnit is a Consumption CDS View that provides data about "Handling Unit (Deprecated)" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitHeaderCombined) and exposes 33 fields with key fields HandlingUnitExternalID, Warehouse. It has 2 associations to related views. It is exposed through 1 OData service (API_HANDLING_UNIT).

Data Sources (1)

SourceAliasJoin Type
I_HandlingUnitHeaderCombined I_HandlingUnitHeaderCombined from

Associations (2)

CardinalityTargetAliasCondition
[0..1] E_HandlingUnitHeader _Extension $projection. HandlingUnitExternalID = _Extension.HandlingUnitExternalID
[0..*] A_HandlingUnitItem _HandlingUnitItem

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName AHANDLINGUNITHU view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entitySet.name HandlingUnit view
EndUserText.label Handling Unit (Deprecated) view

OData Services (1)

ServiceBindingVersionContractRelease
API_HANDLING_UNIT API_HANDLING_UNIT V2 C2 C1

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitExternalID HandlingUnitExternalID
KEY Warehouse Warehouse
PackagingMaterial PackagingMaterial
PackagingMaterialType PackagingMaterialType
Plant Plant
StorageLocation StorageLocation
ShippingPoint ShippingPoint
ParentHandlingUnitNumber ParentHandlingUnitNumber
GrossWeight GrossWeight
NetWeight NetWeight
HandlingUnitMaxWeight HandlingUnitMaxWeight
WeightUnit WeightUnit
HandlingUnitTareWeight HandlingUnitTareWeight
HandlingUnitTareWeightUnit HandlingUnitTareWeightUnit
GrossVolume GrossVolume
HandlingUnitNetVolume HandlingUnitNetVolume
VolumeUnit VolumeUnit
HandlingUnitTareVolume HandlingUnitTareVolume
HandlingUnitTareVolumeUnit HandlingUnitTareVolumeUnit
HandlingUnitLength HandlingUnitLength
HandlingUnitWidth HandlingUnitWidth
HandlingUnitHeight HandlingUnitHeight
UnitOfMeasureDimension UnitOfMeasureDimension
HandlingUnitPackingObjectKey HandlingUnitReferenceDocument
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
HandlingUnitProcessStatus HandlingUnitProcessStatus
StorageType StorageType
StorageSection StorageSection
StorageBin StorageBin
_HandlingUnitItem _HandlingUnitItem
@AbapCatalog: {
    sqlViewName: 'AHANDLINGUNITHU',
    compiler.compareFilter: true,
    preserveKey: true
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@AccessControl: {
    authorizationCheck:     #CHECK,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}

//@ObjectModel.compositionRoot: true

@ObjectModel: {
    usageType: {
      dataClass:       #MIXED,
      serviceQuality:  #C,
      sizeCategory:    #XL
    }
}
@VDM: {
    viewType: #CONSUMPTION,
    lifecycle.contract.type: #PUBLIC_REMOTE_API
// Annotations not allowed in remote API views

//    lifecycle.status: #DEPRECATED,

//    lifecycle.successor: 'A_HandlingUnit_2'

}
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]

@OData.entitySet.name : 'HandlingUnit'

@EndUserText.label: 'Handling Unit (Deprecated)'


define root view A_HandlingUnit  as select from I_HandlingUnitHeaderCombined
  composition [0..*] of A_HandlingUnitItem as _HandlingUnitItem
  //Extensibility

  association [0..1] to E_HandlingUnitHeader  as _Extension    on  $projection. HandlingUnitExternalID = _Extension.HandlingUnitExternalID
{
  key HandlingUnitExternalID, 
  key Warehouse,

      PackagingMaterial, 
      PackagingMaterialType, 

      Plant, 
      StorageLocation,      
      ShippingPoint, 


      ParentHandlingUnitNumber,

      @Semantics.quantity.unitOfMeasure: 'WeightUnit'
      GrossWeight, 
      @Semantics.quantity.unitOfMeasure: 'WeightUnit'
      NetWeight, 
      @Semantics.quantity.unitOfMeasure: 'WeightUnit'
      HandlingUnitMaxWeight, 
      @Semantics.unitOfMeasure:true    
      WeightUnit, 
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitTareWeightUnit'
      HandlingUnitTareWeight, 
      @Semantics.unitOfMeasure:true    
      HandlingUnitTareWeightUnit, 
      
      @Semantics.quantity.unitOfMeasure: 'VolumeUnit'
       GrossVolume, 
       @Semantics.quantity.unitOfMeasure: 'VolumeUnit'
      HandlingUnitNetVolume, 
      @Semantics.unitOfMeasure:true      
      VolumeUnit, 
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitTareVolumeUnit'
      HandlingUnitTareVolume, 
//      HandlingUnitVolumeTolerance, 

      @Semantics.unitOfMeasure:true      
      HandlingUnitTareVolumeUnit, 
 
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'     
      HandlingUnitLength, 
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
      HandlingUnitWidth, 
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
      HandlingUnitHeight, 
      @Semantics.unitOfMeasure:true    
      UnitOfMeasureDimension, 
      
      HandlingUnitReferenceDocument as HandlingUnitPackingObjectKey,
            
      case HandlingUnitPackingObjectType
        when '01' then cast(HandlingUnitReferenceDocument as vbeln)  // inbound delivery document reference

        when '03' then cast(HandlingUnitReferenceDocument as vbeln)  // outbound delivery document reference

        else cast('          ' as vbeln preserving type)            // 07 Repetitive Manufacturing - Finished Products - no document reference

                                                                    // 06 Non-Assigned Handling Unit - no document reference

      end as HandlingUnitReferenceDocument,
       
      CreatedByUser, 
      CreationDateTime, 
      LastChangedByUser, 
      LastChangeDateTime, 
      
      HandlingUnitProcessStatus,

//    EWM specific fields

      StorageType,
      StorageSection,
      StorageBin,

       /* Associations */ 
       
       _HandlingUnitItem


}