No external receipts generated after IBP supply planning with heuristics

[ydyulgerov]

Hello everybody,

I am facing the following case in IBP.

I am running the heuristics supply planning algorithm and it provides proper planning results except for my raw materials which are externally procured. The dependent as well as the net demand for them is generated, but no external receipts are being generated. Production receipts are generated correctly.

All the raw materials have purchase info records created in S/4 and transferred to IBP. In IBP master data type 'Location Source' all the raw materials have a defined combination Product-Location-Location From and a Location Sourcing Ratio = 1 since they are all procured from one and the same supplier.

Within the master data type 'Production Source Header', I have the Product-Location-Source ID combination for my finished good and my semi-finished good and the corresponding Source Type P. However, under 'Production Source Header' I do not have the raw materials with a Source Type U. In S/4, they have a procurement type F. I don't know if this is the root cause, but if yes, why the raw materials do not have this Source Type U here.

Under master data type 'Production Source Item' my raw materials are correctly associated with the their sources - for example RM1 has Source ID '1010_FG1' and RM2 has Source ID '1010_SG1'.

Any help will by highly appreciated. Thank you very much in advance.

BR,
Julian

[AyanBishnu · Accepted solution]

Hello Julian

Lets say you have finished good named FG1, which requires 2 components SFG1 and SFG2 which are procured from a vendor V1 and the produiction in happening at a factoty location L1 where you have a resource R1. Make sure the below points aretaken into account in your config

FG1, SFG1 and SFG2 needs to be extended in location L1 in the LOCPOD MDT

SFG1 & SFG2 are extended to the location V1. No need to put the location type V as mandatory inpunt. let it be similar to other locations.

Resource R1 has to be extened in location L1 and also create a dummy resource DR1 in V1

Also make sure that both the resource R1 in L1 and DR1 in VI is having infinite capacity.

Irrespective of the fact that you are using PIR from S4 HANA or from any other source make sure the below entry is available in sourcelocation MDT in the order of LOCFR, LOC. PRDID, LEADTIME & TRATIO

V1 L1 SFG1 1 1

V1 L1 SFG2 1 1

In the production source header make sure the below entry exists

LOCID PRDID SOURCEID OUTPUTCOEFF PRATIO SOURCE TYPE

L1 FG1 LI_FG1_R1 1 1 P

V1 SFG1 VI_SFG1_DR1 1 1 U

V1 SFG2 V12_SFG2_DR1 1 1 U

Now in the prodution source item MDT make the below entry

PRDID SOURCEID COMpCOEFF SOURCEITEMID

SFG1 LI_FG1_R1 1 10

SFG2 LI_FG1_R1 1 20

In the Production Source Resource MDT create the follwoing

RESID SOUCEID CONSUMPTION RATE

R1 LI_FG1_R1 0.1

Hopefully this will work and you will get the depdendent requirement generated for SFG1 and SFG2 in the DEPENDENTPRODUCTIONDEMAND KF.

Let me know the outcome

[ydyulgerov]

Hello everybody,

I managed to resolve the issue in the following way - within the data flow in the CPI and the 'Add_Suppliers' tab I added a filter with 'X' so that it can read the entries where the source type is equal to 'U'. Afterwards, within the MD production source header I was able to see my raw materials with a Source ID equals to the vendor's ID. Last but not least, I put only source ratio = 1 for my raw materials under production source header MD and I put a ratio = 0 under MD source location for my combination of raw material and vendor. The result was visible as external receipts as expected.

Thanks to everybody that gave me hints, suggestions and proposed solutions!

BR,
Julian

[ydyulgerov]

Hello Lugo,

Thank you for your answer.

Maybe a bit more clarifications from my side. Currently, the vendor is set as 'Supplier' in IBP MD Location Source. Within S/4, the vendor has a location type 'V'.

I expect to see the external receipts into my plant '1010' and transport receipts coming from the vendor. But I am not able to see neither of them.

As mentioned, all the raw materials have valid purchase info records. If I had to define a source type 'U' for them in Production Source Header MD - how can I do it except by manual upload of .csv file in Data Integration Jobs app? How can this be done by the master data transfer from S/4 to IBP via CPI?

Please refer to the attached screenshots as well.

Thanks a lot in advance!

BR,
Julian

[former_member738149]

The location type in IBP must be literally V , not Supplier.

Yes, you may need to apply a rule in CPI to transform the rule to U.

It’s either you have external receipts or transport receipts , cannot have both into same plant. My piece of advice. Good luck

[ydyulgerov]

Hi Lugo,

I changed the MD in IBP from 'Supplier' to just 'V' and ran the heuristics again. Unfortunately, I do not have neither transport receipts at 1010, nor external receipts at vendor's location.

I also checked the data flows in the CPI. For the Location MD - the extractor /IBP/LOCATION_ATTR reads and transfers the vendor location as type 'V' and in IBP it has a description 'Supplier'. The data flow for Production Source MD uses the /IBP/SOURCEPRODUCTION_ATTR extractors and the data flow there reads the records with location type 'P' only, although as you can see from the screenshot, it has an additional field called 'Add Suppliers' / 'Add Suppliers as Entries of Type U'.

Attached you can find the screenshots from the CPI data flow for source production MD and the mapping of the source type.

BR,
Julian

[former_member738149]

Hi

Try marking the vendor Location record as “V” in Location Type attribute .

The external receipts will be shown at vendor’s location , not at your DC. At your DC you’ll see Transport Receipts (because of the location source t-lane defined as MD)

If you expect external receipts to be shown coming into your DC , you need to define the source type as “U” in the Production Source Header MD , and the Location Source can be then removed as everything will be sourced infinitely with no sourcing rules and lead times defined:

hope this helps