Skip to Content
0
May 20, 2019 at 01:47 PM

BUKRS, PRCTR, BWART, SAKTO, KOKRS - no data in 2LIS_03_BX after editing ROOSFIELD

493 Views

Hi guys,

I need the fields below for my 2LIS_03_BX datasource.

BUKRS, PRCTR, BWART, SAKTO, KOKRS

They are hidden by default but was able to show them after editing the value of the field SELECTION in the ROOSFIELD table.

However, after extracting data for 2LIS_03_BX, those fields are still blank.

How can I get the values for the mentioned fields? Is there another way to do this? What is the proper way of doing this?

I read the notes 586163 and 2678507 and I found out that 2LIS_03_BX must not be modified since the fields like the one I needed are not present in MARC nor in MARD. So I think the only way is to have a lookup table upon loading 2LIS_03_BX in BW. However, the note did not state what should be the lookup table so I can create a customized datasource using it. I'm not sure if there is a special table (movement table) for this scenario? Any one here have the same issue? Or what should be the conditions for the lookup to work in MSEG (I believe this is the 2LIS_03_BF) table?


I also tried to think of removing the 2LIS_03_BX in the inventory design since all the fields mentioned are present in 2LIS_03_BF but I saw some disadvantages like I should be loading all of the 2LIS_03_BF data from the start instead of 2018 and above only. Any one here already tried to remove 2LIS_03_BX in their flow?

https://answers.sap.com/questions/429983/is-loading-of-2lis-03-bx-datasource-mandatory-in-i.html

NOTE:

I needed the values of the fields above because the users wanted to analyze the report by COMPANY CODE and GL ACCOUNT using MB5L report/tcode in ECC.

Thank you.

Loed

Attachments

delete.png (27.1 kB)
delete.png (29.6 kB)