BEx variable on Sales Area
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.
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?