SAP ABAP View V_AGR_REL_CM (SD Rebate Agreements for Campaign)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-MD-AM-RAG (Application Component) Rebate Agreements
     ⤷ AGR_EXCHANGE_GENERAL (Package) Exchange Agreements General

Basic Data

View Type	D	Database View
Database View	V_AGR_REL_CM
Short Description	SD Rebate Agreements for Campaign
Root table	AGR_REL_KNUMA_CM	Assignment: Agreement --> Campaign

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AGR_REL_KNUMA_CM	AGR_REL_KNUMA_CM
2	CMPB_MAP
3	KONA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AGR_REL_KNUMA_CM	MANDT	JL	EQ				0	0
2	CMPB_MAP	MANDT	JR	EQ			AND	0	0
3	AGR_REL_KNUMA_CM	CMPGN_ID	JL	EQ				0	0
4	CMPB_MAP	CMPGN_ID	JR	EQ			AND	0	0
5	KONA	MANDT	JL	EQ				0	0
6	AGR_REL_KNUMA_CM	MANDT	JR	EQ			AND	0	0
7	KONA	KNUMA	JL	EQ				0	0
8	AGR_REL_KNUMA_CM	KNUMA	JR	EQ			AND	0	0
9	KONA	KAPPL		EQ	'V '		AND	0	0
10	KONA	ABTYP		EQ	'A'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AGR_REL_KNUMA_CM	MANDT		☐	MANDT	☐	Client
2	KNUMA	AGR_REL_KNUMA_CM	KNUMA		☐	KNUMA	☐	Agreement (various conditions grouped together)
3	CMPGN_ID	AGR_REL_KNUMA_CM	CMPGN_ID		☐	CMPGN_ID_R3	☐	Campaign ID
4	CMPGN_EXTID	CMPB_MAP	CMPGN_EXTID		☐	CMPGN_EXTID_R3	☐	Campaign (External ID)
5	BONEM	KONA	BONEM		☐	BONEM	☐	Rebate recipient
6	BOSTA	KONA	BOSTA		☐	BOSTA	☐	Status of the agreement

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	20100310
SAP Release Created in	463