I_GrantorProgramAttributes

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_GrantorProgramAttributes.
-- 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_GrantorProgramAttributes AS
SELECT
  cast(guid as crmt_gpm_program_guid preserving type) AS GrantorProgramUUID,
  prog_type AS GrantorProgramType,
  cast(vktyp as vktyp_gfn_kk preserving type ) AS ContractAccountCategory,
  auth_group AS GrntoProgramAuthorizationGroup,
  serv_org AS ServiceOrganization,
  sales_area AS GrantorSalesArea,
  cast(left(sales_area, 14) as crmt_sales_org preserving type ) AS SalesOrganizationOrgUnitID,
  time_zone AS TimeZoneID,
  currency AS GrantorProgramCurrency,
  profile_id AS GrantorProgramProfile,
  cast(clearence as crms4_grm_clearing_strategy preserving type ) AS GrantorClearingStrategy,
  cast(transfer as crms4_grm_transfer_to_fm preserving type ) AS GrntoPgmTransferIsRequired,
  avc_prof_id AS GrntoAvailyControlProfile,
  sales_org_sd AS SalesOrganization,
  dis_channel AS DistributionChannel,
  Division
FROM crmd_gpm_att
;