R_ReservationDocumentHeaderTP

DDL: R_RESERVATIONDOCUMENTHEADERTP Type: view_entity TRANSACTIONAL

Reservation Document Header

R_ReservationDocumentHeaderTP is a Transactional CDS View that provides data about "Reservation Document Header" in SAP S/4HANA. It reads from 2 data sources (I_ReservationDocumentHeader, P_ResvnDocRqmtType) and exposes 44 fields with key field Reservation. It has 8 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ReservationDocumentHeader I_ReservationDocumentHeader from
P_ResvnDocRqmtType P_ResvnDocRqmtType inner

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_ResvnDocHeaderStatus _ResvnCalculatedFilters $projection.Reservation = _ResvnCalculatedFilters.Reservation
[0..1] I_UserDescription _CreatedByUser $projection.UserID = _CreatedByUser.UserID
[0..1] I_UserDescription _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID
[0..1] I_Plant _IssuingOrReceivingPlant $projection.IssuingOrReceivingPlant = _IssuingOrReceivingPlant.Plant
[0..1] I_StorageLocation _IssuingOrReceivingStorageLoc $projection.IssuingOrReceivingStorageLoc = _IssuingOrReceivingStorageLoc.StorageLocation and $projection.IssuingOrReceivingPlant = _IssuingOrReceivingStorageLoc.Plant
[0..1] I_ResvnCategoryDetermination _ResvnCategoryDetermination $projection.Reservation = _ResvnCategoryDetermination.Reservation
[1..1] E_ReservationDocument _Extension $projection.Reservation = _Extension.Reservation
[0..*] R_ReservationDocumentItemTP _ReservationDocumentItemTP

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Reservation Document Header view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey Reservation view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name ReservationDocument view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix RDH view
AbapCatalog.extensibility.quota.maximumFields 404 view
AbapCatalog.extensibility.quota.maximumBytes 24080 view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_ReservationDocumentHeader Reservation
ReservationCreationCode I_ReservationDocumentHeader ReservationCreationCode
ReservationOrigin
GoodsMovementType I_ReservationDocumentHeader GoodsMovementType
ResvnVerificationCompanyCode I_ReservationDocumentHeader ResvnVerificationCompanyCode
OrderID I_ReservationDocumentHeader OrderID
CostCenter I_ReservationDocumentHeader CostCenter
ProfitCenter I_ReservationDocumentHeader ProfitCenter
ControllingArea I_ReservationDocumentHeader ControllingArea
GoodsRecipientName I_ReservationDocumentHeader GoodsRecipientName
ReservationDate I_ReservationDocumentHeader ReservationDate
IsCheckedAgainstFactoryCal I_ReservationDocumentHeader IsCheckedAgainstFactoryCal
WBSElementInternalID
WBSElement
SalesOrder I_ReservationDocumentHeader SalesOrder
SalesOrderItem I_ReservationDocumentHeader SalesOrderItem
SalesOrderScheduleLine I_ReservationDocumentHeader SalesOrderScheduleLine
AssetNumber I_ReservationDocumentHeader AssetNumber
AssetSubNumber I_ReservationDocumentHeader AssetSubNumber
NetworkNumberForAcctAssgmt I_ReservationDocumentHeader NetworkNumberForAcctAssgmt
IssuingOrReceivingPlant I_ReservationDocumentHeader IssuingOrReceivingPlant
IssuingOrReceivingStorageLoc I_ReservationDocumentHeader IssuingOrReceivingStorageLoc
ProfitabilitySegment I_ReservationDocumentHeader ProfitabilitySegment_2
Plant
RequirementType P_ResvnDocRqmtType RequirementType
ReservationItemCreationCode P_ResvnDocRqmtType ReservationItemCreationCode
UserID I_ReservationDocumentHeader UserID
CreationDateTime I_ReservationDocumentHeader CreationDateTime
LastChangedByUser I_ReservationDocumentHeader LastChangedByUser
LastChangeDateTime I_ReservationDocumentHeader LastChangeDateTime
_ReservationDocumentItemTP _ReservationDocumentItemTP
_ControllingArea I_ReservationDocumentHeader _ControllingArea
_CostCenter I_ReservationDocumentHeader _CostCenter
_GoodsMovementType I_ReservationDocumentHeader _GoodsMovementType
_VerificationCompanyCode I_ReservationDocumentHeader _VerificationCompanyCode
_Order I_ReservationDocumentHeader _Order
_WBSElementBasicData I_ReservationDocumentHeader _WBSElementBasicData
_ReservationCreationCode I_ReservationDocumentHeader _ReservationCreationCode
_ResvnCalculatedFilters _ResvnCalculatedFilters
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_IssuingOrReceivingPlant _IssuingOrReceivingPlant
_IssuingOrReceivingStorageLoc _IssuingOrReceivingStorageLoc
_ResvnCategoryDetermination _ResvnCategoryDetermination
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Reservation Document Header'
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#TRANSACTIONAL
    },
    semanticKey: ['Reservation'],
    representativeKey: 'Reservation'
}

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.privilegedAssociations: [ '_CreatedByUser', '_LastChangedByUser',
                                         '_ControllingArea', '_CostCenter', 
                                         '_VerificationCompanyCode',
                                         '_Order', '_WBSElementBasicData' ]
