SAP table MAHNS (Accounts blocked by dunning selection)

SAP table MAHNS has 5 primary key fields being MANDT,KOART,BUKRS,KONKO,MABER.

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
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BUKRS Company Code CHAR 4 0 T001 BUKRS
KONKO Open Item Account Number CHAR 10 0 KONKO
MABER Dunning Area CHAR 2 0 T047M MABER
LAUFD Date on Which the Program Is to Be Run DATS 8 0 LAUFD
LAUFI Additional Identification CHAR 6 0 LAUFI

MAHNS foreign key relationships

Table Field Check Table Check Field
0 MAHNS BUKRS T001 Company Codes BUKRS
1 MAHNS MABER T047M Dunning areas MANDT
1 MAHNS MABER T047M Dunning areas BUKRS
0 MAHNS MANDT T000 Clients MANDT