I_ReservationDocumentHeader

DDL: I_RESERVATIONDOCUMENTHEADER Type: view BASIC

Reservation Document Header

I_ReservationDocumentHeader is a Basic CDS View (Dimension) that provides data about "Reservation Document Header" in SAP S/4HANA. It reads from 1 data source (I_ReservationHeader) and exposes 39 fields with key field Reservation. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ReservationHeader I_ReservationHeader from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CostCenter _CostCenter $projection.CostCenter = _CostCenter.CostCenter and $projection.ControllingArea = _CostCenter.ControllingArea and $projection.ReservationDate <= _CostCenter.ValidityEndDate and $projection.ReservationDate >= _CostCenter.ValidityStartDate
[1..*] I_ReservationDocumentItem _ReservationDocumentItem $projection.Reservation = _ReservationDocumentItem.Reservation
[0..1] I_WBSElementByInternalKey _WBSElementByInternalKey $projection.WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
[0..1] I_ReservationCreationCode _ReservationCreationCode $projection.ReservationCreationCode = _ReservationCreationCode.ReservationCreationCode

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IRESVNDOCHDR view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Reservation Document Header view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey Reservation view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #DIMENSION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY Reservation Reservation
ReservationCreationCode ReservationCreationCode
ReservationOrigin ReservationOrigin
OrderID OrderID
GoodsMovementType GoodsMovementType
CostCenter CostCenter
ProfitCenter ProfitCenter
ProfitabilitySegment ProfitabilitySegment
ProfitabilitySegment_2 ProfitabilitySegment_2
ControllingArea ControllingArea
GoodsRecipientName GoodsRecipientName
ReservationDate ReservationDate
IsCheckedAgainstFactoryCal IsCheckedAgainstFactoryCal
Customer Customer
WBSElementInternalID WBSElementInternalID
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
SalesOrderScheduleLine SalesOrderScheduleLine
AssetNumber AssetNumber
AssetSubNumber AssetSubNumber
NetworkNumberForAcctAssgmt NetworkNumberForAcctAssgmt
IssuingOrReceivingPlant IssuingOrReceivingPlant
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc
ResvnVerificationCompanyCode ResvnVerificationCompanyCode
UserID UserID
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_ControllingArea _ControllingArea
_VerificationCompanyCode _VerificationCompanyCode
_Order _Order
_GoodsMovementType _GoodsMovementType
_Customer _Customer
_WBSElementByInternalKey _WBSElementByInternalKey
_WBSElementBasicData _WBSElementBasicData
_ReservationCreationCode _ReservationCreationCode
_ReservationDocumentItem _ReservationDocumentItem
@AbapCatalog: {
                sqlViewName: 'IRESVNDOCHDR',
                preserveKey: true,
                compiler.compareFilter: true
              }
@AccessControl: {
                  authorizationCheck: #CHECK,
                  personalData.blocking: #BLOCKED_DATA_EXCLUDED
                }
@EndUserText.label: 'Reservation Document Header'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
                usageType: {
                             sizeCategory: #M,
                             serviceQuality: #A,
                             dataClass:#TRANSACTIONAL
                            },
                compositionRoot: true,
                semanticKey: ['Reservation'],
                representativeKey: 'Reservation',
                modelingPattern: #ANALYTICAL_DIMENSION,
                supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE]
}
@VDM: {
        viewType: #BASIC,
        lifecycle.contract.type: #PUBLIC_LOCAL_API
      } 
@Analytics.dataCategory: #DIMENSION
@Metadata: {
             ignorePropagatedAnnotations:true,
             allowExtensions: true
           }
           
define view I_ReservationDocumentHeader
  as select from I_ReservationHeader
  association [0..1] to I_CostCenter              as _CostCenter              on  $projection.CostCenter      =  _CostCenter.CostCenter
                                                                              and $projection.ControllingArea =  _CostCenter.ControllingArea
                                                                              and $projection.ReservationDate <= _CostCenter.ValidityEndDate
                                                                              and $projection.ReservationDate >= _CostCenter.ValidityStartDate

  association [1..*] to I_ReservationDocumentItem as _ReservationDocumentItem on  $projection.Reservation = _ReservationDocumentItem.Reservation
  association [0..1] to I_WBSElementByInternalKey as _WBSElementByInternalKey on  $projection.WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID
  association [0..1] to I_WBSElementBasicData     as _WBSElementBasicData     on  $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
  association [0..1] to I_ReservationCreationCode as _ReservationCreationCode on $projection.ReservationCreationCode = _ReservationCreationCode.ReservationCreationCode
{

  key Reservation,
  
      ReservationCreationCode,
      
      ReservationOrigin,
      
      @ObjectModel.foreignKey.association: '_Order'
      OrderID,

      @ObjectModel.foreignKey.association: '_GoodsMovementType'
      GoodsMovementType,

      @ObjectModel.foreignKey.association: '_CostCenter'
      CostCenter,
      
      ProfitCenter,
      @API.element.releaseState: #DECOMMISSIONED
      @API.element.successor: 'ProfitabilitySegment_2'
//      @VDM.lifecycle.status: #DEPRECATED

//      @VDM.lifecycle.successor: 'ProfitabilitySegment_2'

      ProfitabilitySegment,
      ProfitabilitySegment_2, 
      @ObjectModel.foreignKey.association: '_ControllingArea'
      ControllingArea,

      GoodsRecipientName,

      @Semantics.businessDate.at: true
      ReservationDate,
      IsCheckedAgainstFactoryCal,

      @ObjectModel.foreignKey.association: '_Customer'
      Customer,
      WBSElementInternalID,
//      _WBSElementByInternalKey.WBSElement,

      SalesOrder,
      SalesOrderItem,
      SalesOrderScheduleLine,
      AssetNumber,
      AssetSubNumber,
      NetworkNumberForAcctAssgmt,
      IssuingOrReceivingPlant,
      IssuingOrReceivingStorageLoc,
      ResvnVerificationCompanyCode,
      UserID,
      CreationDateTime,
      LastChangedByUser,
      LastChangeDateTime,

      _CostCenter,
      _ProfitCenter,      
      _ControllingArea,
      _VerificationCompanyCode,
      _Order,
      _GoodsMovementType,
      _Customer,
     _WBSElementByInternalKey,
     _WBSElementBasicData,
     _ReservationCreationCode,
       
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _ReservationDocumentItem
      
            
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESERVATIONHEADER"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_CUSTOMER",
"I_GOODSMOVEMENTTYPE",
"I_LOGISTICSORDER",
"I_PROFITCENTER",
"I_RESERVATIONCREATIONCODE",
"I_RESERVATIONDOCUMENTITEM",
"I_WBSELEMENTBASICDATA",
"I_WBSELEMENTBYINTERNALKEY"
],
"BASE":
[
"I_RESERVATIONHEADER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/