@ObjectModel.sapObjectNodeType.name : 'ReservationDocument'
@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['_Extension'],
  elementSuffix: 'RDH',
  quota: {
    maximumFields: 404,
    maximumBytes: 24080
  } }
define root view entity R_ReservationDocumentHeaderTP
  as select from I_ReservationDocumentHeader 
    inner join   P_ResvnDocRqmtType on I_ReservationDocumentHeader.Reservation = P_ResvnDocRqmtType.Reservation
  //                                              and P_ResvnDocRqmtType.RequirementType      = 'MR'

  //    inner join   P_ResvnDocManualGoodsMvtType on I_ReservationDocumentHeader.GoodsMovementType = P_ResvnDocManualGoodsMvtType.GoodsMovementType


  composition [0..*] of R_ReservationDocumentItemTP as _ReservationDocumentItemTP

  //  association [0..1] to I_ResvnDocAccountAssignment as _ResvnDocAccountAssignment    on  $projection.Reservation = _ResvnDocAccountAssignment.Reservation


  association [0..1] to I_ResvnDocHeaderStatus      as _ResvnCalculatedFilters       on  $projection.Reservation = _ResvnCalculatedFilters.Reservation

  association [0..1] to I_UserDescription           as _CreatedByUser                on  $projection.UserID = _CreatedByUser.UserID

  association [0..1] to I_UserDescription           as _LastChangedByUser            on  $projection.LastChangedByUser = _LastChangedByUser.UserID

  association [0..1] to I_Plant                     as _IssuingOrReceivingPlant      on  $projection.IssuingOrReceivingPlant = _IssuingOrReceivingPlant.Plant

  association [0..1] to I_StorageLocation           as _IssuingOrReceivingStorageLoc on  $projection.IssuingOrReceivingStorageLoc = _IssuingOrReceivingStorageLoc.StorageLocation
                                                                                     and $projection.IssuingOrReceivingPlant      = _IssuingOrReceivingStorageLoc.Plant

  association [0..1] to I_ResvnCategoryDetermination as _ResvnCategoryDetermination    on  $projection.Reservation = _ResvnCategoryDetermination.Reservation

  //Extension

  association [1..1] to E_ReservationDocument       as _Extension                    on  $projection.Reservation = _Extension.Reservation
 // interface association

 // association [1..1] to R_ReservationDocumentHeaderTP   as _Interface                    on  $projection.Reservation = _Interface.Reservation


