FAC_VE_GRP_ASSGMT_PARAM

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 FAC_VE_GRP_ASSGMT_PARAM.
-- 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: FACVEGRPASSGMTPA

CREATE VIEW FAC_VE_GRP_ASSGMT_PARAM AS
SELECT
  grp_assgmet.assignment_id AS AssignmentId,
  grp_assgmet.rule_grp_uuid AS RuleGrpUuid,
  assgmt_pa.param_name AS ParamName,
  assgmt_pa.ve_option AS VeOption,
  assgmt_pa.param_lval AS ParamLval,
  assgmt_pa.param_hval AS ParamHval,
  assgmt_pa.value_sign AS ValueSign,
  grp_assgmet.assignment_order AS AssignmentOrder,
  grp_assgmet.createdby AS Createdby,
  grp_assgmet.createdat AS Createdat,
  grp_assgmet.changedby AS Changedby,
  grp_assgmet.changedat AS Changedat,
  grp_assgmet.job_periodic AS JobPeriodic,
  grp_assgmet.peirodicvalue AS Peirodicvalue,
  grp_assgmet.val_start_date AS ValStartDate,
  grp_assgmet.val_end_date AS ValEndDate
FROM vec_grp_assgmt AS grp_assgmet
LEFT OUTER JOIN vec_assgmt_param AS assgmt_pa ON /* join condition not captured in parsed metadata */
;