Skip to Content
0
Former Member
Jan 17, 2009 at 09:46 AM

datasource enhancement or generic datasource in pp

116 Views

Dear all,

I have a requirement in PP where I have to derive the Production and Consumption Values depending on Work Center, Order, Movement Type and Posting Date.

In Standard Datasources we have the following 2LIS_04_P_ARBPL and 2LIS_04_P_COMP.

But I have problem in using the above data sources:

a) (Production Values) 2LIS_04_P_ARBPL gives Workcenter , Order, Posting Date but does not have Movement Types . I have done some analysis and found out that this Datasource is pulling some fixed movement types by itself. But my requirement is I need to have the flexibility of using Movement Types.

b) (Consumption Values) 2LIS_04_P_COMP gives Order, Posting Date but does not have Movement Types and Workcenter . I have done some analysis and found out that this Datasource is pulling some fixed movement types by itself. But my requirement is I need to have the flexibility of using Movement Types and also I require Workcenter.

I think I cannot go for enhancement of Datasource because the movement types of standard ones are coded internally.

So as an alternative option I think I can go for Generic Data source.

In R/3 the above required values are derived from using tcode: COOIS and tcode: COOISPI.

The values which are derived from COOIS have the underlying tables CRHD, AFVC, AUFM. Build a view on these tables and then build a generic datasource

Now please suggest me what will be the performance issue if I go for Generic Datasource considering the amount of data the underlying tables might have.

Or is there any better way of achieving my requirement.

Suggest !!!!