topic need table names in Application Development and Automation Discussions

need table names

Former Member — Fri, 09 Feb 2007 20:28:00 GMT

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

Field Description

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

Re: need table names

Former Member — Fri, 09 Feb 2007 20:30:22 GMT

Field Description

TRIALNR_CA Trial Number(ClinAdmin)

UNITNO_CA Trial Site Number (Clin Admin)

LIFNR Vendor Nr - LFA1

EBELN Purchase Order Number - EKKO

PSPNR WBS Element - PRPS

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

Re: need table names

Former Member — Fri, 09 Feb 2007 20:31:54 GMT

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

Re: need table names

Former Member — Fri, 09 Feb 2007 20:35:50 GMT

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

Re: need table names

Former Member — Fri, 09 Feb 2007 20:42:56 GMT

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.

Re: need table names

Former Member — Sat, 10 Feb 2007 09:21:09 GMT

HI,

GOTO SE85 or SE15.

here u can get the result exactly.

Thank u