Skip to Content
avatar image
Former Member

how many entries are created in standard table which are not having date fields like MAKT

Hi Team,

Please help me to get a way to find how many entries are created in the standard sap table like MAKT. I knew we can track the changes in CDHDR and CDPOS but we can't find the new entries. I need to find the table growth based on yearly. Even I have analyzed the DB02 Transaction but I didn't find solution.

Thanks,

Thirumalaiah.G

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Hello All,

    As of now I didn't find any way to find the table growth based on date(year/month/day) even I have communicated with basis team but didn't find desired solution. If I found any relevant solution from anyone will update here.

    Thanks,

  • Get RSS Feed

3 Answers

  • Nov 14, 2017 at 11:19 AM

    The best people to talk to is your basis team, monitoring is one of their main tasks. Did you ask them?

    We are just random people on the internet who don't know how your monitoring strategy is set up. You can look in SolMan, DB02, SARA (no history), and possibly several other tools specific to your environment.

    Add comment
    10|10000 characters needed characters exceeded

    • Try to analyse the table entries this way.

      For ex

      Go to CDHDR with Object Class as Material and Object ID as the Material Number

      Now go to CDPOS with the same Object Class,material Number and Change Document Number.

      Now see how many "I" are there for each of the tables related to that Material."I" indicates Insertion of a record in the corresponding table.

      But,after seeing the data I find it is quite cumbersome to get the no.of insertions in a table for a Object Class,this way.

      As Mike/Raymond suggested there should already be a tool say SOLMAN or any other SAP standard mechanism to determine the growth of a table at regular intervals.

      May be SAP Analytics forum can get you some lead on existing SAP standard mechanism for this kind of requirement.

      K.Kiran.

  • Nov 14, 2017 at 06:35 AM

    Did you look with transaction SCDO at change document definition of MATERIAL, you would have noticed that the field table is filled with 'DMAKT' and not 'MAKT'.

    Add comment
    10|10000 characters needed characters exceeded

    • Thirumalaiah,

      If I am not wrong, Raymond is pointing towards a select query with CDHDR and CDPOS using table name and CHNGIND as "I", to get the required info.CDHDR has UDATE.

      K.Kiran.

  • Nov 14, 2017 at 07:15 AM

    Hi,

    you need to create a job and to scan a list of tables :

    (exemple of code)

    EXEC SQL PERFORMING APP_SEGMENTS.  
    SELECT    OWNER,    NVL(PARTITION_NAME, SEGMENT_NAME) NAME,    SEGMENT_TYPE,    TABLESPACE_NAME,    HEADER_FILE,    HEADER_BLOCK,    BYTES/1024,    BLOCKS,    EXTENTS,    INITIAL_EXTENT/1024,    NEXT_EXTENT/1024,    MIN_EXTENTS,    MAX_EXTENTS,    PCT_INCREASE,    SEGMENT_NAME,    ''  
    FROM DBA_SEGMENTS  
    INTO :is_sEGMENT
    WHERE BYTES/1024 > :P_BYTESENDEXEC.
    
    

    and if you need to find only the new entries, try change pointer:

    https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=261359032

    regards

    Fred

    Add comment
    10|10000 characters needed characters exceeded