topic SQL Query Required in Application Development and Automation Discussions

SQL Query Required

former_member222105 — Sat, 28 Sep 2013 06:28:52 GMT

Hello Experts,

I want to get net sales value from VBRK Table.

I am thinking to join BSIS,BSAS, BKPF,VBRK Tables.

From BSIS and BSAS Table i want GL Account Number ie. HKONT

From BKPF, I want to track Documents Flown From SD to FI through AWTYP='VBRK' and want to join Billing Document Number VBELN to BKPF=AWKEY.

From BKPF, BSIS /BSAS i want to have Document Number BELNR, and against this Document Number i want required HKONT.

From VBRK i want Net Value NETWR against this Document Number BELNR.

I will put in other words

I want net value from VBRK table

Document Number BKPF or BSIS/BSAS

GL account Number HKONT from BSIS/BSAS

Please send me SQL Query for the same.

Thanks in Advance

Former Member — Sun, 29 Sep 2013 15:42:09 GMT

Hi,

Check this thread once

It might be helpful

Regards,

Giri

former_member662097 — Mon, 30 Sep 2013 04:11:30 GMT

Hope it will helpful for you.

Regards,

Shatrughan

RaymondGiuseppi — Tue, 15 Oct 2013 11:45:05 GMT

Well, you have the tables and the fields, what is the problem in writing the MOVE and SELECT statements , can you elaborate on actual requirement ?

Regards,

Raymond

Former Member — Thu, 17 Oct 2013 14:22:51 GMT

Hi Ismail,

Can you please specify what are your input fileds through selection screen.

Moreover, You can try the INNER JOIN or FOR ALL ENTERIES in your select query to output the data in one internal table.