IBP Virtual MDT Join Conditions

[willsuus]

I have created a virtual MDT in IBP and it works fine as long as there is a value in the join field(s) (i.e. working as an inner join). If one of the join fields is blank (null), no record exists in the virtual MDT.

Is there a way to set up the joins to act as a left join would? Or is there some other workaround for this type of condition?

Example:

MDT1 ProductID GroupID1 GroupID2
ABC 123 MDT2 GroupID1 GroupDesc1 123Group 123 Desc 456Group 456 Desc MDT3 GroupID2 GroupDesc2 111Group 111 Desc 222Group 222 Desc Virtual MDT (MDT1.GroupID1 = MDT2.GroupID1 and MDT1.GroupID2 = MDT3.GroupID2) ProductID GroupID1 GroupDesc1 GroupID2 GroupDesc2 ABC123Group 123 Desc

[willsuus]

Sorry - the formatting did not stay in my example.

Basically, there is a main MDT that contains Product and two ID fields.

Then there are two MDTs that contain the IDs and Descriptions.

The virtual MDT links the main MDT to each of the other MDTs by the IDs and then contains the Product, the two IDs and the two Descriptions.

The issue is if one of the IDs is blank (null).

[lingaiahvanam · Accepted solution]

Hi,

Virtual master data usage is very limited and complex calculations.

I would recommend raising an incident to SAP to rectify the blank values during calcualtions.

Best Regards,

Lingaiah