C_CADunningNotice

DDL: C_CADUNNINGNOTICE SQL: CCADUNNOTICE Type: view CONSUMPTION Package: ODATA_O2C_FICA_DUNNOTICE_MAINT
109 Fields 1 Data Sources 3 Associations 2 OData Services

Dunning Notice

C_CADunningNotice is a Consumption CDS View that provides data about "Dunning Notice" in SAP S/4HANA. It reads from 1 data source (I_CADunningNotice) and exposes 109 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADunningCounter. It has 3 associations to related views. It is exposed through 2 OData services (ASQL_F8301, UI_CAACCOUNTBALANCE_DISPLAY). Part of development package ODATA_O2C_FICA_DUNNOTICE_MAINT.

Data Sources (1)

SourceAliasJoin Type
I_CADunningNotice _CADunningNotice from

Associations (3)

CardinalityTargetAliasCondition
[1..*] C_CADunningNoticeItem _CADunNoticeItem ( $projection.CAMassRunDate = _CADunNoticeItem.CAMassRunDate and $projection.CAMassRunID = _CADunNoticeItem.CAMassRunID and $projection.BusinessPartner = _CADunNoticeItem.BusinessPartner and $projection.ContractAccount = _CADunNoticeItem.ContractAccount and $projection.CADunningCounter = _CADunNoticeItem.CADunningCounter ) or ( $projection.CAMassRunDate = _CADunNoticeItem.CAMassRunDate and $projection.CAMassRunID = _CADunNoticeItem.CAMassRunID and $projection.BusinessPartner = _CADunNoticeItem.BusinessPartner and $projection.CADunningCounter = _CADunNoticeItem.CADunningCounter and _CADunNoticeItem.ContractAccountIsNotUnique = 'X' )
[0..*] C_CADunningNoticeDunReduction _DunReduction ( $projection.CAMassRunDate = _DunReduction.CAMassRunDate and $projection.CAMassRunID = _DunReduction.CAMassRunID and $projection.BusinessPartner = _DunReduction.BusinessPartner and $projection.ContractAccount = _DunReduction.ContractAccount and $projection.CADunningCounter = _DunReduction.CADunningCounter )
[1..1] I_CACompanyCode _CACompanyCode ( $projection.CAStandardCompanyCode = _CACompanyCode.CompanyCode )

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCADUNNOTICE view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.auditFilter #ENABLED view
Search.searchable true view
EndUserText.label Dunning Notice view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F8301 ASQL_F8301 C2 NOT_RELEASED
UI_CAACCOUNTBALANCE_DISPLAY UI_CAACCOUNTBALANCE_DISPLAY V4 C1 NOT_RELEASED

