on 08-04-2011 12:19 PM
Hi,
I create a work order from transaction IW21 but before saving it I need to access the maintenance cycle text. As the data is not committed to the database hence I am not able to fetch from T351P or T351X tables based on the maintenance strategy and Maintenance package number.
Can anyone please tell me what is the structure field in IW21 transaction which stores Maintenance package number/Maintenance strategy before it is committed to tables?
Hi Prashant,
For fetching Maintenance cycle text while using IW21, please proceed with following logic.
Select Task List Type (PLNTY), Key for Task List Group( PLNNR), Group Counter (PLNAL), Sequence(PLNFL), Number of the task list node (PLNKN), Maintenance package number (PAKET), Internal counter (ZAEHL) Maintenance strategy (STRAT) based on AFVGD-PLNTY, AFVGD-PLNNAR, AFVGD-PLNAL, AFVGD-PLNKN and LOEKZ NE 'X'.
As below:
SELECT
plnty Task List Type
plnnr Key for Task List Group
plnal Group Counter
plnfl Sequence
plnkn Number of the task list node
paket Maintenance Package Number
zaehl Internal counter
strat Maintenance strategy
from table PLWP
based on
plnnr Key for Task List Group
plnal Group Counter
plnkn Number of the task list node
loekz Deletion Indicator
which you will get from the structure AFVGD even when the work order is not SAVED.
Now after having Maintenance Package Number and Maintenance strategy
Select Text for maintenance package/cycle (time/performance) (KTEX1) based on Maintenance package number (PAKET), Maintenance strategy(STRAT) from table T351X
as below:
SELECT
KTEX1 Text for maintenance package/cycle
from
T351X
based on
Maintenance strategy (STRAT)
and
Maintenance Package Number (PAKET).
Pass the Maintenance Cycle Text (KTEX1) where required.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
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.