‎2010 Feb 05 11:06 AM
Hi All
We have an interface which captures all the changes done in the transactions XD01, XD02, VD01, VD02, FD01, FD02. There is a select query in the code which fetches latest changes based on an object class as below :-
SELECT objectclas
objectid
changenr
udate
utime
tcode
change_ind
INTO TABLE gi_cdhdr
FROM cdhdr
WHERE objectclas EQ u2018DEBIu2019
AND udate GE gv_start_date
AND tcode IN s_tran.
Whenever we change some customer in say XD02 , suppose we change the value of the field SORT1 (Search term) & save. This change will be logged in CDHDR & CDPOS tables. Each time there is a change on this field, two entries are created in the table CDHDR & CDPOS respectively for this change in customer. One entry will be for objectclass DEBI & another one for objectclass ADDRESSE
So above query will fetch the value from table CDHDR based on objectclass DEBI & do further processing & then finally create a file on application server.
But the problem the user facing is, when user is doing any change as described above, there is only one entry getting created in table CDHDR & CDPOS against the objectclass ADDRESSE only , so the above select query is not fetching anything, since there is no entry created against objectclass DEBI & finally there is no file created on application server.
But one thing interesting here is, user has simulated the error in Quality system & he is getting only one entry in tables CDHDR & CDPOS but when my self (technical) & Functional consultant try to simulate the same error in Quality we are not able to simulate but we are getting the expected result means we are getting both the entries created against the change in a customer on field SORT1(Search term)
Could anyone please help me in understanding as to why the user only is facing this error.
Thanks & Regards
Abhii
‎2010 Feb 05 11:13 AM
Hi,
Check whether the object class is created in tcode SCDO in the system or not.
Regards,
Lakshman.
‎2010 Feb 05 11:24 AM
Hi Lakshman,
I have clearly mentioned that myself & functional consulant are able to get the entries for both DEBI as well as ADDRESSE but not the business user.
Regards
Abhii
‎2010 Feb 05 11:26 AM