Skip to Content
0

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

Nov 14, 2017 at 05:55 AM

64

avatar image
Former Member

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

10 |10000 characters needed characters left 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,

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mike Pokraka Nov 14, 2017 at 11:19 AM
1

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.

Show 5 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Mike,

I didn't approach the basis team, let me check with them. As I need to develop a report to show case table growth based on the every year/month/week/day. As you know if we have the date/year field in the table, we can get it the growth, but I am looking for suggestion which are not having the date/year fields in the table.

Thanks,

Thirumalaiah.G

0

Thirumalaiah,

I think you are misinterpreting the concept of Change Documents and its relation with the table concerned.

A select query on CDHDR and CDPPOS can get you the required details for the corresponding Object class and OBJECTID.Using CDHDR-UDATE and CDPOS-CHNGIND as "I" you can get the count.

TCDOB table can get you the details of Object Class for the corresponding table.

But,fetching data from CDHDR &CDPOS will take time and advisable if you use OPEN/FETCH/CLOSE cursor methodology while fetching the data.

Not necessary that the table "ABCD" should have a date field.

K.Kiran.

0

Date fields are not necessarily relevant to table growth and is really not something you should rely on.

What do you need this info for? There are many different dimensions to the question.

If you break MARA down by months you can allocate a similar proportion to the MAKT total size to estimate growth. But be aware it may be misleading, you may add 1000 records/day, but the physical size may differ due to new functionality.

Basis monitor both rows and size. Also tables in isolation are not always relevant. SARA is good as you can get a size overview of functionally related tables.

That should hopefully be enough info for you to play with.

1
Former Member

Hi Kiran,

Just now I have tested one scenario by creating one sales order but I didn't see the creation related entry in CDHDR Table. I believe it will contain only change information.

Thanks,

0

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.

0
Raymond Giuseppi
Nov 14, 2017 at 06:35 AM
0

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'.

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member
Hi Raymond,

Thanks for your quick response. You are trying to ask me to create change document log for every table using SCDO Transaction but I want to know is there any standard process( using FM, BAPI, Classes) to get this information without activating the change log.

Thanks,Thirumalaiah.G

0

No, I'm asking you to display the standard definition (after some pop-up, click on display icon) which already contains the required information (CDPOS records on DMAKT with code 'I')

0

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.

0
avatar image
Former Member Nov 14, 2017 at 07:15 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi,

Gone through your code, but how to check the entry count based on period(date/year) in the case of MAKT Table. Can you please elaborate it.

Thanks,

Thirumalaiah.G

0
Former Member

There is no historic, you have to do it yourself.

I know there is a tool in Solman that provide this information, but you have to activate it. If no activation, no information

Fred

0