SAP table T047A (Account Level Dunning Control)

SAP table T047A has 2 primary key fields being MANDT,MAHNA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MAHNA Dunning Procedure CHAR 4 0 MAHNA
RHYTH Dunning Interval in Days NUMC 3 0 RHYTH_047A
MIVRZ Days in Arrears After Which a Dunning Notice Will Be Sent DEC 5 0 MIVRZ_N_047A
KULEP Grace Periods per Line Item DEC 5 0 KULEP_N_047A
UMSKD List of Special G/L Indicators to Be Edited CHAR 20 0 UMSKL_047A
UMSKK List of Special G/L Indicators to Be Edited CHAR 20 0 UMSKL_047A
XNUMS Include Standard Transactions? CHAR 1 0 XNUMS_047A
VZSKZ Interest calculation indicator for calc. of dunning interest CHAR 2 0 T056 VZSKZ_047A
MAHNR Reference Dunning Procedure for Text Selection CHAR 4 0 T047A MAHNA_REF
MAHNS Dunning level from which all due items are to be totaled NUMC 1 0 MAHNS_047A
KALID Public holiday calendar key CHAR 2 0 THOCI HIDENT_47A
XMGER Always Print Dunning Notice in Legal Dunning Procedure? CHAR 1 0 XMGER_047A
XSALSH Dunning Notice Even for Credit Account Balance CHAR 1 0 XSALSH_047A
XIGNVZ Indicator: Ignore Interest Indicator in Master Record CHAR 1 0 XIGNVZ_047A

T047A foreign key relationships

Table Field Check Table Check Field
0 T047A MAHNR T047A Account Level Dunning Control MANDT
1 T047A MANDT T000 Clients MANDT
0 T047A VZSKZ T056 Interest Indicator MANDT
0 T047A VZSKZ T056 Interest Indicator VZSKZ