C_ReservationDocItemOPg

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 C_ReservationDocItemOPg.
-- 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 C_ReservationDocItemOPg AS
SELECT
  Reservation,
  ReservationItem,
  RecordType,
  Plant,
  _Plant.PlantName AS PlantName,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  Product AS Material,
  _Product._Text[1:Language=$session.system_language].ProductName AS ProductName,
  GoodsMovementType,
  _GoodsMovementType._Text[1:Language=$session.system_language].GoodsMovementTypeName AS GoodsMovementTypeName,
  cast( '' as boole_d) AS UICT_Batch,
  ValuationType,
  cast( '' as boole_d) AS UICT_ValuationType,
  MatlCompRequirementDate,
  ServiceDocument,
  cast( '' as boole_d) AS UICT_ServiceDocument,
  ServiceDocumentItem,
  cast( '' as boole_d) AS UICT_ServiceDocumentItem,
  ServiceObjectType,
  GoodsMovementIsAllowed,
  BaseUnit,
  GLAccount,
  EntryUnit,
  QuantityIsFixed,
  ConfdQtyForATPInBaseUoM,
  ReservationItemIsFinallyIssued,
  cast( '' as boole_d) AS UICT_ResvnItemIsFinallyIssued,
  ReservationItmIsMarkedForDeltn,
  cast( '' as boole_d) AS UICT_ResvnItmIsMarkedForDeltn,
  ResvnItmRequiredQtyInBaseUnit,
  ResvnItmRequiredQtyInEntryUnit,
  ResvnItmWithdrawnQtyInBaseUnit,
  ResvnItmWithdrawnAmtInCCCrcy,
  I_ReservationDocumentItem.Supplier AS Supplier,
  CompanyCodeCurrency,
  GoodsRecipientName,
  UnloadingPointName,
  ReservationItemText,
  _ReservationDocumentHeader.ResvnVerificationCompanyCode AS ResvnVerificationCompanyCode,
  cast( '' as boole_d) AS UICT_DeliveryFacet,
  RecipientLocationCode,
  _RecipientLocationCode._RecipientLocationText[1:Language=$session.system_language].RecipientLocationText AS RecipientLocationText,
  cast( '' as boole_d) AS UICT_RecipientLocationCode,
  AccountAssignmentCategory,
  cast( '' as boole_d) AS UICT_AccountAssignmentCategory,
  ConsumptionPosting,
  cast( '' as boole_d) AS UICT_ConsumptionPosting
FROM I_ReservationDocumentItem
LEFT OUTER JOIN C_MatlDocOfResvnDocItem AS _MatlDocOfResvnDocItem ON Reservation = _MatlDocOfResvnDocItem.Reservation AND ReservationItem = _MatlDocOfResvnDocItem.ReservationItem AND RecordType = ''  -- association [0..*]
LEFT OUTER JOIN C_DelivDocItemOfResvnDocItem AS _DeliveryDocument ON Reservation = _DeliveryDocument.Reservation AND ReservationItem = _DeliveryDocument.ReservationItem AND RecordType = ''  -- association [0..*]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductStorageLocation AS _ProductStorageLocation ON Material = _ProductStorageLocation.Product AND Plant = _ProductStorageLocation.Plant AND StorageLocation = _ProductStorageLocation.StorageLocation  -- association [0..1]
;