I_RRBSalesPricingDynamicItem

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_RRBSalesPricingDynamicItem.
-- 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: IRRBSLSPRDYNITEM

CREATE VIEW I_RRBSalesPricingDynamicItem AS
SELECT
  vpkdli.vpkid AS RRBSalesPricingDocument,
  vpkdli.dlinr AS RRBDynamicItem,
  vpkdli.vwaer AS DocumentCurrency,
  vpkdli.posnr AS SalesDocumentItem,
  vpkdli.matnr_sd AS Material,
  vpkdli.netvalue AS NetAmount,
  vpkdli.netpr AS NetPriceAmount,
  vpkdli.in_wtgbtr AS AmountToBeBilledInTransacCrcy,
  vpkdli.op_wtgbtr AS TotalAmountInTransactionCrcy,
  vpkdli.no_wtgbtr AS AmtToBeRejectedInTransacCrcy,
  vpkdli.la_wtgbtr AS AmtToBePostponedInTransacCrcy,
  vpkdli.bi_wtgbtr AS BilledAmountInTransacCrcy,
  vpkdli.so_wtgbtr AS OriginalAmountInTransacCrcy,
  vpkdli.ca_wtgbtr AS CanceledAmountInTransacCrcy,
  vpkdli.op_megbtr AS TotalQuantity,
  vpkdli.so_megbtr AS TotalBillableQtyInBaseUnit,
  vpkdli.la_megbtr AS PostponedQuantity,
  vpkdli.no_megbtr AS RejectedQuantity,
  vpkdli.in_megbtr AS BilledQuantity
FROM vpkdli
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_RRBDynamicItemLongText AS _RRBDynamicItemLongText ON RRBDynamicItem = _RRBDynamicItemLongText.RRBDynamicItem AND _RRBDynamicItemLongText.Language = 'E'  -- association [0..1]
;