I_CADunningItem

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_CADunningItem.
-- 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: ICADUNITEM

CREATE VIEW I_CADunningItem AS
SELECT
  laufd AS CAMassRunDate,
  cast(laufi as laufi_kk preserving type ) AS CAMassRunID,
  cast(gpart as bu_partner preserving type ) AS BusinessPartner,
  cast(vkont as vkont_gfn_kk preserving type ) AS ContractAccount,
  mazae AS CADunningCounter,
  opbel AS CADocumentNumber,
  opupw AS CARepetitionItemNumber,
  opupk AS CABPItemNumber,
  opupz AS CASubItemNumber,
  bukrs AS CompanyCode,
  vtref AS CAContract,
  subap AS CASubApplication,
  cast(cast(segment as abap.char(10)) as fb_segment preserving type ) AS Segment,
  cast(cast(prctr as abap.char(10)) as fis_prctr preserving type ) AS ProfitCenter,
  cast(cast(spart as abap.char(2)) as spart preserving type ) AS Division,
  cast(waers as fis_rwcur preserving type) AS TransactionCurrency,
  mbetm AS CADunningAmount,
  mintm AS CADunningInterestAmount,
  mibel AS CADocumentForDunningInterest,
  faedn AS CANetDueDate,
  mdrkd AS CADunningActivityRunDate,
  ausdt AS CAIssueDate,
  mahns AS CADunningLevel,
  mstyp AS CADunningLevelCategory,
  mahnn AS CANextDunningLevel,
  xmfak AS CADunningLevelIsOptional,
  xmsus AS CADunningLevelIsOnlyForIntRsn,
  xmsto AS CADunningNoticeIsReversed,
  cast(xinfo as xinfg_kk preserving type) AS CADunningNoticeIsInfoOnly,
  xmvkt AS ContractAccountIsNotUnique,
  mahnv AS CADunningProcedure,
  higherdl AS CAItemHasHigherDunningLevel,
  dalin AS CAItemIsCreatedByDunActyRun,
  _CompCode.ControllingArea AS ControllingArea,
  mbeth AS CADunningAmountInLocalCurrency
FROM fkkmaze
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CADocumentBPItemLogical AS _DocBPItem ON CADocumentNumber = _DocBPItem.CADocumentNumber AND CARepetitionItemNumber = _DocBPItem.CARepetitionItemNumber AND CABPItemNumber = _DocBPItem.CABPItemNumber AND CASubItemNumber = _DocBPItem.CASubItemNumber  -- association [1..1]
LEFT OUTER JOIN I_CADunningHeader AS _DunHeader ON ( CAMassRunDate = _DunHeader.CAMassRunDate AND CAMassRunID = _DunHeader.CAMassRunID AND BusinessPartner = _DunHeader.BusinessPartner AND ContractAccount = _DunHeader.ContractAccount AND CADunningCounter = _DunHeader.CADunningCounter ) OR ( CAMassRunDate = _DunHeader.CAMassRunDate AND CAMassRunID = _DunHeader.CAMassRunID AND BusinessPartner = _DunHeader.BusinessPartner AND CADunningCounter = _DunHeader.CADunningCounter AND ContractAccountIsNotUnique = 'X' )  -- association [1..1]
LEFT OUTER JOIN I_CADunningLevel AS _DunningLevel ON CADunningProcedure = _DunningLevel.CADunningProcedure AND CADunningLevel = _DunningLevel.CADunningLevel  -- association [0..1]
LEFT OUTER JOIN I_CADunningLevel AS _NextDunningLevel ON CADunningProcedure = _NextDunningLevel.CADunningProcedure AND CANextDunningLevel = _NextDunningLevel.CADunningLevel  -- association [0..1]
LEFT OUTER JOIN I_CADunningLevelCategory AS _DunningLevelCat ON CADunningLevelCategory = _DunningLevelCat.CADunningLevelCategory  -- association [0..1]
LEFT OUTER JOIN I_CADunningProcedure AS _DunningProcedure ON CADunningProcedure = _DunningProcedure.CADunningProcedure  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _DocInterest ON CADocumentForDunningInterest = _DocInterest.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _CAHeader ON ContractAccount = _CAHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON controllingarea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND controllingarea = _ProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_CAStatisticalItemCode AS _CAStatisticalItemCode ON CAStatisticalItemCode = _CAStatisticalItemCode.CAStatisticalItemCode  -- association [0..1]
;