Urgent : Relation b/w PROJ ,JEST ,JSTO.... tables?

[Former Member]

Hi Guys,

I am using these tables PROJ , JSTO , JEST , TJ30 , TJ30T and TJ02T.can anybody tell me how they are Related.I mean Primary Key Freign key Relationship.

In my program i have to download the data from these table based on Created date and Last Updatetd Date .Except PROJ table other tables are not having any date field. So how to download the data based on PROJ Table for all the other tables?

Very Very Urgent.Full points will be given for correct Answer.

Thanks,

Gopi.

[Former Member]

Hello,

Please refer to the FM STATUS_READ.

You need to pass the PROJ-OBJNR to this FM and get the required data.

For the detailed relationship please check the code inside the FM STATUS_READ.

If you need any further help, pls revert.

Regards,

A. Singh

[Former Member]

Hi Amarjit,

I was not able to understand clearly.Can u tell whats the relation b/w the tables which i meantioned in this Thread.Plz Its Very Urgent.

Thanks,

Gopi.

[Former Member]

Hello Gopi,

Please select the field OBJNR from PROJ table for a project not delete status.

Than select all the active user/system status for that project. Active and Inactive status you will find from the FM STATUS_READ and STATUS_TEXT_EDIT

SELECT SINGLE * FROM JSTO CLIENT SPECIFIED

WHERE MANDT = MANDT

AND OBJNR = OBJNR.

SELECT * FROM JEST CLIENT SPECIFIED

APPENDING TABLE JEST_TAB

WHERE MANDT = MANDT

AND OBJNR = OBJNR.

Please let me know your exact requirement, so that I may help you in better way.

Regards,

A.Singh