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

unable to display new billing no for order no having same item

Hi, All.

In my report i m displaying billing no. and delivery no. for the order no.

I m able to display all the billing and delivery no. , but i m not able to display records for the order no. which has same item no. but 2 different billing and delivery no.

e.g.

order item billing no

8546 10 90000069

90000070

delivery no

80000186

80000187

I m able to display only first row of this.

so, pls give me proper solution ASAP.

Thanks & Regards,

Sandip Sonar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 08:42 AM

    Hi

    Could you provide the code which you are using to diplay those details?

    I feel you are doing that in LOOP...ENDLOOP. Provide the code so that we can suggest the changes.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      SELECT avbeln bposnr aaudat bwerks a~kunnr

      FROM vbak AS a INNER JOIN vbap AS b ON avbeln = bvbeln

      INTO CORRESPONDING FIELDS OF TABLE itab

      WHERE a~vbeln IN s_vbeln

      AND a~vkorg IN s_vkorg

      AND a~erdat IN s_erdat

      AND a~vtweg IN s_vtweg

      AND a~spart IN s_spart

      AND a~auart IN s_auart

      AND b~werks IN s_werks

      AND b~matkl IN s_matkl

      AND b~matnr IN s_matnr

      AND a~kunnr IN s_kunnr

      AND a~vbtyp EQ 'C'.

      LOOP AT itab.

      SELECT SINGLE vbeln FROM lips

      INTO itab-dvbeln

      WHERE vgbel EQ itab-vbeln

      AND vgpos EQ itab-posnr.

      SELECT SINGLE bldat FROM likp INTO itab-bldat WHERE vbeln = itab-dvbeln.

      SELECT SINGLE vbeln FROM vbrp INTO itab-ivbeln WHERE aubel = itab-vbeln AND aupos = itab-posnr.

      .

      MODIFY itab.

      CLEAR itab.

      ENDLOOP.

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 08:44 AM

    Have you checked replies in your other thread??? and Stop posting duplicates threads on the same query.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 08:45 AM

    Hi Sandip ,

    how are u Threads u will creates on the same issue , as i told u , u need to check the internal tables , based on the data u need to loop.

    loop at so_item.

    loop at del_item.

    loop at invo.

    append output --->if SO have Billing .

    endloop.

    endloop.

    endloop.

    its 1:N:N relations , so just u need to loop as per it.

    regards

    Prabhu

    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.