topic Re: ZTable for data selection in Application Development and Automation Discussions

ZTable for data selection

rizaldy_hidayat — Mon, 18 Jul 2016 03:27:57 GMT

Hi Abaper,

I created ztable to store GL Account for selection record in COEP table. So, in my program, firstly I get GL Account from ztable. Based on that GL, I query to COEP table. But, not all record are selected. When I hard code GL account directly in my program (not get from ztable) its normally, all record that relevant are selected. My ztable delivery class is Application table (master data and transaction data). anyone can help?

Thanks.

Habib,

Re: ZTable for data selection

Former Member — Mon, 18 Jul 2016 03:33:17 GMT

Dear Habib,

How is your logic to query COEP related with your ztable ? Please give your coding.

Regards,

Yance

Re: ZTable for data selection

rizaldy_hidayat — Mon, 18 Jul 2016 03:45:45 GMT

Dear Yance,

Here the logic

select coep~wtgbtr

INTO CORRESPONDING FIELDS OF TABLE it_coep FROM coep

INNER JOIN csks ON csks~objnr = coep~objnr

INNER JOIN setleaf ON setleaf~valfrom = csks~kostl AND setleaf~setname = setname

FOR ALL ENTRIES IN it_gl

WHERE coep~perio = period AND coep~gjahr = tahun AND coep~wrttp ='04' AND coep~kstar = it_gl-hkont .

Thanks.

Re: ZTable for data selection

Former Member — Mon, 18 Jul 2016 06:08:17 GMT

Dear Habib,

You need to add the additional information like the below logic :

select    coep~kokrs
          coep~belnr
          coep~buzei
          coep~perio
          coep~gjahr
          coep~kstar
        coep~wtgbtr
   INTO CORRESPONDING FIELDS OF TABLE it_coep
FROM coep
INNER JOIN csks ON csks~objnr = coep~objnr
INNER JOIN setleaf ON setleaf~valfrom = csks~kostl AND setleaf~setname = setname

FOR ALL ENTRIES IN it_gl
WHERE coep~perio = period
AND coep~gjahr = tahun
AND coep~wrttp ='04'
AND coep~kstar = it_gl-hkont .

If you query only the amount, then system will not include the same amount into the internal table.

Regards,

Yance

Re: ZTable for data selection

rizaldy_hidayat — Mon, 18 Jul 2016 06:43:35 GMT

Dear Yance,

Thanks for the valuable replies. My problem was solved.

Regards,

Habib