C_FldLogsHandlingUnits

DDL: C_FLDLOGSHANDLINGUNITS SQL: CFLHU Type: view CONSUMPTION

Handling Units

C_FldLogsHandlingUnits is a Consumption CDS View that provides data about "Handling Units" in SAP S/4HANA. It has 1 association to related views.

13 fields

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FldLogsPlntPackggMatl _FldLogsMaterialDetails _FldLogsMaterialDetails.ProductUUID = _HU.PackagingMaterialUUID or _FldLogsMaterialDetails.Material = _HU.PackagingMaterial

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CFLHU view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Handling Units view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.resultSet.sizeCategory #XS view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument
KEY DeliveryDocumentItem DeliveryDocumentItem
KEY HandlingUnitInternalID HandlingUnitInternalID
KEY HandlingUnitItem HandlingUnitItem
KEY HandlingUnitExternalID HandlingUnitExternalID
HandlingUnitType HandlingUnitType
HandlingUnitTypeText HandlingUnitTypeText
HandlingUnitQuantityUnit HandlingUnitQuantityUnit
HandlingUnitQuantity HandlingUnitQuantity
HighestLevelHandlingUnitNumber
PackagingMaterialUUID PackagingMaterialUUID
PackagingMaterial _FldLogsMaterialDetails Material
MaterialName _FldLogsMaterialDetails MaterialName 
@AbapCatalog.sqlViewName: 'CFLHU'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking :#REQUIRED
@EndUserText.label: 'Handling Units'
@VDM.viewType: #CONSUMPTION
@Metadata.allowExtensions: true
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #TRANSACTIONAL,
                         sizeCategory: #L}
@ObjectModel : { resultSet.sizeCategory: #XS }
@ClientHandling.algorithm: #SESSION_VARIABLE
define view C_FldLogsHandlingUnits
  as select distinct from I_FldLogsHandlingUnits as _HU
  association [0..1] to I_FldLogsPlntPackggMatl as _FldLogsMaterialDetails on _FldLogsMaterialDetails.ProductUUID = _HU.PackagingMaterialUUID
                                                                           or _FldLogsMaterialDetails.Material    = _HU.PackagingMaterial
{
  key    ltrim(DeliveryDocument, '0')               as DeliveryDocument,
  key    DeliveryDocumentItem,
  key    HandlingUnitInternalID,
  key    HandlingUnitItem,
  key    HandlingUnitExternalID,
         @ObjectModel : { text.element: ['HandlingUnitTypeText'] }
         HandlingUnitType,
         HandlingUnitTypeText,
         HandlingUnitQuantityUnit,
         @Semantics.quantity.unitOfMeasure: 'HandlingUnitQuantityUnit'
         HandlingUnitQuantity,
         ltrim(HighestLevelHandlingUnitNumber, '0') as HighestLevelHandlingUnitNumber,
         PackagingMaterialUUID,
         @ObjectModel : { text.element: ['MaterialName'] }
         _FldLogsMaterialDetails.Material           as PackagingMaterial,
         _FldLogsMaterialDetails.MaterialName
}
where
  HandlingUnitExternalID is not initial;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FLDLOGSHANDLINGUNITS",
"I_FLDLOGSPLNTPACKGGMATL"
],
"ASSOCIATED":
[
"I_FLDLOGSPLNTPACKGGMATL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More