SAP ABAP Table V_BI_KONA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_BI_KONA	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	LOGSYS	☑	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
3	KNUMA	☑	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)
4	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
5	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
6	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
7	BOART	☐	BOART	BOART	CHAR	4	0	Agreement type	T6B1
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
11	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
13	ABREX	☐	ABREX	CHAR20	CHAR	20	0	External description for agreement
14	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
15	BOLIF	☐	BOGEW	LIFNR	CHAR	10	0	Condition granter	LFA1
16	BOSTA	☐	BOSTA	BOSTA	CHAR	1	0	Status of the agreement
17	DATAB	☐	ABDATAB	DATUM	DATS	8	0	Agreement valid-from date
18	DATBI	☐	ABDATBI	DATUM	DATS	8	0	Agreement valid-to date
19	BOTEXT	☐	BOTEXT	TEXT40	CHAR	40	0	Description of agreement (e.g. sales deal, promotion)
20	IDENT1	☐	WFCID1	WFCID	CHAR	2	0	Settlement calendar for rebate arrangements	TFACD
21	IDENT2	☐	WFCID2	WFCID	CHAR	2	0	Arrangement calendar for rebate arrangements	TFACD
22	UMNAM	☐	UMNAM	USNAM	CHAR	12	0	Person responsible for BVol. comparison f. final settlement
23	UMSDA	☐	UMSDA	DATUM	DATS	8	0	Date of last business volume comparison for final settlement
24	UMNAMP	☐	UMNAMP	USNAM	CHAR	12	0	Pers. responsible for last BVol. comparison, partial settlm.
25	UMSDAP	☐	UMSDAP	DATUM	DATS	8	0	Date of last business vol. comparison for partial settlement
26	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
27	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
28	BUKRS	☐	BUKRS_AB	BUKRS	CHAR	4	0	Company code for subsequent settlement	T001
29	ABPAR	☐	WABPAR	WABPAR	CHAR	1	0	Indicator for type of settlement partner (vendor/customer)
30	BONEM	☐	BONEM	KUNNR	CHAR	10	0	Rebate recipient	KNA1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_BI_KONA	AKTNR	WAKH	AKTNR
2	V_BI_KONA	BOART	T6B1	BOART	KEY	1	CN
3	V_BI_KONA	BOLIF	LFA1	LIFNR	KEY	1	CN
4	V_BI_KONA	BONEM	KNA1	KUNNR	KEY	1	CN
5	V_BI_KONA	BUKRS	T001	BUKRS
6	V_BI_KONA	EKGRP	T024	EKGRP
7	V_BI_KONA	EKORG	T024E	EKORG	KEY	1	CN
8	V_BI_KONA	IDENT1	TFACD	IDENT
9	V_BI_KONA	IDENT2	TFACD	IDENT
10	V_BI_KONA	LOGSYS	TBDLS	LOGSYS	KEY	C	1
11	V_BI_KONA	MANDT	T000	MANDT	KEY	1	CN
12	V_BI_KONA	SPART	TVTA	SPART	KEY	1	CN
13	V_BI_KONA	VKORG	TVKO	VKORG	KEY	1	CN
14	V_BI_KONA	VTWEG	TVKOV	VTWEG	KEY	1	CN
15	V_BI_KONA	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in