C_MRPSchedulingAgreementCard

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_MRPSchedulingAgreementCard.
-- 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_MRPSchedulingAgreementCard AS
SELECT
  _SchedulingAgreementItem.SalesSchedulingAgreement AS SalesSchedulingAgreement,
  _SchedulingAgreementItem.SalesSchedulingAgreementItem AS SalesSchedulingAgreementItem,
  _SalesDocumentScheduleLine.ScheduleLine AS ScheduleLine,
  _SchedulingAgreement.SoldToParty AS SoldToParty,
  _Customer.CustomerName AS SoldToPartyName,
  _SchedulingAgreement.SalesSchedgAgrmtDate AS SalesSchedgAgrmtDate,
  _SalesDocumentScheduleLine.LoadingDate AS LoadingDate,
  _SalesDocumentScheduleLine.RequestedDeliveryDate AS RequestedDeliveryDate,
  _SchedulingAgreementItem.OrderQuantity AS OrderQuantity,
  _SchedulingAgreementItem.OrderQuantityUnit AS OrderQuantityUnit,
  _SchedulingAgreementItem.Product AS Material,
  _SchedulingAgreementItem._Product._Text[1:Language = $session.system_language].ProductName AS ProductName,
  _SchedulingAgreementItem.MaterialByCustomer AS MaterialByCustomer,
  cast ( case when _SchedulingAgreementItem.MaterialByCustomer is initial then 'X' else '' end as boolean preserving type ) AS UICT_CustomerMaterialHidden,
  _SchedulingAgreementItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  cast ( '' as abap.char( 25 ) ) AS UICT_DeliveryIsBlocked,
  _SalesDocumentScheduleLine.DelivBlockReasonForSchedLine AS DelivBlockReasonForSchedLine,
  _SalesDocumentScheduleLine._DelivBlockReasonForSchedLine._Text[1:Language = $session.system_language].DeliveryBlockReasonText AS DeliveryBlockReasonText,
  cast ( case when _SalesDocumentScheduleLine.DelivBlockReasonForSchedLine is initial then 'X' else '' end as boolean preserving type ) AS UICT_DeliveryBlockReason,
  _SalesDocumentScheduleLine.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  _SalesDocumentScheduleLine.BaseUnit AS BaseUnit
FROM I_SalesSchedgAgrmtItem AS _SchedulingAgreementItem
INNER JOIN I_SalesSchedgAgrmt AS _SchedulingAgreement ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocumentScheduleLine AS _SalesDocumentScheduleLine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON SoldToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_MRPElementCategoryText AS _MRPElementCategoryText ON _MRPElementCategoryText.MRPElementCategory = 'VE' AND _MRPElementCategoryText.Language = $session.system_language  -- association [0..1]
;