SQL Query Required

[former_member222105]

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]

Hi,

Check this thread once

http://scn.sap.com/thread/628225

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/link-between-vbrk-bkpf-783204

It might be helpful

Regards,

Giri

[former_member662097]

Hi

Refer link http://scn.sap.com/thread/711832

Hope it will helpful for you.

Regards,

Shatrughan

[RaymondGiuseppi]

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]

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.