SAP Table RF03L
Credit Management Master Data
RF03L (Credit Management Master Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link RF03L to other SAP tables.
RF03L table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
KUNNR
Customer Number
|
KUNNR | KNA1 |
CHAR
|
10 | 0 | |||||||
|
KKBER
Credit control area
|
KKBER | T014 |
CHAR
|
4 | 0 | |||||||
|
KLIMK
Customer's credit limit
|
KLIMK |
CURR
|
15 | 2 | ||||||||
|
KNKLI
Customer's account number with credit limit reference
|
KNKLI | KNA1 |
CHAR
|
10 | 0 | |||||||
|
SAUFT
Total of the sales values for the credit limit check
|
SAUFT |
CURR
|
15 | 2 | ||||||||
|
SKFOR
Total receivables (for credit limit check)
|
SKFOR |
CURR
|
15 | 2 | ||||||||
|
SSOBL
Relevant special liabilities for credit limit check
|
SSOBL |
CURR
|
15 | 2 | ||||||||
|
UEDAT
Date on which the credit limit was exceeded
|
UEDAT |
DATS
|
8 | 0 | ||||||||
|
XCHNG
Indicator: credit limit must be recreated
|
XCHNG_KNKK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM_RF |
CHAR
|
12 | 0 | ||||||||
|
ERDAT
Date on which the Record Was Created
|
ERDAT_RF |
DATS
|
8 | 0 | ||||||||
|
CTLPC
Credit management: Risk category
|
CTLPC_CM | T691A |
CHAR
|
3 | 0 | |||||||
|
DTREV
Last internal review
|
DTREV_CM |
DATS
|
8 | 0 | ||||||||
|
CRBLB
Indicator: Blocked by credit management ?
|
CRBLB_CM |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
SBGRP
Credit representative group for credit management
|
SBGRP_CM | T024B |
CHAR
|
3 | 0 | |||||||
|
NXTRV
Next internal review
|
NXTRV_CM |
DATS
|
8 | 0 | ||||||||
|
KRAUS
Credit information number
|
KRAUS_CM |
CHAR
|
11 | 0 | ||||||||
|
PAYDB
do not use - replaced by DBPAY_CM
|
PAYDB_CM |
NUMC
|
2 | 0 | ||||||||
|
DBRAT
do not use - replaced by DBRTG_CM
|
DBRAT_CM |
CHAR
|
3 | 0 | ||||||||
|
REVDB
Last review (external)
|
REVDB_CM |
DATS
|
8 | 0 | ||||||||
|
AEDAT
Date of Last Change
|
AEDAT_CM |
DATS
|
8 | 0 | ||||||||
|
AETXT
Date of Last Text Change
|
AETXT_CM |
DATS
|
8 | 0 | ||||||||
|
GRUPP
Customer Credit Group
|
GRUPP_CM | T691B |
CHAR
|
4 | 0 | |||||||
|
AENAM
Last changed by
|
AENAM_CM |
CHAR
|
12 | 0 | ||||||||
|
SBDAT
Reference Date
|
SBDAT_CM |
DATS
|
8 | 0 | ||||||||
|
KDGRP
Customer Group
|
KDGRP_CM |
CHAR
|
8 | 0 | ||||||||
|
CASHD
Date of Last Payment
|
CASHD |
DATS
|
8 | 0 | ||||||||
|
CASHA
Amount of Last Payment
|
CASHA |
CURR
|
13 | 2 | ||||||||
|
CASHC
Currency of Last Payment
|
CASHC | TCURC |
CUKY
|
5 | 0 | |||||||
|
DBPAY
Payment Index
|
DBPAY_CM |
CHAR
|
3 | 0 | ||||||||
|
DBRTG
Rating
|
DBRTG_CM |
CHAR
|
5 | 0 | ||||||||
|
DBEKR
Recommended credit limit
|
DBEKR_CM |
CURR
|
15 | 2 | ||||||||
|
DBWAE
Currency of recommended credit limit
|
DBWAE_CM | TCURC |
CUKY
|
5 | 0 | |||||||
|
DBMON
Date Monitoring
|
DBMON_CM |
DATS
|
8 | 0 | ||||||||
|
ABSBT
Total Secured Receivables
|
ABSBT_SUM |
CURR
|
15 | 2 | ||||||||
|
WAERS_KKBER
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||
|
KLIMG
Credit limit: Total limit across all control areas
|
KLIMG |
CURR
|
15 | 2 | ||||||||
|
KLIME
Credit limit: Limit for individual control area
|
KLIME |
CURR
|
15 | 2 | ||||||||
|
WAERS_KNKA
Currency Key
|
WAERS_KNKA |
CUKY
|
5 | 0 | ||||||||
|
DLAUS
Date of the last general information
|
DLAUS |
DATS
|
8 | 0 | ||||||||
|
NAME1
Name 1
|
NAME1_GP |
CHAR
|
35 | 0 | ||||||||
|
NAME2
Name 2
|
NAME2_GP |
CHAR
|
35 | 0 | ||||||||
|
NAME3
Name 3
|
NAME3_GP |
CHAR
|
35 | 0 | ||||||||
|
NAME4
Name 4
|
NAME4_GP |
CHAR
|
35 | 0 | ||||||||
|
ORT01
City
|
ORT01_GP |
CHAR
|
35 | 0 | ||||||||
|
ORT02
District
|
ORT02_GP |
CHAR
|
35 | 0 | ||||||||
|
LAND1
Country Key
|
LAND1_GP |
CHAR
|
3 | 0 | ||||||||
|
CITYC
City Code
|
CITYC |
CHAR
|
4 | 0 | ||||||||
|
COUNC
County Code
|
COUNC |
CHAR
|
3 | 0 | ||||||||
|
PSTLZ
Postal Code
|
PSTLZ |
CHAR
|
10 | 0 | ||||||||
|
PFACH
PO Box
|
PFACH |
CHAR
|
10 | 0 | ||||||||
|
REGIO
Region (State, Province, County)
|
REGIO |
CHAR
|
3 | 0 | ||||||||
|
STRAS
House number and street
|
STRAS_GP |
CHAR
|
35 | 0 | ||||||||
|
TELF1
First telephone number
|
TELF1 |
CHAR
|
16 | 0 | ||||||||
|
TELF2
Second telephone number
|
TELF2 |
CHAR
|
16 | 0 | ||||||||
|
TELFX
Fax Number
|
TELFX |
CHAR
|
31 | 0 | ||||||||
|
TELTX
Teletex number
|
TELTX |
CHAR
|
30 | 0 | ||||||||
|
WAERS_FAEL
Currency Key
|
WAERS |
CUKY
|
5 | 0 | ||||||||
|
SFAE1
Total of Due Items
|
SFAE1_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAE2
Total of Due Items (Interval 2)
|
SFAE2_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAE3
Total of Due Items (Interval 3)
|
SFAE3_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAE4
Total of Due Items (Interval 4)
|
SFAE4_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAE5
Total of Due Items (Interval 5)
|
SFAE5_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAE6
Total of Due Items (Interval 6)
|
SFAE6_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA1
Total of Items not Due 1
|
SNFA1_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA2
Total of Items not Due 2
|
SNFA2_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA3
Total of Items not Due 3
|
SNFA3_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA4
Total of Items not Due 4
|
SNFA4_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA5
Total of Items not Due 5
|
SNFA5_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFA6
Total of Items not Due 6
|
SNFA6_F035 |
CURR
|
15 | 2 | ||||||||
|
SFAEL
Total of Due Items
|
SFAES_F035 |
CURR
|
15 | 2 | ||||||||
|
SNFAE
Total of Items not Due
|
SNFAS_F035 |
CURR
|
15 | 2 | ||||||||
|
SUMOP
Total of Due Items with More Than n Days in Arrears
|
SUMOP_F035 |
CURR
|
15 | 2 | ||||||||
|
OBLIG
Credit exposure (for credit limit check)
|
OBLIG_F02L |
CURR
|
15 | 2 | ||||||||
|
OBLIG_NA
Unhedged Total Liabilities
|
OBLIG_F02L_NA |
CURR
|
15 | 2 | ||||||||
|
DELTA
Over budget amount in credit management
|
DELTA_F02L |
CURR
|
15 | 2 | ||||||||
|
DSO1
DSO Code
|
DSO1_F03L |
NUMC
|
4 | 0 | ||||||||
|
DSO2
DSO Code
|
DSO2_F03L |
NUMC
|
4 | 0 | ||||||||
|
DSO3
DSO Code
|
DSO3_F03L |
NUMC
|
4 | 0 | ||||||||
RF03L foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| RF03L | CASHC | RF03L | MANDT |
TCURC
Currency Codes
|
MANDT |
| RF03L | CASHC | RF03L | CASHC |
TCURC
Currency Codes
|
WAERS |
| RF03L | CTLPC | RF03L | CTLPC |
T691A
Credit management risk categories
|
CTLPC |
| RF03L | CTLPC | RF03L | KKBER |
T691A
Credit management risk categories
|
KKBER |
| RF03L | CTLPC | RF03L | MANDT |
T691A
Credit management risk categories
|
MANDT |
| RF03L | DBWAE | RF03L | MANDT |
TCURC
Currency Codes
|
MANDT |
| RF03L | DBWAE | RF03L | DBWAE |
TCURC
Currency Codes
|
WAERS |
| RF03L | GRUPP | RF03L | MANDT |
T691B
"Credit Management Groups"
|
MANDT |
| RF03L | GRUPP | RF03L | GRUPP |
T691B
"Credit Management Groups"
|
GRUPP |
| RF03L | GRUPP | RF03L | KKBER |
T691B
"Credit Management Groups"
|
KKBER |
| RF03L | KKBER | RF03L | KKBER |
T014
Credit control areas
|
KKBER |
| RF03L | KKBER | RF03L | MANDT |
T014
Credit control areas
|
MANDT |
| RF03L | KNKLI | RF03L | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| RF03L | KNKLI | RF03L | KNKLI |
KNA1
General Data in Customer Master
|
KUNNR |
| RF03L | KUNNR | RF03L | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| RF03L | KUNNR | RF03L | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| RF03L | MANDT | RF03L | MANDT |
T000
Clients
|
MANDT |
| RF03L | SBGRP | RF03L | MANDT |
T024B
Credit management: Credit representative groups
|
MANDT |
| RF03L | SBGRP | RF03L | SBGRP |
T024B
Credit management: Credit representative groups
|
SBGRP |
| RF03L | SBGRP | RF03L | KKBER |
T024B
Credit management: Credit representative groups
|
KKBER |
| RF03L | WAERS_KKBER | * |
TCURC
Currency Codes
|
MANDT | |
| RF03L | WAERS_KKBER | RF03L | WAERS_KKBER |
TCURC
Currency Codes
|
WAERS |