Skip to Content
author's profile photo Former Member
Former Member

Abap Query

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2011 at 12:23 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2011 at 12:43 PM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2011 at 01:35 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2011 at 03:20 PM

    adad

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.