SAP IBP Transport Receipts for components

[ydyulgerov]

Hello everyone,

I have the following scenario and issue. I have a FG, a SG and RMs and after running the supply heuristics in IBP I get my production receipts for my FG and SG. But let's say that RM1 is externally procured from Vendor1 and RM2 is procured from Vendor1 or Vendor2.

Both vendor locations are defined in Location master data with a location type 'Supplier'. Valid purchase info records from S/4 for those raw materials are also transferred to IBP. In the Location Source master data in IBP the records for 'Ship from LocID' - 'LocID' - 'ProductID' with the corresponding 'Location Transport Ratio' are also maintained.

The issue is that I do not see any transport receipts for the raw materials. I checked my Location Product master data and I have combinations for all my materials with my plants but no combinations with material and vendor location? I tested also with manual creation of one such combination and the issue was resolved for this particular material. But if this is the reason that I miss the transport receipts, how can I get all location-product combinations for the product-vendor combinations?

Thank you very much in advance.

BR,
Julian

[SatishWaghmare · Accepted solution]

Hi

You need Vendor-Product records created in Location Product MDT in IBP. Please make sure those Vendor-Product record has appropriate Subnetwork on it.

Vendor-Product records can be created by using below staging tables. I suggest use appropriate target query along with join condition and filter criteria. Following extractor / staging tables will allow you to achieve that :

/IBP/LOCATIONPRODUCT_ATTR

/IBP/SOURCELOCATION_ATTR

/IBP/LOCATION_ATTR

Join Condition could be : "/IBP/LOCATION_ATTR".LOCID = "/IBP/SOURCELOCATION_ATTR".LOCFR

Filter condition could be something like this : "/IBP/LOCATION_ATTR".LOCTYPE = 'V' or "/IBP/LOCATION_ATTR".LOCTYPE = 'S'

Please setup CPI-DS task as given above and let me know if it helps resolve the issue.

Thank you

Satish Waghmare

[AyanBishnu]

Hi Julian

In case you are not leveraging the SDI ADDON and the staging table in S4 HANA, I recommend you use that. The problem that you have stated is due to the reason that the Product and vendor combination is not present in the LOCPROD master. But still you have the LOCATIONSOURCE MDT updated with the proper combination.My advice is as follows.

1) in the LOCATIONSOURCE MDT put the attribute check on to make sure that if the PRODLOC combination doesnt exist in the LOCPROD MDT it wont allow CPIDS to update the LOCATIONSOURCE MDT with vendor as LOCFR location as LOCID and product as PRDID.

2) in the SDI staging table is S4 HANA activate the BADI that allows you to include addtional field in the MARC_EXT table. Their you can se the BADI to update the MARC_EXT table with product and vendor combination and then leverage this same table using CPIDS tp update the LOCPROD MDT so that all combinations are updated in the LOCPROD MDT.

Hope this helps

[ydyulgerov]

Hi Girish,

Thank you for your reply. I see your point, but I would like to keep it more simple. Is there any other way to maintain all Prod-Loc combinations between products and vendors directly from S/4? With the transaction codes I can integrate materials but together with plants.

BR,
Julian

[former_member654033]

Hi,

You can use attribute as a KF concept at location product level to create planning object combinations.

Supply Planning run will only create combination if it has any output KF to write at Prod-loc Level otherwise it won't.

Thanks

Girish