C_CADunningException_2

DDL: C_CADUNNINGEXCEPTION_2 Type: view_entity CONSUMPTION
59 Fields 1 Data Sources 3 Associations

Display Dunning Run Exeptions

C_CADunningException_2 is a Consumption CDS View that provides data about "Display Dunning Run Exeptions" in SAP S/4HANA. It reads from 1 data source (I_CADunningException) and exposes 59 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADocumentNumber. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CADunningException _CADunningException from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CAStatisticalItemCode _StatCode $projection.CAStatisticalItemCode = _StatCode.CAStatisticalItemCode
[0..*] I_CountryText _CountryText $projection.country = _CountryText.Country
[0..*] I_ProfitCenterText _ProfitCenterText $projection.ProfitCenter = _ProfitCenterText.ProfitCenter and $projection.ControllingArea = _ProfitCenterText.ControllingArea and $projection.CAIssueDate >= _ProfitCenterText.ValidityStartDate and $projection.CAIssueDate <= _ProfitCenterText.ValidityEndDate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Display Dunning Run Exeptions view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (59)

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
CAMassRunDateAndID Date ID
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName Broker Name
CANetDueDate CANetDueDate Net Due Date
CAIssueDate CAIssueDate Dunning Date
CADunningExceptionReason CADunningExceptionReason Payt Exception
CADunningExceptionReasonName
CompanyCode CompanyCode Receiver Company Code
CAContract CAContract Contract
CAProviderContractName _ProviderContract CAProviderContractName
CASubApplication CASubApplication Subapplication
CASubApplicationText
HouseNumber1asAddressLine1
CityName
PostalCode
CityName1asAddressLine2
Country
Segment Segment Segment number
ProfitCenter ProfitCenter Profit Center
Division Division Internal Division ID
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
CADocumentType CADocumentType Document Type
CADunningLockReason CADunningLockReason DunnLockReason
ControllingArea ControllingArea Controlling Area
BusinessArea BusinessArea Business Area
CAContractSemanticObject
_CAPartner _CAPartner
_ProviderContract _ProviderContract
_BusinessPartner _BusinessPartner
_CompCode _CompCode
_CAHeader _CAHeader
_SegmentText _Segment _Text
UICT_Segment _Segment Segment Segment number
_DivisionText _Division _Text
UICT_Division _Division Division Internal Division ID
_CADocumentTypeText _DocType _Text
UICT_CADocumentType _DocType CADocumentType Document Type
UICT_CAApplicationArea _DocType CAApplicationArea ApplicationArea
_MainTransactionText _MainTransaction _Text
UICT_CAApplArea _MainTransaction CAApplicationArea ApplicationArea
UICT_CAMainTransaction _MainTransaction CAMainTransaction Main Trans.
_SubtransactionText _SubTransaction _Text
UICT_ApplicationArea _SubTransaction CAApplicationArea ApplicationArea
UICT_CAMainTrans _SubTransaction CAMainTransaction Main Trans.
UICT_CASubTransaction _SubTransaction CASubTransaction Subtransaction
_DunningLockRsnText _DunningLockRsn _Text
UICT_CADunningLockReason _DunningLockRsn CADunningLockReason DunnLockReason
_CountryText _CountryText
_ProfitCenterText _ProfitCenterText
_BusinessAreaText _BusinessArea _Text
UICT_BusinessArea _BusinessArea BusinessArea Business Area

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_2.
-- 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 C_CADunningException_2 AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  BusinessPartner,
  ContractAccount,
  CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  cast(concat( cast(CAMassRunDate as date), CAMassRunID) as abap.char(20) ) AS CAMassRunDateAndID,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  CANetDueDate,
  CAIssueDate,
  CADunningExceptionReason,
  _DunExceptionReason._Text[1:Language = $session.system_language].CADunningExceptionReasonName AS CADunningExceptionReasonName,
  CompanyCode,
  CAContract,
  _ProviderContract.CAProviderContractName AS CAProviderContractName,
  CASubApplication,
  cast('' as subap_text_kk) AS CASubApplicationText,
  concat_with_space( _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName, _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber, 1) as AddressLine1 AS HouseNumber1asAddressLine1,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName AS CityName,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  concat_with_space( _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode, _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName, 1) as AddressLine2 AS CityName1asAddressLine2,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country AS Country,
  Segment,
  ProfitCenter,
  Division,
  CAMainTransaction,
  CASubTransaction,
  CADocumentType,
  CADunningLockReason,
  ControllingArea,
  BusinessArea,
  cast('' as vtref_semobj_kk ) AS CAContractSemanticObject,
  _Segment._Text AS _SegmentText,
  _Segment.Segment AS UICT_Segment,
  _Division._Text AS _DivisionText,
  _Division.Division AS UICT_Division,
  _DocType._Text AS _CADocumentTypeText,
  _DocType.CADocumentType AS UICT_CADocumentType,
  _DocType.CAApplicationArea AS UICT_CAApplicationArea,
  _MainTransaction._Text AS _MainTransactionText,
  _MainTransaction.CAApplicationArea AS UICT_CAApplArea,
  _MainTransaction.CAMainTransaction AS UICT_CAMainTransaction,
  _SubTransaction._Text AS _SubtransactionText,
  _SubTransaction.CAApplicationArea AS UICT_ApplicationArea,
  _SubTransaction.CAMainTransaction AS UICT_CAMainTrans,
  _SubTransaction.CASubTransaction AS UICT_CASubTransaction,
  _DunningLockRsn._Text AS _DunningLockRsnText,
  _DunningLockRsn.CADunningLockReason AS UICT_CADunningLockReason,
  _BusinessArea._Text AS _BusinessAreaText,
  _BusinessArea.BusinessArea AS UICT_BusinessArea
FROM I_CADunningException AS _CADunningException
LEFT OUTER JOIN I_CAStatisticalItemCode AS _StatCode ON CAStatisticalItemCode = _StatCode.CAStatisticalItemCode  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON country = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ProfitCenter = _ProfitCenterText.ProfitCenter AND ControllingArea = _ProfitCenterText.ControllingArea AND CAIssueDate >= _ProfitCenterText.ValidityStartDate AND CAIssueDate <= _ProfitCenterText.ValidityEndDate  -- association [0..*]
;

Learn More