C_CADunningException

DDL: C_CADUNNINGEXCEPTION SQL: CCADUNNINGEXC Type: view CONSUMPTION
47 Fields 1 Data Sources

Dunning Run Exceptions

C_CADunningException is a Consumption CDS View that provides data about "Dunning Run Exceptions" in SAP S/4HANA. It reads from 1 data source (I_CADunningException) and exposes 47 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADocumentNumber.

Data Sources (1)

SourceAliasJoin Type
I_CADunningException _CADunningException from

Parameters (4)

NameTypeDefault
P_Currency waers_kk
P_CAInternalAppCode tileid_kk
P_Language sylangu
P_Date sydatum

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCADUNNINGEXC view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Dunning Run Exceptions view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate I_CADunningException CAMassRunDate Date ID
KEY CAMassRunID I_CADunningException CAMassRunID Run ID
KEY BusinessPartner I_CADunningException BusinessPartner Issuing Authority
KEY ContractAccount I_CADunningException ContractAccount Contract Acct
KEY CADocumentNumber I_CADunningException CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADunningException CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADunningException CABPItemNumber Item
KEY CASubItemNumber I_CADunningException CASubItemNumber Subitem
BusinessPartnerName
PostalCode
FirstName
LastName
ContractAccountName _ContractAccount ContractAccountName Cont. acct name
CAContract I_CADunningException CAContract Contract
CASubApplication I_CADunningException CASubApplication Subapplication
CASubApplicationText
CompanyCode I_CADunningException CompanyCode Receiver Company Code
CompanyCodeName
CAIssueDate I_CADunningException CAIssueDate Dunning Date
CADunningExceptionReason I_CADunningException CADunningExceptionReason Payt Exception
CADunningExceptionReasonName
CADunningLockReason I_CADunningException CADunningLockReason DunnLockReason
CADunningLockReasonName
CAAmountInTransactionCurrency I_CADunningException CAAmountInTransactionCurrency Amount
TransactionCurrency I_CADunningException TransactionCurrency Transaction Currency
DisplayCurrency
CANetDueDate I_CADunningException CANetDueDate Net Due Date
Segment I_CADunningException Segment Segment number
Division I_CADunningException Division Internal Division ID
BusinessArea I_CADunningException BusinessArea Business Area
CAAccountDeterminationCode I_CADunningException CAAccountDeterminationCode Acct Determ. ID
CADocumentType I_CADunningException CADocumentType Document Type
CAMainTransaction I_CADunningException CAMainTransaction Main Trans.
CASubTransaction I_CADunningException CASubTransaction Subtransaction
ProfitCenter I_CADunningException ProfitCenter Profit Center
_CompCode I_CADunningException _CompCode
_Segment I_CADunningException _Segment
_Division I_CADunningException _Division
_BusinessArea I_CADunningException _BusinessArea
CreditAmountInDisplayCrcy
DebitAmountInDisplayCrcy
WorklistItemCreationDate
CAClrfctnStatus
CAClrfctnStatusName
CAAuthorizationGroup _ContractAccount CAAuthorizationGroup AuthorizGroup
CAProviderContractAuthznGroup _ProviderContract CAAuthorizationGroup AuthorizGroup
_CAPartner _CAPartner

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 C_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: CCADUNNINGEXC
-- Parameters: P_Currency : waers_kk, P_CAInternalAppCode : tileid_kk, P_Language : sylangu, P_Date : sydatum

CREATE VIEW C_CADunningException AS
SELECT
  _CADunningException.CAMassRunDate AS CAMassRunDate,
  _CADunningException.CAMassRunID AS CAMassRunID,
  _CADunningException.BusinessPartner AS BusinessPartner,
  _CADunningException.ContractAccount AS ContractAccount,
  _CADunningException.CADocumentNumber AS CADocumentNumber,
  _CADunningException.CARepetitionItemNumber AS CARepetitionItemNumber,
  _CADunningException.CABPItemNumber AS CABPItemNumber,
  _CADunningException.CASubItemNumber AS CASubItemNumber,
  _CADunningException._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CADunningException._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _CADunningException._BusinessPartner.FirstName AS FirstName,
  _CADunningException._BusinessPartner.LastName AS LastName,
  _ContractAccount.ContractAccountName AS ContractAccountName,
  _CADunningException.CAContract AS CAContract,
  _CADunningException.CASubApplication AS CASubApplication,
  _CASubApp._CASubApplicationText[1:Language = :P_Language].CASubApplicationText AS CASubApplicationText,
  _CADunningException.CompanyCode AS CompanyCode,
  _CADunningException._CompCode.CompanyCodeName AS CompanyCodeName,
  _CADunningException.CAIssueDate AS CAIssueDate,
  _CADunningException.CADunningExceptionReason AS CADunningExceptionReason,
  _CADunningException._DunExceptionReason._Text[1:Language = :P_Language].CADunningExceptionReasonName AS CADunningExceptionReasonName,
  _CADunningException.CADunningLockReason AS CADunningLockReason,
  _CADunningException._DunningLockRsn._Text[1:Language = :P_Language].CADunningLockReasonName AS CADunningLockReasonName,
  _CADunningException.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _CADunningException.TransactionCurrency AS TransactionCurrency,
  $parameters.P_Currency AS DisplayCurrency,
  _CADunningException.CANetDueDate AS CANetDueDate,
  _CADunningException.Segment AS Segment,
  _CADunningException.Division AS Division,
  _CADunningException.BusinessArea AS BusinessArea,
  _CADunningException.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  _CADunningException.CADocumentType AS CADocumentType,
  _CADunningException.CAMainTransaction AS CAMainTransaction,
  _CADunningException.CASubTransaction AS CASubTransaction,
  _CADunningException.ProfitCenter AS ProfitCenter,
  _CADunningException._CompCode AS _CompCode,
  _CADunningException._Segment AS _Segment,
  _CADunningException._Division AS _Division,
  _CADunningException._BusinessArea AS _BusinessArea,
  _DebitsCredits( P_DisplayCurrency : $parameters.P_Currency, P_ExchangeRateDate : $parameters.P_Date ).OpenPayablesAmountInDspCrcy AS CreditAmountInDisplayCrcy,
  _DebitsCredits( P_DisplayCurrency : $parameters.P_Currency, P_ExchangeRateDate : $parameters.P_Date ).OpenReceivablesAmountInDspCrcy AS DebitAmountInDisplayCrcy,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).WorklistItemCreationDate AS WorklistItemCreationDate,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).CAClrfctnStatus AS CAClrfctnStatus,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).CAClrfctnStatusName AS CAClrfctnStatusName,
  _ContractAccount.CAAuthorizationGroup AS CAAuthorizationGroup,
  _ProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup
FROM I_CADunningException AS _CADunningException
;

Learn More