I_UtilsOutsrtgCheckGrpBillgChk

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_UtilsOutsrtgCheckGrpBillgChk.
-- 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: IEOUTSRTGCHKGBC

CREATE VIEW I_UtilsOutsrtgCheckGrpBillgChk AS
SELECT
  cast(te327.ausgrup as e_ausgrup_vdm preserving type) AS UtilsOutsrtgCheckGrpForBillg,
  te327.abrvorg AS UtilitiesBillingReason,
  te327.consecno AS UtilsBillgChkSequenceNumber,
  cast(te327.validation as e_validation_vdm preserving type) AS UtilitiesBillingCheck,
  cast(te327.value1 as e_valu_vdm preserving type) AS UtilsBillingCheckValue1,
  cast(te327.value2 as e_valu_vdm preserving type) AS UtilsBillingCheckValue2,
  cast(te327.value3 as e_valu_vdm preserving type) AS UtilsBillingCheckValue3,
  cast(te327.value4 as e_valu_vdm preserving type) AS UtilsBillingCheckValue4,
  cast(te327.value5 as e_valu5_vdm preserving type) AS UtilsBillingCheckText
FROM te327
LEFT OUTER JOIN I_UtilsOutsrtgChkGrpBillg AS _UtilsOutsrtgChkGrpBillg ON UtilsOutsrtgCheckGrpForBillg = _UtilsOutsrtgChkGrpBillg.UtilsOutsrtgCheckGrpForBillg  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesBillingReason AS _UtilitiesBillingReason ON UtilitiesBillingReason = _UtilitiesBillingReason.UtilitiesBillingReason  -- association [0..1]
;