C_SupInvListHeader

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_SupInvListHeader.
-- 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: CSUPINVLSTHDR

CREATE VIEW C_SupInvListHeader AS
SELECT
  InvoiceHeader.SupplierInvoice AS SupplierInvoice,
  InvoiceHeader.FiscalYear AS FiscalYear,
  case InvoiceHeader.SupplierInvoice when '' then '' else cast( concat(concat(InvoiceHeader.SupplierInvoice, '/'), InvoiceHeader.FiscalYear) as abap.char( 17 )) end as SupplierInvoiceWthnFiscalYear AS char17endasSupplierInvoiceWthnFiscalYear,
  InvoiceHeader.SupplierInvoiceUUID AS SupplierInvoiceUUID,
  InvoiceHeader.InvoicingParty AS InvoicingParty,
  _Supplier.SupplierName AS InvoicingPartyName,
  InvoiceHeader.CompanyCode AS CompanyCode,
  InvoiceHeader.DocumentDate AS DocumentDate,
  InvoiceHeader.PostingDate AS PostingDate,
  InvoiceHeader.DocumentCurrency AS DocumentCurrency,
  InvoiceHeader.SupplierInvoiceOrigin AS SupplierInvoiceOrigin,
  InvoiceHeader.DueCalculationBaseDate AS DueCalculationBaseDate,
  InvoiceHeader.CashDiscount1Days AS CashDiscount1Days,
  InvoiceHeader.CashDiscount1Percent AS CashDiscount1Percent,
  InvoiceHeader.SupplierInvoiceIDByInvcgParty AS SupplierInvoiceIDByInvcgParty,
  InvoiceHeader.CreatedByUser AS CreatedByUser,
  InvoiceHeader.DocumentHeaderText AS DocumentHeaderText,
  cast('00000000' as abap.dats) AS CashDiscount1DueDate,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  case InvoiceHeader.SupplierInvoice when _SupInvBlockDistinct.SupplierInvoice then case InvoiceHeader.FiscalYear when _SupInvBlockDistinct.FiscalYear then 'X' else ' ' end else ' ' end as IsBlocked AS FiscalYearthenXelseendelseendasIsBlocked,
  InvoiceHeader.InvoiceGrossAmount AS InvoiceGrossAmount,
  InvoiceHeader.SupplierInvoiceStatus AS SupplierInvoiceStatus,
  InvoiceHeader.InvoiceStatusAndOrigin AS InvoiceStatusAndOrigin,
  SupplierInvoiceStatusDesc,
  SupplierInvoiceOriginDesc,
  InvoiceStatusAndOriginDesc,
  InvoiceHeader.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
LEFT OUTER JOIN I_Supplier AS _Supplier ON InvoicingParty = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON InvoicingParty = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_SupplierInvoiceBlock AS _SupplierInvoiceBlock ON SupplierInvoice = _SupplierInvoiceBlock.SupplierInvoice AND FiscalYear = _SupplierInvoiceBlock.FiscalYear  -- association [0..*]
LEFT OUTER JOIN I_SupplierInvoiceBlkdDistinct AS _SupInvBlockDistinct ON _SupInvBlockDistinct.SupplierInvoice = SupplierInvoice AND _SupInvBlockDistinct.FiscalYear = FiscalYear AND _SupInvBlockDistinct.CompanyCode = CompanyCode  -- association [0..1]
;