Application Development and Automation 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: 
Read only

need table names

Former Member
0 Likes
722

Hi all,

i have to create purchase order through me21

i have the following fields but i dont know the table names for them

please tell me the table names

<b>Field</b> <b>Description</b>

TRIALNR_CA Trial Number(ClinAdmin)

UNITNO_CA Trial Site Number (Clin Admin)

LIFNR Vendor Nr

EBELN Purchase Order Number

PSPNR WBS Element

TRIAL_UNIT_

REFERENCE Trial Site Number (MEDIAS)

ACT_CODE Activity Code

SAKTO G/L account number (MEDIAS)

REPOS Invoice receipt indicator

WEBRE GR-based nvoice verification

XERSY Evaluated receipt settlement

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
686

press F1 and then F9 on the field in the transaction. Some times you get the table name also directly and if not most of the times you get the data element through which you can do a where used list of tables and get the fields in the appropriate tables. hope this helps.

award points if it helps.

5 REPLIES 5
Read only

Former Member
0 Likes
686

Field Description

TRIALNR_CA Trial Number(ClinAdmin)

UNITNO_CA Trial Site Number (Clin Admin)

LIFNR Vendor Nr - <b>LFA1</b>

EBELN Purchase Order Number - <b>EKKO</b>

PSPNR WBS Element - <b>PRPS</b>

TRIAL_UNIT_

REFERENCE Trial Site Number (MEDIAS)

ACT_CODE Activity Code

SAKTO G/L account number (MEDIAS)

REPOS Invoice receipt indicator

WEBRE GR-based nvoice verification

XERSY Evaluated receipt settlement

Thanks,

Santosh

Read only

Former Member
0 Likes
686

Hi,

You can try to search those field names in SE11 and click on where-used list button to find where is used in table fields.

Regards,

Ferry Lianto

Read only

Former Member
0 Likes
686

TRIALNR_CA Trial Number(ClinAdmin)

UNITNO_CA Trial Site Number (Clin Admin)

LIFNR Vendor Nr

EBELN Purchase Order Number

PSPNR WBS Element

TRIAL_UNIT_

REFERENCE Trial Site Number (MEDIAS)

ACT_CODE Activity Code

SAKTO G/L account number (MEDIAS) - COOI / TXW_S_MSEG

REPOS Invoice receipt indicator - EKPO

WEBRE GR-based nvoice verification - EKPO

XERSY Evaluated receipt settlement - EKPO

Thanks,

Santosh

Read only

Former Member
0 Likes
687

press F1 and then F9 on the field in the transaction. Some times you get the table name also directly and if not most of the times you get the data element through which you can do a where used list of tables and get the fields in the appropriate tables. hope this helps.

award points if it helps.

Read only

Former Member
0 Likes
686

HI,

GOTO SE85 or SE15.

here u can get the result exactly.

Thank u