CRMS4V_PS_REQ_TYPE

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 CRMS4V_PS_REQ_TYPE.
-- 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: CRMS4VPSREQTYPE

CREATE VIEW CRMS4V_PS_REQ_TYPE AS
SELECT
  MAIN.req_type AS RequestCategory,
  TEXT.description AS Description,
  MAIN.process_type AS ProcessType,
  MAIN.active AS active,
  MAIN.textid AS TextType,
  MAIN.change_mode AS change_mode,
  MAIN.req_type_group AS RequestCategoryGroup,
  TEXT2.description AS RequestCategoryGroupDesc,
  MAIN.req_type_guid AS RequestCategoryGUID,
  MAIN.katalogart AS katalogart,
  MAIN.codegruppe AS CodeGroup,
  MAIN.code AS Code
FROM crmc_req_type AS MAIN
LEFT OUTER JOIN crmc_req_type_t AS TEXT ON MAIN.req_type = TEXT.req_type AND TEXT.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN crmc_reqt_grp_t AS TEXT2 ON MAIN.req_type_group = TEXT2.req_type_group AND TEXT2.language = $session.system_language  -- association [0..1]
;