topic Re: read table dbtable in Application Development and Automation Discussions

read table dbtable

Former Member — Tue, 04 Dec 2007 20:44:01 GMT

Hello Experts,

I am "read table dbtable" in a program and iam getting an error that 'field does not eixts'. Can anybody please let me know what is the reason?

Thanks a lot for you help.

Code:

DB table ZTABLE has the following fields:

KUNNR

BSTNK

VBELN

POSNR

MATNR

MAKTX

ZZWKTNR2

PRSDT

ZNEWDT

ERNAM

ZPOSTDT

ZPOSTTIME

data: i_ztable like ztable occurs 0 with header line.

sort i_ztable by kunnr bstnk vbeln posnr matnr zzwktnr2.

  if not i_ztable is initial.
*   loop at i_ztable.
     read table ztable with key
            kunnr = i_ztable-kunnr
            bstnk = i_ztable-bstnk
            vbeln = i_ztable-chargeback
            posnr = i_ztable-posnr
            matnr = i_ztable-matnr
            zzwktnr2 = i_ztable-zzwktnr2
            binary search.
* endloop.

During syntax check it's giving error: The field KUNNR is unknown.

Re: read table dbtable

Former Member — Tue, 04 Dec 2007 20:53:11 GMT

Sam,

You can not use READ Statement on DBTABLE, you can only use on Internal tables.

Regards,

Satish

Re: read table dbtable

Former Member — Tue, 04 Dec 2007 20:56:48 GMT

You can do like this

data: wa type ztable.
Select single * from ztable into wa where 
            kunnr = i_ztable-kunnr and
            bstnk = i_ztable-bstnk and
            vbeln = i_ztable-chargeback and
            posnr = i_ztable-posnr and
            matnr = i_ztable-matnr and
            zzwktnr2 = i_ztable-zzwktnr2.

Regards,

Satish

Re: read table dbtable

Former Member — Tue, 04 Dec 2007 21:12:01 GMT

Thanks Satish for the response. But when I looked in SAP HELP, it's mentioned in that you can use 'Read' Statement on Database Tables. Isn't it true?

Re: read table dbtable

Former Member — Tue, 04 Dec 2007 21:14:08 GMT

It is true, but not recommended. Use SELECTs instead.

Rob

Re: read table dbtable

former_member195698 — Tue, 04 Dec 2007 21:18:46 GMT

Can you please provide the link

Re: read table dbtable

Former Member — Tue, 04 Dec 2007 21:22:36 GMT

> Thanks Satish for the response. But when I looked in

> SAP HELP, it's mentioned in that you can use 'Read'

> Statement on Database Tables. Isn't it true?

In the same help document, also says that it is obsolete and the following statement needs special attention.

For dbtab, you must specify the name of a database table that begins with "T" and is not longer than five characters. The table work area must have been declared with statement TABLES for database table dbtab. If a database table is specified that does not begin with "T", then the first letter is implicitly replaced by "T".

Re: read table dbtable

Former Member — Tue, 04 Dec 2007 21:46:48 GMT

Yes. I haven't paid attention to that comments. Thanks for clearing.

Thanks all for your help.