which table and field sare to be used to get the PIR change history details
we would like to have a quiery in which we will input the plant and other required things and know
the change detaisl related to PIR like
when the existing PIR quantity is changed , which user has changed , changed from which quantity to which quantity etc..
now we are going to MD63 ,enter one by one materials for which PIR quantity changes happened , going to item history and seeing
if some table and field are there we can get the required details easily
For the material no(MATNR), get the values of the requirements pointer(BDZEI) from table PBIM(Independent Requirements for Material)
GO to PBHI table(Independent item history) with req.pointer(BDZEI) and get the value of the original created qty from field DBMNG (Planned qty in database) ,present changed qty (PLNMG), Changed by , last changed date (LAEDA) and changed time (UZEIT).
Hope this will help you..
Please try these fields it will be helpful
Planned independent requirements
PBIM Independent requirements for material
PBED Independent requirement data
PBHI Independent requirement history
PBIV Independent requirement index
PBIC Independent requirement index for customer req.