cancel
Showing results for 
Search instead for 
Did you mean: 

How to create Generic DS based on FM and Delta on Calday

kr_pavankumar
Contributor
0 Kudos

Hi Experts,

Could you please tell the steps to create a generic datasource based on Function module and delta should be on calday.

For Example, On KONV table i need a Z FM(copied from the standard RSAX_BW_GET_DATA) and delta should be based on the KDATU field.

how to achieve delta? Could explain the logic and how delta works in this scenario?

-- KRPK

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member192933
Active Participant
0 Kudos

Hi Pavan,

Please go through this document.

http://scn.sap.com/docs/DOC-33246

Regards,

Anjali

RamanKorrapati
Active Contributor
0 Kudos

Hi Pavan,

b4 creating the generic data source , first u need to create a structure at SE11, select table type, there u create structure, then go to T. code - RSO2, provide data source name, go with create button, next screen provide structure name and click on extraction by function module provide all descriptions and save n generate, next screen, hide,selection, reverse and  field known exit  choose as per ur business concern save data source and generate it..

u can check ur data source puling data or not at RSA3 at R/3 side.

below screen will help u more with screen shots. go thru it

   http://www.saptechnical.com/Tutorials/BI/Datastore/Index.htm

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8d...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8d...

Hope this may help you,

Regards

former_member363950
Participant
0 Kudos

Hi Pavan,

For the delta setting in rso2, click on Generic delta (F9), and in the register "Delta Specific Field"

1. select or Enter the Field Nm "KDATU"

2. and select calendar Day without selecting Real-Time Enabl

For setting between New status or additive Delta:

3.a. Additive delta

The key figures for extracted data are added up in BW.

Data Sources with this delta type can supply data to ODS objects and Info Cubes.

3.b. New status for changed records

Each record to be loaded delivers the new status for the key figures and characteristics.

Data Sources with this delta type can write to ODS objects or master data tables.

Hope this would help

K. Regards

kr_pavankumar
Contributor
0 Kudos

I would like to Thank both of u.

Could you please share a document or link of Generic DS based on FM copied from RSAX_BW_GET_DATA.

-- KRPK

RamanKorrapati
Active Contributor
former_member363950
Participant
0 Kudos

Hi Pavan,

Execute the transaction RSO2.

Depending on the text, attribute or transactional data you want to load in BI, enter a the datasource name you want to create in the correct field, and then enter your function module name in the corresponding field, and click on create, to create your generic datasource.

In the next window, you would select whether the ds shall be delta or not, and then define which field will correspond to the delta.

For you function module, just compare the corresponding fields fom the structure and transparent tables from fm RSAX_BW_GET_DATA to yours. And do not forget the initialization in the others function group includes and fm.

I hope this would help you.

Br.