topic Re: Source for DDIC Table in Application Development and Automation Discussions

Source for DDIC Table

Former Member — Mon, 27 Jan 2014 07:09:33 GMT

Hello ,

I have a transaction and some tables are used in that transaction which are automatically popping out. Kindly can you please explain me the procedure , so how can i find the source for that table, like from where the data is entering into that Zee table. Thanks.

Re: Source for DDIC Table

former_member187748 — Mon, 27 Jan 2014 07:15:19 GMT

Hi Kittu,

i am not getting your problem properly, please elaborate it.

If it is a custom program, which is updating your Ztable,

see your whole code, and find UPDATE, or MODIFY

keywords.

Otherwise, please explain little bit.

Re: Source for DDIC Table

Former Member — Mon, 27 Jan 2014 07:20:16 GMT

Hello thanks for your concern,

Yeah actually its a custom program, when transaction is executed values are automatically popping out and its easy when a program is small but in my requirement it has so many includes , i cannot figure out where the code exactly written, So please explain me any easy procedure that taking one reference field i can find out.

Re: Source for DDIC Table

former_member187748 — Mon, 27 Jan 2014 07:35:17 GMT

Hi,

without knowing your program, what you have written there, how could anyone explain.

If you have any function module, like REUSE_ALV_GRID_DISPLAY, REUSE_ALV_LIST_DISPLAY

please check what is the parameters used in table.

Means you have to find the main table through, your data is moving in Ztable.

Then you can find the flow of data.

Or you have to use ST05, or you can use transaction SAT to analyse your whole source code.

The best way to know flow of data.

Re: Source for DDIC Table

Former Member — Mon, 27 Jan 2014 07:48:35 GMT

HI ,

you have to debug the TCODE by using /H command , then only you can get to know where exactly table is getting filled.

Regards,

Ravikiran.K

Re: Source for DDIC Table

Former Member — Mon, 27 Jan 2014 07:54:31 GMT

Hi ABAP consult,

Go to transaction SE11/ SE16n and in table TSTCP (table for parameter transaction).

In the field PARAM, pass *Z_TABLE*

This will give the list of the table involved in the transaction further you can debug the program that you think is updating your zee table.

Steps in detail:

Goto SE93,

1. Press F4 on the Transaction Code field, If you see a Input help Personal value list, Press F5 ( Information System ) button, another screen will open.

2. Click on All selections button (the one with a + sign), the screen will expand.

3. Enter Z* in the Transaction Code field, Select Parameter transaction, press enter.

Now you will get all the Z transactions that were created as Parameter transaction. Copy the T-codes

Goto se16 and in table TSTCP and enter all the transaction found as above. Filter the list on the parameter of the table name you are searching for.

Happy Coding,

Santhosh Yadav

Re: Source for DDIC Table

Former Member — Mon, 27 Jan 2014 09:23:50 GMT

Actually , so now i have that custom table used in that transaction, So is there any way easily to check how that custom table is filling up like source, is it manually or any data transfer technique.

Re: Source for DDIC Table

nabheetscn — Mon, 27 Jan 2014 09:27:41 GMT

What i would have done is to check from where this table can get filled or data read is by simply doing a where used list on the table in SE11. Check whatever list you get is doing something realted to your custom table

Nabheet

Re: Source for DDIC Table

Former Member — Mon, 27 Jan 2014 09:29:18 GMT

Hi Abap Consult,

What you are trying to know is the logging of the changes made to the z table, This can be achieved by referring to this link Maintaining Change Log for Database Tables - ABAP Development - SCN Wiki and further search forum for "Log database tables".

Hope this Helps!.

Happy Coding,

Santhosh Yadav

Re: Source for DDIC Table

former_member187748 — Mon, 27 Jan 2014 09:34:05 GMT

Hi,

you can go to SE16N or SE11,

and put the name of table, then click on where used list

on succesive screens, you will get what you wants.

You have to do it manually, its easy.

Re: Source for DDIC Table

Former Member — Mon, 27 Jan 2014 09:35:38 GMT

Thanks , but there are so many options which i am getting after going into where used list and when i select all there are lot of programs screens, so what the best option to select to know about the source of table. Thanks again

Re: Source for DDIC Table

former_member187748 — Mon, 27 Jan 2014 09:39:56 GMT

Hi ,

from so many options, select the one for which you wants to see , the content

just check it , see below, you will get the desired output showing use of ztable data population.

Re: Source for DDIC Table

Former Member — Mon, 27 Jan 2014 09:40:21 GMT

Good question!

Usually first priority is the customized programs ( colleagues already investigated and used )

Second function modules

Standard report programs

Based on this I usually checks the table usages

Re: Source for DDIC Table

anup_deshmukh4 — Mon, 27 Jan 2014 09:55:46 GMT

Hello ABAP Consult,

The traditional way of doing it is ,

Go to the table in SE11
Find the where used list ( Which will fetch you a long list depending the usage of the table )
In the list you can search for UPDATE / INSERT / MODIFY Statements and put your breakpoints
Run your Transaction to get at the statement

Hope this helps,

Anup D.

Re: Source for DDIC Table

Former Member — Tue, 28 Jan 2014 08:37:02 GMT

Hello Thanks for your concern, but in where used list there is not option of uUPDATE/INSERT/MODIFY ,