Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Select only new/updated lines

0 Kudos
532

Hello,

Is there a way to select only new/modified rows in VBUP and VBPA ?

Regards

1 ACCEPTED SOLUTION
Read only

RaymondGiuseppi
Active Contributor
0 Kudos
486

So you require a kind of Delta Extractor for VBUP and VBPA.

Did you consider

  • BW way of life, using LBWE (look at SD, LE nodes) (simulate a BW extraction to your ETL)
  • Analyzing of change documents (as frdric.girod suggested)
  • Filling you own buffer table /or/ appending some timestamp to the tables thru BAdI or exits
4 REPLIES 4
Read only

FredericGirod
Active Contributor
486

It depends, where do you need this ? in a report ? or in user exit ?

Read only

0 Kudos
486

The client has an ETL that comes to extract the data but it gives him too much data to recover.

Read only

FredericGirod
Active Contributor
486

You could check what have been updated with tables CDHDR and CDPOS, but they are also really big tables

Read only

RaymondGiuseppi
Active Contributor
0 Kudos
487

So you require a kind of Delta Extractor for VBUP and VBPA.

Did you consider

  • BW way of life, using LBWE (look at SD, LE nodes) (simulate a BW extraction to your ETL)
  • Analyzing of change documents (as frdric.girod suggested)
  • Filling you own buffer table /or/ appending some timestamp to the tables thru BAdI or exits