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'
⤷ 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 |