We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-bw] Generic Extraction - FM - Delta Logic

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

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.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2015 Ziff Davis, LLC. and message author.
Ziff Davis, LLC. 28 E 28th Street New York, NY 10016
sviszt  

achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Become a blogger at Toolbox.com and share your expertise with the community. Start today.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language