{
      //I_ReservationDocumentHeader

  key I_ReservationDocumentHeader.Reservation,
      I_ReservationDocumentHeader.ReservationCreationCode,
//      I_ReservationDocumentHeader.ReservationOrigin,

      cast ( I_ReservationDocumentHeader.ReservationOrigin as imrs_reservation_origin preserving type) as ReservationOrigin,
      I_ReservationDocumentHeader.GoodsMovementType                                                                                                     as GoodsMovementType,
      I_ReservationDocumentHeader.ResvnVerificationCompanyCode,
      I_ReservationDocumentHeader.OrderID,
      I_ReservationDocumentHeader.CostCenter,
      I_ReservationDocumentHeader.ProfitCenter,
      I_ReservationDocumentHeader.ControllingArea,
      I_ReservationDocumentHeader.GoodsRecipientName,
      I_ReservationDocumentHeader.ReservationDate,
      I_ReservationDocumentHeader.IsCheckedAgainstFactoryCal,
//      I_ReservationDocumentHeader.Customer, // Not needed

      cast ( I_ReservationDocumentHeader.WBSElementInternalID as ps_s4_pspnr preserving type )                                                          as WBSElementInternalID,
      I_ReservationDocumentHeader._WBSElementBasicData.WBSElementExternalID                                                                             as WBSElement,
      I_ReservationDocumentHeader.SalesOrder,
      I_ReservationDocumentHeader.SalesOrderItem,
      I_ReservationDocumentHeader.SalesOrderScheduleLine,
      I_ReservationDocumentHeader.AssetNumber,
      I_ReservationDocumentHeader.AssetSubNumber,
      I_ReservationDocumentHeader.NetworkNumberForAcctAssgmt,
      I_ReservationDocumentHeader.IssuingOrReceivingPlant,
      I_ReservationDocumentHeader.IssuingOrReceivingStorageLoc,
      I_ReservationDocumentHeader.ProfitabilitySegment_2                                                                                                as ProfitabilitySegment,
      cast ( I_ReservationDocumentHeader._ReservationDocumentItem [ 1: ReservationItem = '0001' and RecordType = '' ].Plant as werks_d preserving type) as Plant,
      //      P_ResvnDocRqmtType.RecordType,

      P_ResvnDocRqmtType.RequirementType,
      P_ResvnDocRqmtType.ReservationItemCreationCode,
      @Semantics.user.createdBy: true
      I_ReservationDocumentHeader.UserID,
      @Semantics.systemDateTime.createdAt: true
      I_ReservationDocumentHeader.CreationDateTime,
      @Semantics.user.lastChangedBy: true
      I_ReservationDocumentHeader.LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      @Semantics.systemDateTime.localInstanceLastChangedAt: true
      I_ReservationDocumentHeader.LastChangeDateTime,

      /* Associations */
      //I_ReservationDocumentHeader

      _ReservationDocumentItemTP,
      I_ReservationDocumentHeader._ControllingArea,
      I_ReservationDocumentHeader._CostCenter,
//      I_ReservationDocumentHeader._Customer,

      I_ReservationDocumentHeader._GoodsMovementType,
      I_ReservationDocumentHeader._VerificationCompanyCode,
      I_ReservationDocumentHeader._Order,
      I_ReservationDocumentHeader._WBSElementBasicData,
      I_ReservationDocumentHeader._ReservationCreationCode,
      //      _ResvnDocAccountAssignment,

      _ResvnCalculatedFilters,
      _CreatedByUser,
      _LastChangedByUser,
      _IssuingOrReceivingPlant,
      _IssuingOrReceivingStorageLoc,
      _ResvnCategoryDetermination
  //    _Interface

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESERVATIONDOCUMENTHEADER",
"I_RESERVATIONDOCUMENTITEM",
"I_WBSELEMENTBASICDATA",
"P_RESVNDOCRQMTTYPE"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_GOODSMOVEMENTTYPE",
"I_LOGISTICSORDER",
"I_PLANT",
"I_RESERVATIONCREATIONCODE",
"I_RESVNCATEGORYDETERMINATION",
"I_RESVNDOCHEADERSTATUS",
"I_STORAGELOCATION",
"I_USERDESCRIPTION",
"I_WBSELEMENTBASICDATA",
"R_RESERVATIONDOCUMENTITEMTP"
],
"BASE":
[
"I_RESERVATIONDOCUMENTHEADER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/