topic Re: table name in Application Development and Automation Discussions

table name

Former Member — Mon, 06 Oct 2008 11:06:46 GMT

can anyone tell the table for field - P1001TEXT,it is in structure"q1001" ??

it is related to relationaship in maintaining organizational unit (t.code-po10)

thanks

Re: table name

valter_oliveira — Mon, 06 Oct 2008 11:21:32 GMT

It's DB table HRP1000, field MC_STEXT.

Regards,

Valter Oliveira.

Re: table name

Former Member — Mon, 06 Oct 2008 21:45:47 GMT

go to SE15--> ABAP Dictionary --> Fields ~~> Table Fields~~>Enter Fieldname and search. if you dont find it there go to structure fields and search.

Re: table name

Former Member — Tue, 07 Oct 2008 04:30:04 GMT

hii sameer,

searching doesnt showing table name.

thanks valter

but i want to link this field with table pa0001.

Edited by: aks on Oct 7, 2008 12:30 AM

Edited by: aks on Oct 7, 2008 12:34 AM

Edited by: aks on Oct 7, 2008 12:48 AM

Re: table name

valter_oliveira — Tue, 07 Oct 2008 08:58:56 GMT

Use HRP1000-OBJID = PA0001-ORGEH.

Regards,

Valter Oliveira.

Re: table name

Former Member — Tue, 07 Oct 2008 09:23:22 GMT

r u sure ,this is right?

Re: table name

valter_oliveira — Tue, 07 Oct 2008 09:34:27 GMT

Yes, but what I said is not completely right. To link those tables, you have 3 fields of PA0001, because infotype 1000 contains Organizational Unit (ORGEH), Position (PLANS) and Job (STELL).

This way, you can link 1 record of PA0001 with 3 OBJID's in HRP1000 (linked with ORGEH, PLANS and STELL).

Use SE16 to see check it.

Regards,

Valter Oliveira.

Re: table name

Former Member — Tue, 07 Oct 2008 09:42:50 GMT

okk thanks.

Re: table name

valter_oliveira — Tue, 07 Oct 2008 10:40:43 GMT

Did it work? If so, please close the thread.

Regards,

Valter Oliveira.

Re: table name

Former Member — Tue, 07 Oct 2008 10:53:57 GMT

not getting the same field in o/p.

wat else i can link with??

Edited by: aks on Oct 7, 2008 7:07 AM

Re: table name

valter_oliveira — Tue, 07 Oct 2008 11:33:29 GMT

What do you mean by "not getting the same field in o/p"?

Re: table name

Former Member — Tue, 07 Oct 2008 11:46:56 GMT

Is 'MC_STEXT' field same as 'P1001TEXT'.

data in mc_stext is not as per requirement..

Re: table name

valter_oliveira — Tue, 07 Oct 2008 12:22:41 GMT

Sorry, I missunderstood the field you wanted.

For that field you need 3 steps ...

1 - with pernr, get field ORGEH (Orhanizational Unit) in PA0001

2 - with field ORGEH, go to table HRP1001, and use it in field OBJID. It will give you some records, that you can restrict using otype and relat field (depending in the case) and get field SOBID.

3 - with this SOBID, go to table HRP1000, and get field STEXT (not MC_TEXT)

Now it works!

Regards,

Valter Oliveira.

Re: table name

Former Member — Tue, 07 Oct 2008 15:18:17 GMT

anyways..

we learn from mistakes..:)

let me try out this one.

Re: table name

Former Member — Wed, 08 Oct 2008 07:00:21 GMT

i guess both the fields mc_stext and stext hav same data..

its "p1001stext".

Edited by: aks on Oct 8, 2008 3:14 AM

Re: table name

Former Member — Fri, 10 Oct 2008 10:51:40 GMT

hi,

do the sql trace on transaction po10 and u will get the table name...transaction st05 for sql trace...

Re: table name

Former Member — Sat, 11 Oct 2008 06:32:20 GMT

hii,

can u explain the steps involved in st05??

thanks.