topic ABAP DICTIONARY in Application Development and Automation Discussions

ABAP DICTIONARY

Former Member — Tue, 22 May 2007 05:21:20 GMT

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

Re: ABAP DICTIONARY

Former Member — Tue, 22 May 2007 05:24:59 GMT

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.

Re: ABAP DICTIONARY

Former Member — Tue, 22 May 2007 05:25:16 GMT

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

Re: ABAP DICTIONARY

Bema — Tue, 22 May 2007 05:26:14 GMT

hi,

Select kunnr into v_kunnr from kna1 where kunnr = p_kunnr.

if sy-subrc = 0.

" it is available

else.

" not avalialble

endif.

Re: ABAP DICTIONARY

Former Member — Tue, 22 May 2007 05:36:24 GMT

hi,

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

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.

Re: ABAP DICTIONARY

Former Member — Tue, 22 May 2007 06:05:40 GMT

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

Re: ABAP DICTIONARY

Former Member — Tue, 22 May 2007 07:55:40 GMT

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.

Re: ABAP DICTIONARY

Former Member — Tue, 22 May 2007 07:58:43 GMT

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.