2LIS_03_BF

[Former Member]

One tricky req, has come I want experts ur opinion whether we can do it or not...

say I get a consignment movement record in 2LIS_03_bf having quantity 6....now this is a single record...

Can I split this into 6 records with quantity 1.

Say 2LIS_03_BF

-

---

Mat_Doc Mat_Item year Special stock Qty

40000001 1 2005 W 6

Desired output of 2LIS_03_BF

-

---

Mat_Doc Mat_Item year Special stock Qty

40000001 1 2005 W 1

40000001 1 2005 W 1

40000001 1 2005 W 1

40000001 1 2005 W 1

40000001 1 2005 W 1

40000001 1 2005 W 1

-

---

Can this be done in BW or R/3 extractor side.

I am using 2LIS_03_BF.

Anyhelp will be greatly appreciated & rewarded with points.

Monica

[Former Member · Accepted solution]

Hi Monica,

You can do it in the start routine of update rule.

Regards

Praveen

[Former Member]

hi Monica

YOu can do it in update rules using 'Return Table'option.

But you need to split it based on time chars...

Hope it helps you

Thanks

Teja

[Former Member]

Praveen,

So we can not do it on R/3 side...that extract will give us 6 records rather than 1.

Just making it clear.

Thanx in advance.

Monica

[Former Member]

You can do it in the exit (though SAP documentation mentions to use the exit only to add fields, not records) on R/3. Theoretically it is possible (I have done similar in test scenarios).

You can also use the 'return table' option in update rules on BW to split one record into n.

[Former Member]

Hi Monica,

I am not very sure if we can do it in R/3 side, but splitting the recors at R/3 side for a std extractor may not be that simple. Its better to do that in BW side. Also your requirement seems to be simple and can be designed in BW easily.

Regards,

Praveen

[Former Member]

Hi Monica

I agree with Praveen's suggestion that you should not change the way the records are populated for standard extractor on R/3 side. I would suggest that once you get the records on BW side, you can perform this desired operations on it on BW side.

Regards

Pradip