Load IBP Master data type via HCI DS

[adithya_kambmpati]

Hello Friends,

      Need some guidance on loading IBP Master data types via HCI DS. Our company have recently signed up for SAP IBP Cloud S&OP Product. I have created a planning area by copying standard SAP1 planning area and activated it. Everything is good on IBP side. Now, went to HCI DS to try a simple scenario of loading customer data from Flat file(as source) to IBP master data type. I was able to establish connections successfully to systems. When I try to create a new task under a project and try to pick Target as IBP instance, I can see the Planning area and master data types that are created. However, when I choose any data type as target, it is giving me error message saying, it can be only used as Source.

       If I go and look in Data stores section, I see the table, but it says as usable as Source only. Can you help me understand what I am doing wrong? See the snapshot below:

Thanks in advance..

[Former Member · Accepted solution]

Adithya,

You will see three types of tables when you try to import the IBP tables into HCI:

1. STAG tables

2. Non STAG tables

3. REP tables

1. You can load data into IBP via the tables with STAG in them. When you import the table names with STAG, then you will be able to use them on target side. HCI shall push the data into these staging tables and then IBP shall load the data into core tables from staging area.

2. Tables with out the STAG are used for reading the data from IBP, meaning as source.

3. REP tables are used for IBP internal purposes. We can not load nor read data from these tables.

Hope this helps.

Thanks,

Kiran

[mahlako]

Hi Alecsandra,

I am integrating customer master from a flat file to IBP staging table however I am getting the following error:

<SOPMD_STAG_TTPCUSTOMER\Target_Query> mappings<FILENAME> field of the <Target_Query> schema is not mapped ERROR

The FILENAME field is supposedly the target table name and it should be mapped to the name of the target table in the Transform Details Screen. I've been struggling to get this mapping correct.

I've tried the following:

1. Mapped the field as a global variable with 'SOPMD_STAG_TTPCUSTOMER' as the value
2. Tried to manually map the field as FLATFILE_CUSTOMER.FILENAME in the Map tab of the Transform Details Screen
3. Included an additional field in the input screen named FILENAME to map to the output FILENAME

Please see image of the view of my transform query for the task:

May you please provide recommended steps one should follow to map the field name.Your assistance would be much appreciated.

Thank you kindly

Malebo

[Alecsandra]

Hi Dinesh M,

Once data is loaded to the staging / target tables, IBP will check its consistency / integrity before moving it to the core tables. e.g: if you send transactional data for 10 product ids, but only 8 out of the 10 product ids are defined in IBP master data, the transactional data for the 2 product ids will be rejected and not moved to the core tables.

Best

Alecsandra

[Former Member]

Hi Alecsandra,

I am Integrating location master from ECC to IBP and getting below error log. I am using target staging table SOPMD_STAG_SM1LOCATION. Is it valid table in IBP to push the data for location master?

2019-05-09 17:42:44 (E)(1952:13332) RUN-59108 |Data flow FCG_LOC_ETL_S4_LOC_DATA_FLOW|Loader Target_Query_SOPMD_STAG_SM1LOCATION

Data Services Engine received error message from server. Error message: Target table validity check failed.Unable to load data.""SAPSOPG"".""SOPMD_STAG_SM1LOCATION"" is not a valid "SNOP" target table.. 2019-05-09 17:42:54 (E)(10640:14296) RUN-59108 |Data flow FCG_LOC_ETL_S4_LOC_DATA_FLOW|Loader Target_Query_SOPMD_STAG_SM1LOCATION Data Services Engine received error message from server. URL:

Regards,

[adithya_kambmpati]

Thanks Alecsandra and Kiran. I was able to complete the transfer. Thanks once again for helping me understand some basics about tables.

[Alecsandra]

Hi Adithya,

You can only use STAG (staging) tables as target for your data flows. HCI sends data to the staging tables only. After IBP successful post-processing data will reach the core tables.

Please include same tables but with STAG suffix.

Rgds

Alecsandra

[former_member494013]

Hi Alecsandra ,

Just to understand .. Any reason why we use stag table before core table to write? What will happen inbetween stag to core table?

Thanks,

Dinesh