P_CADunningException

DDL: P_CADUNNINGEXCEPTION Type: view_entity COMPOSITE
46 Fields 1 Data Sources 2 Associations

Dunning Run Exceptions

P_CADunningException is a Composite CDS View that provides data about "Dunning Run Exceptions" in SAP S/4HANA. It reads from 1 data source (I_CADunningException) and exposes 46 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADocumentNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CADunningException I_CADunningException from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_CAFioApUsrDunExcRsnGrAs _DunExcRsnGrpAssgmt _DunExcRsnGrpAssgmt.CAFioriApplication = 'F2596A' and _DunExcRsnGrpAssgmt.CAFioriApplicationUser = $session.user and _DunExcRsnGrpAssgmt.CADunningExceptionReason = $projection.CADunningExceptionReason
[0..1] P_CASubApplicationContractType _ContractType $projection.CASubApplication = _ContractType.CASubApplication

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Dunning Run Exceptions view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate CAMassRunDate Date ID
KEY CAMassRunID CAMassRunID Run ID
KEY BusinessPartner BusinessPartner Issuing Authority
KEY ContractAccount ContractAccount Contract Acct
KEY CADocumentNumber CADocumentNumber Document Number
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item
KEY CABPItemNumber CABPItemNumber Item
KEY CASubItemNumber CASubItemNumber Subitem
CompanyCode CompanyCode Receiver Company Code
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
BusinessArea BusinessArea Business Area
Segment Segment Segment number
ProfitCenter ProfitCenter Profit Center
Division Division Internal Division ID
TransactionCurrency TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency Amount
CANetDueDate CANetDueDate Net Due Date
CAIssueDate CAIssueDate Dunning Date
CAApplicationArea CAApplicationArea ApplicationArea
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
CAAccountDeterminationCode CAAccountDeterminationCode Acct Determ. ID
CADocumentType CADocumentType Document Type
CADunningLockReason CADunningLockReason DunnLockReason
CADunningExceptionReason Payt Exception
ControllingArea ControllingArea Controlling Area
_ApplArea _ApplArea
_BusinessArea _BusinessArea
_BusinessPartner _BusinessPartner
_CAHeader _CAHeader
_CAPartner _CAPartner
_CompCode _CompCode
_ControllingArea _ControllingArea
_Currency _Currency
_Division _Division
_DocBPItem _DocBPItem
_DocType _DocType
_DunExceptionReason _DunExceptionReason
_DunningLockRsn _DunningLockRsn
_MainTransaction _MainTransaction
_ProfitCenter _ProfitCenter
_ProviderContract _ProviderContract
_Segment _Segment
_SubTransaction _SubTransaction
_DunExcRsnGrpAssgmt _DunExcRsnGrpAssgmt

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

CREATE VIEW P_CADunningException AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  BusinessPartner,
  ContractAccount,
  CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  CompanyCode,
  CAContract,
  CASubApplication,
  BusinessArea,
  Segment,
  ProfitCenter,
  Division,
  TransactionCurrency,
  cast( CAAmountInTransactionCurrency as betrw_aggr_kk) AS CAAmountInTransactionCurrency,
  CANetDueDate,
  CAIssueDate,
  CAApplicationArea,
  CAMainTransaction,
  CASubTransaction,
  CAAccountDeterminationCode,
  CADocumentType,
  CADunningLockReason,
  cast ( CADunningExceptionReason as poken_dun_ui_kk preserving type ) AS CADunningExceptionReason,
  ControllingArea
FROM I_CADunningException
LEFT OUTER JOIN I_CAFioApUsrDunExcRsnGrAs AS _DunExcRsnGrpAssgmt ON _DunExcRsnGrpAssgmt.CAFioriApplication = 'F2596A' AND _DunExcRsnGrpAssgmt.CAFioriApplicationUser = $session.user AND _DunExcRsnGrpAssgmt.CADunningExceptionReason = CADunningExceptionReason  -- association [0..*]
LEFT OUTER JOIN P_CASubApplicationContractType AS _ContractType ON CASubApplication = _ContractType.CASubApplication  -- association [0..1]
;

Learn More