cancel
Showing results for 
Search instead for 
Did you mean: 

Open Orders and COPA Cube

Former Member
0 Kudos
104

Hi,

I have a specific requirement, where we want to add open orders from sales to the existing COPA cube and also we want Existing Open order/sales pipeline reports in SAP to be moved into BI.

Can any one help me on how to go about this and what should be the best apporoach to achieve this task.

Any help technically and functionally will be very helpful

Regards

Vishwanath

Accepted Solutions (1)

Accepted Solutions (1)

sven_mader2
Active Contributor
0 Kudos

Hi,

don't load open orders in the same infocube. Create a new one.

there are two options:

1. copy the ERP-report to a datasource. and load every day this data to a infocube.

2. look at the LO datasources in LBWE. calculate the open orders with

- order receipt

- reason for rejection

- order status

- deliveries

....

Sven

Former Member
0 Kudos

Hi Swen,

Thanks for the reply and suggested methods.

What do you mean by copying the report to the datasource? What is the process for that?

Second how to calculate the open orders from the fields listed by you. Can you elaborate on this and give me the complete solution to begin.

Regards

Vishwanath

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Viswanath,

You can evaluate Open orders using datasources 2LIS_11_V_ITM and 2LIS_11_V_SCL.

We extract COPA data by creating a datasource using trasaction KEB0. This datasource would be based on tables CE1**** to CE4****, where **** is the name of the operating concern. These tables get generated when the functional consultants create the operating concern in ECC. What data flows into these tables is controlled by the rules set by the functional folks. Unless the data that you need exists in these tables, you cannot get it otherwise using the datasource. You would need to check in the tables whether the data needed exists there.

Former Member
0 Kudos

Hi Murali,

How about the idea of getting the results of the report output in a datasource and load daily. What will be the procedure for that. I guess it will be flat file loads.

Regards

Vishwanath

Former Member
0 Kudos

Hi Viswanath,

You could create a Funtion Module based datasource and implement the logic from the ABAP report in ECC to get desired data.

You can find good docs on SDN regarding FM based datasources.