Table search for required fields

[Former Member]

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....

[Former Member]

Please search for appropriate fields in following tables:-

KNA1,KNVP,KNV,KNVD,KNB1,KNBS

Regards...

[RaymondGiuseppi]

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

[Former Member]

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.

[Former Member]

hi try these tables for customer conditions

KUAKDK

KUKOV

Regards,

kavitha.k