on 09-21-2011 5:35 PM
I would like to find the original trip creator after the field uname in table PTRV_HEAD was updated.
Which tables or function modules can provide me the data of the original trip creator?
Thanks in advance!
Fisher Li
Sally,
I used the t code PRTE you mentioned to get another SDN posting.
I copied the codes in this posting and made a little change and solved my problem.
:
:
DATA: BEGIN OF ITAB_HEADER OCCURS 100,
PERNR TYPE PTRV_HEAD-PERNR,
REINR TYPE PTRV_HEAD-REINR,
ZORT1 TYPE PTRV_HEAD-ZORT1,
KUNDE TYPE PTRV_HEAD-KUNDE,
DATV1 TYPE PTRV_HEAD-DATV1,
DATB1 TYPE PTRV_HEAD-DATB1,
UNAME TYPE PTRV_HEAD-UNAME,
ANTRG TYPE PTRV_PERIO-ANTRG,
UEBRF TYPE PTRV_PERIO-UEBRF,
ABREC TYPE PTRV_PERIO-ABREC,
:
:
END OF ITAB_HEADER.
DATA : BEGIN OF ITAB_SRTFD OCCURS 100 ,
SRTFD LIKE PCL1-SRTFD ,
END OF ITAB_SRTFD.
DATA: W_SRTFD TYPE PCL1-SRTFD.
DATA BEGIN OF COMMON PART CLUSTER_DEFINITION.
INCLUDE RPRSTR00.
INCLUDE RPC1TE00.
INCLUDE MP56TT99.
DATA END OF COMMON PART.
:
:
:
Read the cluster table PCL1 to get the origial trip creator.
CLEAR W_SRTFD.
CONCATENATE ITAB_HEADER-PERNR ITAB_HEADER-REINR '%'
INTO W_SRTFD.
REFRESH ITAB_SRTFD.
SELECT SRTFD INTO TABLE ITAB_SRTFD
FROM PCL1
WHERE RELID = 'TE'
AND SRTFD LIKE W_SRTFD.
LOOP AT ITAB_SRTFD.
MOVE ITAB_SRTFD-SRTFD TO TE-KEY.
ENDLOOP.
REFRESH AEND.
RP-IMP-C1-TE.
SORT AEND BY DATUM UZEIT.
LOOP AT AEND WHERE UNAME+0(5) <> 'BATCH'.
get the original trip creator
ITAB_HEADER-UNAME = AEND-UNAME.
EXIT.
ENDLOOP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
PRTE is the cluster of all the trip information and versions - would this help you?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
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.