Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Display BOM Header Material(s) in which item material exists for a particular plant

manish_gupta32
Participant
0 Kudos
2,459

Hi All,

My requirement is to enter the item material along with the plant, and get all the header materials where this item material is present along with the valid to and valid from dates.

I know this can be achieved with the CS15 transaction, but I am looking for a report that helps to input more than one item material number at one time.

I am also OK to prepare a query if there is any logical database available which fulfills the requirement.

Would prefer the table flow for getting the output similar to CS15.

Thanks a lot,

Manish

1 REPLY 1

Former Member
0 Kudos
378

hello,

BOM tables

MAST Material BOM

STKO BOM Header

STPO BOM Positions (detail)

MAPL Assignment fo Task Lists to Materials

PLKO Routing Group Header

PLSO Routing Group Sequence

PLPO Routing Group Operations

AFKO Production Order Header

AFPO Production Order Position (details)

The logic to get the BOM data from SAP tables is as follows :

1.     Search Material, Plant and Material Description.

Read the material number, plant and material description from join of MARA, MARC and MAKT using the following conditions:

 

Material Number (MARA-MATNR)  in input material (select-options) and

Plant (MARC-WERKS) in input plant (select-options) and

Material type (MARA-MTART) in input material type (select-options).

Note: Proceeding to Step 2 or 3 or 4 depends on the input radio button for Production or  Engineering or ALL BOM option.

2.     Search for BOM – Engineering.

BOM link search from MAST -

Select material numbers and BOM link from MAST based on the material numbers selected above using the following conditions:

Material (MAST-MATNR) = Materials selected above and

Plant (MAST–WERKS) = As in input and

BOM usage (MAST-STLAN) = 2 (Engineering usage).

Read BOM Header and Item.

Read BOM Header details as per data mapping (Section 5.2) from table STKO using the               

conditions:

BOM Number (STKO-STLNR) = BOM number got in previous step and

BOM alternative (STKO-STLAL) =  BOM alternative got in previous step.

Read Item details as per data mapping from STOP using the conditions :

BOM number (STOP-STLNR) = STKO-STNLR.

           Read BOM text from table STZU.  

3.     Search BOM – Production.

BOM link search from MAST -

Select material numbers and BOM link from MAST based on the material numbers selected above using the following conditions:

Material (MAST-MATNR) = Materials selected above and

Plant (MAST–WERKS) = As in input and

BOM usage (MAST-STLAN) = 1 (Production usage).

Read BOM Header and Item.

Read BOM Header details as per data mapping (Section 5.2) from table STKO using the

conditions:

BOM Number (STKO-STLNR) = BOM number got in previous step and

BOM alternative (STKO-STLAL) =  BOM alternative got in previous step.

Read Item details as per data mapping (Section 5.2) from table STOP using the

conditions:

BOM number (STOP-STLNR) = STKO-STNLR.

Read BOM text from table STZU.

Search for Resource / Production Version (Production BOM’s only)

Read Production Version and Resource as per data mapping (Section 5.2) from table MKAL using the conditions:

Material number (MKAL–MATNR) = Material number from above selection (MAST) And

Plant (MKAL–WERKS) = Plant from above selection (MAST)

And

Alternative BOM (MKAL-STLAL) = Alternative BOM from above selection (MAST)

And

BOM Usage (MKAL-STLAN) = 1 (Production BOM).

Note:

1.     If no production version exists for any of the BOM’s write such records at the bottom of the report under the heading “No Production Version Exists (Production BOM’s)”.

2.     Sort the output on Plant, Usage and then on Material.

3.     If multiple plants then the report will be displayed Plant wise.

•     Header to be displayed for Production / Engineering BOM option.

     4.  Material BOM Comparison.

Search for BOM’s

BOM link search from MAST -

Select material numbers and BOM link from MAST based on the material numbers selected above using the following conditions:

Material (MAST-MATNR) = Materials selected above and

Plant (MAST–WERKS) = As in input.

Read BOM Header’s

Read BOM Header details as per data mapping (Section 5.2) from table STKO using the               

conditions:

BOM Number (STKO-STLNR) = BOM number got in previous step and

BOM alternative (STKO-STLAL) =  BOM alternative got in previous step.

Read Item details as per data mapping from STPO using the conditions:

BOM number (STPO-STLNR) = STKO-STNLR.

Let me know if this helps ur need.

best regards,

swanand