I_RESERVATIONDOCUMENTHEADER

CDS View

Reservation Document Header

I_RESERVATIONDOCUMENTHEADER is a CDS View in S/4HANA. Reservation Document Header. It contains 34 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_ReservationDocumentHeader view from BASIC Document Header
C_ReservationDocOPg view_entity from CONSUMPTION Reservation Document Object Page
I_ReservationDocumentItem view inner BASIC Reservation Document Item
I_ResvnDocAccountAssignment view from COMPOSITE Calculation of Account Assignment
P_FcstDmndWithdrawals view inner COMPOSITE
R_ReservationDocumentHeaderTP view_entity from TRANSACTIONAL Reservation Document Header
R_ReservationDocumentSearch view from COMPOSITE Reservation Document Search

Fields (34)

KeyField CDS FieldsUsed in Views
KEY Reservation Reservation 2
_ControllingArea _ControllingArea 2
_CostCenter _CostCenter 2
_Customer _Customer 1
_GoodsMovementType _GoodsMovementType 2
_Order _Order 2
_ProfitCenter _ProfitCenter 1
_ReservationCreationCode _ReservationCreationCode 1
_VerificationCompanyCode _VerificationCompanyCode 2
_WBSElementBasicData _WBSElementBasicData 1
AssetNumber AssetNumber 2
AssetSubNumber AssetSubNumber 2
ControllingArea ControllingArea 2
CostCenter CostCenter 2
CreationDateTime CreationDateTime 2
Customer Customer 1
GoodsMovementType GoodsMovementType 2
GoodsRecipientName GoodsRecipientName 2
IsCheckedAgainstFactoryCal IsCheckedAgainstFactoryCal 2
IssuingOrReceivingPlant IssuingOrReceivingPlant 2
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
NetworkNumberForAcctAssgmt NetworkNumberForAcctAssgmt 2
OrderID OrderID 2
ProfitabilitySegment_2 ProfitabilitySegment 2
ProfitCenter ProfitCenter 2
ReservationCreationCode ReservationCreationCode 1
ReservationDate ReservationDate 2
ResvnVerificationCompanyCode ResvnVerificationCompanyCode 2
SalesOrder SalesOrder 2
SalesOrderItem SalesOrderItem 2
SalesOrderScheduleLine SalesOrderScheduleLine 2
UserID UserID 2
@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":""
}
}*/