Could any one provide the relations ship between the following tables
AUFK, AFKO, AFPO , MKPF, TCC02 and T132T tables
Actually we need to capture the some xxxx fileds from Production Order(CO03). by using the below realtion we can pull the data.
->AFKO ->AFPO -> MSEG--
(AUFNR) (AUFNR) (AUFNR) (AUFNR, MBLNR) (MBLNR)
But we need two more fileds System Status and User status from Production Order(CO03), we couldnt able to find these two fileds in any of the above mentioned tables. However we found that these two fileds are actually coming from TCC02 and T132T tables. so could any one please help in finding the relation between these tables.
Many thanks for your help.