Records Used for Transferring Dunning Data (SAP Library)

Records Used for Transferring Dunning Data

Definition

In order to send dunning items to a collection agency, the R/3 System creates three different records, containing:

Header data
Customer/vendor data
Open item data

Structure

Header (All Files)

Field	Description	Length	Type	Field name
1	Record type (01)	2	NUMC
2	Date	8	DATS	F150V-AUSDT
3		1	CHAR

Customer/Vendor Records

Field	Description	Length	Type	Field name
1	Record type (02)	2	NUMC
2	Customer ID at collection agency	48	CHAR	T001Z-PAVAL
3	Company code	4	CHAR	T001-BUKRS
4	Account type (K or D)	1	CHAR	MHND-KOART
5	Customer/vendor number	10	CHAR	MHND-KUNNR
6	Alternative dunning recipient	10	CHAR	KNB5-KNRMA
7	Customer/vendor name 1	35	CHAR	KNA1-NAME1
8	Customer/vendor name 2	35	CHAR	KNA1-NAME2
9	Customer/vendor name 3	35	CHAR	KNA1-NAME3
10	Customer/vendor name 4	35	CHAR	KNA1-NAME4
11	Customer/vendor house number and street	35	CHAR	KNA1-STRAS
12	Customer/vendor P.O. box	10	CHAR	KNA1-PFACH
13	Customer/vendor postal code	10	CHAR	KNA1-PSTLZ
14	Customer/vendor P.O. box postal code	10	CHAR	KNA1-PSTL2
15	Customer/vendor city	35	CHAR	KNA1-ORT01
16	Customer/vendor ISO country key	3	CHAR	KNA1-LAND1
17	Customer/vendor VAT registration number	20	CHAR	KNA1-STCEG
18	Customer/vendor telephone number 1	16	CHAR	KNA1-TELF1
19	Customer/vendor telephone number 2	16	CHAR	KNA1-TELF2
20	Customer/vendor fax number	31	CHAR	KNA1-TELFX

Open Items

Field	Description	Length	Type	Field name
1	Record type (03)	2	NUMC
2	Item type In files sent to collection agency, this field is left blank. In files sent back by the collection agency: I: interest C: charges	1	CHAR
3	Document number	10	CHAR	BSEG-BELNR
4	Posting date	8	NUMC	BSEG-BUDAT
5	Reference document number at collection agency (left blank in files sent to the collection agency)	12	CHAR	BSEG-XREF1
6	Payment reference number	30	CHAR	BSEG-KIDNO
7	Line item number	3	NUMC	BSEG-BUZEI
8	Fiscal year	4	NUMC	BSEG-GJAHR
9	Baseline date for calculating due date	8	NUMC	BSEG-ZFBDT
10	Due date	8	NUMC	MHND-FAEDT
11	Local currency key	5	CHAR	T001-WAERS
12	Amount in local currency	13	NUMC
13	Debit/credit indicator: S: debit H: credit	1	CHAR	MHND-SHKZG
14	Foreign currency key	5	CHAR	MHND-WAERS
15	Amount in foreign currency	13	NUMC

The system stores the amounts in a numerical character field (that is, without any decimal points). The number of the decimal places depends on which currency fields are used.

In step 1, all the fields are filled out for all customers except for one-time customers.

In step 2, the following fields must be filled out:

Record	Fields
Header	All
Customer/vendor	1, 5, 6
Line item	1, 2, 6, 11–15

In step 3, all the fields are filled out for all customers other than one-time customers. If an alternative dunning recipient has been specified, fields 7–20 in the customer/vendor record are left blank.

See also:

Dunning Using Collection Agencies

Configuring Dunning Using Collection Agencies