SAP ABAP Table TXI_KNKK (Customer master credit management: Control area data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_KNKK	Table Relationship Diagram
Short Description	Customer master credit management: Control area 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	KLIMK_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
39	SAUFT_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
40	SKFOR_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
41	SSOBL_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
42	CASHA_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
43	DBEKR_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST
44	ABSBT_CY	☐	SYCUKY	SYCUKY	CUKY	5	0	CUKY for SYST

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in