I_PL_SAFTGeneralSettings

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_PL_SAFTGeneralSettings.
-- 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.

CREATE VIEW I_PL_SAFTGeneralSettings AS
SELECT
  bukrs AS CompanyCode,
  endda AS ValidityEndDate,
  begda AS ValidityStartDate,
  main_alt_acct AS PL_SAFTAccountSelectCriterion,
  fi_view AS PL_SAFTAccountingViewType,
  cast(file_email as abap.char(241)) AS EmailAddress,
  regon AS PL_OfficialEntityRegistration,
  district AS PL_CompanyDistrictName,
  sub_district AS PL_CompanySubDistrictName,
  tax_office AS PL_TaxOfficeCode,
  cast(business_type as abap.char(30)) AS BusinessType,
  cit AS PL_EstonianCITIsUsedForSAFT,
  cast(case when cit = 'X' then '1' else ' ' end as abap.char(1)) as PL_EstonianCITText AS char1asPL_EstonianCITText,
  ifrs AS PL_IFRSForSAFTIsUsed,
  cast (case when ifrs = 'X' then '1' else ' ' end as abap.char(1)) as PL_IFRSText AS char1asPL_IFRSText
FROM snc_pl_bc
;