cancel
Showing results for 
Search instead for 
Did you mean: 

get sales office from sales area

former_member196079
Active Contributor
0 Kudos

Hi gurus

I'm looking for a FM or METHOD for get all the sales office linked at one sales area....

somebody can help me??

regards

Marco

Accepted Solutions (0)

Answers (2)

Answers (2)

Sridharnekkanti
Active Participant
0 Kudos

Directly you can get the details from the TVKBZ table

former_member196079
Active Contributor
0 Kudos

Hi thanks for you replys...

But the issue is that i'm in CRM, not in R3....

other ideas??

Thaks in advance

Marco

Former Member
0 Kudos

Hi Marco,

Try using CRM_MAPPING_SALES_OFFICE which has relation between R3 and CRM.

Former Member
0 Kudos

Hi Marco,

Try using CRM_MAPPING_SALES_OFFICE which has relation between R3 and CRM.

former_member196079
Active Contributor
0 Kudos

Hi RAJ.

thanks for your reply.

I no need the mapping trought the two system.

I need only of the mapping trought sales area and sales office in CRM....

thanks

Marco

Edited by: Menegazzo Marco on Jul 5, 2010 3:46 PM

Edited by: Menegazzo Marco on Jul 6, 2010 9:36 AM

former_member196079
Active Contributor
0 Kudos

SOLVED.

I've used the FM RH_STRUC_GET , for get the office directly from the organizational structure.

Thanks all.

Former Member
0 Kudos

Hi Marco,

You can fetch the Sales office by passing the Sales area data to the table TVKBZ.

FM - TVKBZ_SINGLE_READ

Edited by: Raj on Jul 5, 2010 4:13 PM