Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from sviszt on Jan 5 at 5:39 AM In your status / log tables you can use any format for the timestamp e.g. YYYYMMDDhhmmss, and then in code you can cut this into date and time, and select from the tables using both fields. SELECT * FROM VBAK WHERE ( ERDAT = lv_date_from AND ERZET > lv_time_from ) OR ERDAT > lv_date_from
| | | ---------------Original Message--------------- From: maruthiv Sent: Monday, January 05, 2015 5:33 AM Subject: Generic Extraction - FM - Delta Logic Thanks for your quick response, but in my case all 9 tables have creation date and changed date. How can I implement logic for this? As you said according to time stamp we can do it, but what about date field? Table Creation Date Creation Time Change Date Change Time VBAK ERDAT ERZET aedat VBAP ERDAT ERZET AEDAT VIMI01 DBEAR TBEAR VIOB03 DBEAR TBEAR VIOB01 DBEAR TBEAR ZFI_CHEQUE_RECD ZCDATE ZCTIME ZMDATE ZMTIME VBRK ERDAT ERZET AEDAT VBFA ERDAT ERZET | | Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today. _.____.__ |