SAP ABAP View KNKK_AEDAT (BW FI: KNKK Extraction usign AEDAT)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI (Application Component) Financial Accounting
     ⤷ BWFI (Package) BW: Delta Process for Data Extraction in FI

Basic Data

View Type	D	Database View
Database View	KNKK_AEDAT
Short Description	BW FI: KNKK Extraction usign AEDAT
Root table	KNKK	Customer master credit management: Control area data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNKK	KNKK
2	BWFI_AEDA3

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BWFI_AEDA3	MANDT	JL	EQ				0	0
2	KNKK	MANDT	JR	EQ			AND	0	0
3	BWFI_AEDA3	KONTO	JL	EQ				0	0
4	KNKK	KUNNR	JR	EQ			AND	0	0
5	BWFI_AEDA3	KKBER	JL	EQ				0	0
6	KNKK	KKBER	JR	EQ			AND	0	0
7	BWFI_AEDA3	TABNAME		EQ	'KNKK'		AND	0	0
8	BWFI_AEDA3	BUKRS		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KNKK	MANDT		☐	MANDT	☐	Client
2	KUNNR	KNKK	KUNNR		☐	KUNNR	☐	Customer Number
3	KKBER	KNKK	KKBER		☐	KKBER	☐	Credit control area
4	TABNAME	BWFI_AEDA3	TABNAME		☐	TABNAME	☐	Table Name
5	BUKRS	BWFI_AEDA3	BUKRS		☐	BUKRS	☐	Company Code
6	KLIMK	KNKK	KLIMK		☐	KLIMK	☐	Customer's credit limit
7	KNKLI	KNKK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
8	SAUFT	KNKK	SAUFT		☐	SAUFT	☐	Total of the sales values for the credit limit check
9	SKFOR	KNKK	SKFOR		☐	SKFOR	☐	Total receivables (for credit limit check)
10	SSOBL	KNKK	SSOBL		☐	SSOBL	☐	Relevant special liabilities for credit limit check
11	UEDAT	KNKK	UEDAT		☐	UEDAT	☐	Date on which the credit limit was exceeded
12	XCHNG	KNKK	XCHNG		☐	XCHNG_KNKK	☐	Indicator: credit limit must be recreated
13	ERNAM	KNKK	ERNAM		☐	ERNAM_RF	☐	Name of Person who Created the Object
14	ERDAT	KNKK	ERDAT		☐	ERDAT_RF	☐	Date on which the Record Was Created
15	CTLPC	KNKK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
16	DTREV	KNKK	DTREV		☐	DTREV_CM	☐	Last internal review
17	CRBLB	KNKK	CRBLB		☐	CRBLB_CM	☐	Indicator: Blocked by credit management ?
18	SBGRP	KNKK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
19	NXTRV	KNKK	NXTRV		☐	NXTRV_CM	☐	Next internal review
20	KRAUS	KNKK	KRAUS		☐	KRAUS_CM	☐	Credit information number
21	PAYDB	KNKK	PAYDB		☐	PAYDB_CM	☐	do not use - replaced by DBPAY_CM
22	DBRAT	KNKK	DBRAT		☐	DBRAT_CM	☐	do not use - replaced by DBRTG_CM
23	REVDB	KNKK	REVDB		☐	REVDB_CM	☐	Last review (external)
24	AETXT	KNKK	AETXT		☐	AETXT_CM	☐	Date of Last Text Change
25	GRUPP	KNKK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
26	AENAM	KNKK	AENAM		☐	AENAM_CM	☐	Last changed by
27	SBDAT	KNKK	SBDAT		☐	SBDAT_CM	☐	Reference Date
28	KDGRP	KNKK	KDGRP		☐	KDGRP_CM	☐	Customer Group
29	CASHD	KNKK	CASHD		☐	CASHD	☐	Date of Last Payment
30	CASHA	KNKK	CASHA		☐	CASHA	☐	Amount of Last Payment
31	CASHC	KNKK	CASHC		☐	CASHC	☐	Currency of Last Payment
32	DBPAY	KNKK	DBPAY		☐	DBPAY_CM	☐	Payment Index
33	DBRTG	KNKK	DBRTG		☐	DBRTG_CM	☐	Rating
34	DBEKR	KNKK	DBEKR		☐	DBEKR_CM	☐	Recommended credit limit
35	DBWAE	KNKK	DBWAE		☐	DBWAE_CM	☐	Currency of recommended credit limit
36	DBMON	KNKK	DBMON		☐	DBMON_CM	☐	Date Monitoring
37	ABSBT	KNKK	ABSBT		☐	ABSBT_SUM	☐	Total Secured Receivables
38	AEDAT	BWFI_AEDA3	AEDAT		☐	AEDAT_BKPF	☐	Date of the Last Document Change by Transaction
39	AETIM	BWFI_AEDA3	AETIM		☐	CPUTM	☐	Time of data entry

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20110901
SAP Release Created in