P_SchedgAgrmtItemScheduleLines

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 P_SchedgAgrmtItemScheduleLines.
-- 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.
-- SQL view name: PSCHAGSCHEDLINE
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_SchedgAgrmtItemScheduleLines AS
SELECT
  cast( SchedulingAgreementItem.SchedulingAgreement as mm_scheduling_agreement ) AS SchedulingAgreement,
  cast( SchedulingAgreementItem.SchedulingAgreementItem as mm_scheduling_agreement_item ) AS SchedulingAgreementItem,
  ScheduleLine,
  SchedulingAgreement.Supplier AS Supplier,
  SchedulingAgreement.PurchasingOrganization AS PurchasingOrganization,
  SchedulingAgreement.PurchasingGroup AS PurchasingGroup,
  SchedulingAgreement.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  SchedulingAgreement.DocumentCurrency AS DocumentCurrency,
  SchedulingAgreement.ValidityStartDate AS ValidityStartDate,
  SchedulingAgreement.ValidityEndDate AS ValidityEndDate,
  SchedulingAgreement.PurchasingDocumentType AS PurchasingDocumentType,
  SchedulingAgreement.CompanyCode AS CompanyCode,
  SchedulingAgreementItem.Plant AS Plant,
  SchedulingAgreementItem.StorageLocation AS StorageLocation,
  SchedulingAgreementItem.MaterialGroup AS MaterialGroup,
  SchedulingAgreementItem.Material AS Material,
  SchedulingAgreementItem.NetPriceAmount AS NetPriceAmount,
  SchedulingAgreementItem.NetPriceQuantity AS NetPriceQuantity,
  SchedulingAgreementItem.OrderQuantityUnit AS OrderQuantityUnit,
  SchedulingAgreementItem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  SchedulingAgreementItem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  SchedulingAgreementItem.ProductType AS ProductType,
  SchedulingAgreementItem.MaterialType AS MaterialType,
  SchedulingAgreementItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  SchedulingAgreementItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  SchedulingAgreementItem.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  SchedulingAgreementItem.TargetQuantity AS TargetQuantity,
  ScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  case when OrdPriceUnitToOrderUnitDnmntr > 0 then cast( currency_conversion(amount => NetPriceAmount, source_currency => SchedulingAgreement.DocumentCurrency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => ScheduleLine.ScheduleLineDeliveryDate ) as abap.curr(13,3) ) * cast( division( OrderPriceUnitToOrderUnitNmrtr , OrdPriceUnitToOrderUnitDnmntr , 3 ) as abap.dec(3,2) ) else 0 end as NetPriceAmountInDspCrcy AS dec32else0endasNetPriceAmountInDspCrcy
FROM I_SchedgAgrmtItm AS SchedulingAgreementItem
INNER JOIN I_Schedgagrmthdr AS SchedulingAgreement ON /* join condition not captured in parsed metadata */
INNER JOIN I_Schedgline AS ScheduleLine ON /* join condition not captured in parsed metadata */
;