I_SuplrInvcItemConsignment

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_SuplrInvcItemConsignment.
-- 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: ISINVCITMCONS

CREATE VIEW I_SuplrInvcItemConsignment AS
SELECT
  belnr AS SupplierInvoice,
  gjahr AS FiscalYear,
  buzei AS SupplierInvoiceItem,
  mblnr AS MaterialDocument,
  mjahr AS MaterialDocumentYear,
  mblpo AS MaterialDocumentItem,
  matnr AS Material,
  bukrs AS CompanyCode,
  werks AS Plant,
  _SupplierInvoice.DocumentCurrency AS DocumentCurrency,
  wrbtr AS SupplierInvoiceItemAmount,
  shkzg AS DebitCreditCode,
  mwskz AS TaxCode,
  txjcd AS TaxJurisdiction,
  meins AS QuantityUnit,
  menge AS Quantity,
  gsber AS BusinessArea,
  saknr AS GLAccount,
  prctr AS ProfitCenter,
  tax_country AS TaxCountry
FROM recon
LEFT OUTER JOIN I_SupplierInvoice AS _SupplierInvoice ON SupplierInvoice = _SupplierInvoice.SupplierInvoice AND FiscalYear = _SupplierInvoice.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON documentcurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
;