Skip to Content

CPI-DS error while loading data from S/4 Hana to IBP

trace-log.jpgHello Experts,

I am getting the error

"List of columns provided for batch 7605bd55fa8811e78ac8030c0dfc303f in SOPMD_STAG_SM1LOCATION is invalid"

while loading Location master from Hana to IBP. I am using the Location master template in CPI DS for this purpose.

I am attaching the Trace log as well. Please help in resolving the error.

Regards,

A.Basu

trace-log.jpg (120.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 16 at 11:55 PM

    Hi Basu,

    You may need to check the CPI dataflow mapping configuration from CPI side and the Location master data configuration from IBP side. It is important to map the attributes included in Location only in the CPI dataflow. If you keep facing the issue, please open an incident so we can proceed with the investigation in your system.

    Thanks&Best regards,
    Gabby Guo

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Gabby,

      Thank you for your inputs. I managed to transfer Customer master data from Hana to IBP by the mentioned settings.

      But when i tried transferring Location master, it failed. I checked the data flow and found the Source extractor to be "0PLANT_ATTR". I checked in table ROOSATTR, but did not get the extractor - 0PLANT_ATTR (Location master template).

      Similarly, for Product master the extractor mentioned in SAP help portal is 0MATERIAL_ATTR, but in CPI-DS when we select the Product master template the extractor is 0MATERIAL_ATTR_SOP.

      The extractor for Plant is not present and for Product is different in CPI-DS system and in SAP Help documentation. Can you please suggest how to sort this issue for the extractors, as without updating these, the standard flow is not working.

      product-master.jpg

      Regards,

      A. Basu.

      product-master.jpg (36.5 kB)
  • Jan 19 at 12:35 PM

    Hi Abhra,

    Additional checks you can do, if you still have the issue along with the Gabby Guo suggestions.

    1) Data inconsistency (Check for the special characters)

    2) element data type mismatch with data.

    I have used the Global variables as below which were sufficient in my case.

    Regards

    Prasad Konda

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Prasad,

      Thanks for your inputs. The global variables worked with the mentioned values.

      I have responded to Gabby's comment, regarding the extractors which is causing issues for other master data objects.

      Regards,

      A Basu.

  • Jan 24 at 11:23 AM

    Hi Gabby,

    Thank you for your inputs. I managed to transfer Customer master data from Hana to IBP by the mentioned settings.

    But when i tried transferring Location master, it failed. I checked the data flow and found the Source extractor to be "0PLANT_ATTR". I checked in table ROOSATTR, but did not get the extractor - 0PLANT_ATTR (Location master template).

    Similarly, for Product master the extractor mentioned in SAP help portal is 0MATERIAL_ATTR, but in CPI-DS when we select the Product master template the extractor is 0MATERIAL_ATTR_SOP.

    The extractor for Plant is not present and for Product is different in CPI-DS system and in SAP Help documentation. Can you please suggest how to sort this issue for the extractors, as without updating these, the standard flow is not working.

    product-master.jpg

    Regards,

    A. Basu.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ashish,

      Below is the error in CPI-DS log. When i checked for 0MATERIAL_ATTR_SOP in table ROOSATTR in S/4, it was not found. Instead 0PLANT_ATTR was there. But in CPI-DS system the extractor is 0MATERIAL_ATTR_SOP.

      Error:

      ""(E)(5648:7748) RES-20102 |SESSION __JOB_DSoD_JIT_S4_Product_1516871897966_923|DATAFLOW R3_PAL_PRD_1516871898270_250|STATEMENT <GUID::'2pNJtTMGhHmJFtrwq-FZ1S::Z4y5fKcThEypOV5zD0VO0x' QUERY Query_Join> Query <0MATERIAL_ATTR_SOP> was not found in data flow. Correct the data flow or notify Customer Support. ""

      Regards,

      A.Basu