Skip to Content

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

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply