topic Re: ACDOCA Select Query Issue in Application Development and Automation Discussions

ACDOCA Select Query Issue

naveen_yadavs — Wed, 11 Mar 2020 13:13:06 GMT

Hello All, I am fetching data from below select query -

SELECT rldnr,
rbukrs AS bukrs,
gjahr,
belnr,
"docln AS buzei,
drcrk AS shkzg,
hsl AS dmbtr,
wsl AS wrbtr,
zuonr,
sgtxt,
rcntr AS kostl,
anln1,
racct AS saknr,
ps_psp_pnr AS posid,
kunnr,
lifnr,
"wmwst,
kokrs,
awsys,
"projn,
ebeln,
ebelp,
racct AS hkont,
"mwsts,
koart,
ktosl
FROM acdoca
INTO CORRESPONDING FIELDS OF TABLE @lt_bseg
FOR ALL ENTRIES IN @lt_bkpf
WHERE rbukrs = @lt_bkpf-bukrs
AND belnr = @lt_bkpf-belnr
AND gjahr = @lt_bkpf-gjahr.

where lt_bkpf-bukrs = '1000', lt_bkpf-belnr = '1000002099' and lt_bkpf-gjahr = '2020', i got 26 records in my internal table (lt_bseg).

But when i am checking in SE16N with above BUKRS, BELNR & GJAHR, there are 50 records.

Any solution for above issue.

Thankyou In advance.

Regards,

Naveen

Re: ACDOCA Select Query Issue

FredericGirod — Wed, 11 Mar 2020 13:19:07 GMT

FOR ALL ENTRIES removes duplicates result of the fields indicated in the SELECT.

The entire logical expression sql_cond is evaluated for each individual row of the internal table itab. The results set of the SELECT statement is the union set of the results sets produced by the individual evaluations. Rows that appear in duplicate are removed from the results set automatically. If the internal table itab is empty, the entire WHERE condition is ignored and all rows from the database are placed in the results set.

Re: ACDOCA Select Query Issue

RaymondGiuseppi — Wed, 11 Mar 2020 14:21:36 GMT

To prevent the FOR ALL ENTRIES suppression of duplicates I almost always extract the full primary keys of the database table, so no record will be discarded. So add fields RLDNR, and DOCLN (back) to your select and structure.

Re: ACDOCA Select Query Issue

naveen_yadavs — Wed, 11 Mar 2020 15:27:20 GMT

Thankyou Frederic and Raymond,

For your quick response, both of you are right.