Tables or Logical database to create standard report for Equipment BOM?

[former_member619422]

Dear All

My client has requirement for the report with fields like to see the status of Equipment BOM(input of Equipment number in selection screen) or for Particular set of Materials(input of component number in selection screen) available stock quantity,storage location of stock,description of component,price of component,Pending PR of component(if any),Pending PO of component(if any) etc

I want to develop the report with standard infoset query instead of going for abap development.is there any logical database to map the report or what tables can i use for table joins??

Required sample report with fields as below

BOM Component	Stock available/Not available indicator	Description of Components	BOMQty/ UOM	Price	Part Number	Plnt	Sloc	Stock Qty	Bin	Pending PR	Pending PO
1000001121	YES	BEARING	NO	2000	ERS22	1000	MECH	4	A1	300012431	-

Regards

M.Manojkumar

[jogeswararao_kavala · Accepted solution]

Manoj,

The following is the tested solution.

Table join

Output

This figure shows the case of a Equipment BOM where 3 components are there. Installed Quantity are 4, 1, 1 respectively. Last two columns are showing the Storage Locations and the Stocks available.

Fields taken to output are

From STPO : IDNRK MENGE MEINS

From MARD  LGORT LABST

As said before, more than this you can not do in SQVI. With this basic join in SQ02, using codes in Extras you can do much more.

Jogeswara Rao K

[former_member619422 · Accepted solution]

Thank You  Jogeswara sir,I have tested this with PR and PO table too...I got the result as expected.

Thanks everybody @ Maheswaran,Rakesh Mane and Peter Atkin

Regards

M.Manojkumar

[jogeswararao_kavala]

Manoj,

Forget about LDB.

See the following join I used to get similar report for Material BOM.

Use Table EQST instead of MAST (1st table)

The report I get for MatBOM is

So you'll have Equipment and Equipment Text in 2nd and 3rd Columns.

Also have the field  VERPR (MvgPrice) from table MARA into query. Multiply this with the quantity into an Additional field for stock value of this BOM component.

Remaining are your PR PO. Get them in a similar way from the concerned tables (EBAN etc for PR and EKPO etc for PO)

Jogeswara Rao K

Message was edited by: Jogeswara Rao Kavala

[peter_atkin]

Jogeswara Rao K

As it happens I stumbled across an issue with the current clients BOM reports.

And they had done exactly what you described above. The only issue with this approach is that it won't work for multi-level BOMs.

PeteA

[jogeswararao_kavala]

Agreed Peter !

[former_member619422]

Dear Sir

I try to develop using table join as said below

with selection and list fields such as below,but after execution..im getting 'No data was selected" ...What can be the reason for this?

[peter_atkin]

What selection-screen data are you using?

PeteA

[former_member619422]

I filled equipment number which has BOM in the selection screen and i also tried without any entry in selection .After execution,im not getting report

[jogeswararao_kavala]

Hi Manoj,

I think I understood the problem.

It is the join between tables STPO and MARA.

Remove the system proposed join and manually connect  STPO-IDNRK to MARA-MATNR.

Jogeswara Rao K

[jogeswararao_kavala]

[former_member619422]

Ok Sir..Im trying now

[peter_atkin]

Here are the Logical Database options for BOMs:

However, none of these will give you stocking levels/quantities/etc.

You can use the following to create your report:

• ABAP program (SE38)
• Quick viewer (SQVI)
• SAP Query (SQ01/SQ02)

PeteA

[jogeswararao_kavala]

Logical database is CEC

Tables:

EQST, STKO, STPO, STZU, STPU

With LDB it is very easy to make reports through Infoset Query.

Jogeswara Rao K

[former_member619422]

Dear Sir

As you said,its easy to develop report easily in infoset,but when i checked I am unable to find the PR and PO fields in CEC logical database,can u  tell the technical name of PR and PO fields in CEC Logical database??

Regards

M.Manojkumar

[jogeswararao_kavala]

Manoj,

I meant to make reports of Equipment vs BOM components (See the attached pictures). It seems you need LDBs in other area (Purchase).

Jogeswara Rao K

[former_member619422]

Ok Sir,but my report requirement is to see available stock quantity&its storage location,PR and PO for material. Now i am trying to develop report with Table join

[jogeswararao_kavala]

Manoj,

Sorry somehow I missed viewing at your report table. I'll study and if I have something , shall let you know.

[jogeswararao_kavala]

You should be able to develop this using this LDB and some Additional fields in Extras for other fields. But you need to know some coding to get these values to your Addl fields.

You might need ABAPer,

Jogeswara Rao K

[rakesh_mane]

Hello

As per my knowledge to get the all info listed in as "Particular set of Materials(input of component number in selection screen) available stock quantity,storage location of stock,description of component,price of component,Pending PR of component(if any),Pending PO of component(if any) etc "not possible to get via standard info-set query.In this regard you need only have option for abap development by using multiple tables.(Go for Z-Function Module)

Br

Rakesh

[Former Member]

BoM related tables - EQST, STKO, STPO

Material related tables - Stock Tables and Stock Types - ERP SCM - SCN Wiki

PR / PO related table - EBAN