What is P_ReservationItem in SAP S/4HANA?

P_ReservationItem is a consumption CDS view in SAP S/4HANA. Reservation Item It contains 68 fields.

Which tables does P_ReservationItem read from?

P_ReservationItem reads data from: I_ReservationItem.

What VDM layer is P_ReservationItem?

P_ReservationItem is classified as a Consumption view optimized for specific business scenarios and reporting.

P_ReservationItem

DDL: P_RESERVATIONITEM SQL: PRESERVITM Type: view CONSUMPTION

68 Fields 1 Data Sources 1 Associations

Reservation Item

P_ReservationItem is a Consumption CDS View that provides data about "Reservation Item" in SAP S/4HANA. It reads from 1 data source (I_ReservationItem) and exposes 68 fields with key fields Reservation, ReservationItem, RecordType. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
I_ReservationItem	I_ReservationItem	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_MRPAreaSubcontractor	_MRPAreaSubcontractor	`_MRPAreaSubcontractor.MRPAreaPlant = $projection.Plant and _MRPAreaSubcontractor.MRPAreaSubcontractor = $projection.Supplier`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	PRESERVITM	view
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_ALLOWED	view
EndUserText.label	Reservation Item	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	P_ProcmtDocSubcontrg	view

Fields (68)

Key	Field	Source Table	Source Field	Description
KEY	Reservation		Reservation	Reservation
KEY	ReservationItem		ReservationItem	Reservation Item
KEY	RecordType		RecordType	Reservation Record Type
	Material		Material	Vehicle Model
	MRPArea	_MRPAreaSubcontractor	MRPArea	MRP Area
	RequirementType		RequirementType	RequirementType
	MatlCompRequirementDate		MatlCompRequirementDate	Reqmts date
	Plant		Plant	Valuation Area
	ManufacturingOrderOperation		ManufacturingOrderOperation	Activity
	GoodsMovementIsAllowed		GoodsMovementIsAllowed	Mvt Allowed
	StorageLocation		StorageLocation	StorageLocation
	Batch		Batch	Lot No.
	DebitCreditCode		DebitCreditCode	Single-Character Flag
	BaseUnit		BaseUnit	Unit of Measure
	GLAccount		GLAccount	General Ledger
	GoodsMovementType		GoodsMovementType	Movement Type
	EntryUnit		EntryUnit	Unit of Entry
	QuantityIsFixed		QuantityIsFixed	Qty. is fixed
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	IssuingOrReceivingPlant		IssuingOrReceivingPlant	Transfer Plant
	IssuingOrReceivingStorageLoc		IssuingOrReceivingStorageLoc	Receiving SLoc.
	PurchasingDocument		PurchasingDocument	Purchasing Document
	PurchasingDocumentItem		PurchasingDocumentItem	Purchasing Doc. Item
	ResvnItmRequiredQtyInBaseUnit		ResvnItmRequiredQtyInBaseUnit	Requirement qty
	ReservationItemIsFinallyIssued		ReservationItemIsFinallyIssued	Final Issue
	ReservationItmIsMarkedForDeltn		ReservationItmIsMarkedForDeltn	Deleted
	ResvnItmRequiredQtyInEntryUnit		ResvnItmRequiredQtyInEntryUnit	Quantity in UnE
	ResvnItmWithdrawnQtyInBaseUnit		ResvnItmWithdrawnQtyInBaseUnit	Withdrawal Qty
	ResvnItmWithdrawnAmtInCCCrcy		ResvnItmWithdrawnAmtInCCCrcy	Withdr. Value
	Supplier		Supplier	Supplier
	InventorySpecialStockType		InventorySpecialStockType	Special Stock Type
	MaterialComponentIsPhantomItem		MaterialComponentIsPhantomItem	Phantom Item
	IsBulkMaterialComponent		IsBulkMaterialComponent	Bulk material
	MatlCompIsTextItem		MatlCompIsTextItem	Text Item
	PurchaseRequisition		PurchaseRequisition	Requisition
	PurchaseRequisitionItem		PurchaseRequisitionItem	Requisn. item
	ReferenceOrder		ReferenceOrder	Reference Order
	MaterialGroup		MaterialGroup	Product Group
	ReservationQuantityRqmtTime		ReservationQuantityRqmtTime	Time qty req'd
	MaterialComponentIsMissing		MaterialComponentIsMissing	Missing Part
	PlannedOrder		PlannedOrder	Planned Order
	ScheduleLine		ScheduleLine	Schedule Line
	ProductionSupplyArea		ProductionSupplyArea	Supply Area
	IsComponentQuantityFixed		IsComponentQuantityFixed	Qty. is fixed
	IsMaterialProvision		IsMaterialProvision	Mat. Prov. Ind.
	GoodsRecipientName		GoodsRecipientName	Recipient Name
	UnloadingPointName		UnloadingPointName	Unloading Point Name
	ReservationItemText		ReservationItemText	Text
	MaterialCompIsProcuredDirectly		MaterialCompIsProcuredDirectly	Checkbox
	IssgOrRcvgSpclStockInd		IssgOrRcvgSpclStockInd	Special Stock
	_DebitCreditCode		_DebitCreditCode
	_Plant		_Plant
	_IssuingOrReceivingPlant		_IssuingOrReceivingPlant
	_Material		_Material
	_StorageLocation		_StorageLocation
	_IssuingOrReceivingStorageLoc		_IssuingOrReceivingStorageLoc
	_GoodsMovementType		_GoodsMovementType
	_Currency		_Currency
	_PurchasingDocument		_PurchasingDocument
	_PurchasingDocumentItem		_PurchasingDocumentItem
	_BaseUnit		_BaseUnit
	_EntryUnit		_EntryUnit
	_Supplier		_Supplier
	_InventorySpecialStockType		_InventorySpecialStockType
	_Batch		_Batch
	_MRPAreaSubcontractor		_MRPAreaSubcontractor
	_SupplierCompanyByPlant		_SupplierCompanyByPlant
	_ReservationHeader		_ReservationHeader

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 P_ReservationItem.
-- 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.
-- SQL view name: PRESERVITM

