Skip to Content

BODS - Extract bulk data from CDHDR and CDPOS - last 3 years

Hello All,

I have a requirement to extract the data from change log tables CDHDR & CDPOS tables for last 3 years using BODS

Also i aware that CDHDR and CDPOS are the biggest tables in sap system and holds vast no of entries.

Further , Using this tables information we are going to identify / report on the changed values in appropriate ECC landscapes in past 3 years.

I able to extract this change log data successfully from ECC development landscape with help of "ABAP data flow in BODS"

https://answers.sap.com/questions/505949/adf-abap-data-flow-error-in-bods.html

As discussed in above link , i have some roadblocks to do this same in Quality and Prod landscapes. To proceed to quality and prod, i need to learn on the best approach

So here , Can anyone please let me know about the best approach or Best practice to extract the change log tables CDHDR & CDPOS for last 3 years using BODS ?

Many Thanks in Advance

Ahalya Inturi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 10, 2018 at 09:24 AM

    Also , i am expecting memory issue and that too in DEV with limited data

    16400 13480 SYS-170115 5/9/2018 9:40:30 AM /DD_TEST_SAMPLE_JOB/WF_Stage_EDG_Extract_Change_Log_Tables/WF_Stage_EDG_Extract_CDPOS/ADF_Customer_CDPOS_EDG

    16400 13480 SYS-170115 5/9/2018 9:40:30 AM Warning: Your system is running low on virtual memory. Total size is <57526>, available <338>.

    12268 17264 SYS-170115 5/9/2018 9:40:31 AM memoryMonitor

    12268 17264 SYS-170115 5/9/2018 9:40:31 AM Warning: Your system is running low on virtual memory. Total size is <57526>, available <336>.

    Just looking for best solution that how everyone else will approach Similar type of requirement ?

    Add comment
    10|10000 characters needed characters exceeded

  • May 14, 2018 at 09:55 AM

    Hello Team

    I am still looking for help on this . Can any one pick this and help me in the community please ?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 05, 2018 at 03:59 PM

    Hi Ahalya,

    Which version of BODS you are using? In BODS 4.2 we have option to extract from SAP source table (Transparent or cluster) in a background job. You can define the array size and avoid the memory issues. Hope this will solve the issue for extracting the giant tables (CDHDR and CDPOS). These tables log each and every information across all objects. Try to minimize the data the flowing with more filters. Try to use push down option if you want to aggregate the data in source instead of bringing all data to BODS staging and do aggregation.

    Regards,

    Mohan.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 06, 2018 at 05:34 AM

    Hi.

    The error above is when you are using ADF (i.e. has your problem with respect to ABAP program transport been resolved) or directly importing the table in the DF? Can you please post the DF screenshot.

    Regards. S

    Add comment
    10|10000 characters needed characters exceeded