Requirment ( Split material in line based on Quaintity )
I found many of people to face a trouble on quick one to split rows based on Quantity.
In this blog I will discussed how to split row based on Quantity.
Let’s begin with our learning.
Step 1. Create a structure using SE11 Or Create in Program
For full fill your requirement you need to create structure in SE11 or also you can create internal declaration
DATA:GT_MAIN TYPE ZST_SPLIT_QUANTITY,
GT_MAIN_TMP TYPE ZST_SPLIT_QUANTITY
When you have a multiple material in your (Result Table i.e below snap) for this you need to create or append a multiple split based on Quantity.
Step 2. Write your Query statement to return data into your Result Table.
For this you can write a query using (Inline Declaration or INTO CORRESPONDING FIELDS OF TABLE)
Step 3. Write your logic.
SORT LT_MAIN_DATA BY MATNR ASCENDING.
LOOP AT LT_MAIN_DATA INTO DATA(LS_MAIN_DATA).
VALUE # (
FOR J = 1 UNTIL J > LS_MAIN_DATA-MENGE
MATNR = LS_MAIN_DATA-MATNR
APPEND LINES OF GT_MAIN_TMP TO GT_MAIN.
//This will append a GT_MAIN_TMP to GT_MAIN
*For purpose to move this in GT_MAIN_TMP when For loop run to next item then the previous on is *disappears ( That’s why need to append this to other table.
Now you can work on this kindly of requirement easily like this.you can slipt any line based of Quantity
For assigning a value to table must sequence of your fields.
For further any query feel free to ask OR share you feed back and query through comment section .