CREATE VIEW P_ReservationItem AS
SELECT
  Reservation,
  ReservationItem,
  RecordType,
  Material,
  _MRPAreaSubcontractor.MRPArea AS MRPArea,
  RequirementType,
  MatlCompRequirementDate,
  Plant,
  ManufacturingOrderOperation,
  GoodsMovementIsAllowed,
  StorageLocation,
  Batch,
  DebitCreditCode,
  BaseUnit,
  GLAccount,
  GoodsMovementType,
  EntryUnit,
  QuantityIsFixed,
  CompanyCodeCurrency,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  PurchasingDocument,
  PurchasingDocumentItem,
  ResvnItmRequiredQtyInBaseUnit,
  ReservationItemIsFinallyIssued,
  ReservationItmIsMarkedForDeltn,
  ResvnItmRequiredQtyInEntryUnit,
  ResvnItmWithdrawnQtyInBaseUnit,
  ResvnItmWithdrawnAmtInCCCrcy,
  Supplier,
  InventorySpecialStockType,
  MaterialComponentIsPhantomItem,
  IsBulkMaterialComponent,
  MatlCompIsTextItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  ReferenceOrder,
  MaterialGroup,
  ReservationQuantityRqmtTime,
  MaterialComponentIsMissing,
  PlannedOrder,
  ScheduleLine,
  ProductionSupplyArea,
  IsComponentQuantityFixed,
  IsMaterialProvision,
  GoodsRecipientName,
  UnloadingPointName,
  ReservationItemText,
  MaterialCompIsProcuredDirectly,
  IssgOrRcvgSpclStockInd
FROM I_ReservationItem
LEFT OUTER JOIN I_MRPAreaSubcontractor AS _MRPAreaSubcontractor ON _MRPAreaSubcontractor.MRPAreaPlant = Plant AND _MRPAreaSubcontractor.MRPAreaSubcontractor = Supplier  -- association [0..*]
;

Depth:

P_ReservationItem view

I_ReservationItem view