I_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 I_ReservationHeader.
-- 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_ReservationHeader AS
SELECT
  rsnum AS Reservation,
  creationcode AS ReservationCreationCode,
  kzver AS ReservationOrigin,
  usnam AS UserID,
  aufnr AS OrderID,
  bwart AS GoodsMovementType,
  kostl AS CostCenter,
  prctr AS ProfitCenter,
  kokrs AS ControllingArea,
  cast(paobjnr as rkeobjnr_char) AS ProfitabilitySegment_2,
  wempf AS GoodsRecipientName,
  rsdat AS ReservationDate,
  xcale AS IsCheckedAgainstFactoryCal,
  kunnr AS Customer,
  ps_psp_pnr AS WBSElementInternalID,
  kdauf AS SalesOrder,
  kdpos AS SalesOrderItem,
  kdein AS SalesOrderScheduleLine,
  anln1 AS AssetNumber,
  anln2 AS AssetSubNumber,
  nplnr AS NetworkNumberForAcctAssgmt,
  umwrk AS IssuingOrReceivingPlant,
  umlgo AS IssuingOrReceivingStorageLoc,
  parbu AS ResvnVerificationCompanyCode,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM rkpf
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND ReservationDate >= _ProfitCenter.ValidityStartDate AND ReservationDate <= _ProfitCenter.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_ReservationItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation  -- association [1..*]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKey ON WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrderItem = _SalesOrderItem.SalesOrderItem AND SalesOrder = _SalesOrderItem.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderScheduleLine AS _SalesOrderScheduleLine ON SalesOrderScheduleLine = _SalesOrderScheduleLine.ScheduleLine AND SalesOrder = _SalesOrderScheduleLine.SalesOrder AND SalesOrderItem = _SalesOrderScheduleLine.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON AssetNumber = _MasterFixedAsset.MasterFixedAsset  -- association [0..*]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON AssetSubNumber = _FixedAsset.FixedAsset  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON IssuingOrReceivingPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON IssuingOrReceivingStorageLoc = _StorageLocation.StorageLocation AND IssuingOrReceivingPlant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _VerificationCompanyCode ON ResvnVerificationCompanyCode = _VerificationCompanyCode.CompanyCode  -- association [0..1]
;