Skip to Content
Author's profile photo Former Member

Work around for Displaying multiple line items to single line item

Displaying Multiple Line Items to Single Line Item in Output table :-


Suppose we have below scenario,

We have internal table t_vbrp ,which is having 3 fields, VBELN, PARVW, KUNNR. In this internal table there are multiple records of same VBELN based on PARVW.

  1. e.g for VBELN ‘0020395017’ , three records are existing as Partner Function(PARVW) is different.

/wp-content/uploads/2013/09/img1_285063.png

Now in the Output table , if we want our output into single record (VBELN as the key ) means Sold to , Bill to , End user should be fill according to the Partner Function(PARVW) and it should come as one record as VBELN is same.

vbeln

Sold to

Bill to

End user

0020395017

0070001424

0070001424

5070247006

For this purpose, following code can help.

/wp-content/uploads/2013/09/img2_285064.png

Output:-

/wp-content/uploads/2013/09/img3_285065.png

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      nice explanation!!

      Author's profile photo Former Member
      Former Member

      Gud One Raghu!!!

      Author's profile photo Former Member
      Former Member

      Thanks Lokesh 🙂

      Author's profile photo MANASI DEORE
      MANASI DEORE

      hi can you please explain how you have added multiple entries of Kunnr for same vbeln?