to find damage code and Equipment id fields in a table....urgent

[Former Member]

Hi...

i have to find damage code and Equipment id fields in a table....urgent

for this....If the Sales Order type is KB (i.e. VBAK-AUART=KB) then Equipment ID and Damage Code are instead taken from the Service Order referred by the KB Order. From Sales Document Flow table (VBFA) find document no of preceding Service Order.

please reply soon.

[Former Member]

Hi

We will find the DAMAGE code in the Notifications table nly

<b>QMFE-FECOD</b>

Get the order details from the order related tables(AUFK,AFKO and AFPO) for the order that is fetched from VBFA and link with the notificatiosn table and fetch this

field from QMFE

Use the VIEW <b>VIQMFEL</b>to fetch the Equipment no and the Damage code by passing the Order no AUFNR

Reward points for useful Answers

Regards

Anji

Message was edited by:

Anji Reddy Vangala

[Former Member]

hi...

i went to the same procedure initially....n found EQUNR from AFIH table.....

will that be ok...as common field for QMEL ,AFIH, QMFE tables is QMNUM..(notififcation no.)

[Former Member]

Hi,

Check in the table S064 Single object - damage analysis.

Regards