on 2011 Aug 30 2:56 PM
Hi Gurus,
I am looking for a link to pick up the Operation number along with Operation description and the details of components required using tables. I will have the input as a number of Maintenance Orders and I want the system to bring out the details given below using the data tables. This will be for a report to print out the pick list for a number of Maintenance Order together. The same way as you can print the pick list for an individual Maintenance Order. I want the system to compile the pick list of a number of Maintenance orders and allow the users to print it. As far as i am aware I do not think it is possible to print the pick list of a number of maintenance orders together.
1. Maintenance Order.
2. Maintenance Order type.
3. Maintenance Order description.
4. Operation number.
5. Operation description.
6. Plant.
7. Storage Location.
8. Work Center.
9. Reservation Number.
10. Reservation Date (when required).
11. Material.
12. Material Description.
13. Quantity Required.
Any help with the logic to get all these details will be much appreciated the input for the report will be Scheduled start date, Scheduled Finish date, Order types, Order numbers.
Regards
Anoop
Equipment number u2013 Apply AUFNR value in AFIH table & get EQUNR values. Only for the found out AUFNR values, further report should be developed. Consider corresponding EQUNR values.
Maintenance Order Description u2013 Apply AUFNR value in the table AUFK field KTEXT and display in the report (For the MTD period Calculated)
Order type u2013 Apply AUFNR value in AUFNR field in table AUFK & get AUART value.
Operation / Activity u2013 The transaction has to read the field AUFPL in
the table AFKO. Selection criterion is the order number (Field AUFNR table AUFK).
The content of field AUFPL has to be used afterwards as selection criterion in the table AFVC. The selection field in this table is again AUFPL and display the field LTXA1.
Planning Plant u2013 The entry must be checked against table EQUI and field
EQUNR and against ITOB and field IWERK and display the value from table T001W
Fields WERKS & NAME1
Reservation - You can get from RESB table
Material Number - From RESB table
Work center - Apply EQUNR value in AFIH table to get GEWRK. Apply that value in OBJID in CRHD table to get ARBPL value.
I guess, you can't link operation & material in single report. As one operation may have multiple materials, just define the logic before finalising the format.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
7 | |
6 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.