Hi Guys,

I would like to share my knowledge on technical which will be helpful to the Functional consultant to prepare the Functional specifications and hope will help full to the Technical developer on designing the Structure or Transparent Table and finding the data type and length in simple way.

Before going to detailed explanation, we have to understand – Why Functional consultant need technical knowledge:

  1. Prepare the Functional specifications
  2. Understood requirement from client in detail and can map into Technical words.
  3. Helping to Technical developer on difficulty developments.
  4. To discuss with Client on possibility and non-possibilities of logic and impact on report performance.
  5. Discussion with Technical developer will be more flexible if you have knowledge on Technical.

I would like to explain knowledge on How to differentiate the tables and How to find Table name with reference to field and description and etc…

And also will discuss about the logics which will be frequently used in Developments of smart forms and in new customized Reports developments.

  • How to find Configuration table name with reference of master data table – field name.

Generally we know lot of configuration data will be used in Master data’s. But we will be used only code to create the master data’s. While saving table also we know only code will be save in master data’s table or in transaction data tables and corresponding code description will not get update in master data tables.

While developing the report or smart form development mostly user need only description in the output development. For this again we will be search in configuration level what was table name finding through F1 or some other ways.

Here explaining some fields configuration table can find from Master data table- field name.

Example : If Material Group code will be enter in Material master but if you need to find description of Material group then you have to go in OMSF and need to find the table name or description. But below table which will be help full to find the Configuration table name.

Table Name: DD03M or DD03L

DD03M – Generated Table for view

Enter table and field name:

Assume MARA table and field name MATKL and language “EN”.

/wp-content/uploads/2015/04/1_693979.png

And execute the table.

Check “Check table – filed (CHECKTABLE) in DD03M or DD03L

/wp-content/uploads/2015/04/2_694052.png

See the table name T023 and pass this into se16n

/wp-content/uploads/2015/04/3_694053.png

It will help full Not only for functional consultant but also for technical developers to develop the reports and smart forms and in data extraction these table will be help full lot.

Not only configuration table, we can find data type, ABAP type, data element (in DD03L) and length of field and position number in se11 and number of character  and table category from  DD03VT and  DD03M and DD03L table.

  • From Table  How to find where used list of programmes

Too much difficult to remember the program every time which was developed for each developer and functional consultant. Developer Sometimes they will create maintenance table for pick the user values. In this case Z table remembering is little bit easy to compare to remembering the table.

The following way we can find the program name from table.

Table: D010TAB

D010TAB: Table for Use Report<->Tables

Pass table name in this D010TAB table,

Assume ZMM_TABLE which is developed for STO auto creation.

I need to find the program which I was used this table —

So I have passed this table into D010TAB table.


/wp-content/uploads/2015/04/4_694054.png


Execute

/wp-content/uploads/2015/04/5_694055.png

Check in Se38

/wp-content/uploads/2015/04/6_694056.png

Execute

/wp-content/uploads/2015/04/7_694057.png

This is one way can find program name from tables..

As of now we are discussed How to find Configuration table and from table how to find where used list of programs. Now will discuss How to find the Transaction code for the Program

  • From Program how to find the Transaction code

Using below table we can find Transaction code:Table name: TSTC   Program name: ZBDC_XX_PO1.PNGExecute the Program 2.PNGHere you can get details of Transaction code of the Program.Now we will discuss on list of tables used in one program

  • Find List of tables used in One program

Some programs developer need to create lot of customized tables. It is difficult to remember what are the tables used in the Program. The below simple way we can find the list of tables and structures used in Program.

Go to Se16n,

Enter table D010B

Enter Program name

3.PNG

Execute

4.PNG

You will get all tables and structures used in Program ..

To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. Jim Tasker

    Hi Ravi,

    I don’t really understand why you’re advocating for going directly to the DDIC tables instead of using the tools that are provided for pretty much everything you’ve talked about here.  For example, why not just use the where-used feature for a table instead of remembering that you can browse table D010B?

    Regards,

    Jim

    (0) 
    1. Ravindra Devarapalli Post author

      Hi Jim,

      Thanks for reading the article. You query was excellent, But For developer they know very well know about how to use where used list from the table or program. But as Functional consultant we don’t have authorization some times to check the program and where used list. And also Some server when you click on program and click on where used list will be take lot of time because of performance issue and also her multiple program you can see at a time…

      As a Functional consultant, I am thinking this was good sharing tips to other.

      (0) 
  2. Michelle Crapo

    OK – I’m usually a  “if you don’t have anything nice to say don’t say anything” type of person.   But I’m going to jump in with both feet here.   The functional consultant doesn’t need to know the tables – or shouldn’t need to know the tables.   Most of the developers can give you many of the tables just because they know them.   In the specs they could simply say they want the material master description – and put a screen shot.   Let your technical people handle the technical side.  This also seems like a hard way of finding information.   There are easier ways as Jim has said.   Ummm…   If you don’t have access that’s strange, but wouldn’t it again make sense to work with your developer.   You might find the table, but not the best table with less records or header/detail table that would work better in a join, or…………   Yes, I could add a huge list.    And yes I do both the development and functional side so who am I to say a functional person doesn’t need to know where to get this information.  Personally I think debug would be more of a tool that they should understand and be able to use.   Also many functional consultants I know use SAP Query if they understand the table linkages.   Alright I’m done venting.

    This blog was excellent from the standpoint I’ve never thought about looking at the D010TAB.   It’s something I may use in the future.

    (0) 

Leave a Reply