C_LU_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 C_LU_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: CLUSAFTHEADER

CREATE VIEW C_LU_SAFTHeader AS
SELECT
  Head.CompanyCode AS CompanyCode,
  Head.StartDate AS StartDate,
  Head.EndDate AS EndDate,
  Head.FiscalYear AS FiscalYear,
  cast(Head._CompanyCode.VATRegistration as abap.char(20)) AS VATRegistration,
  case when Head._CompanyCode._OrgAddressDefaultRprstn.AddresseeName1 is not initial then concat_with_space (Head._CompanyCode._OrgAddressDefaultRprstn.AddresseeName1, Head._CompanyCode._OrgAddressDefaultRprstn.AddresseeName2, 1) else Head._CompanyCode.CompanyCodeName end as CompanyName AS CompanyCodeNameendasCompanyName,
  Head._CompanyCode._OrgAddressDefaultRprstn.StreetName AS StreetName,
  Head._CompanyCode._OrgAddressDefaultRprstn.HouseNumber AS HouseNumber,
  case when Head._CompanyCode.CityName is not initial then Head._CompanyCode.CityName else Head._CompanyCode._OrgAddressDefaultRprstn.CityName end as CityName AS CityNameendasCityName,
  Head._CompanyCode._OrgAddressDefaultRprstn.PostalCode AS PostalCode,
  Head._CompanyCode._OrgAddressDefaultRprstn.Country AS Country,
  Vers.EmbeddedSwVersionStatusDesc AS EmbeddedSwVersionStatusDesc,
  Head._CompanyCode.AddressID AS AddressID,
  cast( '' as ad_persnum ) AS Person,
  _ContactFirstName.CompanyCodeParameterValue AS FirstName,
  _ContactLastName.CompanyCodeParameterValue AS LastName,
  Phone.InternationalPhoneNumber AS PhoneNumber,
  cast(Fax.InternationalFaxNumber as abap.char(31)) AS FaxNumber,
  cast( Email.EmailAddress as abap.char(241) ) AS EmailAddress,
  ' ' AS URLFieldLength,
  ' ' AS WebsiteURL
FROM I_SAFTHeader AS Head
INNER JOIN I_LU_SAFTGenericSettings AS GenSet ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS _ContactFirstName ON CompanyCode = _ContactFirstName.CompanyCode AND _ContactFirstName.CompanyCodeParameterType = 'FNAME'  -- association [1..1]
LEFT OUTER JOIN I_AddlCompanyCodeInformation AS _ContactLastName ON CompanyCode = _ContactLastName.CompanyCode AND _ContactLastName.CompanyCodeParameterType = 'LNAME'  -- association [1..1]
;