Application Development and Automation 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: 
Read only

Infoset - Check database table with internal table

antonio_bruno
Participant
0 Likes
563

Hi,

I've created an infoset based on VBRK and VBRP and the internal table NC2 with the following structure:

data: begin of NC2 occurs 0,

VBELV like VBFA-VBELV,

POSNV like VBFA-POSNV,

VBELN like VBFA-VBELN,

POSNN like VBFA-POSNN,

AUDAT like VBAK-AUDAT,

end of NC2.

I want extract only the records (related to VBRK-VBRP) relevant in relation to the internal table. I've tried with:

LOOP AT NC2.
CHECK: VBRK-VBELN = NC2-VBELN
and VBRP-POSNR = NC2-POSNN.
endloop.

But doesn't work, the report display all the records of VBRK-VBRP not only the invoices relevant for the internal table.

How I can select from the table used in the query only the records in relation to the internal table?

Thanks and regards.

Hi,

I've created an infoset based on VBRK and VBRP and the internal table NC2 with the following structure:

data: begin of NC2 occurs 0,

VBELV like VBFA-VBELV,

POSNV like VBFA-POSNV,

VBELN like VBFA-VBELN,

POSNN like VBFA-POSNN,

AUDAT like VBAK-AUDAT,

end of NC2.

I want extract only the records (related to VBRK-VBRP) relevant in relation to the internal table. I've tried with:

LOOP AT NC2.
CHECK: VBRK-VBELN = NC2-VBELN
and VBRP-POSNR = NC2-POSNN.
endloop.

But doesn't work, the report display all the records of VBRK-VBRP not only the invoices relevant for the internal table.

How I can select from the table used in the query only the records in relation to the internal table?

Thanks and regards.

0 REPLIES 0