topic Re: hi in Application Development and Automation Discussions

hi

Former Member — Wed, 12 Dec 2007 06:24:40 GMT

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

Former Member — Wed, 12 Dec 2007 15:59:41 GMT

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) (A}AGR_NAME etc...)

b_{(wht arr the fields u required from AGR_HIER)(B}OBJECT_ID etc...)

c_{(wht arr the fields u required from AGR_1016)(c}COUNTER etc..)

from AGR_USERS as a inner join AGR_HIER as b

on A_{AGR_NAME = c}AGR_NAME

inner join AGR_1016 as c on b_{AGR_NAME = c}AGR_NAME.

into table gt_all

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

Former Member — Thu, 13 Dec 2007 04:17:16 GMT

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