Skip to Content
0
Former Member
May 13, 2008 at 04:35 AM

Extraction - Order Settlement Data Extraction

426 Views

Hello Experts,

Sorry, my thread went to wrong Sub-forum. hence posting it again.

I have implemented PS Module in SAP ERP 6.0 and SAP BI 7.0 System, BI Cont 3 Add on SP09

I am facing a challenge of pulling Order Settlement Information into BI System.

Let me give a background before i shoot my question,

In PS Module all the PS - Projects Elements are Statistical in nature and (hence) we are using PM work Orders to carry the costs/commitment/plan.

PReq are raised against PM Work Orders and appear as Plan Costs.

PO are raised against PM work orders and appear as Commitment Cost

PM Orders carries the Actual, planned and commitment costs.

These PM orders are then settled to Assets(AUC and Fixed Assets) and Expenses (G/L Accounts),

this happens in 2 phases mainly,

1. during the lifecycle of the project the orders are marked against a AUC (Asset under Construction) and

2. at the end of the Projects the PM orders are settled finally to Fixed Assets and remainder costs are settled as expenses to G/L Accoutns.

I have captured the order Commitment/plan/Actual and WBS Budget Information in BI System Successfully.

The only link missing is the Order Settlement information (to Assets or G/L Accounts) this information is available in tables COBRA and COBRB in ERP System

My Question

Is there a Standard Datasource/Extractor (SAP Business Content Delivered) to pull the *Order

Settlement* information in BI System ?

What are the other ways i can extract this information into BI System (Remmember i am on ERP 6.0 and BI 7.0) i know Generic Extractor is one of the solutions, but i am looking for other options as well.

Any suggestions/answers will be appreciated.

Thanks in advance

Chitrarth Kastwar