07-03-2007 3:00 AM
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.
07-03-2007 3:43 AM
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
07-03-2007 4:05 AM
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.
07-03-2007 5:15 AM
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