C_PL_SAFTCompany

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_PL_SAFTCompany.
-- 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: CPLSAFTCOMPANY

CREATE VIEW C_PL_SAFTCompany AS
SELECT
  I_PL_SAFTGeneralSettings.CompanyCode AS CompanyCode,
  I_PL_SAFTGeneralSettings.ValidityEndDate AS ValidityEndDate,
  I_PL_SAFTGeneralSettings.ValidityStartDate AS ValidityStartDate,
  I_PL_SAFTGeneralSettings.EmailAddress AS EmailAddress,
  I_PL_SAFTGeneralSettings.PL_OfficialEntityRegistration AS PL_OfficialEntityRegistration,
  I_PL_SAFTGeneralSettings.PL_CompanyDistrictName AS PL_CompanyDistrictName,
  I_PL_SAFTGeneralSettings.PL_CompanySubDistrictName AS PL_CompanySubDistrictName,
  I_PL_SAFTGeneralSettings.PL_TaxOfficeCode AS PL_TaxOfficeCode,
  concat_with_space( concat_with_space( concat_with_space( I_CompanyCode._Address.BusinessPartnerName1, I_CompanyCode._Address.BusinessPartnerName2, 1), I_CompanyCode._Address.BusinessPartnerName3, 1), I_CompanyCode._Address.BusinessPartnerName4, 1) as CompanyName AS BusinessPartnerName41asCompanyName,
  I_CompanyCode._Address.CityName AS CityName,
  I_CompanyCode._Address.PostalCode AS PostalCode,
  I_CompanyCode._Address.StreetName AS StreetName,
  I_CompanyCode._Address.HouseNumber AS HouseNumber,
  I_CompanyCode._Address.HouseNumberSupplementText AS HouseNumberSupplementText,
  case when I_CompanyCode._Address.HomeCityName is initial then I_CompanyCode._Address.CityName else I_CompanyCode._Address.HomeCityName end as HomeCityName AS HomeCityNameendasHomeCityName,
  case when I_CompanyCode._Address.Region is initial then 'Nie dotyczy' else case when I_CompanyCode._Address._Region._RegionText[1: Language = 'L'].RegionName is not initial then I_CompanyCode._Address._Region._RegionText[1: Language = 'L'].RegionName when I_CompanyCode._Address._Region._RegionText[1: Language = 'L'].RegionName is initial then I_CompanyCode._Address._Region._RegionText[1: Language = $session.system_language].RegionName else I_CompanyCode._Address._Region._RegionText[1: Language = 'E'].RegionName end end as Region AS RegionNameendendasRegion,
  replace(I_CompanyCode.VATRegistration,I_CompanyCode.Country,'') AS CompanyVATRegistration,
  I_CompanyCode.Currency AS CompanyCodeCurrency
FROM I_CompanyCode
INNER JOIN I_PL_SAFTGeneralSettings ON /* join condition not captured in parsed metadata */
;