Table relationship in Refurbishment Order

[former_member211679]

Hi All,

I am looking for table  which display 'From Plant','To Plant','From Storage Loc',To Storage Loc', 'From Valuation Type' 'To Valuation Type' from Refurbishment Order in Transaction Code IW33,Table Relationship between Order Number and above mentioned Fields,Please refer Attachement

[jogeswararao_kavala · Accepted solution]

Hello Sumit,

It is like this:

AUFK-AUFNR  <------> RESB-AUFNR

                                      RESB-MATNR <---------> MCHA-MATNR

From Plant, To Plant, From StLoc, To StLoc are from RESB table.

From Val type, To Val Type are from MCHA table

KJogeswaraRao

[former_member211679 · Accepted solution]

Hello Jogeshwara,

Thanks a ton for the reply,Whatever relationship between Order Number( AUFNR) and mentioned fields which you have given are working well for 'From Plant','From Stloc' but what about 'To Plant' and 'To StLoc', conditions is 'From Plant' and 'To Plant' are different and MCHA

gives all the Valuation types.

[jogeswararao_kavala · Accepted solution]

Try this

AUFK-AUFNR  <------> RESB-AUFNR

                                          RESB-MATNR <---------> MCHA-MATNR

                                          RESB-CHARG <---------> MCHA-CHARG

OR  this

AUFK-AUFNR  <------> RESB-AUFNR

                                          RESB-MATNR <---------> MCHA-MATNR

                                          RESB-CHARG <---------> MCHA-CHARG

                                          RESB-WERKS <---------> MCHA-WERKS

[kiran_ambi]

Hi Sumit,

From Plant and from storage location fields are available in RESB table.

To plant and To storage location fields are available in AFPO table.

Regards

Kiran