Loading of Data sent from HCI to IBP STAG tables to Core Tables

[Former Member]

Hi Experts -

I'm just curious on what's the next steps after loading the MasterData coming from ECC (for example LocationMaster) to IBP. The Global variables are defined (I guess this is how the post processing triggers stag tables to core tables in IBP) but when I check it in IBP, the data coming from source is loaded already in stag tables, but still not seeing it in core tables. Is there anything I need to do from HCI perspective for that to be loaded in Core tables?

Cheers,

R-jay

[parveen_kumar6 · Accepted solution]

Hello R-jay

Once the data is loaded into staging tables in IBP, then no further action is required from HCI side. The CRON Jobs will trigger the post processing from Staging to core tables in HANA.

You need to make sure that CRON jobs setup is properly done in the HANA Database.The CRON job set up will be done by SAP in case of Cloud based system whereas you will have to do the CRON Job set up in case of on-premise.

I can suggest you next steps based on what system you are using Cloud based or on premise system.

Thanks

Parveen Kumar

[Former Member · Accepted solution]

Hi Praveen,

We're using IBP on demand (cloud).

Cheers,

R-jay

[parveen_kumar6 · Accepted solution]

Hello R-jay

What is the status of the Data Integraiton Job in IBP system?  If it is successful, then data should have reached the core tables.  Otherwise, you can create an OSS message with SAP to check why the data integration jobs are not successful or verify the CRON job setup in your system.

Thanks

Parveen Kumar

[Former Member · Accepted solution]

All runs made from HCI to IBP (SAPSOPINTEG) are Green (successful).

Another question for this. I'm not if got to have a clear outcome in IBP, if data is manually uploaded to IBP, you see the following details?

- FileName

- Data Type

- Data Name

- Duration

- Total records

- Successful Record(s)

- Rejected Record(s)

- and data can be download

I guess this is because it's directly loaded to the core tables.

For Data Loaded coming from HCI, you only see Data in Duration and file can't be downloaded (probably because this for staging tables)?

I guess I just have to raise an OSS for CRON job setup verification for this system we have.

I'll update you with the result Parveen.

Cheers,

R-jay

[parveen_kumar6 · Accepted solution]

Hello R-jay

Even if you directly upload the data in IBP using flat files, the data will still go to staging table first. The Post processing remains same for data integration and HCI jobs. You should be able to see all the details in IBP for HCI jobs in a similar way you see for data integration jobs in IBP.

I think there is already an OSS message for this. When I looked at this message, the HCI Agent was not available. So I couldn't run the task to reproduce the issue.

Can you check the HCI agent setup and send the message back?

Thanks

Parveen Kumar

[Former Member · Accepted solution]

Hi Parveen,

We had the Agent running again yesterday. Let me know if the authorization you have in HCI is sufficient. Thanks!

Cheers,

R-jay

[Former Member · Accepted solution]

Hi,

Is your issue resolved?

You are suppose to specify filename in HCI Dataflow.

E.G. assume you have developed masterdata Dataflow.

Target Staging Table = XYZ_STAG_TABLE

You need to specify name of this table in HCI dataflow (last mapping).

Target Field name = Filename

Value in mapping tab = 'XYZ_STAG_TABLE'

This is mandatory.

This will ensure your data is loaded in core table in IBP and you should also be able to download Error Report / Complete report from IBP.

Thanks,

Purav

[Former Member · Accepted solution]

Hi Purav - Yes, it's already resolved. Thanks!