on 10-01-2013 6:27 AM
Hi Experts,
Is there any common table which connects sales office with sales division.
BR.
Dear,
If you want relation between Sales Office and sales area.
Table is KNVV.
Thanks,
Ranjit K.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
In SD ,we have relation b/w sales office to sales area not pacifically to division.Please check " table-TVKBZ " .
Kindly ,let me know if you need any further help on this.
Thanks,
Naren
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
Please have a look into below threads .
http://scn.sap.com/thread/3268727
http://scn.sap.com/thread/2138741
Thanks,
Naren
Hi,
I think you mean V_VBAK_VKO auth object.
This is actually Sales Document: Authorization for Sales Areas therefore it will give you option for Sales area which includes (Sales Org + Dist Chnl + Division).
I think you want to restrict it by Division along with a check Sales Office.
Please let me know what is your exact requirement.
Thanks,
Suman$
Hi,
Can you tell me what is your exact requirement?So that I can suggest you accordingly.
Regards,
Pankaj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Both are select options (Multiple selections) and they are not mandatory fields as well.
Does it mean you want to restrict them in some Z transaction or in VA01,VA02? I will suggest you to create an authorization object by taking VBAK-VKBUR and VBAP-SPART fields. Add authority check logic in MV45AFZZ in user exits mentioned in there. Use move field to VBAK for sales office and move field to VBAP for sales division ot item division
If I have understood you wrong then be clear sales division. Is it header division or item divion?
Thank$
For this you can select sales office from TVKBT and Divison from TSPA. If you are not able to do this in one object then you can use two objects for both fields separately.
I have used Sales District field for this purpose in customized reports and logic will be like this
SELECT bzirk INTO input FROM T171
WHERE bzirk IN s_bzirk.
AUTHORITY-CHECK OBJECT 'ZBZIRK'
ID 'ACTVT' FIELD '01' " read access
ID 'BZIRK' FIELD input. " actual value
IF sy-subrc NE 0.
MESSAGE text-002 TYPE 'E'.
EXIT.
ENDIF.
ENDSELECT.
Thank$
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.