I_IPUTSTestPlanMapping

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_IPUTSTestPlanMapping.
-- 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: IPUTSTPMAPPING

CREATE VIEW I_IPUTSTestPlanMapping AS
SELECT
  tpmapid AS IPUTSTestPlanGroupMappingUUID,
  tpgroup_id AS IPUTSTestPlanGroupUUID,
  _TestPlanGroup.IPUTSTestPlanGroupName AS IPUTSTestPlanGroupName,
  cloud_release AS IPUTSCloudRelease,
  appl_comp_group_id AS IPUTSApplicationCompGroupUUID,
  _AppCompGroup.IPUTSApplicationComponentGroup AS IPUTSApplicationComponentGroup,
  executionuser AS IPUTSSystemUser,
  executionuser_pwd AS IPUTSSystemUserPassword,
  exeuser_pwd_guid AS IPUTSSystemUserPasswordUUID,
  tpg_coverage_flag AS IPUTSHasCoverage
FROM iputs_a_tpmap AS IPUTSTPGMapping
LEFT OUTER JOIN I_IPUTSTestPlanGroup AS _TestPlanGroup ON IPUTSTestPlanGroupUUID = _TestPlanGroup.IPUTSTestPlanGroupUUID  -- association [1..1]
LEFT OUTER JOIN I_IPUTSApplComponentGroup AS _AppCompGroup ON IPUTSApplicationCompGroupUUID = _AppCompGroup.IPUTSApplicationCompGroupUUID  -- association [1..1]
;