I_ReservationDocumentHeader

DDL: I_RESERVATIONDOCUMENTHEADER Type: view BASIC
39 Fields 1 Data Sources 5 Associations

Reservation Document Header

I_ReservationDocumentHeader (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Supply Chain

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.

SAP API Hub

StateC1
Line of BusinessSupply Chain
Application ComponentMM-IM-VDM-RSV
CapabilitiesAnalytical Dimension, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageSupply Chain for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p> How many reservations were done per period?</p></li> <li><p> How many reservations were done per cost center?</p></li> <li><p> How many reservations were done per customer?</p></li> <li><p> How many reservation items are there per reservation document?</p></li> </ul>

Documentation

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 Number of reservation/dependent requirements
ReservationCreationCode ReservationCreationCode Reservation Creation Code
ReservationOrigin ReservationOrigin Origin
OrderID OrderID Order Number
GoodsMovementType GoodsMovementType Movement Type (Inventory Management)
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
ProfitabilitySegment ProfitabilitySegment Deprecated: Profitability Segment
ProfitabilitySegment_2 ProfitabilitySegment_2 Profitability Segment
ControllingArea ControllingArea Controlling Area
GoodsRecipientName GoodsRecipientName Goods Recipient
ReservationDate ReservationDate Base date for reservation
IsCheckedAgainstFactoryCal IsCheckedAgainstFactoryCal Check date against factory calendar
Customer Customer Account number of customer
WBSElementInternalID WBSElementInternalID Work Breakdown Structure Element (WBS Element)
SalesOrder SalesOrder Sales Order Number
SalesOrderItem SalesOrderItem Item Number in Sales Order
SalesOrderScheduleLine SalesOrderScheduleLine Delivery schedule for sales order
AssetNumber AssetNumber Main Asset Number
AssetSubNumber AssetSubNumber Asset Subnumber
NetworkNumberForAcctAssgmt NetworkNumberForAcctAssgmt Network Number for Account Assignment
IssuingOrReceivingPlant IssuingOrReceivingPlant Receiving plant/issuing plant
IssuingOrReceivingStorageLoc IssuingOrReceivingStorageLoc Receiving/issuing storage location
ResvnVerificationCompanyCode ResvnVerificationCompanyCode Clearing company code
UserID UserID User Name
CreationDateTime CreationDateTime Creation Date
LastChangedByUser LastChangedByUser Last Changed By User
LastChangeDateTime LastChangeDateTime Last Changed On
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_ControllingArea _ControllingArea
_VerificationCompanyCode _VerificationCompanyCode
_Order _Order
_GoodsMovementType _GoodsMovementType
_Customer _Customer
_WBSElementByInternalKey _WBSElementByInternalKey
_WBSElementBasicData _WBSElementBasicData
_ReservationCreationCode _ReservationCreationCode
_ReservationDocumentItem _ReservationDocumentItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ReservationDocumentHeader.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ReservationDocumentHeader AS
SELECT
  Reservation,
  ReservationCreationCode,
  ReservationOrigin,
  OrderID,
  GoodsMovementType,
  CostCenter,
  ProfitCenter,
  ProfitabilitySegment,
  ProfitabilitySegment_2,
  ControllingArea,
  GoodsRecipientName,
  ReservationDate,
  IsCheckedAgainstFactoryCal,
  Customer,
  WBSElementInternalID,
  SalesOrder,
  SalesOrderItem,
  SalesOrderScheduleLine,
  AssetNumber,
  AssetSubNumber,
  NetworkNumberForAcctAssgmt,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  ResvnVerificationCompanyCode,
  UserID,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_ReservationHeader
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND ReservationDate <= _CostCenter.ValidityEndDate AND ReservationDate >= _CostCenter.ValidityStartDate  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentItem AS _ReservationDocumentItem ON Reservation = _ReservationDocumentItem.Reservation  -- association [1..*]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKey ON WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ReservationCreationCode AS _ReservationCreationCode ON ReservationCreationCode = _ReservationCreationCode.ReservationCreationCode  -- association [0..1]
;

Learn More