I_NO_SAFTHeader

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_NO_SAFTHeader.
-- 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: INOSAFTHEAD

CREATE VIEW I_NO_SAFTHeader AS
SELECT
  a.CompanyCode AS CompanyCode,
  a.StartDate AS StartDate,
  a.EndDate AS EndDate,
  b.EmbeddedSwVersionStatusDesc AS EmbeddedSwVersionDescription,
  a._CompanyCode.CompanyCodeName AS CompanyCodeName,
  case when a._CompanyCode.Country = 'NO' then CcodRegNumber.VATRegistration else substring(a._CompanyCode.VATRegistration, 3, 18) end as VATRegistration AS VATRegistration318endasVATRegistration,
  case when CcodVATFirstName.FirstName is not initial and CcodVATFirstName.FirstName is not null then substring(CcodVATFirstName.FirstName,1,35) else 'NA' end as FirstName AS FirstName135elseNAendasFirstName,
  case when CcodVATLastName.LastName is not initial and CcodVATLastName.LastName is not null then CcodVATLastName.LastName else 'NA' end as LastName AS LastNameelseNAendasLastName,
  a._CompanyCode AS _CompanyCode
FROM I_SAFTHeader AS a
LEFT OUTER JOIN P_NO_CompanyCodeVAT AS CcodVAT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_NO_CompanyCodeRegNumber AS CcodRegNumber ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_NO_CompanyCodeFirstName AS CcodVATFirstName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_NO_CompanyCodeLastName AS CcodVATLastName ON /* join condition not captured in parsed metadata */
;