Fields (109)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate I_CADunningNotice CAMassRunDate Date ID
KEY CAMassRunID I_CADunningNotice CAMassRunID Run ID
KEY BusinessPartner I_CADunningNotice BusinessPartner Issuing Authority
KEY ContractAccount I_CADunningNotice ContractAccount Contract Acct
KEY CADunningCounter I_CADunningNotice CADunningCounter Dunning Counter
CADunningRunDateAndID Dunning Run
CAContract CAContract Contract
CAProviderContractName _ProviderContract CAProviderContractName Contract Text
CASubApplication CASubApplication Subapplication
CASubApplicationText Subapplication Text
CAContractSemanticObject
BusinessPartnerFullName Business Partner Text
ContractAccountName Contract Account Text
CityName1assecdep_home_town_kkasHomeTown Postal Code / City
Country Country/Region
CountryName
CAIssueDate I_CADunningNotice CAIssueDate
CADunningProcedure I_CADunningNotice CADunningProcedure Dunning Proc.
CADunningProcedureName Dunning Procedure Text
CADunningLevel I_CADunningNotice CADunningLevel Dunning Level
CADunningLevelName Dunning Level Text
CADunningLevelCategory I_CADunningNotice CADunningLevelCategory Dunning Level Category
CADunningLevelCategoryName Dunning Level Category Text
CACollectionStrategy I_CADunningNotice CACollectionStrategy Coll. Strategy
CACollectionStrategyName Collection Strategy Text
CACollectionStep I_CADunningNotice CACollectionStep
CACollectionStepName Collection Step Text
CACollectionStepType I_CADunningNotice CACollectionStepType Collection Step Type
CACollectionStepTypeName
CADunningNoticeIsReversed I_CADunningNotice CADunningNoticeIsReversed Reversed
CADunningBalance I_CADunningNotice CADunningBalance
CADunningReductionAmount I_CADunningNotice CADunningReductionAmount
TransactionCurrency I_CADunningNotice TransactionCurrency Transaction Currency
Division I_CADunningNotice Division Division
OrganizationDivisionText Division Text
CADunningActivityRunDate I_CADunningNotice CADunningActivityRunDate Execution Date
CAMassRunDateAndID Dunning Run
CADunningChargesSchema I_CADunningNotice CADunningChargesSchema
CAChargesSchemaName
CADunningChargeAmount I_CADunningNotice CADunningChargeAmount Total Amount of Charges
CADunningInterestAmount I_CADunningNotice CADunningInterestAmount Amount
CADocumentForDunningInterest I_CADunningNotice CADocumentForDunningInterest Document
CASuccessPercentage I_CADunningNotice CASuccessPercentage Success Rate
CAPercentageUnit
CADunningValuationRunDate I_CADunningNotice CADunningValuationRunDate Date of Success Valuation
CADunningValuationStatus I_CADunningNotice CADunningValuationStatus Status of Success Valuation
CADunningValuationStatusName
CASubstituteDocumentNumber I_CADunningNotice CASubstituteDocumentNumber Sub. Doc.
CASubstituteDocumentCategory I_CADunningNotice CASubstituteDocumentCategory Doc.Cat.
CASubstituteDocCategoryName
CAMaximumDeferralDate I_CADunningNotice CAMaximumDeferralDate
CompanyCodeName Company Code Text
CACompanyCodeGroup I_CADunningNotice CACompanyCodeGroup Company Code Gp
CACompanyCodeGroupName Company Code Group Text
CALeadingContractAccount I_CADunningNotice CALeadingContractAccount
LeadingContractAccountName Leading Account Text
CAAlternativeDunningRecipient I_CADunningNotice CAAlternativeDunningRecipient Alternative Dunning Recipient
CAAltvDunningRecipientName
CAContrAcctGroupForCollMgmt I_CADunningNotice CAContrAcctGroupForCollMgmt Contract Account Group
BusinessArea I_CADunningNotice BusinessArea Business Area
BusinessAreaName
CADunningNoticeGroup I_CADunningNotice CADunningNoticeGroup Grouping
CADunningNoticeGroupName Dunning Grouping Text
CAKeyDateForConsideredPayts I_CADunningNotice CAKeyDateForConsideredPayts Payments considered to
CAPaymentFormNumber I_CADunningNotice CAPaymentFormNumber Payment Form
CAPaymentFormExternalNumber I_CADunningNotice CAPaymentFormExternalNumber
CAPaymentTargetDate I_CADunningNotice CAPaymentTargetDate Payment Target
CADunningNoticeIsInfoOnly I_CADunningNotice CADunningNoticeIsInfoOnly Information Only
CAIsSubmittedToCollAgency I_CADunningNotice CAIsSubmittedToCollAgency Submitted to Collection Agency
CACreditWorthinessBeforeDun I_CADunningNotice CACreditWorthinessBeforeDun
CAReplacedCollectionStep I_CADunningNotice CAReplacedCollectionStep Replaced Collection Step
CAReplacedCollectionStepName
CACapForDunActyIsRestricted I_CADunningNotice CACapForDunActyIsRestricted Capacity Restricted
CADunningNoticeMustBeReleased I_CADunningNotice CADunningNoticeMustBeReleased
CALatestReleaseDate I_CADunningNotice CALatestReleaseDate
CAGroupingFieldForCollMgmt I_CADunningNotice CAGroupingFieldForCollMgmt
CACollectionStepOfLastDunning I_CADunningNotice CACollectionStepOfLastDunning
CACollStepOfLastDunningName
CAReplacedCollectionStrategy I_CADunningNotice CAReplacedCollectionStrategy
CAReplacedCollStrategyName
CACollectionTestSeries I_CADunningNotice CACollectionTestSeries
CANextDunningDate I_CADunningNotice CANextDunningDate
CAAmountForDunningCharge1 I_CADunningNotice CAAmountForDunningCharge1 Amount
CATypeForDunningCharge1 I_CADunningNotice CATypeForDunningCharge1 Type
CAChargeTypeName1
CADocumentForDunningCharge1 I_CADunningNotice CADocumentForDunningCharge1 Document
CAPostingCodeForDunningCharge1 I_CADunningNotice CAPostingCodeForDunningCharge1
CAAmountForDunningCharge2 I_CADunningNotice CAAmountForDunningCharge2 Amount
CATypeForDunningCharge2 I_CADunningNotice CATypeForDunningCharge2 Type
CAChargeTypeName2
CADocumentForDunningCharge2 I_CADunningNotice CADocumentForDunningCharge2 Document
CAPostingCodeForDunningCharge2 I_CADunningNotice CAPostingCodeForDunningCharge2
CAAmountForDunningCharge3 I_CADunningNotice CAAmountForDunningCharge3 Amount
CATypeForDunningCharge3 I_CADunningNotice CATypeForDunningCharge3 Type
CAChargeTypeName3
CADocumentForDunningCharge3 I_CADunningNotice CADocumentForDunningCharge3 Document
CAPostingCodeForDunningCharge3 I_CADunningNotice CAPostingCodeForDunningCharge3
CorrespondenceKey I_CADunningNotice CorrespondenceKey
CADisputeCaseProcessingIsActv _CACompanyCode CADisputeCaseProcessingIsActv
CAAuthorizationGroup
CAProviderContractAuthznGroup
ReverseIsHidden
_CADunNoticeItem _CADunNoticeItem
_DunNoticeAct _DunNoticeAct
_DunReduction _DunReduction
_BusinessPartner _BusinessPartner
_CAPartner _CAPartner
_ProviderContract _ProviderContract
_CASubApplication _CASubApplication

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_CADunningNotice.
-- 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: CCADUNNOTICE

