I_CADUNNINGHISTORY

CDS View

Mahnhistorie

I_CADUNNINGHISTORY is a CDS View in S/4HANA. Mahnhistorie. It contains 12 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_CADunningNoticeCFO view from CONSUMPTION Mahnung
C_CADunningNoticeCollectionCFO view from CONSUMPTION Mahnungen aus Collection-Strategie
I_CALastDunningIssueDate view from COMPOSITE Ausstellungsdatum der letzten Mahnung
P_CACollectionvolume view from CONSUMPTION
P_CADunningVolume view from CONSUMPTION

Fields (12)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 2
KEY CADunningCounter CADunningCounter 2
KEY CAMassRunDate CAMassRunDate 2
KEY CAMassRunID CAMassRunID 2
KEY ContractAccount ContractAccount 2
CACollectionStep CACollectionStep 1
CACollectionStrategy CACollectionStrategy 1
CADunningBalance CADunningBalance 2
CADunningLevel OldDunningLevel 1
CADunningProcedure CADunningProcedure 1
CAIssueDate CAIssueDate 2
TransactionCurrency TransactionCurrency 2

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.

-- Mahnhistorie
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CADUNNINGHISTORY (
    BUSINESSPARTNER,
    CADUNNINGCOUNTER,
    CAMASSRUNDATE,
    CAMASSRUNID,
    CONTRACTACCOUNT,
    CACOLLECTIONSTEP,
    CACOLLECTIONSTRATEGY,
    CADUNNINGBALANCE,
    CADUNNINGLEVEL,
    CADUNNINGPROCEDURE,
    CAISSUEDATE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BUSINESSPARTNER, CADUNNINGCOUNTER, CAMASSRUNDATE, CAMASSRUNID, CONTRACTACCOUNT)
);