Routing Table

[Former Member]

Dear All,

I opened the <b>Routing display : material component overview through CA03</b>. I saw the component, backflushing Indicator, phantom assy etc.so I want to know the table name, where these fields are stored against material.

[Former Member]

unsolved

[Former Member]

Hi Abinay,

I hope you are having routing for Header material, u want routing details.

Following is the one way to fetch data,

<b>Step1.</b>Table: MAPL.; MATNR->PLANNR,ZKRIZ,

<b>Step2.</b> TablePLMZ; MAPL-PLNNR =PLMZ-PLNNR,MAPL- ZKRIZ=MAPL-PLNAL , PLMZ-LOEKZ not eqaul to 'X' (DEL ind)

Field to be fetched: PLMZ-STLTY,PLMZ -STLNR, PLMZ -STLKN,PLMZ-RGEKZ=X

Step3:Table:STPO; PLMZ-STLTY=STPO-STLTY,PLMZ -STLNR=STPO-STLNR, PLMZ -STLAL =STPO-STLKN

Field to be fetched : STPO-IDNRK,

Now you will get component list and Backflush indicator set.

Step4: Assuming component which has assigned Phanthom Assembly indicator has special procurement Key =50 at MRP view .

Table MARC; STPO-IDNRK=MARC-MATNR, MARC-SOBSL="50"

Now u will get only component list which has phantom assembly indicator in routing.

i hope this ill solve ur provlem

regards

pradeep

[Former Member]

Abhinay,

On any field, just press F1 help and click on the technical information pushbutton in Help. You can get the required information.

Sumeet

[former_member204463]

Hi Abhinay,

Following are the tables relevant to your requirement.

<b>PLMZ Component Allocation</b>

PLPO Routing Operation Details

PLKO Routing Header Details

MAPL Routing Link to Material

PLAB Relationships - Standard Network

PLAS Task List - Selection of Operations

PLPH CAPP Sub-operations

PLFH PRT Allocation

PLWP Maintenance Package Allocation

PLMK Inspection Characteristics

Reward if cleared and close the thread.

Keerthi