C_HandlingUnitReservation

DDL: C_HANDLINGUNITRESERVATION SQL: CHANDLINGUNITRES Type: view CONSUMPTION

Handling Unit Tentative Reservation

C_HandlingUnitReservation is a Consumption CDS View that provides data about "Handling Unit Tentative Reservation" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitHeader) and exposes 5 fields. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_HandlingUnitHeader _HandlingUnitHeader inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_HandlingUnitObjectKeyType _HandlingUnitObjectKeyType _HandlingUnitObjectKeyType.HandlingUnitObjectKeyType = $projection.ReservationObjectType

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CHANDLINGUNITRES view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Search.searchable true view
UI.headerInfo.typeName Tentative Reservation view
UI.headerInfo.typeNamePlural Tentative Reservations view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value Tentative Reservation view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value Tentative Reservation view
EndUserText.label Handling Unit Tentative Reservation view

Fields (5)

KeyFieldSource TableSource FieldDescription
ReservationObjectType HandlingUnitItemReservation ReservationObjectType
ReservationObjectNumber HandlingUnitItemReservation ReservationObjectNumber
Plant I_HandlingUnitHeader Plant
LastChangeDateTime HandlingUnitItemReservation LastChangeDateTime
_HandlingUnitObjectKeyType _HandlingUnitObjectKeyType 
@AbapCatalog.sqlViewName: 'CHANDLINGUNITRES'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm:#SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl: {
    authorizationCheck:     #CHECK,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}
@Search.searchable: true

@UI.presentationVariant:{
sortOrder: [
    { by: 'ReservationObjectNumber' , direction: #DESC }]}

@UI.headerInfo: {
 typeName:         'Tentative Reservation',
 typeNamePlural:   'Tentative Reservations',
 title: {
    type:   #STANDARD,
    value:  'Tentative Reservation'
    },
 description: {
   type:   #STANDARD,
    value:  'Tentative Reservation'
    }
}

@EndUserText.label: 'Handling Unit Tentative Reservation'
define view C_HandlingUnitReservation
  as select distinct from I_HandlingUnitItemReservation as HandlingUnitItemReservation
  inner join I_HandlingUnitHeader as _HandlingUnitHeader on  HandlingUnitItemReservation.HandlingUnitInternalID = _HandlingUnitHeader.HandlingUnitInternalID
  
  association [0..1] to I_HandlingUnitObjectKeyType as _HandlingUnitObjectKeyType on _HandlingUnitObjectKeyType.HandlingUnitObjectKeyType = $projection.ReservationObjectType

{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold : 0.8
      HandlingUnitItemReservation.ReservationObjectType,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold : 0.8
      HandlingUnitItemReservation.ReservationObjectNumber,
      _HandlingUnitHeader.Plant,
      HandlingUnitItemReservation.LastChangeDateTime,
      // Associations

      _HandlingUnitObjectKeyType
}

Learn More