topic for all entries + client specified in Application Development and Automation Discussions

for all entries + client specified

Former Member — Mon, 05 May 2008 09:54:53 GMT

Hi experts

plz check the below code

SELECT MANDT

ZTXPMTTYP

LIFNR

ZPMTDSC

TXJCD

ZDPMTDY

ZAPMTDY

ZPMTAMT

WAERS

ZLSCH

HKONT

KTOPL

FROM z0132

CLIENT SPECIFIED

INTO CORRESPONDING FIELDS OF

TABLE i_z0132_new

FOR ALL ENTRIES IN i_z0132

WHERE mandt eq i_z0132-mandt

AND ztxpmttyp eq i_z0132-ztxpmttyp

AND lifnr eq i_z0132-lifnr

AND zpmtdsc eq i_z0132-zpmtdsc.

the table i_z0132 have 13 entries......my issue is this query is throwing a subrc value of 4........can someone help me out in this plz....its urgent

thanks in advance

Re: for all entries + client specified

Former Member — Mon, 05 May 2008 09:57:36 GMT

HI,

you select over the same table then you insert.

INTO CORRESPONDING FIELDS OF

TABLE i_z0132_new

FOR ALL ENTRIES IN i_z0132

regards

Nicole

Re: for all entries + client specified

Former Member — Mon, 05 May 2008 10:03:10 GMT

Hi Nicole

Thanks for ur quick response

Can u be a bit more clear plz

rgs

Re: for all entries + client specified

Former Member — Mon, 05 May 2008 10:22:07 GMT

Hi,

sure. But I saw, that my answer was not right, cause your insert table ends with _new.

So...forget my first answer.

Did you try to get datas if you run the program only with

FROM z0132

CLIENT SPECIFIED

INTO CORRESPONDING FIELDS OF

TABLE i_z0132_new

FOR ALL ENTRIES IN i_z0132

WHERE mandt eq i_z0132-mandt.

Re: for all entries + client specified

Former Member — Mon, 05 May 2008 10:34:36 GMT

yes....but it is of no use

Re: for all entries + client specified

Former Member — Mon, 05 May 2008 10:50:26 GMT

First sort the Internal table i_z0132 with the WHERE conditions u mentioned.

Thanks