I_HU_DomesticSlsPurList

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_HU_DomesticSlsPurList.
-- 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: IHUDOMSLSPURLIST

CREATE VIEW I_HU_DomesticSlsPurList AS
SELECT
  P_Hu_Domesticslspurlist.CompanyCode AS CompanyCode,
  P_Hu_Domesticslspurlist.AccountingDocument AS AccountingDocument,
  P_Hu_Domesticslspurlist.FiscalYear AS FiscalYear,
  P_Hu_Domesticslspurlist.AccountingDocumentItem AS AccountingDocumentItem,
  P_Hu_Domesticslspurlist.DocumentDate AS DocumentDate,
  P_Hu_Domesticslspurlist.PostingDate AS PostingDate,
  P_Hu_Domesticslspurlist.TaxReportingDate AS TaxReportingDate,
  P_Hu_Domesticslspurlist.TaxCode AS TaxCode,
  P_Hu_Domesticslspurlist.TaxRate AS TaxRate,
  P_Hu_Domesticslspurlist.ReferenceDocumentType AS ReferenceDocumentType,
  cast( P_Hu_Domesticslspurlist.DocumentReferenceID as xblnr1 ) AS DocumentReferenceID,
  P_Hu_Domesticslspurlist.InvoiceReference AS InvoiceReference,
  P_Hu_Domesticslspurlist.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  P_Hu_Domesticslspurlist.OriginalReferenceDocument AS OriginalReferenceDocument,
  P_Hu_Domesticslspurlist.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  P_Hu_Domesticslspurlist.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  P_Hu_Domesticslspurlist.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_Hu_Domesticslspurlist.FinancialAccountType AS FinancialAccountType,
  P_Hu_Domesticslspurlist.BusinessPartner AS BusinessPartner,
  P_Hu_Domesticslspurlist.BusinessPartnerName AS BusinessPartnerName,
  P_Hu_Domesticslspurlist.Country AS Country,
  case when P_Hu_Domesticslspurlist.Country = 'HU' then substring(P_Hu_Domesticslspurlist.TaxNumber1, 1, 8) else substring(P_Hu_Domesticslspurlist.VATRegistration, 3, 18) end as VATRegistration AS VATRegistration318endasVATRegistration,
  cast( P_Hu_Domesticslspurlist.Invoice as xblnr1 ) AS Invoice,
  P_Hu_Domesticslspurlist.InvoiceDate AS InvoiceDate,
  cast( P_Hu_Domesticslspurlist.ReferenceDocument as xblnr1 ) AS ReferenceDocument,
  P_Hu_Domesticslspurlist.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  P_Hu_Domesticslspurlist.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  cast( '' as abap.char( 3 ) ) AS HU_InvoiceCorrectionType,
  cast( '' as abap.char( 4 ) ) AS HU_SalesPurListReturnSection,
  cast( '' as xblnr1 ) AS OriginReferenceDocument,
  cast( '' as abap.numc( 4 ) ) AS TechnicalObject,
  P_Hu_Domesticslspurlist.AuthorizationGroup AS AuthorizationGroup,
  P_Hu_Domesticslspurlist.DataControllerSet AS DataControllerSet,
  P_Hu_Domesticslspurlist.DataController1 AS DataController1,
  P_Hu_Domesticslspurlist.DataController2 AS DataController2,
  P_Hu_Domesticslspurlist.DataController3 AS DataController3,
  P_Hu_Domesticslspurlist.DataController4 AS DataController4,
  P_Hu_Domesticslspurlist.DataController5 AS DataController5,
  P_Hu_Domesticslspurlist.DataController6 AS DataController6,
  P_Hu_Domesticslspurlist.DataController7 AS DataController7,
  P_Hu_Domesticslspurlist.DataController8 AS DataController8,
  P_Hu_Domesticslspurlist.DataController9 AS DataController9,
  P_Hu_Domesticslspurlist.DataController10 AS DataController10
FROM P_Hu_Domesticslspurlist
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON CompanyCodeCurrency = _ReportingCurrency.Currency  -- association [0..1]
;