on 09-03-2008 11:48 AM
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
Any suggestions from experts?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.