UPOV_GET_ALLOCATION_BASIS

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 UPOV_GET_ALLOCATION_BASIS.
-- 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: UPOS_GET_ALBASIS

CREATE VIEW UPOV_GET_ALLOCATION_BASIS AS
SELECT
  upo_novd.tplnr AS tplnr,
  upo_novd.effective_to AS effective_to,
  case when nwrule.alloc_basis = '01' then 'V' when nwrule.alloc_basis = '02' then 'E' when nwrule.alloc_basis = '04' then 'D' else '' end as al_basis_cd AS alloc_basis04thenDelseendasal_basis_cd
INNER JOIN gho_nwrule_h AS nwrule ON /* join condition not captured in parsed metadata */
;