C_SupInvListDrafts

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_SupInvListDrafts.
-- 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: CSIDRAFTS

CREATE VIEW C_SupInvListDrafts AS
SELECT
  db_key AS SupplierInvoiceUUID,
  belnr AS SupplierInvoice,
  gjahr AS FiscalYear,
  blart AS AccountingDocumentType,
  bldat AS DocumentDate,
  budat AS PostingDate,
  siroot.waers AS DocumentCurrency,
  ivtyp AS SupplierInvoiceOrigin,
  usnam AS CreatedByUser,
  xblnr AS SupplierInvoiceIDByInvcgParty,
  siroot.bukrs AS CompanyCode,
  siroot.lifnr AS InvoicingParty,
  siroot.zfbdt AS DueCalculationBaseDate,
  siroot.zbd1t AS CashDiscount1Days,
  siroot.zbd1p AS CashDiscount1Percent,
  siroot.bktxt AS DocumentHeaderText,
  cast('' as abap.dats) AS CashDiscount1DueDate,
  siroot.rbstat AS SupplierInvoiceStatus,
  _SupplierInvoiceStatusText.SupplierInvoiceStatusDesc AS SupplierInvoiceStatusDesc,
  _SupplierInvoiceOriginText.SupplierInvoiceOriginDesc AS SupplierInvoiceOriginDesc,
  case when ( ivtyp = 'I' and (siroot.business_network_origin = '' or siroot.business_network_origin ='01')) then cast('11' as abap.char(2)) when ( ivtyp = 'I' and siroot.business_network_origin ='02') then cast('14' as abap.char(2)) else cast('10' as abap.char(2) ) end as InvoiceStatusAndOrigin AS char2endasInvoiceStatusAndOrigin,
  cast ('' as eopblocked preserving type) AS IsEndOfPurposeBlocked
FROM mmiv_si_d_root AS siroot
LEFT OUTER JOIN I_SupplierInvoiceStsOriginText AS _SupplierInvoiceStsOriginText ON InvoiceStatusAndOrigin = _SupplierInvoiceStsOriginText.InvoiceStatusAndOrigin AND _SupplierInvoiceStsOriginText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoiceStatus AS _SupplierInvoiceStatus ON SupplierInvoice = _SupplierInvoiceStatus.SupplierInvoiceStatus  -- association [1..1]
LEFT OUTER JOIN I_SupplierInvoiceStatusText AS _SupplierInvoiceStatusText ON SupplierInvoiceStatus = _SupplierInvoiceStatusText.SupplierInvoiceStatus AND _SupplierInvoiceStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupplierInvoiceOriginText AS _SupplierInvoiceOriginText ON SupplierInvoiceOrigin = _SupplierInvoiceOriginText.SupplierInvoiceOrigin AND _SupplierInvoiceOriginText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
;