R_HandlingUnitTP

DDL: R_HANDLINGUNITTP Type: view_entity TRANSACTIONAL

Handling Unit TP View

R_HandlingUnitTP is a Transactional CDS View that provides data about "Handling Unit TP View" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitHeaderCombined) and exposes 81 fields with key fields HandlingUnitExternalID, Warehouse. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_HandlingUnitHeaderCombined I_HandlingUnitHeaderCombined from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_HandlingUnitHeader _Extension $projection.HandlingUnitExternalID = _Extension.HandlingUnitExternalID
[0..*] R_HandlingUnitItemTP _HandlingUnitItem
[0..*] R_HandlingUnitReferenceDocTP _HandlingUnitReferenceDoc
[0..*] R_HandlingUnitAlternativeIdTP _HandlingUnitAlternativeID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Handling Unit TP View view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name HandlingUnit view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (81)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitExternalID HandlingUnitExternalID
KEY Warehouse Warehouse
HandlingUnitCharUUID
HandlingUnitExternalIdType HandlingUnitExternalIdType
HndlgUnitExtIDCheckIsDisabled
Plant Plant
StorageLocation StorageLocation
ShippingPoint ShippingPoint
HandlingUnitInternalID HandlingUnitInternalID
HandlingUnitLowerLevelRefer HandlingUnitLowerLevelRefer
ParentHandlingUnitNumber ParentHandlingUnitNumber
HighestLevelHandlingUnitNumber HighestLevelHandlingUnitNumber
PackagingMaterial PackagingMaterial
PackagingMaterialType PackagingMaterialType
GrossWeight GrossWeight
NetWeight NetWeight
HandlingUnitMaxWeight HandlingUnitMaxWeight
WeightUnit WeightUnit
HandlingUnitTareWeight HandlingUnitTareWeight
HandlingUnitTareWeightUnit HandlingUnitTareWeightUnit
GrossVolume GrossVolume
HandlingUnitNetVolume HandlingUnitNetVolume
HandlingUnitMaxVolume HandlingUnitMaxVolume
VolumeUnit VolumeUnit
HandlingUnitTareVolume HandlingUnitTareVolume
HandlingUnitTareVolumeUnit HandlingUnitTareVolumeUnit
HandlingUnitLength HandlingUnitLength
HandlingUnitWidth HandlingUnitWidth
HandlingUnitHeight HandlingUnitHeight
UnitOfMeasureDimension UnitOfMeasureDimension
HandlingUnitPackingObjectType HandlingUnitPackingObjectType
HandlingUnitReferenceDocument
HandlingUnitHasCrossRefDoc HandlingUnitHasCrossRefDoc
CreatedByUser CreatedByUser
CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime
HandlingUnitInternalStatus HandlingUnitInternalStatus
HandlingUnitProcessStatus HandlingUnitProcessStatus
SourceHandlingUnitUUID SourceHandlingUnitUUID
PackingInstruction PackingInstruction
HandlingUnitSecondExternalId HandlingUnitSecondExternalId
HandlingUnitSlotNumber HandlingUnitSlotNumber
HndlgUnitRlvnceForJIT HndlgUnitRlvnceForJIT
StorageType StorageType
StorageSection StorageSection
StorageBin StorageBin
EWMResource EWMResource
EWMConsolidationGroup EWMConsolidationGroup
HandlingUnitIsClosed HandlingUnitIsClosed
ExternalStorageProcessStep ExternalStorageProcessStep
StorageProcess StorageProcess
EWMHUProcessStepIsCompleted EWMHUProcessStepIsCompleted
EWMHandlingUnitIsPlanned EWMHandlingUnitIsPlanned
EWMHandlingUnitIsInStock EWMHandlingUnitIsInStock
EWMHandlingUnitIsUnloaded EWMHandlingUnitIsUnloaded
EWMHandlingUnitIsLoaded EWMHandlingUnitIsLoaded
EWMTranspUnitIsAssigned EWMTranspUnitIsAssigned
EWMHUContentChangeIsBlocked EWMHUContentChangeIsBlocked
EWMHUMovementChangeIsBlocked EWMHUMovementChangeIsBlocked
EWMHUAttributeChangeIsBlocked EWMHUAttributeChangeIsBlocked
EWMHUPostingChangeIsBlocked EWMHUPostingChangeIsBlocked
EWMHUIsBlockedByCustoms EWMHUIsBlockedByCustoms
EWMHUIsPackedForShipping EWMHUIsPackedForShipping
EWMHandlingUnitType HandlingUnitType
EWMSrlNmbrForPackagingMaterial EWMSrlNmbrForPackagingMaterial
HandlingUnitMaxLength HandlingUnitMaxLength
HandlingUnitMaxWidth HandlingUnitMaxWidth
HandlingUnitMaxHeight HandlingUnitMaxHeight
HandlingUnitMaxDimensionUnit HandlingUnitMaxDimensionUnit
EWMHUIsJITUpdateRelevant EWMHUIsJITUpdateRelevant
EWMHUDestinationProdnSupArea EWMHUDestinationProdnSupArea
EWMHUDestinationStorageBin EWMHUDestinationStorageBin
_HandlingUnitItem _HandlingUnitItem
_HandlingUnitReferenceDoc _HandlingUnitReferenceDoc
_HandlingUnitAlternativeID _HandlingUnitAlternativeID
_UnitOfMeasureDimension _UnitOfMeasureDimension
_VolumeUnit _VolumeUnit
_VolumeUnitTare _VolumeUnitTare
_WeightUnit _WeightUnit
_WeightUnitTare _WeightUnitTare
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Handling Unit TP View'

