for all entries + client specified

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Nicole

Thanks for ur quick response

Can u be a bit more clear plz

rgs

[Former Member]

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.

[Former Member]

yes....but it is of no use

[Former Member]

Hi

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

Thanks