I_ReservationDocumentHeader
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)
| Source | Alias | Join Type |
|---|---|---|
| I_ReservationHeader | I_ReservationHeader | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA