topic Re: Table search for required fields in Application Development and Automation Discussions

Table search for required fields

Former Member — Fri, 22 Feb 2008 08:00:14 GMT

I have to add two fields in a customer based report , i know only the description of field name 'Customer comments' and 'contact notes'.

in which table i have to search for getting SAP database field. i have searched in all customer related tables but unable to get the data.

could any one help on this please.

Regards....

Re: Table search for required fields

Former Member — Fri, 22 Feb 2008 08:01:30 GMT

Please search for appropriate fields in following tables:-

KNA1,KNVP,KNV,KNVD,KNB1,KNBS

Regards...

Re: Table search for required fields

RaymondGiuseppi — Fri, 22 Feb 2008 08:13:28 GMT

Table fields

Go to any of the repository transactions (SE84, SE85 or SE86) and go to dictionary table fields, and search with designation.

SE84

R/3 Repository Information Sys

ABAP Dictionary

Fields

Table fields

SAPscript Texts

But the names you give look like "long text" names (comments and notes), so they may be stored in SAPscript text files. To find these data, you have to call the customer maintenance transaction (XD02, FD02) and edit these text, there when editing the text go to Header a popup will display the keys to access the long text in the popup window you will find TDNAME, TDSPRAS, TDID and TDOBJECT which are the key of the header text file STXH.

Use these keys in function modules like READ_TEXT, because the text lines are stored in a cluster file STXL.

Regards

Re: Table search for required fields

Former Member — Fri, 22 Feb 2008 09:44:57 GMT

Hi,

go to table DD03T,

in the selection screen porvide ku* in FIELDNAME input then excute, now u can get all relavent fields in the output.

seshu.

Re: Table search for required fields

Former Member — Fri, 22 Feb 2008 10:03:39 GMT

hi try these tables for customer conditions

KUAKDK

KUKOV

Regards,

kavitha.k