I_CADunningException

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_CADunningException.
-- 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: ICADUNEXCPTN

CREATE VIEW I_CADunningException 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,
  opbel AS CADocumentNumber,
  opupw AS CARepetitionItemNumber,
  opupk AS CABPItemNumber,
  opupz AS CASubItemNumber,
  bukrs AS CompanyCode,
  vtref AS CAContract,
  subap AS CASubApplication,
  cast(cast(gsber as abap.char(4)) as fis_rbusa) AS BusinessArea,
  cast(cast(segment as abap.char(10)) as fb_segment) AS Segment,
  cast(cast(prctr as abap.char(10)) as fis_prctr) AS ProfitCenter,
  cast(cast(spart as abap.char(2)) as spart) AS Division,
  cast(waers as fis_rwcur) AS TransactionCurrency,
  betrw AS CAAmountInTransactionCurrency,
  faedn AS CANetDueDate,
  ausdt AS CAIssueDate,
  applk AS CAApplicationArea,
  hvorg AS CAMainTransaction,
  tvorg AS CASubTransaction,
  kofiz AS CAAccountDeterminationCode,
  blart AS CADocumentType,
  mansp AS CADunningLockReason,
  poken AS CADunningExceptionReason,
  _CompCode.ControllingArea AS ControllingArea
FROM fkkmaex
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..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_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- 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_CAProviderContractHeader AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..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_ControllingArea AS _ControllingArea ON controllingarea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CAMainTransaction AS _MainTransaction ON CAApplicationArea = _MainTransaction.CAApplicationArea AND CAMainTransaction = _MainTransaction.CAMainTransaction  -- association [1..1]
LEFT OUTER JOIN I_CASubTransaction AS _SubTransaction ON CAApplicationArea = _SubTransaction.CAApplicationArea AND CAMainTransaction = _SubTransaction.CAMainTransaction AND CASubTransaction = _SubTransaction.CASubTransaction  -- association [1..1]
LEFT OUTER JOIN I_CADocumentType AS _DocType ON CADocumentType = _DocType.CADocumentType AND CAApplicationArea = _DocType.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CADunningLockReason AS _DunningLockRsn ON CADunningLockReason = _DunningLockRsn.CADunningLockReason  -- association [1..1]
LEFT OUTER JOIN I_CADunningExceptionReason AS _DunExceptionReason ON CADunningExceptionReason = _DunExceptionReason.CADunningExceptionReason  -- association [0..1]
LEFT OUTER JOIN I_CAApplicationArea AS _ApplArea ON CAApplicationArea = _ApplArea.CAApplicationArea  -- association [1..1]
;