I_CADUNNINGNOTICE

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);