I_CADUNNINGNOTICE
Contract Accounting Dunning Notice
I_CADUNNINGNOTICE is a CDS View in S/4HANA. Contract Accounting Dunning Notice. It contains 66 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CADunningNotice | view | from | CONSUMPTION | Dunning Notice |
| C_CADunningNoticeCollStrgy | view | from | CONSUMPTION | Dunning Notice Collection Strategy |
| C_CADunningNoticeDunProced | view | from | CONSUMPTION | Consumption View for Dunning Procedure |
| C_CADunningNoticeQuickView | view | from | CONSUMPTION | Quick View for Dunning Notice |
| N_CADunningNotice | view_entity | from | Contract Accounting Dunning Notice |
Fields (66)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BusinessPartner | BusinessPartner | 4 |
| KEY | CADunningCounter | CADunningCounter | 4 |
| KEY | CAMassRunDate | CAMassRunDate | 4 |
| KEY | CAMassRunID | CAMassRunID | 4 |
| KEY | ContractAccount | ContractAccount | 4 |
| BusinessArea | BusinessArea | 3 | |
| CAAlternativeDunningRecipient | CAAlternativeDunningRecipient | 3 | |
| CAAmountForDunningCharge1 | CAAmountForDunningCharge1 | 3 | |
| CAAmountForDunningCharge2 | CAAmountForDunningCharge2 | 3 | |
| CAAmountForDunningCharge3 | CAAmountForDunningCharge3 | 3 | |
| CACapForDunActyIsRestricted | CACapForDunActyIsRestricted | 3 | |
| CACollectionStep | CACollectionStep | 3 | |
| CACollectionStepOfLastDunning | CACollectionStepOfLastDunning | 3 | |
| CACollectionStepType | CACollectionStepType | 3 | |
| CACollectionStrategy | CACollectionStrategy | 3 | |
| CACollectionTestSeries | CACollectionTestSeries | 3 | |
| CACompanyCodeGroup | CACompanyCodeGroup | 3 | |
| CAContrAcctGroupForCollMgmt | CAContrAcctGroupForCollMgmt | 3 | |
| CAContrAcctGrpForCollMgmtName | CAContrAcctGrpForCollMgmtName | 1 | |
| CACreditWorthinessBeforeDun | CACreditWorthinessBeforeDun | 3 | |
| CADocumentForDunningCharge1 | CADocumentForDunningCharge1 | 3 | |
| CADocumentForDunningCharge2 | CADocumentForDunningCharge2 | 3 | |
| CADocumentForDunningCharge3 | CADocumentForDunningCharge3 | 3 | |
| CADocumentForDunningInterest | CADocumentForDunningInterest | 3 | |
| CADunningActivityRunDate | CADunningActivityRunDate | 3 | |
| CADunningBalance | CADunningBalance | 4 | |
| CADunningChargeAmount | CADunningChargeAmount | 3 | |
| CADunningChargesSchema | CADunningChargesSchema | 3 | |
| CADunningInterestAmount | CADunningInterestAmount | 3 | |
| CADunningLevel | CADunningLevel | 4 | |
| CADunningLevelCategory | CADunningLevelCategory | 3 | |
| CADunningNoticeGroup | CADunningNoticeGroup | 3 | |
| CADunningNoticeIsInfoOnly | CADunningNoticeIsInfoOnly | 3 | |
| CADunningNoticeIsReversed | CADunningNoticeIsReversed | 3 | |
| CADunningNoticeMustBeReleased | CADunningNoticeMustBeReleased | 3 | |
| CADunningProcedure | CADunningProcedure | 3 | |
| CADunningReductionAmount | CADunningReductionAmount | 3 | |
| CADunningValuationRunDate | CADunningValuationRunDate | 3 | |
| CADunningValuationStatus | CADunningValuationStatus | 3 | |
| CAGroupingFieldForCollMgmt | CAGroupingFieldForCollMgmt | 3 | |
| CAIsSubmittedToCollAgency | CAIsSubmittedToCollAgency | 3 | |
| CAIssueDate | CAIssueDate | 4 | |
| CAKeyDateForConsideredPayts | CAKeyDateForConsideredPayts | 3 | |
| CALatestReleaseDate | CALatestReleaseDate | 3 | |
| CALeadingContractAccount | CALeadingContractAccount | 3 | |
| CAMaximumDeferralDate | CAMaximumDeferralDate | 3 | |
| CANextDunningDate | CANextDunningDate | 3 | |
| CAPaymentFormExternalNumber | CAPaymentFormExternalNumber | 3 | |
| CAPaymentFormNumber | CAPaymentFormNumber | 3 | |
| CAPaymentTargetDate | CAPaymentTargetDate | 3 | |
| CAPostingCodeForDunningCharge1 | CAPostingCodeForDunningCharge1 | 3 | |
| CAPostingCodeForDunningCharge2 | CAPostingCodeForDunningCharge2 | 3 | |
| CAPostingCodeForDunningCharge3 | CAPostingCodeForDunningCharge3 | 3 | |
| CAReplacedCollectionStep | CAReplacedCollectionStep | 3 | |
| CAReplacedCollectionStrategy | CAReplacedCollectionStrategy | 3 | |
| CAStandardCompanyCode | CAStandardCompanyCode | 3 | |
| CAStatisticalItemCode | CAStatisticalItemCode | 3 | |
| CASubstituteDocumentCategory | CASubstituteDocumentCategory | 3 | |
| CASubstituteDocumentNumber | CASubstituteDocumentNumber | 3 | |
| CASuccessPercentage | CASuccessPercentage | 3 | |
| CATypeForDunningCharge1 | CATypeForDunningCharge1 | 3 | |
| CATypeForDunningCharge2 | CATypeForDunningCharge2 | 3 | |
| CATypeForDunningCharge3 | CATypeForDunningCharge3 | 3 | |
| CorrespondenceKey | CorrespondenceKey | 3 | |
| Division | Division | 2 | |
| TransactionCurrency | TransactionCurrency | 4 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Contract Accounting Dunning Notice
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CADUNNINGNOTICE (
BUSINESSPARTNER,
CADUNNINGCOUNTER,
CAMASSRUNDATE,
CAMASSRUNID,
CONTRACTACCOUNT,
BUSINESSAREA,
CAALTERNATIVEDUNNINGRECIPIENT,
CAAMOUNTFORDUNNINGCHARGE1,
CAAMOUNTFORDUNNINGCHARGE2,
CAAMOUNTFORDUNNINGCHARGE3,
CACAPFORDUNACTYISRESTRICTED,
CACOLLECTIONSTEP,
CACOLLECTIONSTEPOFLASTDUNNING,
CACOLLECTIONSTEPTYPE,
CACOLLECTIONSTRATEGY,
CACOLLECTIONTESTSERIES,
CACOMPANYCODEGROUP,
CACONTRACCTGROUPFORCOLLMGMT,
CACONTRACCTGRPFORCOLLMGMTNAME,
CACREDITWORTHINESSBEFOREDUN,
CADOCUMENTFORDUNNINGCHARGE1,
CADOCUMENTFORDUNNINGCHARGE2,
CADOCUMENTFORDUNNINGCHARGE3,
CADOCUMENTFORDUNNINGINTEREST,
CADUNNINGACTIVITYRUNDATE,
CADUNNINGBALANCE,
CADUNNINGCHARGEAMOUNT,
CADUNNINGCHARGESSCHEMA,
CADUNNINGINTERESTAMOUNT,
CADUNNINGLEVEL,
CADUNNINGLEVELCATEGORY,
CADUNNINGNOTICEGROUP,
CADUNNINGNOTICEISINFOONLY,
CADUNNINGNOTICEISREVERSED,
CADUNNINGNOTICEMUSTBERELEASED,
CADUNNINGPROCEDURE,
CADUNNINGREDUCTIONAMOUNT,
CADUNNINGVALUATIONRUNDATE,
CADUNNINGVALUATIONSTATUS,
CAGROUPINGFIELDFORCOLLMGMT,
CAISSUBMITTEDTOCOLLAGENCY,
CAISSUEDATE,
CAKEYDATEFORCONSIDEREDPAYTS,
CALATESTRELEASEDATE,
CALEADINGCONTRACTACCOUNT,
CAMAXIMUMDEFERRALDATE,
CANEXTDUNNINGDATE,
CAPAYMENTFORMEXTERNALNUMBER,
CAPAYMENTFORMNUMBER,
CAPAYMENTTARGETDATE,
CAPOSTINGCODEFORDUNNINGCHARGE1,
CAPOSTINGCODEFORDUNNINGCHARGE2,
CAPOSTINGCODEFORDUNNINGCHARGE3,
CAREPLACEDCOLLECTIONSTEP,
CAREPLACEDCOLLECTIONSTRATEGY,
CASTANDARDCOMPANYCODE,
CASTATISTICALITEMCODE,
CASUBSTITUTEDOCUMENTCATEGORY,
CASUBSTITUTEDOCUMENTNUMBER,
CASUCCESSPERCENTAGE,
CATYPEFORDUNNINGCHARGE1,
CATYPEFORDUNNINGCHARGE2,
CATYPEFORDUNNINGCHARGE3,
CORRESPONDENCEKEY,
DIVISION,
TRANSACTIONCURRENCY,
PRIMARY KEY (BUSINESSPARTNER, CADUNNINGCOUNTER, CAMASSRUNDATE, CAMASSRUNID, CONTRACTACCOUNT)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA