SAP ABAP View V_BI_KONA (View for Agreement Master Data BI Extraction)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WBON (Package) WWS: Bonus

Basic Data

View Type	D	Database View
Database View	V_BI_KONA
Short Description	View for Agreement Master Data BI Extraction
Root table	KONA	Agreements

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KONA	KONA
2	T000

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KONA	MANDT	JL	EQ				0	0
2	T000	MANDT	JR	EQ			AND	0	0
3	KONA	KAPPL		EQ	'M'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KONA	MANDT		☐	MANDT	☐	Client
2	LOGSYS	T000	LOGSYS		☐	LOGSYS	☐	Logical system
3	KNUMA	KONA	KNUMA		☐	KNUMA	☐	Agreement (various conditions grouped together)
4	VKORG	KONA	VKORG		☐	VKORG	☐	Sales Organization
5	VTWEG	KONA	VTWEG		☐	VTWEG	☐	Distribution Channel
6	SPART	KONA	SPART		☐	SPART	☐	Division
7	BOART	KONA	BOART		☐	BOART	☐	Agreement type
8	ERNAM	KONA	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
9	ERDAT	KONA	ERDAT		☐	ERDAT	☐	Date on which the record was created
10	ERZET	KONA	ERZET		☐	ERZET	☐	Entry time
11	AEDAT	KONA	AEDAT		☐	AEDAT	☐	Last Changed On
12	WAERS	KONA	WAERS		☐	WAERS	☐	Currency Key
13	ABREX	KONA	ABREX		☐	ABREX	☐	External description for agreement
14	EKORG	KONA	EKORG		☐	EKORG	☐	Purchasing organization
15	BOLIF	KONA	BOLIF		☐	BOGEW	☐	Condition granter
16	BOSTA	KONA	BOSTA		☐	BOSTA	☐	Status of the agreement
17	DATAB	KONA	DATAB		☐	ABDATAB	☐	Agreement valid-from date
18	DATBI	KONA	DATBI		☐	ABDATBI	☐	Agreement valid-to date
19	BOTEXT	KONA	BOTEXT		☐	BOTEXT	☐	Description of agreement (e.g. sales deal, promotion)
20	IDENT1	KONA	IDENT1		☐	WFCID1	☐	Settlement calendar for rebate arrangements
21	IDENT2	KONA	IDENT2		☐	WFCID2	☐	Arrangement calendar for rebate arrangements
22	UMNAM	KONA	UMNAM		☐	UMNAM	☐	Person responsible for BVol. comparison f. final settlement
23	UMSDA	KONA	UMSDA		☐	UMSDA	☐	Date of last business volume comparison for final settlement
24	UMNAMP	KONA	UMNAMP		☐	UMNAMP	☐	Pers. responsible for last BVol. comparison, partial settlm.
25	UMSDAP	KONA	UMSDAP		☐	UMSDAP	☐	Date of last business vol. comparison for partial settlement
26	EKGRP	KONA	EKGRP		☐	EKGRP	☐	Purchasing group
27	AKTNR	KONA	AKTNR		☐	WAKTION	☐	Promotion
28	BUKRS	KONA	BUKRS		☐	BUKRS_AB	☐	Company code for subsequent settlement
29	ABPAR	KONA	ABPAR		☐	WABPAR	☐	Indicator for type of settlement partner (vendor/customer)
30	BONEM	KONA	BONEM		☐	BONEM	☐	Rebate recipient

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	700