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,
  StartDate,
  EndDate,
  FiscalYear,
  cast(head._CompanyCode.VATRegistration as abap.char(20)) AS VATRegistration,
  case when head._CompanyCode._Address.BusinessPartnerName1 is not initial then concat_with_space (head._CompanyCode._Address.BusinessPartnerName1, head._CompanyCode._Address.BusinessPartnerName2, 1) else head._CompanyCode.CompanyCodeName end as CompanyName AS CompanyCodeNameendasCompanyName,
  head._CompanyCode._Address.StreetName AS StreetName,
  head._CompanyCode._Address.HouseNumber AS HouseNumber,
  case when head._CompanyCode.CityName is not initial then head._CompanyCode.CityName else head._CompanyCode._Address.CityName end as CityName AS CityNameendasCityName,
  head._CompanyCode._Address.PostalCode AS PostalCode,
  head._CompanyCode._Address.Country AS Country,
  vers.EmbeddedSwVersionStatusDesc AS EmbeddedSwVersionStatusDesc,
  head._CompanyCode._Address.AddressID AS AddressID,
  head._CompanyCode._Address.Person AS Person,
  _ContactFirstName.CompanyCodeParameterValue AS FirstName,
  _ContactLastName.CompanyCodeParameterValue AS LastName,
  head._CompanyCode._Address._DefaultPhoneNumber.PhoneNumber AS PhoneNumber,
  cast(head._CompanyCode._Address._DefaultFaxNumber.FaxNumber as abap.char(31)) AS FaxNumber,
  head._CompanyCode._Address._DefaultEmailAddress.EmailAddress AS EmailAddress,
  head._CompanyCode._Address._DefaultURLAddress.URLFieldLength AS URLFieldLength,
  lower(head._CompanyCode._Address._DefaultURLAddress.SearchURLAddress) 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]
;