sql query to identify transports in dev but not in prod

[jose_hernandez5]

I use sqlplus to select fields from saperp.e070v so I can compare transports in prod with those in qa. The purpose is to identify those transports that I need to run when I H-copy prod to QA. I'm using this where clause (TRFUNCTION='K' OR TRFUNCTION='W') . Should I look at TRSTATUS? I'd appreciate any recommendations or ideas. I do not have access to ABAP.

[jose_hernandez5]

New user error in marking this as answered

[markus_doehr2]

You transport without having access to ABAP? Hmm...

I would use STMS - import queue of the source system - select the history and check the sequence in which the transports have been imported. It´s possible that there´s a dependency between a higher transport number needed to be import first.

Markus

[jose_hernandez5]

Hello Markus;

I don't transport without ABAP.

The purpose of this is to have a script tell me which transports are in Prod and not Q, so I can re-transport them when I H-Copy Prod to Q. There is an ABAP program available but I haven't the authority to tweak it. If I query the Prod and Q databases with sqlplus than I can use any UNIX scripting language to perform the logic. I am just concerned that my select is not getting me the records and fields I need as there isn't much documentation on E070V

[markus_doehr2]

I understand what you want to do.

States are

Q      Request is ready for import again
R      Request waiting to be imported
X      Request already imported

I would use those.

Markus

[jose_hernandez5]

Thanks Markus.

Here are the distinct codes I found. Are there any ot these That I need to be concerned about? Is there a Key/Legend for these?

SQL> select distinct trstatus from saperp.e070v;

T

-

R

D

O

SQL> select distinct trfunction from saperp.e070v;

T

-

W

R

P

K

D

Q

M

T

X

F

S

T

-

G

12 rows selected.

SQL> describe saperp.e070v;

Name Null? Type

-

---

-

---

-

---

TRKORR NOT NULL VARCHAR2(20)

TRFUNCTION NOT NULL VARCHAR2(1)

TRSTATUS NOT NULL VARCHAR2(1)

TARSYSTEM NOT NULL VARCHAR2(10)

AS4USER NOT NULL VARCHAR2(12)

AS4DATE NOT NULL VARCHAR2(8)

AS4TIME NOT NULL VARCHAR2(6)

STRKORR NOT NULL VARCHAR2(20)

LANGU NOT NULL VARCHAR2(1)

AS4TEXT NOT NULL VARCHAR2(60)

CLIENT NOT NULL VARCHAR2(3)

SQL>

F

S

T

-

G

12 rows selected.

SQL> describe saperp.e070v;

Name Null? Type

-

---

-

---

-

---

TRKORR NOT NULL VARCHAR2(20)

TRFUNCTION NOT NULL VARCHAR2(1)

TRSTATUS NOT NULL VARCHAR2(1)

TARSYSTEM NOT NULL VARCHAR2(10)

AS4USER NOT NULL VARCHAR2(12)

AS4DATE NOT NULL VARCHAR2(8)

AS4TIME NOT NULL VARCHAR2(6)

STRKORR NOT NULL VARCHAR2(20)

LANGU NOT NULL VARCHAR2(1)

AS4TEXT NOT NULL VARCHAR2(60)

CLIENT NOT NULL VARCHAR2(3)

SQL>

[Former Member]

HI,

View E070V does not contain status about request whether it is imported to system or not.

field TRFUNCTION contain

K Workbench Request

W Customizing Request

C Relocation of Objects Without Package Change

O Relocation of Objects with Package Change

E Relocation of Complete Package

T Transport of Copies

S Development/Correction

R Repair

X Unclassified Task

Q Customizing Task

G Piece List for CTS Project

M Client Transport Request

P Piece List for Upgrade

D Piece List for Support Package

F Piece List

and field TRSTATUS contain

D Modifiable

L Modifiable, Protected

O Release Started

R Released

N Released (with Import Protection for Repaired Objects)

so you can not get information about imported request.

if you get correct result you must login into sap and follow the steps which is provide by Mr. Markus.

Run tcode STMS_IMPORT and click on import history and enter from date and to date download the result in EXCEL format

do same in QAS system..

compare both Excel Report so you get request which are imported in QAS system but not in PRD System.

regards,

kaushal