C_CADunningNotice

DDL: C_CADUNNINGNOTICE SQL: CCADUNNOTICE Type: view CONSUMPTION
102 Fields 1 Data Sources 3 Associations

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 102 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADunningCounter. It has 3 associations to related views.

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 )
[0..1] I_BPCurrentDefaultAddress _BPCurrentDefaultAddress $projection.BusinessPartner = _BPCurrentDefaultAddress.BusinessPartner

Annotations (11)

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
Search.searchable true view
EndUserText.label Dunning Notice view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (102)

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
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CAContractSemanticObject
BusinessPartnerFullName
ContractAccountName
HouseNumber1asHouseNumber Street / House Number
CityName1asHomeTown Postal Code / City
Country Country/Region
CountryName
CAIssueDate I_CADunningNotice CAIssueDate
CADunningProcedure I_CADunningNotice CADunningProcedure Dunning Proc.
CADunningProcedureName
CADunningLevel I_CADunningNotice CADunningLevel Dunning Level
CADunningLevelName
CADunningLevelCategory I_CADunningNotice CADunningLevelCategory Dunning Level Category
CADunningLevelCategoryName
CACollectionStrategy I_CADunningNotice CACollectionStrategy Coll. Strategy
CACollectionStrategyName
CACollectionStep I_CADunningNotice CACollectionStep
CACollectionStepName
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
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
CACompanyCodeGroup I_CADunningNotice CACompanyCodeGroup Company Code Gp
CACompanyCodeGroupName
CALeadingContractAccount I_CADunningNotice CALeadingContractAccount
LeadingContractAccountName
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
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
CAAuthorizationGroup I_CADunningNotice CAAuthorizationGroup AuthorizGroup
CAProviderContractAuthznGroup I_CADunningNotice CAProviderContractAuthznGroup AuthorizGroup
_CADunNoticeItem _CADunNoticeItem
_DunNoticeAct _DunNoticeAct
_DunReduction _DunReduction

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,
  CAContract,
  CASubApplication,
  cast('' as vtref_semobj_kk) AS CAContractSemanticObject,
  _CADunningNotice._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CADunningNotice._CAHeader.ContractAccountName AS ContractAccountName,
  concat_with_space( _BPCurrentDefaultAddress._AddressDefaultRepresentation.StreetName, _BPCurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber, 1) as HouseNumber AS HouseNumber1asHouseNumber,
  concat_with_space( _BPCurrentDefaultAddress._AddressDefaultRepresentation.PostalCode, _BPCurrentDefaultAddress._AddressDefaultRepresentation.CityName, 1) as HomeTown AS CityName1asHomeTown,
  _BPCurrentDefaultAddress._AddressDefaultRepresentation.Country AS Country,
  _BPCurrentDefaultAddress._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,
  _CADunningNotice._CACompanyCode.CADisputeCaseProcessingIsActv AS CADisputeCaseProcessingIsActv,
  _CADunningNotice.CAAuthorizationGroup AS CAAuthorizationGroup,
  _CADunningNotice.CAProviderContractAuthznGroup AS CAProviderContractAuthznGroup
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_BPCurrentDefaultAddress AS _BPCurrentDefaultAddress ON BusinessPartner = _BPCurrentDefaultAddress.BusinessPartner  -- association [0..1]
;

Learn More