Business Partner for Indirect Promotions 

Technical Name: 0CP_SLSC6_Q0010

Use

This query determines all promotions for a business partner over the past twelve fiscal year periods with a positive billing quantity.  The query can be used in an indirect sales scenario, for example. If the query is called using the “Marketing Element for Business Partner” variable (0Q_MKTEL) from the Indirect Promotions query (0CP_SLSC6_Q0009), the user specifies a wholesaler or bottler as the business partner.  The system determines all trade promotions of the past twelve fiscal year periods for the business partner, and returns them to the Indirect Promotions query.  The Indirect Promotions query then determines all subordinate trade promotions with retailers.

Filters

Element	InfoObject, Restrictions, Formula
Fiscal year variant	0FISCVARNT restricted to ‘K4’
Fiscal Year/Period	0FISCPER restricted to selection variable 0I_PRFY2
Promotion phase	0PERIODTYP restricted to the value ‘50’
Version	0VERSION restricted to the value ‘0’ (planned/actual version)
Life cycle status	0CRM_MKTELM__0STAMKTYSYS0

Free Characteristics

Element	InfoObject, Restrictions, Formula
Business partner	0BPARTNER restricted to the selection variable 0S_BPART

Rows

Element	InfoObject, Restrictions, Formula
CRM Marketing element	0CRM_MKTELM

Columns

Element	InfoObject, Restrictions, Formula
Billing quantity base UoM	0BILL_QTY