I_PlndIndepRqmtItemHistoryBsc

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_PlndIndepRqmtItemHistoryBsc.
-- 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_PlndIndepRqmtItemHistoryBsc AS
SELECT
  pbhi.bdzei AS PlndIndepRqmtInternalID,
  cast(pbhi.pdatu as pdatu preserving type) AS OrderEndDate,
  pbhi.laeda AS LastChangeDate,
  pbhi.uzeit AS LastChangeTime,
  pbhi.aenam AS LastChangedByUser,
  _PlndIndepRqmtItem.BaseUnit AS BaseUnit,
  cast(pbhi.plnmg as pph_plan_qty preserving type) AS PlannedQuantity,
  pbhi.entmg AS WithdrawalQuantity
FROM pbhi
LEFT OUTER JOIN I_PlndIndepRqmtByIntKey AS _PlndIndepRqmt ON PlndIndepRqmtInternalID = _PlndIndepRqmt.PlndIndepRqmtInternalID  -- association [1..1]
LEFT OUTER JOIN I_PlndIndepRqmtItemByIntKey AS _PlndIndepRqmtItem ON PlndIndepRqmtInternalID = _PlndIndepRqmtItem.PlndIndepRqmtInternalID AND OrderEndDate = _PlndIndepRqmtItem.WorkingDayDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _OrderEndDate ON OrderEndDate = _OrderEndDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _LastChangeDate ON LastChangeDate = _LastChangeDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedUser ON LastChangedByUser = _LastChangedUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_SalesDelivDateCategory AS _ForecastPeriodType ON ForecastPeriodType = _ForecastPeriodType.SalesDelivDateCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON BaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;