I_DUNNINGENTRY

CDS View
32 Fields 5 CDS Views

Dunning Entry

I_DUNNINGENTRY is a CDS View in S/4HANA. Dunning Entry. It contains 32 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_DunningEntry view from CONSUMPTION Dunning Entry
C_EmailDunningEntryData view_entity from CONSUMPTION Email Data For Dunning Entry
C_MyDunnProposals view_entity from CONSUMPTION My Dunning Proposals
I_DunningEntryForOutpDetn view_entity from COMPOSITE Determine Output Parameter for Dunning
P_DunningNoticeOMPrmDet view from CONSUMPTION Dunning Notice OM Param Determination

Fields (32)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY Customer Customer 1
KEY CustomerHeadOffice CustomerHeadOffice 2
KEY DunningClerk DunningClerk 2
KEY DunningRun DunningRun 2
KEY DunningRunDate DunningRunDate 2
KEY FinancialAccountType FinancialAccountType 2
KEY GroupingDunningArea GroupingDunningArea 2
KEY GroupingDunningLevel GroupingDunningLevel 1
KEY OneTimeAcctBankAccount OneTimeAcctBankAccount 2
KEY Supplier Supplier 2
_AccountingClerk _AccountingClerk 1
_CompanyCode _CompanyCode 1
_Customer _Customer 2
_DunningBlockingReason _DunningBlockingReason 1
_DunningCurrency _DunningCurrency 1
CityName CityName 1
Country Country 1
DocIncldUpToPostgDate DocIncldUpToPostgDate 1
DunAreaAcctBalanceDunCrcy DunAreaAcctBalanceDunCrcy 1
DunningBlockingReason DunningBlockingReason 1
DunningCurrency DunningCurrency 2
DunningDate DunningDate 1
DunningLevel DunningLevel 2
DunningNoticeIsToBeSent DunningNoticeIsToBeSent,PrintIsReal 2
DunningPrintDate DunningPrintDate 1
DunningRecipient DunningRecipient 1
LastDunningPrntDate LastDunningPrntDate 1
LegDunningProcedureOn LegDunningProcedureOn 1
POBox POBox 1
PostalCode PostalCode 1
StreetName StreetName 1

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.

-- Dunning Entry
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DUNNINGENTRY (
    COMPANYCODE,
    CUSTOMER,
    CUSTOMERHEADOFFICE,
    DUNNINGCLERK,
    DUNNINGRUN,
    DUNNINGRUNDATE,
    FINANCIALACCOUNTTYPE,
    GROUPINGDUNNINGAREA,
    GROUPINGDUNNINGLEVEL,
    ONETIMEACCTBANKACCOUNT,
    SUPPLIER,
    _ACCOUNTINGCLERK,
    _COMPANYCODE,
    _CUSTOMER,
    _DUNNINGBLOCKINGREASON,
    _DUNNINGCURRENCY,
    CITYNAME,
    COUNTRY,
    DOCINCLDUPTOPOSTGDATE,
    DUNAREAACCTBALANCEDUNCRCY,
    DUNNINGBLOCKINGREASON,
    DUNNINGCURRENCY,
    DUNNINGDATE,
    DUNNINGLEVEL,
    DUNNINGNOTICEISTOBESENT,
    DUNNINGPRINTDATE,
    DUNNINGRECIPIENT,
    LASTDUNNINGPRNTDATE,
    LEGDUNNINGPROCEDUREON,
    POBOX,
    POSTALCODE,
    STREETNAME,
    PRIMARY KEY (COMPANYCODE, CUSTOMER, CUSTOMERHEADOFFICE, DUNNINGCLERK, DUNNINGRUN, DUNNINGRUNDATE, FINANCIALACCOUNTTYPE, GROUPINGDUNNINGAREA, GROUPINGDUNNINGLEVEL, ONETIMEACCTBANKACCOUNT, SUPPLIER)
);

Learn More