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

[Loed]

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

[former_member587269]

Hi Loed.

I have the same problema as you. I need to add Company Code (BUKRS) to the extractor 2LIS_03_BX. I have changed the Table ROOSFIELD so that the field now appears in the structure of the datasource however I dont know how extract the values for this field.

The attribute 0COMP_CODE of 0PLANT is NOT suitable since the company is not 'Retail' and therefore doesnt have 0SALESORG which is used to populate 0COMP_CODE in the transformation of 0PLANT.

Just as you mentioned, I do not want to use 2LIS_03_BF as a solution, due to performance.

Have you any suggestions? What abap code did you add to reach the value of 0COMP_CODE (BUKRS) in the extractor 2LIS_03_BX?

I hope you can help please.

Many thanks

Michelle

[Loed]

bibyrne

Get the company code from T001K table using the plant field from 2lis_03_bx.

Regards.

Loed

[former_member71289]

Hi Loed,

SAP Note 2678507 'SAP ERP / S/4HANA Inventory Management in SAP BW/4HANA'

might help: (chapter 4.a 'Tips & Tricks'):

Enhancing the /IMO/D_MMIM01 or /IMO/D_MMIM02 advanced DSOs with additional characteristic

• These additional characteristics must be updated from the 2LIS_03_BX InfoSource, as well as from the 2LIS_03_BF and 2LIS_03_UM InfoSources
• The following enhancements are possible:
  • Valuation type (0VAL_TYPE) - Source field from 2LIS_03_BX/BF: BWTAR
  • Company code (0COMP_CODE) - Source field from 2LIS_03_BF/UM: BUKRS
  • Valuation area (0ID_VALAREA) - Source field from 2LIS_03_BX/BF/UM: BWKEY
  • Sales order (0DOC_NUMBER/0S_ORD_ITEM) for sales order stocks - Source field from 2LIS_03_BX/BF: KDAUF/KDPOS
  • Project number (0WBS_ELEMT) for project stocks - Source field from 2LIS_03_BX/BF: PS_PSP_PNR

Enhancement possibilities for 2LIS_03_BX:

• Note that the 2LIS_03_BX DataSource cannot be extended in the same way as the 2LIS_03_BF DataSource, for example. Only SAP can enhance this DataSource. Other enhancements are no longer useful since fields, such as the movement type, G/L account or profit center do not in appear in the stock tables (for example, MARC and MARD) but only in the movement tables (for instance, MSEG).

• Evaluation restrictions that occur as a result (similar to the two preceding points) can only be resolved by a data enhancement (for example, reading from a DataStore object with all material movements) subsequent to the extraction or by not using 2LIS_03_BX. In both cases, all material movements must exist in the source system. If this is not the case, you must read from the corresponding archive files for the extraction.

Best regards,

Andreas

[Loed]

Thanks Andreas, I already read it before posting.

Loed

[former_member71289]

Hi Loed,

true that, you mentioned the SAP Note(s) already in your post.

Just to summarize: Following the SAP Note 0COMP_CODE could be enhanced to the 2LIS_03_BX extract structure, the others you mentioned not. The Note says that it might be possible to read missing information from the movements but which information can be read and from where is depending on the business processes / configuration and can be highly complex.

If you are lucky the valuation class for example has a 1:1 mapping to a GL Account (e.g. table T030) and the Company Code as mentioned you could get via BX extension or alternatively, it might be also easier possible just to use the navigation attribute Company Code of the plant (InfoObject 0PLANT) instead.

Actually, I would be also very interested to hear from others if somebody has done the stock reporting just based on movements and what the experience is. As you said, it is only possible if you have all movement data available. It depends also on the number of data records if it is actually feasible...

All the best for your project Loed,

Andreas