update TargetTable
set ItemQty = null
where (ItemID, ItemNb, PC, ItemQty) NOT IN
(SELECT A.ItemID, A.ItemNb, B.PC, A.ItemQty FROM Table1 as A
inner join
Table2 as B on A.ItemID = B.ItemID)
Error - sql processing error: invaild ColOffset ...
We have a calculation view in the HANA source system with a mandatory input parameter, Using CPI-DS can we load the data keeping calculation view with IP as the source and IBP as the target.
All,
We have requirement to pull the IBP KF and MDT data from IBP to Power BI using Odata service.
I went over the help document to get the format on how to construct the API query to pull the data but i was not able to find the example API query...
Hi All,
During my SAP IBP 300 training, I came across an option to upload the data to IBP PA using sftp.
Can some please help me with the link or the document to do this setup where I can upload the data extract from CSV file to SAP IBP using sft...
We have a CPI-DS Task which is transferring the data from IBP to SQL Server table
We have observed that when the task is executed around 11M records are getting transferred from IBP to SQL server table. In our analysis of the data in the table we f...
Thanks, Ajay.The KBA which you have shared is still pointing to old Odata service.IBP help doc says to use /IBP/EXTRACT_ODATA_SRV OData Service. Can you please share the KBA around this service.Thanks,Adam