I_CADunningProcedure

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_CADunningProcedure.
-- 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.

CREATE VIEW I_CADunningProcedure AS
SELECT
  mahnv AS CADunningProcedure,
  cast(mvtyp as mvtyp_gfn_kk preserving type) AS CADunningProcedureCategory,
  cast(altmv as altmv_gfn_kk preserving type) AS CAAltvDunProcedForInstallments,
  cast(altmv2 as altmv2_gfn_kk preserving type) AS CAAltvDunProcedForReturns,
  vlmst AS CAProcessControlAtLastDunLevel,
  xmfac AS CAFactoryCalendarIsUsedForDun,
  cast(mfcid as fabkl preserving type) AS FactoryCalendar,
  not_lower_dl AS CADunningLevelMustNotBeReduced,
  vbgut AS CAProcessControlForCredits
FROM tfk047a
LEFT OUTER JOIN I_CADunningProcedureText AS _Text ON CADunningProcedure = _Text.CADunningProcedure  -- association [0..*]
LEFT OUTER JOIN I_CADunningProcedure AS _DunProcedInstallments ON CAAltvDunProcedForInstallments = _DunProcedInstallments.CADunningProcedure  -- association [0..1]
LEFT OUTER JOIN I_CADunningProcedure AS _DunProcedReturns ON CAAltvDunProcedForReturns = _DunProcedReturns.CADunningProcedure  -- association [0..1]
LEFT OUTER JOIN I_CADunningProcedureCategory AS _Category ON CADunningProcedureCategory = _Category.CADunningProcedureCategory  -- association [1..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
;