on 09-25-2015 8:44 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.