Issue with LOCFR transfer with CPI

[ydyulgerov]

Hello everyone,

am using a custom created data flow for transferring source list information. For all materials that are received from an external vendor I have no problem. But I have also intercompany transfer between two Plants. Unfortunately, CPI does not transfer those records - for example plant 1000 is the Location From and plant 2000 is the Location (the receiving location). Both Location IDs are maintained in the Master Data Location and are visible in Location From MD (which is a subset of Location MD).

Within the rejection report from the CPI, I get the message 'Foregin key violation' and 'Check that the matching value exists in object LOCFR.'

I am really confused. Any help will be highly appreciated. Thank you very much in advance.

Best regards,
Julian

[piyush_parekh · Accepted solution]

Hi Julian,

Can you share what do you see in View Design time data in CI-DS against LOCFR field for mentioned transform?

Regards,

Piyush

[ydyulgerov · Accepted solution]

Hi Piyush Parekh,

yes, I am sharing a screenshot from the query after the transform, because the transform itself is an abap aggregation.

Maybe the problem is in the '000000' in froont? I will check it. Maybe 0000001000 should be defined as a supplier in MDT Location?

Best regards,
Julian

[piyush_parekh · Accepted solution]

Hi Julian,

Yes, you need to remove leading zeros. For IBP, 1000 and 0000001000 are 2 different locations. I would suggest to remove leading zeros as I can see same has been done from LOCID as well.

Regards,

Piyush

[ydyulgerov · Accepted solution]

Hi piyush.parekh,

Yes, the leading zeros caused the issue. Thanks a lot to everyone.

BR,
Julian

[ydyulgerov]

Hi ayanbishnu1981,

Unfortunately, this does not work as well.

BR,
Julian

[AyanBishnu]

Now I am out of options as well. Everything looks ok but still the error is coming. Are you also getting the error if you are manually updating the location source from the master data excel sheet ? Better to raise a OSS to SAP

[ydyulgerov]

Hello ayanbishnu1981,

Thanks for you answer.
Yes, both locations exist in MDT Location:

In the CPI I am maping LOCFR with LIFNR from the standard table EORD and the field WERKS with LOCID:

As I mentioned, with all materials that are received from an external vendor I have no problem. But when I have transfer between two plants for example LOCFR = 1000 and LOCID = 2000 , then I got the rejections.

BR,
Julian

[AyanBishnu]

Hello Julian

Please check the following

• In the location from MDT please check if it is matching with the below screenshot
• 
• in the location source MDT please check the following

• 

• and if the attribute checks are on for location source MDT, then please remove it.
• Purge all the exisitng records in the location source MDT and then reload

Let me know if that works

[ydyulgerov]

Hello ayanbishnu1981,

I checked both master data types - LOCATIONFR and SOURCELOCATION and both are as per your screenshot (including same checkboxes, etc.). Attribute check of the MDT SOURCELOCATION is also turned off. I tried numerous times to reload the master data, but there is no effect.

Best regards,
Julian

[AyanBishnu]

from the screenshot I see that in the location MDT 1000 and 2000 are marked as X in the validity attribute. Can you please unmark that and try to update the location source. its a kind of far fetched idea but please give it a try

[AyanBishnu]

Hello yuliyand

thier is a separate MDT called LOCFR, which is a reference MDT in IBP and it refers to the LOCID only. Although you cant maintain anything directly in LOCFR MDT, but please recheck if the MDT exists and that it is refering to the LOCID MDT.Also if you can share screenshot of the transformation for the CPI flow highlighting the source field in the table that is mapped to the LOCFR attribute in the LOCATIONSOURCE MDT, that would helpful

[piyush_parekh]

Hi Julian,

Please check what is the attribute check enabled for location source MDT. For e.g., if attribute check is enabled with Location and Product ID in Location Product MDT, make sure Product ID is extended to both the locations.

Regards,

Piyush

[ydyulgerov]

Hello Piyush,

Thanks for your reply.
I checked MD and for Location Source MDT - I have no attribute check maintained. For Location Product MDT - I have attribute check maintained but only for planning unit (SPA).

I updated also my Location Product MDT so that I extended my PRDID to both Location IDs.
Unfortunately, there is still no results. Those records get rejected by the CPI with the same rejection reason.

Best regards,
Julian