Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

batch splits

Former Member
0 Kudos

Hi friends,

I want to display items per batch splits. If Item 10 has 3 batch splits, the line no. will be 10-001, 10-002, 10-003 for each batch split. If Item 20 does not have any batch split, the line number will be 20.

n condition given to me is use last 3 digits of batch split POSNR)

Use VGBEL + VGPOS to determine link of batch split lines to main line.

thanks

himanshu sharma

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Himanshu,

First get all the line items from LIPS table.

SELECT VBELN POSNR UECHA FROM LIPS

INTO TABLE T_LIPS_SO

WHERE VBELN in VBELN

AND UECHA = 0.

u ll get all the line items for that VBELN. Condition should be UECHA = 0.

If UECHA = 0 u ll get the mail line item.

if UECHA contains value of POSNR for that VBELN that means that item is batch split line item of that main line item.

IF NOT T_LIPS_SO[] IS INITIAL.

SELECT VBELN POSNR MATNR LFIMG VGBEL VGPOS UECHA FROM LIPS

INTO TABLE T_LIPS_SO_TEMP2

FOR ALL ENTRIES IN T_LIPS_SO

WHERE VBELN = T_LIPS_SO-VBELN

AND UECHA = T_LIPS_SO-POSNR.

ENDIF.

Thanks & Regards

Santhosh

2 REPLIES 2

Former Member
0 Kudos

plz answer it soon

Former Member
0 Kudos

Hi Himanshu,

First get all the line items from LIPS table.

SELECT VBELN POSNR UECHA FROM LIPS

INTO TABLE T_LIPS_SO

WHERE VBELN in VBELN

AND UECHA = 0.

u ll get all the line items for that VBELN. Condition should be UECHA = 0.

If UECHA = 0 u ll get the mail line item.

if UECHA contains value of POSNR for that VBELN that means that item is batch split line item of that main line item.

IF NOT T_LIPS_SO[] IS INITIAL.

SELECT VBELN POSNR MATNR LFIMG VGBEL VGPOS UECHA FROM LIPS

INTO TABLE T_LIPS_SO_TEMP2

FOR ALL ENTRIES IN T_LIPS_SO

WHERE VBELN = T_LIPS_SO-VBELN

AND UECHA = T_LIPS_SO-POSNR.

ENDIF.

Thanks & Regards

Santhosh