Abap Query

[Former Member]

Hi all,

I want to generate Abap query in which I want to extract a delivery, delivery creation date, material, qty, net value for a particulat division

I have joined MARA - Division, LIPS - Delivery and other details , VBAP - Net value of the material

The problem is when I lick MARA and LIPS, it works fine and gives the output expected

But when I link VBAP with LIPS to extract the net value.It fails and doesn't show any output

Kindly let me know what changes I need to do

Regards

Vish

[Former Member · Accepted solution]

HI

In the Query

First use the tables as below.

VBAP---LIPS and then MARA

Now join the VBAP-VBELN to LIPS-VGBEL and then MARA-MATNR

After this select the fields. I got the report as desired when i tested in my sandbox

regards

Prashanth

[Former Member]

adad

[former_member209761]

Dear Vish,

Tcode : SQVI

Give a QUERY NAME and CREATE

Give a Title and Data source = Table Join

Mode: Layout Mode

Inside join tables give :

VBAP

VBFA

LIPS

Select VBAP and VBFA

Click on JOIN CONDITONS

Specify conditions

Proposals requested = yes

delete all the =

make VBELN in VBAP linked to VBELV in VBFA i,e enter 1 in the fields from both tables and press enter and you will find =

Come back

Now select VBFA and LIPS

Click on JOIN CONDITONS

Specify conditions

Proposals requested = yes

delete all the =

make VBELN in VBFA linked to VBELN in LIPS i,e enter 1 in the fields from both tables and press enter and you will find =

Come back

You will reach a new screen

'quickviewer 'your query name ' list design

You will find 3 tables in the left part of window.

Select VBAP-SPART and click both SELECT and LIST

take VBFA-VBELN and click LIST

Now from the LIPS, select those fields which you need in your query.

Save and execute the query.

Check and revert back.

Thanks & Regards,

Hegal K charles

[Former Member]

Dear all,

I tried and got the output, but the output is wrong.It shows many duplicate entries and wrong net value

Here is the complete requirement

For a particular division, sales org, delivery creation date I want Delivery number, material, del creation date, qty, item category, net value from the sales order..

Kindly assist

Regards

Vish

[od_manikandan]

Hai Vishwa,

For the similar thread i gave the basic working

Please close this thread.

Regards,

Mani

[Shiva_Ram]

You can use only two tables LIPS and VBAP. For item division, you can find the field in VBAP-SPART itself. You dont need MARA table for this.

Regards,