Integrating Purchasing & FI-AP in single report

[Former Member]

Hi Friends,

I have got the requirement of getting data from Puchasing & FI-AP into single reports, actually i was told by PM to give the data in single report.

I was given 47 fields & 2 value fields from 8 tables, those are given below

for PURCHASING:(Tables) for FI-AP: (Tables)

EBAN LFA1

EKPO YFBILLREG

EKKO YFEPAYBATCH

MSEG BKPF

MKPF

in those there are two customized tables and the remaining tables are sap defined tables.

can anybody give me the suggestions saying that how to follow, and how to achieve this strategy using generic extraction ?

it's very helpfull for me, if anybody gives step-by-step analysis in doing this.

Regards,

Balaji

[Former Member]

Hi,

Before you get into creating views etc, please check your exisitng BW setup. You would be getting in purchasing and AP data into BW. If you are, then, you need to work out what fields are missing from these areas in your current scenario. You will have the following cases:

1. Fields missing in Data targets but available in data source

2. Fields missing in Data targets and in data source

Evaluate whether you need to enhance the data source or data target for these additional fields.

For the first case, if you have retained your PSA, then a modification to the data target and a subsequent reconstruction will populate the fields. if not then you can use a flat file.

In the second case, you can re setup data. If that is not possible, then create a generic data source using RSO2 in R/3 and get these fields into the exisitng data target or a new one. You also have the option of, as a one time effort, extract the data into a flat file and update the earlier records after modifying the data target.

For the Z tables you can get them in as a separate datasource/data target. decision to form a view will be yours.

Once you have them in, an infoset (if all data targets are ODSs') or a multiprovider can be used to deliver the reports. An infoset uses a join whereas a MP uses a union to pick up records.

Rgds

[Former Member]

You are not going to like this answer..

One AP invoicie cam be for multiple purchasing line items or even purchase orders - so you can't really put purchasing doc info onto the AP cube

Of course if your PO/AP config is a one to one match then yes you can cmod the data in

A way around it - is to

Enhance GL4 to bring in the EBELN and line item from BSEG on the std CI_BSIS include

Then info set AP4 to GL4 based on Co Code, Doc No and year - add an infoset of Purchasign line items and link GL4 to Purchasing line items on purchasing doc no and line item

Add the extra indexes on the ODS objects

Then create a report where with whatever selections you want

(just so happens - I am doing exactly the same thing right now)

[Former Member]

Hi,

First of all determine the fields that you require fro the Tables to do your BW reporting and also determine their Join conditions.

Create a View with respect to the Requirement and create a Generic data source.

Gereric Extraction can be done in 3 ways.

If you go to transaction RSO2 in R/3 side, provide tech name for data source and click create.

you will get the 3 options.

1)From a DB Table

2)From a DB View

3)From Functional module/ Infoset Query

in first option you can directly give a standard or custom build talbe name. in second option you can select the necessary fields from more than one talbe(eiter standard or custom). In third option you will create a function module or Query to extract data. When creating function modules you can use standard function modules as a template e.g. RSAX_BIW_GET_DATA_SIMPLE.

Also check this link for more details...

http://help.sap.com/saphelp_nw04/helpdata/en/3f/548c9ec754ee4d90188a4f108e0121/content.htm

Hope its helps for you...

Regards,

Vidhya

[Former Member]

Hi Vidhya,

Thanx for your replay, how to determine join conditions, can you pls tell me in detail that giving join conditions? and also in this scenario i have got 9 tables (two customized & 7 SAP Defined tables), can we do view on these tables?

Regards,

Balaji

[Former Member]

Hi,

View can be created on any number of Tables...

View is just a structure which combines fields from n number of tables using certain conditions. These conditions are called as Joins...

To have more idea on creating views and jooins have a look at the follwing link:

Views: http://help.sap.com/saphelp_erp2005vp/helpdata/en/cf/21ecf9446011d189700000e8322d00/frameset.htm

Joins:

http://help.sap.com/saphelp_erp2005vp/helpdata/en/cf/21ecf9446011d189700000e8322d00/frameset.htm

Regards,

Vidhya