Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

hi

Former Member
0 Kudos
103

I hv four table

AGR_USERS AGR_HIER AGR_1016 and UST12

I wanted to conect all these in bapi I got common fields in first three table but not in last ust12 how to join these three tables.

I want user to enter uname n for that I wanted to disply field of the tables

I am writing bapi for Authorisation object

Shashikant

1 ACCEPTED SOLUTION

Former Member
0 Kudos
51

i think this is related to authorisation,

SUSR_USER_AGR_ACTIVITYGR_GET is available.

if ugive the user name it displays all authorisations.

if not so,

join three tables:

select A(wht arr the fields u required from AGR_USERS) (AAGR_NAME etc...)

b(wht arr the fields u required from AGR_HIER)(BOBJECT_ID etc...)

c(wht arr the fields u required from AGR_1016)(cCOUNTER etc..)

from AGR_USERS as a inner join AGR_HIER as b

on AAGR_NAME = cAGR_NAME

inner join AGR_1016 as c on bAGR_NAME = cAGR_NAME.

into table gt_all

where A~AGR_NAME = .....all ur conditons

2 REPLIES 2

Former Member
0 Kudos
52

i think this is related to authorisation,

SUSR_USER_AGR_ACTIVITYGR_GET is available.

if ugive the user name it displays all authorisations.

if not so,

join three tables:

select A(wht arr the fields u required from AGR_USERS) (AAGR_NAME etc...)

b(wht arr the fields u required from AGR_HIER)(BOBJECT_ID etc...)

c(wht arr the fields u required from AGR_1016)(cCOUNTER etc..)

from AGR_USERS as a inner join AGR_HIER as b

on AAGR_NAME = cAGR_NAME

inner join AGR_1016 as c on bAGR_NAME = cAGR_NAME.

into table gt_all

where A~AGR_NAME = .....all ur conditons

Former Member
0 Kudos
51

Dear Ms. Laxmi

how to join the ust12 with agr_users , agr_hier, or with agr_1016

I hv aleady join these three only problem with ust12

thanks for ur previous reply