A_HandlingUnitItem

DDL: A_HANDLINGUNITITEM SQL: AHANDLINGUNITIT Type: view CONSUMPTION

Handling Unit Item (Deprecated)

A_HandlingUnitItem is a Consumption CDS View that provides data about "Handling Unit Item (Deprecated)" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitItemCombined) and exposes 13 fields with key fields HandlingUnitExternalID, Warehouse, StockItemUUID.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_HandlingUnitItemCombined I_HandlingUnitItemCombined from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName AHANDLINGUNITIT 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 HandlingUnitItem view
EndUserText.label Handling Unit Item (Deprecated) view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitExternalID HandlingUnitExternalID
KEY Warehouse Warehouse
KEY StockItemUUID StockItemUUID
HandlingUnitItem HandlingUnitItem
HandlingUnitReferenceDocument HandlingUnitReferenceDocument
HandlingUnitRefDocumentItem HandlingUnitRefDocumentItem
HandlingUnitQuantity HandlingUnitQuantity
HandlingUnitQuantityUnit HandlingUnitQuantityUnit
HandlingUnitAltUnitOfMeasure HandlingUnitAltUnitOfMeasure
Material Material
ShelfLifeExpirationDate ShelfLifeExpirationDate
HandlingUnitGoodsReceiptDate HandlingUnitGoodsReceiptDate
_HandlingUnit _HandlingUnit 
@AbapCatalog.sqlViewName: 'AHANDLINGUNITIT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

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

@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_HandlingUnitItem_2' 

}

@OData.entitySet.name : 'HandlingUnitItem'
 
@EndUserText.label: 'Handling Unit Item (Deprecated)'

define view A_HandlingUnitItem as select from I_HandlingUnitItemCombined
  association to parent A_HandlingUnit as _HandlingUnit on  $projection.HandlingUnitExternalID              = _HandlingUnit.HandlingUnitExternalID
                                          and $projection.Warehouse = _HandlingUnit.Warehouse
{
  key HandlingUnitExternalID, 
  key Warehouse,
  key StockItemUUID,
  HandlingUnitItem,

  HandlingUnitReferenceDocument, 
  HandlingUnitRefDocumentItem, 

  @Semantics.quantity.unitOfMeasure: 'HandlingUnitQuantityUnit'
  HandlingUnitQuantity, 
  @Semantics.unitOfMeasure:true      
  HandlingUnitQuantityUnit, 
  @Semantics.unitOfMeasure:true      
  HandlingUnitAltUnitOfMeasure, 
  Material, 
//  Batch, 

  ShelfLifeExpirationDate,
  HandlingUnitGoodsReceiptDate,

 
//  @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT] 

  _HandlingUnit 
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_HANDLINGUNITITEMCOMBINED"
],
"ASSOCIATED":
[
"A_HANDLINGUNIT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More