Skip to Content
avatar image
Former Member

Need approch for extract

Hi Experts,

I need to take an extract of all the customers whom we have made a change in last one week. This extract woul be taken in a file.And I have the format for this file.

I need to know what approch I can use to take the extract for all the customers which have been changed in last one week . I know about the tables CDHDR and cdpos. This approch should have good performance.

Thanks and Regards,

Jasvinder Kumar

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 03, 2013 at 03:08 AM

    Hi Jasvinder,

    I don't think you will be able to create a query by joinning the tables, as CDPOS is a cluster table.

    Is this a one-off extract? If yes, then you can use the FM's CHANGEDOCUMENT_READ or CHANGEDOCUMENT_READ_POSITIONS to develop a custom program which would give you the desired results.

    Alternatively, if you have a BW system connected to your Source System, then you can use generic data sources for CDHDR and CDPOS and can extract the report from BW system.

    Hope it helps...

    Thanks,

    Amlan

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 08, 2013 at 02:49 PM

    The only other option would be to enhance one of the BP events to store data in a custom table. As for standard approaches, cdhdr and cdpos are the only option.

    Add comment
    10|10000 characters needed characters exceeded