topic Re: Relation between different PP tables in Application Development and Automation Discussions

Relation between different PP tables

bpawanchand — Sun, 03 Aug 2008 17:12:05 GMT

Hi All

Can any one help me to know the all possible relations between the different PP (Production Planning) tables and

What is the genral work flow of the data in PP module not regarding the functional aspect but in Technical aspect.

Regards

Pavan

Re: Relation between different PP tables

Former Member — Mon, 04 Aug 2008 13:05:13 GMT

Hi,

<lots of meaningless stuff copied from somewhere removed by moderator. Didn't even come close to answering the question>

Edited by: Mike Pokraka on Aug 4, 2008 6:47 PM

Re: Relation between different PP tables

bpawanchand — Mon, 04 Aug 2008 13:09:57 GMT

HI Das

Very thanks for you information but what i want is to how can i get the relations ships between these tables I mean not all the tables but at least the tables that we use regularly .

Regards

pavan

Re: Relation between different PP tables

Former Member — Mon, 04 Aug 2008 13:15:15 GMT

the t-code is sqvi.

to get the relationship between tables,

sqvi~~>create a quickview~~>select data source as table join--> go on adding tables,

we will get the relationship between them

Amit.

Re: Relation between different PP tables

Former Member — Mon, 04 Aug 2008 13:20:23 GMT

Hello Pavan,

Check the belwo url link for PP table relations :

[http://www.abap.es/Descargas/TAB%20-%20Relacion%20de%20las%20tablas%20por%20modulos.PDF|http://www.abap.es/Descargas/TAB%20-%20Relacion%20de%20las%20tablas%20por%20modulos.PDF]

Thanks,

Greetson

Re: Relation between different PP tables

Former Member — Mon, 04 Aug 2008 14:01:35 GMT

Hi,

The PP flow consists of planning and execution.

Here is the flow of PP in simple language:

First of all demand is generated for the product to be produced through demand management. It calculated the quantities to produce and the time for the final assembly.

The data from demand management is transferred to MRP. The data from demand mgt can come from Customer Sales Order (firm) or Planned Order (forecast).

The MRP checks for the availability of material at various stages of BOM. In case material is not available MRP generated planned order and Purchase requisition for production of components in house and procurement from vendor respectively.

The planned orders are converted into production order by the planner and the purchase requisition are converted into purchase order by the purchaser.

Production in charge converts the planned order to production order and carries out the production activities once the order is released for production. Production is carried out as per the operation steps provided in the routing. Work centers are also mentioned with each operation in the routings where these operations are to be carried out.

Once the production is completed production confirmation is done and goods movement (delivery created) takes place.

Capacity planning is yet another part of PP which planes the capacities for various work centers. MPS is another tool which is used to plan out the master products. If MPS is to be run the inputs are provided from demand management to MPS. And the out put from MPS is then feed into MRP.

This is the overall flow for PP.

Regards,

Bhaskar

Re: Relation between different PP tables

Former Member — Mon, 04 Aug 2008 14:43:46 GMT

Hi Pavan,

you can check the relationship through SE11, just click on the field and then click on Foreigh Keys button it will tell show you the relations.

<removed by moderator>

Thanks,

Kamesh Bathla

Edited by: Mike Pokraka on Aug 4, 2008 6:53 PM