SAP ABAP Table RF03L (Credit Management Master Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'

Basic Data

Table Category	INTTAB	Structure
Structure	RF03L	Table Relationship Diagram
Short Description	Credit Management Master Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Customer master credit management: Control area data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
4	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
5	KLIMK	☐	KLIMK	WERT8	CURR	15	2	Customer's credit limit
6	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
7	SAUFT	☐	SAUFT	WRTV8	CURR	15	2	Total of the sales values for the credit limit check
8	SKFOR	☐	SKFOR	WRTV8	CURR	15	2	Total receivables (for credit limit check)
9	SSOBL	☐	SSOBL	WRTV8	CURR	15	2	Relevant special liabilities for credit limit check
10	UEDAT	☐	UEDAT	DATUM	DATS	8	0	Date on which the credit limit was exceeded
11	XCHNG	☐	XCHNG_KNKK	XFELD	CHAR	1	0	Indicator: credit limit must be recreated
12	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
13	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
14	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
15	DTREV	☐	DTREV_CM	DATUM	DATS	8	0	Last internal review
16	CRBLB	☐	CRBLB_CM	XFELD	CHAR	1	0	Indicator: Blocked by credit management ?
17	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
18	NXTRV	☐	NXTRV_CM	DATUM	DATS	8	0	Next internal review
19	KRAUS	☐	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
20	PAYDB	☐	PAYDB_CM	NUM02	NUMC	2	0	do not use - replaced by DBPAY_CM
21	DBRAT	☐	DBRAT_CM	CHAR3	CHAR	3	0	do not use - replaced by DBRTG_CM
22	REVDB	☐	REVDB_CM	DATUM	DATS	8	0	Last review (external)
23	AEDAT	☐	AEDAT_CM	DATUM	DATS	8	0	Date of Last Change
24	AETXT	☐	AETXT_CM	DATUM	DATS	8	0	Date of Last Text Change
25	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	T691B
26	AENAM	☐	AENAM_CM	USNAM	CHAR	12	0	Last changed by
27	SBDAT	☐	SBDAT_CM	DATUM	DATS	8	0	Reference Date
28	KDGRP	☐	KDGRP_CM	CHAR8	CHAR	8	0	Customer Group
29	CASHD	☐	CASHD	DATUM	DATS	8	0	Date of Last Payment
30	CASHA	☐	CASHA	WERT7	CURR	13	2	Amount of Last Payment
31	CASHC	☐	CASHC	WAERS	CUKY	5	0	Currency of Last Payment	TCURC
32	DBPAY	☐	DBPAY_CM	CHAR3	CHAR	3	0	Payment Index
33	DBRTG	☐	DBRTG_CM	CHAR5	CHAR	5	0	Rating
34	DBEKR	☐	DBEKR_CM	WERT8	CURR	15	2	Recommended credit limit
35	DBWAE	☐	DBWAE_CM	WAERS	CUKY	5	0	Currency of recommended credit limit	TCURC
36	DBMON	☐	DBMON_CM	DATUM	DATS	8	0	Date Monitoring
37	ABSBT	☐	ABSBT_SUM	WERTV8	CURR	15	2	Total Secured Receivables
38	WAERS_KKBER	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
39	KLIMG	☐	KLIMG	WERT8	CURR	15	2	Credit limit: Total limit across all control areas
40	KLIME	☐	KLIME	WERT8	CURR	15	2	Credit limit: Limit for individual control area
41	WAERS_KNKA	☐	WAERS_KNKA	WAERS	CUKY	5	0	Currency Key	*
42	DLAUS	☐	DLAUS	DATUM	DATS	8	0	Date of the last general information
43	.INCLUDE	☐				0	0	Credit Management Address Communication Data
44	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
45	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
46	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
47	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
48	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
49	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
50	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
51	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
52	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
53	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
54	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
55	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
56	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
57	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
58	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
59	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
60	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
61	.INCLUDE	☐				0	0	Credit Management: Due Items
62	WAERS_FAEL	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
63	SFAE1	☐	SFAE1_F035	WRTV8	CURR	15	2	Total of Due Items
64	SFAE2	☐	SFAE2_F035	WRTV8	CURR	15	2	Total of Due Items (Interval 2)
65	SFAE3	☐	SFAE3_F035	WRTV8	CURR	15	2	Total of Due Items (Interval 3)
66	SFAE4	☐	SFAE4_F035	WRTV8	CURR	15	2	Total of Due Items (Interval 4)
67	SFAE5	☐	SFAE5_F035	WRTV8	CURR	15	2	Total of Due Items (Interval 5)
68	SFAE6	☐	SFAE6_F035	WRTV8	CURR	15	2	Total of Due Items (Interval 6)
69	SNFA1	☐	SNFA1_F035	WRTV8	CURR	15	2	Total of Items not Due 1
70	SNFA2	☐	SNFA2_F035	WRTV8	CURR	15	2	Total of Items not Due 2
71	SNFA3	☐	SNFA3_F035	WRTV8	CURR	15	2	Total of Items not Due 3
72	SNFA4	☐	SNFA4_F035	WRTV8	CURR	15	2	Total of Items not Due 4
73	SNFA5	☐	SNFA5_F035	WRTV8	CURR	15	2	Total of Items not Due 5
74	SNFA6	☐	SNFA6_F035	WRTV8	CURR	15	2	Total of Items not Due 6
75	SFAEL	☐	SFAES_F035	WRTV8	CURR	15	2	Total of Due Items
76	SNFAE	☐	SNFAS_F035	WRTV8	CURR	15	2	Total of Items not Due
77	SUMOP	☐	SUMOP_F035	WRTV8	CURR	15	2	Total of Due Items with More Than n Days in Arrears
78	OBLIG	☐	OBLIG_F02L	WRTV8	CURR	15	2	Credit exposure (for credit limit check)
79	OBLIG_NA	☐	OBLIG_F02L_NA	WRTV8	CURR	15	2	Unhedged Total Liabilities
80	DELTA	☐	DELTA_F02L	WRTV8	CURR	15	2	Over budget amount in credit management
81	DSO1	☐	DSO1_F03L	NUM04	NUMC	4	0	DSO Code
82	DSO2	☐	DSO2_F03L	NUM04	NUMC	4	0	DSO Code
83	DSO3	☐	DSO3_F03L	NUM04	NUMC	4	0	DSO Code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RF03L	CASHC	TCURC	WAERS	REF	C	CN
2	RF03L	CTLPC	T691A	CTLPC	REF	C	CN
3	RF03L	DBWAE	TCURC	WAERS
4	RF03L	GRUPP	T691B	GRUPP	REF	C	CN
5	RF03L	KKBER	T014	KKBER	KEY	1	CN
6	RF03L	KNKLI	KNA1	KUNNR	REF	1	CN
7	RF03L	KUNNR	KNA1	KUNNR	KEY	1	CN
8	RF03L	MANDT	T000	MANDT	KEY	1	CN
9	RF03L	SBGRP	T024B	SBGRP	REF	C	CN
10	RF03L	WAERS_KKBER	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in