Unable to load data from ECC TO BW

[sri_pamarthi]

Hi Team,

I've one of Z datasource designed using Functional module. Data is available in ECC (RSA3).

While triggering the infopackage with fulll upadate. 0 records are coming and status is showing green.

For reference Screenshots are provided below.

Please assist me how to load all the records which are available.

Thanks & Regards.

P Sriram.

[sri_pamarthi]

Hi Team,

Please find attachment below for the function module code on which the data source was designed.

Please assist me on this issue.

Thanks & Regards.

P Sriram.

[anshu_lilhori]

Just try this:

Replace this line

 if e_t_data [] is initial

with  IF S_COUNTER_DATAPAKID = 1.

see if this works or not.

Regards,

AL

[sri_pamarthi]

Hi Anshu,

Thanks for your reply,

May i know in which line the statement supposed to replace. .

Please assist me on this issue.

Thanks & Regards.

P Sriram.

[anshu_lilhori]

yes in your screenshot you have written the statement as

if e_t_data [] is initial.

Remove this and replace with IF S_COUNTER_DATAPAKID = 1.

Regards,

AL

[arun_kumar165]

Hi,

-->Please perform RSA1 Check,

-->Try to replicate once again .

-->If there are any error message try to paste.

Check your inbound and outbound queue of ecc and bw system .

[Former Member]

Hi Pamarthi,

In SU53, mine was all ok as well. Can you check with Basis admin if you have these roles

SAP_ALL & SAP_NEW.

I too had same issue as you. I was able to see data in RSA3 but infopackage was pulling 0 records with "Green status" with following in details tab " Data might not be present in corresponding table in source".

I would suggest you to ask Basis admin to add above specified roles if not present.

regards,

Vinay

[Former Member]

Hi PAMARTHI,

If you are seeing data in RSA3 and not in BW, one of the probability is authorization.

Can you check with your basis admin if following authorization is present or not. If not then add them, your info package will work.

SAP_ALL & SAP_NEW.

Regards,

Vinay

[sri_pamarthi]

Hi Team,

In SU53, it is not showing any authorization issues.after triggering the Info Package through manually/Process Chain

for reference screenshot is attached.

Please assist me on this issue.

Thanks & Regards.

P Sriram.

[karthik_vasudevan]

Hi Sriram

Did you try running any other infopackages? from the same source system. Also check the job overview in source system.

This is to make sure all connections are good between your source and target system.

Regards

Karthik

[Former Member]

Hi,

If possible put your function module code here.

Are there any hardcodes in code such as user name / time zone restrictions, etc.,?

[KodandaPani_KV]

HI,

are you working on same data source or different data source both systems.

i think you are using other source system data source if yes please check the below points.

in ECC side you are running data source ZREVENUE_TRACKR_FSS then same data source running.

replicate the data source again using RSDS -> give the data source name -> select source system -> replicate the data soruce.

after create the new info pacakae without selections run it check the PSA data count.

[KodandaPani_KV]

Hi,

are you using any selecitons at info pacakge?

which system you are  working its dev or prodction.

if it is the dev create the new info pacagke and run it -> now you will get the data.

while running the RSA3 data for selciton and same slelciton use it at IPK.

Thanks,

Phani.

[RamanKorrapati]

please check required authorization to extract data.

Or lets try to run info pack thru process chains and see. it may pulls data.

is it delta load?

[sri_pamarthi]

Hi Raman,

Thanks for reply,

It is full load..

Thanks & Regards.

P Sriram.

[karthik_vasudevan]

Hi Sriram

Do you have any selections in IP?

Its not throwing any error message, it says no data found. So its better to check if you have any filters maintained in infopackage data selection screen

Regards

Karthik

[KodandaPani_KV]

HI,

if it is full load you will get those reocrds into PSA.

can you share the header tab details?

[sri_pamarthi]

Hi Raman,

How to check required Authorizations are there to extract Data for that Data source.

already triggered info package with process chain, still it is showing same unfortunately.

Please assist me on this issue.

Thanks & Regards.

P Sriram.

[sri_pamarthi]

I haven't maintained any selections for that info package Karthik,.

Thanks & Regards.

P Sriram.

[KodandaPani_KV]

Hi,

you want check the authorizztion issue first run any thing the  use the tcode - SU53.

SU53 will say which authorizaiton objects may required.

take screen shot and send to basis team,

or

they with your team members have sufficient auhorization for running the info pacakge.

Thanks,

Phani.

[karthik_vasudevan]

You have already tried running the infopackage through process chain which is also having the same issue. So I think this might not be an authorization issue. But as others have mentioned, check using SU53 to see if you have authorization issue.

I would like to know if you are able to extract data from any other datasource from the same source system. This would be another easy way to know if you have authorization.

Regards

Karthik

[sri_pamarthi]

Hi Team,

Checked SU53, No authorization Issues, and also tried loading with Process chain is well.

Still unable to bring data from ECC to BW.

able to extract data from other datasource using the same source system.

Please assist me on this issue.

Thanks & Regards.

P Sriram.

[RamanKorrapati]

is this is fresh or new system?

Other than this load, are you able load data by manual info pack execution?

Lets try to run your info pack thru process chains and see.

Lets try to have SAP_ALL or SAP_NEW.

Seek basis team help and ask them to assign BW extraction related authorizations or seek security team help.

thru SU53 you can find missing authorizations on your id.