I_SDMassChgCkptSlsSchdLnChgBsc

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_SDMassChgCkptSlsSchdLnChgBsc.
-- 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_SDMassChgCkptSlsSchdLnChgBsc AS
SELECT
  sdmcc_chgsline.slsdocmasschangerequestuuid AS SlsDocMassChangeRequestUUID,
  sdmcc_chgsline.slsdocmasschgactioncategory AS SlsDocMassChgActionCategory,
  sdmcc_chgsline.slsdocmasschgactionid AS SlsDocMassChgActionID,
  sdmcc_chgsline.schedulelinecategory AS ScheduleLineCategory,
  sdmcc_chgsline.requesteddeliverydate AS RequestedDeliveryDate,
  sdmcc_chgsline.delivblockreasonforschedline AS DelivBlockReasonForSchedLine
FROM sdmcc_chgsline
LEFT OUTER JOIN I_SDMassChgCkptMassChgReqBsc AS _ChangeRequest ON SlsDocMassChangeRequestUUID = _ChangeRequest.SlsDocMassChangeRequestUUID  -- association [1..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DelivBlockReasonForSchedLine = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_ScheduleLineCategory AS _ScheduleLineCategory ON ScheduleLineCategory = _ScheduleLineCategory.ScheduleLineCategory  -- association [0..1]
LEFT OUTER JOIN I_SDMassChgCkptActionCategory AS _ChangeActionCategory ON SlsDocMassChgActionCategory = _ChangeActionCategory.SlsDocMassChgActionCategory  -- association [0..1]
LEFT OUTER JOIN I_SDMassChgCkptActionMaster AS _ChangeActionID ON SlsDocMassChgActionID = _ChangeActionID.SlsDocMassChgActionID  -- association [0..1]
;