SAP Transportation Management tables or extractors in ECC?

[Loed]

Hi guys,

I'm just trying my luck if there are standard extractors for Transportation Management module which can be found in ECC? I checked our ECC server and some white papers but I think the standard extractors are only available in SCM server?

What are the tables in ECC for SAP Transportation Management where I can create VIEW and make it as a custom datasource for BW? Right now our company doesn't have SCM server, we only have ECC.

What are the other ways for me to extract data in ECC for Tranportation Management reports to be created in BW?

Thank you.

Loed

[RafkeMagic]

You could use function module extractors in stead of views (once you figure out which tables to use - can't help you on that as I have never worked with SAP TMS).

Regarding standard extractors... not sure this will work, but have you checked the 2LIS_08* extractors? We used those (back in the day) for transport related information (but that was before SAP TMS existed).

[Loed]

Hi Raf,

Thanks for the 2LIS_08* extractors, I will check them. Can you guide me for the easiest way to create a generic datasource using function module? Is it better compared to datasource using a view?

Thank you.

Loed

[RafkeMagic]

The best way is to have a look at function module RSAX_BIW_GET_DATA_SIMPLE, you can use this as a "template" for your own function module.

Advantages are, amongst others, you don't have to create a new (database view), you can have selects in "data packages" (like a normal SAP extractor - it works with an open cursor), you can add custom code (which may be necessary from time to time), ...

I only use view extractors in case all my data is in 1 table (or an existing view).

Should you get stuck with the function module, let me know and I'll help you further.

[Loed]

Thanks a lot Raf, I will try to create one and update you. 🙂

Loed