cancel
Showing results for 
Search instead for 
Did you mean: 

BEx variable on Sales Area

Former Member
0 Kudos

Hi

We have an InfoObject 0CUST_SALES. This gives sales area information for customer and hence it is compounded with 3 InfoObjects 0SALESORG, 0DIST_CHAN, 0DIVISION that combinely determine the sales area.

We want to show data in our report for only some particular sales areas. And these particular sales areas would be determined in user exit.

The problem is a combination of Sales Org, Dist Chan and Div result in meaningful sales area. We can not assign separate variables to these infoobjects else results may not be correct.

Example:

Transaction data:

Customer SalesOrg DisChan Div

C1 SO1 DC1 DV1

C2 SO2 DC2 DV2

C3 SO1 DC2 DV2

Let us say, as per master data user should be able to see data for Sales areas S01/DC1/DV1 and SO2/DC2/DV2 only.

If we restrict InfoObjects separately, let us say,

SalesOrg = SO1, SO2

DistChan = DC1, DC2

Division = DV1, DV2

then system would even permit a combination like SO1/DC2/DV2 which is not correct.

Could someone please suggest how can we restrict the sales area to some specific values in user exit variables?

Thanks

Seema

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Any suggestions from experts?

Regards

Former Member
0 Kudos

Based on end user profile in analysis authorization, you can restrict user input for particular combination of S.org/Dc/DV ( a meaningful sales area).

I assume you have user input variable for sales org/ Dc/ div to fetch values from the infoproviders

Former Member
0 Kudos

Hi,

Sorry but we can not follow this approach because of 2 reasons.

1. There are no user input variables for Sales Org, Dist Chnl, Div.

2. We want users to make free selections and do not want any authorisation control at this level.

Hence, we are struggling....

Thanks a lot for your reply though...

Best Regards

Former Member
0 Kudos

Hi,

Try doiing this-

add 1 more field, say Flag, to transaction data. In transformation, Map this field from 0SALESORG, 0DIST_CHAN, 0DIVISION which combinely determinesthe sales area.Then populate this Flag field in the routine with '1' for S01/DC1/DV1 and SO2/DC2/DV2 only & with '0' for other combinations ( write the routine for the same). The transaction data would look like somthing below-

Cust Saleorg Dischan Div Flag

C1 SO1 DC1 DV1 1

C2 SO2 DC2 DV2 1

C3 SO1 DC2 DV2 0

Now , in report, you can very well restrict to the 'Flag = 1' directly. This will filter out the data having Sales Org, Dist Chan and Div other than S01/DC1/DV1 and SO2/DC2/DV2.

Hope this helps.

Regards,

Pritesh.

Former Member
0 Kudos

Hi Pritesh,

I have assigned point to you.

Actually I am aware of what you said and I am seeing it as only available option.

I posted this question to the forum to see if somebody can come up with a better solution because as you would agree in this approach we need to modify all InfoProviders where queries are based. And that is a lot of work in our case.

Thanks