@Search.searchable: true

@ObjectModel: {
   usageType: {
     serviceQuality:  #C,
     dataClass:       #MIXED,
     sizeCategory:    #XL
   }
}

@ObjectModel.sapObjectNodeType.name:'HandlingUnit'

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL

define root view entity R_HandlingUnitTP
  as select from I_HandlingUnitHeaderCombined
  composition [0..*] of R_HandlingUnitItemTP                      as _HandlingUnitItem


  composition [0..*] of R_HandlingUnitReferenceDocTP              as _HandlingUnitReferenceDoc

  composition [0..*] of R_HandlingUnitAlternativeIdTP             as _HandlingUnitAlternativeID

  //Extensibility

  association [0..1] to E_HandlingUnitHeader                      as _Extension on $projection.HandlingUnitExternalID = _Extension.HandlingUnitExternalID

{

      @Search.defaultSearchElement : true
      @Search.fuzzinessThreshold : 0.8
      @Search.ranking : #HIGH
  key HandlingUnitExternalID,
  key Warehouse,
      cast(HandlingUnitCharUUID as char32)                        as HandlingUnitCharUUID, //proper casting needs to be implemented | Edm.GUID


      HandlingUnitExternalIdType,
      cast( '' as lohum_hu_extid_check_disabled preserving type ) as HndlgUnitExtIDCheckIsDisabled,

      Plant,
      StorageLocation,
      ShippingPoint,

      HandlingUnitInternalID,
      HandlingUnitLowerLevelRefer,
      ParentHandlingUnitNumber,
      HighestLevelHandlingUnitNumber,

      PackagingMaterial,
      PackagingMaterialType,

      @Semantics.quantity.unitOfMeasure: 'WeightUnit'
      GrossWeight,
      @Semantics.quantity.unitOfMeasure: 'WeightUnit'
      NetWeight,
      @Semantics.quantity.unitOfMeasure: 'WeightUnit'
      HandlingUnitMaxWeight,
      WeightUnit,

      @Semantics.quantity.unitOfMeasure: 'HandlingUnitTareWeightUnit'
      HandlingUnitTareWeight,
      HandlingUnitTareWeightUnit,

      @Semantics.quantity.unitOfMeasure: 'VolumeUnit'
      GrossVolume,
      @Semantics.quantity.unitOfMeasure: 'VolumeUnit'
      HandlingUnitNetVolume,
      @Semantics.quantity.unitOfMeasure: 'VolumeUnit'
      HandlingUnitMaxVolume,
      VolumeUnit,

      @Semantics.quantity.unitOfMeasure: 'HandlingUnitTareVolumeUnit'
      HandlingUnitTareVolume,
      HandlingUnitTareVolumeUnit,

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
      HandlingUnitLength,
      HandlingUnitWidth,
      HandlingUnitHeight,
      UnitOfMeasureDimension,

      HandlingUnitPackingObjectType,
      //remove leading zeros

      ltrim( HandlingUnitReferenceDocument, '0'   )               as HandlingUnitReferenceDocument,
      HandlingUnitHasCrossRefDoc,

      CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      cast( CreationDateTime as tzntstmps)                        as CreationDateTime,
      LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      cast( LastChangeDateTime as tzntstmps)                      as LastChangeDateTime,

      HandlingUnitInternalStatus,

      HandlingUnitProcessStatus,

      SourceHandlingUnitUUID,
      PackingInstruction,
      HandlingUnitSecondExternalId,
      HandlingUnitSlotNumber,
      HndlgUnitRlvnceForJIT,

      // EWM fields

      StorageType,
      StorageSection,
      StorageBin,
      EWMResource,
      EWMConsolidationGroup,
      HandlingUnitIsClosed,
      // EWM fields Process Oriented Storage Control (POSC)

      // E.g., After packing create a warehouse task to move a HU from a work center to the staging/goods issue area

      ExternalStorageProcessStep,
      StorageProcess,
      EWMHUProcessStepIsCompleted,
      // EWM fields HU Process Status

      EWMHandlingUnitIsPlanned,
      EWMHandlingUnitIsInStock,
      EWMHandlingUnitIsUnloaded,
      EWMHandlingUnitIsLoaded,
      EWMTranspUnitIsAssigned,
      // EWM fields HU Blocked Status

      EWMHUContentChangeIsBlocked,
      EWMHUMovementChangeIsBlocked,
      EWMHUAttributeChangeIsBlocked,
      EWMHUPostingChangeIsBlocked,
      EWMHUIsBlockedByCustoms,
      EWMHUIsPackedForShipping,

      HandlingUnitType                                            as EWMHandlingUnitType,

      EWMSrlNmbrForPackagingMaterial,

      @Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
      HandlingUnitMaxLength,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
      HandlingUnitMaxWidth,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
      HandlingUnitMaxHeight,
      HandlingUnitMaxDimensionUnit,

      // Multifitment Point

      EWMHUIsJITUpdateRelevant,
      EWMHUDestinationProdnSupArea,
      EWMHUDestinationStorageBin,

      /* Associations */
      _HandlingUnitItem,
      _HandlingUnitReferenceDoc,
      _HandlingUnitAlternativeID,
      _UnitOfMeasureDimension,
      _VolumeUnit,
      _VolumeUnitTare,
      _WeightUnit,
      _WeightUnitTare
}