ABAP DICTIONARY

[Former Member]

Hi everydody,

This is srikanth and I am doing a dummy project.......In my project if i want

customer number, How can i know it is available in kna1 table.........Is there any way to approach......

With Regards,

Srikanth.M

[Former Member]

1. open the customer no(KUNNR) field in se11.

2. data element kunnr will open

3. Keep the curser in kunnr and find the where used list by the button tool bar.

4. Select tables.

now you will get all the tables that have kunnr as a field. Select a suitable table from the list.

[Former Member]

Hi

Go to Se16 Tcode

enter your number and see if a record exists or not

or use an existing customer number in that table.

Reward points if useful

Regards

Anji

[Bema]

hi,

Select kunnr into v_kunnr from kna1 where kunnr = p_kunnr.

if sy-subrc = 0.

" it is available

else.

" not avalialble

endif.

[Former Member]

hi,

goto se11 -> kna1 -> display -> click on find and give kunnr -> u will get the kunnr field.

or

in ur proram

parameters: p_kunnr like kna1-kunnr.

types: begin of itab,

kunnr like kna1-kunnr'

end of itab.

data: itab1 type itab occurs 0 with header line.

at selection-screen.

select kunnr form kna1 into table itab1 where kunnr = p_kunnr.

if sy-subrc ne 0.

'no filed available'.

else.

' field available'.

endif.

helpful reward some points.

with regards,

suresh babu aluri.

[Former Member]

Hi,

If you know the transaction code of the customer master then go to that tcode and in that particular field press F1 to display the technical details.Sometimes it will show the table direectly or it will show the structure.if it is structure you use the where used list to find the exact table

Reward points if it is helpfiul.

Regards,

Sangeetha.A

[Former Member]

Hi,

I think u didnt get me....if i have to use" item no "in my project .....How can i know the pre-defined sap table for that item no.

[Former Member]

hi,

Goto transaction code SE11.and then enter table name KNA1.

there u will be having fieldname Kunnr. for customer number.

Reward with points if helpful.