Material where used list with 200 Class and Object Dependency

[jez_lawson]

Hi Experts,

I am looking at building a where used lookup for component materials on BOMs. The caveat being the materials are tied to a 200 class lookup and to add further complexity I have characteristics within the 200 class being altered via an object dependency in some but not all cases. The plan is to do this via ABAP and in a Z transaction, but have been trying to map out transactionally how it would be done to help the developer.

I was looking at pulling the 200 class from the material and using CSC5 logic to determine all the configurable materials with the class in the BOM. From here using CL30N with the 300 class to determine anything the matches the 200 class characteristics. This fails when an object dependency overrides one of the characteristics within the BOM itself.

I realise that potentially I could explode all the BOM's from the list returned in the CL30N search and compare the results against my initial component, but even one of our smaller 200 lookup classes has 5,000 materials, so I believe the speed of running this way would be prohibitive.

[jez_lawson · Accepted solution]

For anyone interested we eventually decided to use the RESB table to see where the components had actually been used. This excludes 200 class lookups that have never been used, so potential usage of the component, but for our purposes it was sufficient and much faster that trying to resolve all the 200 class lookups.

[Mahendran8888]

Hi

You can retrieve the data from tables using t code SE16n .USe the tables for getting data.

refer below link

https://blogs.sap.com/2013/09/27/list-of-tables-for-vc/

Regards

Mahe

[jez_lawson]

Hi Mahendran,

The problem I have is determining the effect of the object dependency.

I have fully configured materials built off a configurable material.

In the BOM of the configurable material I have 200 class look ups.

An example of my issue being where I have a 200 class in the BOM with Height, Width, Colour as the characteristics.

For a particular product the component is only available in 200cm width so in the object dependency the VC characteristics coming in from the fully configured material has width = 180cm but the BOM item has an object dependency setting $self.WIDTH = 200 .

To determine the where used list I have been taking the 200 class characteristics of the component and matching with them characteristics in the configuration of the finished material. In the above I would not find a match as the 200 class says width 200, but the fully configured material I am looking for has a width value of 180cm. I was hoping there was some clever functionality to process the object dependency in reverse, so a where used list on the component that shows only finished materials that genuinely use it.

I have a lot of materials so the overhead of exploding all the BOMs with the 200 class attached to it and matching my required component would be very slow.

The table list is very useful, it just doesn't solve my current issue.

Thanks,

Jez