SAP ABAP Table KNKK_AEDAT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	KNKK_AEDAT	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
3	KKBER	☑	KKBER	KKBER	CHAR	4	0	Credit control area	T014
4	TABNAME	☑	TABNAME	AS4TAB	CHAR	30	0	Table Name
5	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code
6	KLIMK	☐	KLIMK	WERT8	CURR	15	2	Customer's credit limit
7	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
8	SAUFT	☐	SAUFT	WRTV8	CURR	15	2	Total of the sales values for the credit limit check
9	SKFOR	☐	SKFOR	WRTV8	CURR	15	2	Total receivables (for credit limit check)
10	SSOBL	☐	SSOBL	WRTV8	CURR	15	2	Relevant special liabilities for credit limit check
11	UEDAT	☐	UEDAT	DATUM	DATS	8	0	Date on which the credit limit was exceeded
12	XCHNG	☐	XCHNG_KNKK	XFELD	CHAR	1	0	Indicator: credit limit must be recreated
13	ERNAM	☐	ERNAM_RF	USNAM	CHAR	12	0	Name of Person who Created the Object
14	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
15	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
16	DTREV	☐	DTREV_CM	DATUM	DATS	8	0	Last internal review
17	CRBLB	☐	CRBLB_CM	XFELD	CHAR	1	0	Indicator: Blocked by credit management ?
18	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
19	NXTRV	☐	NXTRV_CM	DATUM	DATS	8	0	Next internal review
20	KRAUS	☐	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
21	PAYDB	☐	PAYDB_CM	NUM02	NUMC	2	0	do not use - replaced by DBPAY_CM
22	DBRAT	☐	DBRAT_CM	CHAR3	CHAR	3	0	do not use - replaced by DBRTG_CM
23	REVDB	☐	REVDB_CM	DATUM	DATS	8	0	Last review (external)
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	AEDAT	☐	AEDAT_BKPF	DATUM	DATS	8	0	Date of the Last Document Change by Transaction
39	AETIM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in