SAP table TFK047A (Dunning procedure)

SAP table TFK047A has 2 primary key fields being MANDT,MAHNV.

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
MAHNV Dunning Procedure CHAR 2 0 MAHNV_KK
MVTYP Dunning Procedure Category CHAR 2 0 TFK047J MVTYP_KK
ALTMV Alternative Dunning Procedure For Installments CHAR 2 0 TFK047A ALTMV_KK
ALTMV2 Alternative Dunning Procedure For Returns CHAR 2 0 TFK047A ALTMV2_KK
VLMST Behaviour at Last Dunning Level NUMC 1 0 VLMST_KK
0 No dunning, no output in log
1 No dunning, output in log
2 Dun after end of dunning frequency for all line items
3 Dunning for new overdue items only
4 Dunning only with new items-dunning frequency with new items
XDLOD Ignore Dunning Levels from Other Dunning Procedures CHAR 1 0 XDLOD_KK
XMFAC Days in arrears+dunning freq. by factory calendar CHAR 1 0 XMFAC_KK
MFCID Factory Calendar ID CHAR 2 0 TFACD MFCID_KK
NOT_LOWER_DL Do Not Reduce Dunning Levels CHAR 1 0 NOT_LOWER_DL_KK
VBGUT Behavior if Credit Exists NUMC 1 0 VBGUT_KK
0 Dun All Items, Ignore Credit for Dunning Balance
1 Dun All Items, Consider Credit for Dunning Balance
2 Do Not Dun if Credit Exists

TFK047A foreign key relationships

Table Field Check Table Check Field
0 TFK047A ALTMV TFK047A Dunning procedure MAHNV
1 TFK047A ALTMV2 TFK047A Dunning procedure MAHNV
0 TFK047A MVTYP TFK047J Dunning procedure types MANDT
0 TFK047A MVTYP TFK047J Dunning procedure types MVTYP