CREATE VIEW C_CADunningNotice AS
SELECT
  _CADunningNotice.CAMassRunDate AS CAMassRunDate,
  _CADunningNotice.CAMassRunID AS CAMassRunID,
  _CADunningNotice.BusinessPartner AS BusinessPartner,
  _CADunningNotice.ContractAccount AS ContractAccount,
  _CADunningNotice.CADunningCounter AS CADunningCounter,
  cast(concat( cast(_CADunningNotice.CAMassRunDate as date), _CADunningNotice.CAMassRunID) as abap.char(20) ) AS CADunningRunDateAndID,
  CAContract,
  _ProviderContract.CAProviderContractName AS CAProviderContractName,
  CASubApplication,
  _CADunningNotice._CASubApplication._CASubApplicationText[1:Language=$session.system_language].CASubApplicationText AS CASubApplicationText,
  cast('' as vtref_semobj_kk) AS CAContractSemanticObject,
  _CADunningNotice._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CADunningNotice._CAHeader.ContractAccountName AS ContractAccountName,
  cast(concat_with_space(_BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode, _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName, 1) as secdep_home_town_kk) as HomeTown AS CityName1assecdep_home_town_kkasHomeTown,
  cast(_BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.Country as secdep_country_descrip_kk) AS Country,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._Country._Text[1:Language=$session.system_language].CountryName AS CountryName,
  _CADunningNotice.CAIssueDate AS CAIssueDate,
  _CADunningNotice.CADunningProcedure AS CADunningProcedure,
  _CADunningNotice._DunningProcedure._Text[1:Language = $session.system_language].CADunningProcedureName AS CADunningProcedureName,
  _CADunningNotice.CADunningLevel AS CADunningLevel,
  _CADunningNotice._DunningLevel._Text[1:Language = $session.system_language].CADunningLevelName AS CADunningLevelName,
  _CADunningNotice.CADunningLevelCategory AS CADunningLevelCategory,
  _CADunningNotice._DunningLevel._DunningLevelCat._Text[1:Language = $session.system_language].CADunningLevelCategoryName AS CADunningLevelCategoryName,
  _CADunningNotice.CACollectionStrategy AS CACollectionStrategy,
  _CADunningNotice._CollectionStrategy._Text[1:Language = $session.system_language].CACollectionStrategyName AS CACollectionStrategyName,
  _CADunningNotice.CACollectionStep AS CACollectionStep,
  _CADunningNotice._CollectionStep._Text[1:Language = $session.system_language].CACollectionStepName AS CACollectionStepName,
  _CADunningNotice.CACollectionStepType AS CACollectionStepType,
  _CADunningNotice._CollStepType._Text[1:Language = $session.system_language].CACollectionStepTypeName AS CACollectionStepTypeName,
  _CADunningNotice.CADunningNoticeIsReversed AS CADunningNoticeIsReversed,
  _CADunningNotice.CADunningBalance AS CADunningBalance,
  _CADunningNotice.CADunningReductionAmount AS CADunningReductionAmount,
  _CADunningNotice.TransactionCurrency AS TransactionCurrency,
  _CADunningNotice.Division AS Division,
  _CADunningNotice._Division._Text[1:Language = $session.system_language].DivisionName AS OrganizationDivisionText,
  _CADunningNotice.CADunningActivityRunDate AS CADunningActivityRunDate,
  concat_with_space( concat_with_space( cast(CAMassRunDate as date) , '/', 1), CAMassRunID, 1) AS CAMassRunDateAndID,
  _CADunningNotice.CADunningChargesSchema AS CADunningChargesSchema,
  _CADunningNotice._ChargesSchema._Text[1:Language = $session.system_language].CAChargesSchemaName AS CAChargesSchemaName,
  _CADunningNotice.CADunningChargeAmount AS CADunningChargeAmount,
  _CADunningNotice.CADunningInterestAmount AS CADunningInterestAmount,
  _CADunningNotice.CADocumentForDunningInterest AS CADocumentForDunningInterest,
  _CADunningNotice.CASuccessPercentage AS CASuccessPercentage,
  cast('%' as unit) AS CAPercentageUnit,
  _CADunningNotice.CADunningValuationRunDate AS CADunningValuationRunDate,
  _CADunningNotice.CADunningValuationStatus AS CADunningValuationStatus,
  _CADunningNotice._DunValStatus._Text[1:Language = $session.system_language].CADunningValuationStatusName AS CADunningValuationStatusName,
  _CADunningNotice.CASubstituteDocumentNumber AS CASubstituteDocumentNumber,
  _CADunningNotice.CASubstituteDocumentCategory AS CASubstituteDocumentCategory,
  _CADunningNotice._CASubstituteDocCategory._Text[1:Language = $session.system_language].CASubstituteDocCategoryName AS CASubstituteDocCategoryName,
  _CADunningNotice.CAMaximumDeferralDate AS CAMaximumDeferralDate,
  _CADunningNotice._CompCode.CompanyCodeName AS CompanyCodeName,
  _CADunningNotice.CACompanyCodeGroup AS CACompanyCodeGroup,
  _CADunningNotice._CompCodeGroup._Text[1:Language = $session.system_language].CACompanyCodeGroupName AS CACompanyCodeGroupName,
  _CADunningNotice.CALeadingContractAccount AS CALeadingContractAccount,
  _CADunningNotice._CAHeaderLeading.ContractAccountName AS LeadingContractAccountName,
  _CADunningNotice.CAAlternativeDunningRecipient AS CAAlternativeDunningRecipient,
  _CADunningNotice._BPAltvDunRcpnt.BusinessPartnerFullName AS CAAltvDunningRecipientName,
  _CADunningNotice.CAContrAcctGroupForCollMgmt AS CAContrAcctGroupForCollMgmt,
  _CADunningNotice.BusinessArea AS BusinessArea,
  _CADunningNotice._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  _CADunningNotice.CADunningNoticeGroup AS CADunningNoticeGroup,
  _CADunningNotice._DunNoticeGroup._Text[1:Language = $session.system_language].CADunningNoticeGroupName AS CADunningNoticeGroupName,
  _CADunningNotice.CAKeyDateForConsideredPayts AS CAKeyDateForConsideredPayts,
  _CADunningNotice.CAPaymentFormNumber AS CAPaymentFormNumber,
  _CADunningNotice.CAPaymentFormExternalNumber AS CAPaymentFormExternalNumber,
  _CADunningNotice.CAPaymentTargetDate AS CAPaymentTargetDate,
  _CADunningNotice.CADunningNoticeIsInfoOnly AS CADunningNoticeIsInfoOnly,
  _CADunningNotice.CAIsSubmittedToCollAgency AS CAIsSubmittedToCollAgency,
  _CADunningNotice.CACreditWorthinessBeforeDun AS CACreditWorthinessBeforeDun,
  _CADunningNotice.CAReplacedCollectionStep AS CAReplacedCollectionStep,
  _CADunningNotice._CollStepReplaced._Text[1:Language = $session.system_language].CACollectionStepName AS CAReplacedCollectionStepName,
  _CADunningNotice.CACapForDunActyIsRestricted AS CACapForDunActyIsRestricted,
  _CADunningNotice.CADunningNoticeMustBeReleased AS CADunningNoticeMustBeReleased,
  _CADunningNotice.CALatestReleaseDate AS CALatestReleaseDate,
  _CADunningNotice.CAGroupingFieldForCollMgmt AS CAGroupingFieldForCollMgmt,
  _CADunningNotice.CACollectionStepOfLastDunning AS CACollectionStepOfLastDunning,
  _CADunningNotice._CollStepLast._Text[1:Language = $session.system_language].CACollectionStepName AS CACollStepOfLastDunningName,
  _CADunningNotice.CAReplacedCollectionStrategy AS CAReplacedCollectionStrategy,
  _CADunningNotice._CollStrategyReplaced._Text[1:Language = $session.system_language].CACollectionStrategyName AS CAReplacedCollStrategyName,
  _CADunningNotice.CACollectionTestSeries AS CACollectionTestSeries,
  _CADunningNotice.CANextDunningDate AS CANextDunningDate,
  _CADunningNotice.CAAmountForDunningCharge1 AS CAAmountForDunningCharge1,
  _CADunningNotice.CATypeForDunningCharge1 AS CATypeForDunningCharge1,
  _CADunningNotice._ChargeType1._Text[1:Language = $session.system_language].CAChargeTypeName AS CAChargeTypeName1,
  _CADunningNotice.CADocumentForDunningCharge1 AS CADocumentForDunningCharge1,
  _CADunningNotice.CAPostingCodeForDunningCharge1 AS CAPostingCodeForDunningCharge1,
  _CADunningNotice.CAAmountForDunningCharge2 AS CAAmountForDunningCharge2,
  _CADunningNotice.CATypeForDunningCharge2 AS CATypeForDunningCharge2,
  _CADunningNotice._ChargeType2._Text[1:Language = $session.system_language].CAChargeTypeName AS CAChargeTypeName2,
  _CADunningNotice.CADocumentForDunningCharge2 AS CADocumentForDunningCharge2,
  _CADunningNotice.CAPostingCodeForDunningCharge2 AS CAPostingCodeForDunningCharge2,
  _CADunningNotice.CAAmountForDunningCharge3 AS CAAmountForDunningCharge3,
  _CADunningNotice.CATypeForDunningCharge3 AS CATypeForDunningCharge3,
  _CADunningNotice._ChargeType3._Text[1:Language = $session.system_language].CAChargeTypeName AS CAChargeTypeName3,
  _CADunningNotice.CADocumentForDunningCharge3 AS CADocumentForDunningCharge3,
  _CADunningNotice.CAPostingCodeForDunningCharge3 AS CAPostingCodeForDunningCharge3,
  _CADunningNotice.CorrespondenceKey AS CorrespondenceKey,
  _CACompanyCode.CADisputeCaseProcessingIsActv AS CADisputeCaseProcessingIsActv,
  _CADunningNotice._CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  _CADunningNotice._ProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup,
  cast('' as fkk_boole_d ) AS ReverseIsHidden
