Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

what is the reason for Invalid database interface call in the statement

Former Member
0 Kudos

Hi all,

Invalid database interface call in the statement where table "ZPP_STORAGE ".

Thanks.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

DATA: BEGIN OF itab4 OCCURS 0,

mandt TYPE mandt,

matnr LIKE mseg-matnr,

werks LIKE mseg-werks,

lgort LIKE mseg-lgort,

tarih LIKE sy-datum ,

meins LIKE mseg-meins,

bldat LIKE mkpf-bldat,

menge LIKE mseg-menge,

  • SHKZG like mseg-SHKZG,

  • BWART like mseg-bwart,

END OF itab4.

LOOP AT itab4.

insert into zpp_storage from itab4.

COMMIT WORK.

ENDLOOP.

At insert, dump occurs.

Why?

Thanks.

5 REPLIES 5

Former Member
0 Kudos

DATA: BEGIN OF itab4 OCCURS 0,

mandt TYPE mandt,

matnr LIKE mseg-matnr,

werks LIKE mseg-werks,

lgort LIKE mseg-lgort,

tarih LIKE sy-datum ,

meins LIKE mseg-meins,

bldat LIKE mkpf-bldat,

menge LIKE mseg-menge,

  • SHKZG like mseg-SHKZG,

  • BWART like mseg-bwart,

END OF itab4.

LOOP AT itab4.

insert into zpp_storage from itab4.

COMMIT WORK.

ENDLOOP.

At insert, dump occurs.

Why?

Thanks.

0 Kudos

Does ITAB4 have the same exact structure as ZPP_STORAGE. If not, this could be the issue.

Regards,

Rich Heilman

0 Kudos

Also, I believe the statement syntax is like this.

INSERT ZPP_STORAGE from ITAB4.

Regards,

Rich Heilman

0 Kudos

Hi Deniz,

it should be as below

insert zpp_storage from table itab4.

Reward if it helps,

Satish

JozsefSzikszai
Active Contributor
0 Kudos

some more information would be very useful, what is the exact statement for example...

on the other hand ZPP_STORAGE exists in your DB?

ec