I_FldLogsProdReservationDetail

DDL: I_FLDLOGSPRODRESERVATIONDETAIL SQL: IFLDPRODRESVD Type: view COMPOSITE
23 Fields 4 Data Sources

Reservation details of products

I_FldLogsProdReservationDetail is a Composite CDS View that provides data about "Reservation details of products" in SAP S/4HANA. It reads from 4 data sources (I_FldLogsAllReservation, I_FldLogsAllReservation, I_ReservationHeader, I_ReservationHeader) and exposes 23 fields with key fields Material, FldLogsRemotePlant, FldLogsReferenceDocumentNumber, ReferenceDocumentItem, FldLogsMaintenanceOrder.

Data Sources (4)

SourceAliasJoin Type
I_FldLogsAllReservation _Resb from
I_FldLogsAllReservation _Resb union_all
I_ReservationHeader _ResbHeader inner
I_ReservationHeader _ResbHeader inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFLDPRODRESVD view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Reservation details of products view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Material I_FldLogsAllReservation Material Vehicle Model
KEY FldLogsRemotePlant I_FldLogsAllReservation FldLogsRemotePlant Plant
KEY FldLogsReferenceDocumentNumber I_FldLogsAllReservation FldLogsReferenceDocumentNumber Reference Doc Number
KEY ReferenceDocumentItem I_FldLogsAllReservation ReferenceDocumentItem Reference item
KEY FldLogsMaintenanceOrder I_FldLogsAllReservation FldLogsMaintenanceOrder
KEY RemoteStorageLocation I_FldLogsAllReservation RemoteStorageLocation
KEY Reservation I_FldLogsAllReservation Reservation Reservation
KEY ReservationItem I_FldLogsAllReservation ReservationItem Reservation Item
OrderID I_ReservationHeader OrderID Network
QuantityUnit I_FldLogsAllReservation QuantityUnit Unit of measure
ResvnItmRequiredQtyInBaseUnit I_FldLogsAllReservation ResvnItmRequiredQtyInBaseUnit Requirement qty
Material Vehicle Model
KEY FldLogsRemotePlant I_FldLogsAllReservation FldLogsRemotePlant Plant
KEY FldLogsReferenceDocumentNumber I_FldLogsAllReservation FldLogsReferenceDocumentNumber Reference Doc Number
KEY ReferenceDocumentItem I_FldLogsAllReservation ReferenceDocumentItem Reference item
KEY FldLogsMaintenanceOrder I_FldLogsAllReservation FldLogsMaintenanceOrder
KEY RemoteStorageLocation I_FldLogsAllReservation RemoteStorageLocation
KEY Reservation I_FldLogsAllReservation Reservation Reservation
KEY ReservationItem I_FldLogsAllReservation ReservationItem Reservation Item
OrderID I_ReservationHeader NetworkNumberForAcctAssgmt Network
QuantityUnit I_FldLogsAllReservation QuantityUnit Unit of measure
ResvnItmRequiredQtyInBaseUnit I_FldLogsAllReservation ResvnItmRequiredQtyInBaseUnit Requirement qty
ResvnItmWithdrawnQtyInBaseUnit I_FldLogsAllReservation ResvnItmWithdrawnQtyInBaseUnit Withdrawal Qty

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_FldLogsProdReservationDetail.
-- 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: IFLDPRODRESVD

CREATE VIEW I_FldLogsProdReservationDetail AS
SELECT
  _Resb.Material AS Material,
  _Resb.FldLogsRemotePlant AS FldLogsRemotePlant,
  _Resb.FldLogsReferenceDocumentNumber AS FldLogsReferenceDocumentNumber,
  _Resb.ReferenceDocumentItem AS ReferenceDocumentItem,
  _Resb.FldLogsMaintenanceOrder AS FldLogsMaintenanceOrder,
  _Resb.RemoteStorageLocation AS RemoteStorageLocation,
  _Resb.Reservation AS Reservation,
  _Resb.ReservationItem AS ReservationItem,
  _ResbHeader.OrderID AS OrderID,
  _Resb.QuantityUnit AS QuantityUnit,
  _Resb.ResvnItmRequiredQtyInBaseUnit AS ResvnItmRequiredQtyInBaseUnit,
  _Resb.ResvnItmWithdrawnQtyInBaseUnit AS ResvnItmWithdrawnQtyInBaseUnit
FROM I_FldLogsAllReservation AS _Resb
INNER JOIN I_ReservationHeader AS _ResbHeader ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_FldLogsAllReservation
;

Learn More