table name

[Former Member]

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

[valter_oliveira]

It's DB table HRP1000, field MC_STEXT.

Regards,

Valter Oliveira.

[former_member184551]

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

[Former Member]

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

[valter_oliveira]

Use HRP1000-OBJID = PA0001-ORGEH.

Regards,

Valter Oliveira.

[Former Member]

r u sure ,this is right?

[valter_oliveira]

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.

[Former Member]

okk thanks.

[valter_oliveira]

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

Regards,

Valter Oliveira.

[Former Member]

not getting the same field in o/p.

wat else i can link with??

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

[valter_oliveira]

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

[Former Member]

Is 'MC_STEXT' field same as 'P1001TEXT'.

data in mc_stext is not as per requirement..

[valter_oliveira]

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.

[Former Member]

anyways..

we learn from mistakes..:)

let me try out this one.

[Former Member]

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

its "p1001stext".

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

[Former Member]

hi,

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

[Former Member]

hii,

can u explain the steps involved in st05??

thanks.