I_SuplrCsgnmtPplineWithdrawal

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_SuplrCsgnmtPplineWithdrawal.
-- 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: ISUPLRCSGPPLWDR

CREATE VIEW I_SuplrCsgnmtPplineWithdrawal AS
SELECT
  mblnr AS MaterialDocument,
  mjahr AS MaterialDocumentYear,
  zeile AS MaterialDocumentItem,
  status AS SuplrCsgnmtPplineWthdrwlStatus,
  bldat AS DocumentDate,
  budat AS PostingDate,
  bukrs AS CompanyCode,
  sobkz AS IssgOrRcvgStkIdfgSpclStkType,
  lifnr AS ConsignmentPipelineSupplier,
  werks AS Plant,
  matnr AS Material,
  shkzg AS DebitCreditCode,
  gsber AS BusinessArea,
  bwaer AS DocumentCurrency,
  wrbtr AS SuplrCsgnmtPplineWthdrwlAmount,
  bstme AS SupCsgnmtPplineWthdrwlQtyUnit,
  bstmg AS SuplrCsgnmtPplineWthdrwlQty,
  hkont AS GLAccount,
  mwskz AS TaxCode,
  navnw AS NonDeductibleInputTaxAmount,
  prctr AS ProfitCenter,
  tax_country AS TaxCountry
FROM rkwa
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON ConsignmentPipelineSupplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UoM ON SupCsgnmtPplineWthdrwlQtyUnit = _UoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SupCsgnmtPplineInvcHist AS _SupplierInvoiceHistory ON MaterialDocument = _SupplierInvoiceHistory.MaterialDocument AND MaterialDocumentYear = _SupplierInvoiceHistory.MaterialDocumentYear AND MaterialDocumentItem = _SupplierInvoiceHistory.MaterialDocumentItem  -- association [0..*]
;