FROM I_CADunningNotice AS _CADunningNotice
LEFT OUTER JOIN C_CADunningNoticeItem AS _CADunNoticeItem ON ( CAMassRunDate = _CADunNoticeItem.CAMassRunDate AND CAMassRunID = _CADunNoticeItem.CAMassRunID AND BusinessPartner = _CADunNoticeItem.BusinessPartner AND ContractAccount = _CADunNoticeItem.ContractAccount AND CADunningCounter = _CADunNoticeItem.CADunningCounter ) OR ( CAMassRunDate = _CADunNoticeItem.CAMassRunDate AND CAMassRunID = _CADunNoticeItem.CAMassRunID AND BusinessPartner = _CADunNoticeItem.BusinessPartner AND CADunningCounter = _CADunNoticeItem.CADunningCounter AND _CADunNoticeItem.ContractAccountIsNotUnique = 'X' )  -- association [1..*]
LEFT OUTER JOIN C_CADunningNoticeDunReduction AS _DunReduction ON ( CAMassRunDate = _DunReduction.CAMassRunDate AND CAMassRunID = _DunReduction.CAMassRunID AND BusinessPartner = _DunReduction.BusinessPartner AND ContractAccount = _DunReduction.ContractAccount AND CADunningCounter = _DunReduction.CADunningCounter )  -- association [0..*]
LEFT OUTER JOIN I_CACompanyCode AS _CACompanyCode ON ( CAStandardCompanyCode = _CACompanyCode.CompanyCode )  -- association [1..1]
;

Learn More