Skip to Content
Author's profile photo Maria Terence

How to find ABAP Tables and Fields

As part of functional consultant responsibilities, nowadays it is very essential to learn different ways to find the tables.  It is not easy to remember all the tables associated to one module and the way it is integrated to other modules.


This particular learning will help us


  • To prepare the functional specification documents
  • To Provide correct and accurate information to the Technical Consultant for developing reports
  • To Improve time management on handling issue

This blog will help you to identify the Tables and I am going to describe a scenario where we need to find the Cost Centers assigned to Work Center in different periods.


Step 1: In the Work Order Operation Tab, click F1 in the field Work Center

Pic 1.jpg

Step 2 : Click on highlighted Icon – Technical Details

Pic 2.JPG

Step 3 : Double on the Data Element – ARBPL

Pic 3.JPG

Step 4 : Click Where used List as highlighted above

pic 4.jpg

Step 5: Check Tables and Press the Green Tick

pic 5.jpg

Now you can search for the appropriate table relevant to your requirement. Here i am searching for Work Center related Table

pic 6.jpg

Step 6 : We have got the header table CRHD. Go to SE16 – CRHD – Pass Work Center, check whether cost center is available

pic 7.jpg

This table does not have the cost center data.

In most of the case, to link between tables, SAP uses Internal Number, Object ID’s, Object Number. In this Table ID (Object ID) can be a link between tables.

Kindly repeat the STEP 1 to STEP 5 to get the tables associated with the Object ID

Step 7 : Repeating the STEP 1 to STEP 5 for the field ID “10000208”

pic 8.JPG

We found Table CRCO – Assignment of Work Center to Cost Center

Step 8 : Go to SE16 – Table – CRCO – Pass Object ID “10000208″

pic 9.jpg

On execution

pic 10.jpg

Work Center is associated with Cost Center 1213 till 25.09.2015 and from 26.09.2015 it is associated with cost center 1215.

In my experience, this looks like a simple scenario, but more complex scenarios will be when you are trying to find linkages with Task list and datas corresponding to it.

Assigned Tags

      18 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kamlesh Kumar Arya
      Kamlesh Kumar Arya

      Nicely described document and very useful for Functional Consultants. 🙂

      Thanks for sharing

      Regards

      Kamlesh

      Author's profile photo Maria Terence
      Maria Terence
      Blog Post Author

      Thank you Kamlesh 🙂

      Author's profile photo Satheesh Lellapalli
      Satheesh Lellapalli

      Useful Document, nicely explained thanks for sharing.

      Author's profile photo Maria Terence
      Maria Terence
      Blog Post Author

      Thanks Satheesh 🙂

      Author's profile photo Ganesh Sadula
      Ganesh Sadula

      Hi,

      Thank you for sharing informative message  ...

      -------------------------

      How to find Object ID with respective field

      As mentioned as below:-

      In most of the case, to link between tables, SAP uses Internal Number, Object ID's, Object Number. In this Table ID (Object ID) can be a link between tables.

      Kindly repeat the STEP 1 to STEP 5 to get the tables associated with the Object ID

      Step 7 : Repeating the STEP 1 to STEP 5 for the field ID "10000208"

      In Step 4 : Click Where used List as highlighted above which selection we need to select.

      With regards,

      Ganesh

      Author's profile photo Maria Terence
      Maria Terence
      Blog Post Author

      Thank you Ganesh 🙂

      Author's profile photo Former Member
      Former Member

      Very Useful Document

      Thanks for sharing.

      Regards,

      Shravan 😉 .

      Author's profile photo Maria Terence
      Maria Terence
      Blog Post Author

      Thank you Shravan

      Author's profile photo Thammisetty Venkata Shiva
      Thammisetty Venkata Shiva

      Very good document.

      Regards,

      T. Venkata Shiva

      Author's profile photo Maria Terence
      Maria Terence
      Blog Post Author

      Thanks Thammisetty 🙂

      Author's profile photo Rekha D R
      Rekha D R

      The document is neat and helpful.

      Regards,

      Rekha

      Author's profile photo Maria Terence
      Maria Terence
      Blog Post Author

      Thanks Rekha 🙂

      Author's profile photo PS R
      PS R

      Good Morning Maria,

      Thanks for sharing useful document.

      Regards,

      PS R

      Author's profile photo Maria Terence
      Maria Terence
      Blog Post Author

      Thanks PS R 🙂

      Author's profile photo Sudhakar Chaganti
      Sudhakar Chaganti

      Thanks for sharing good document.

      Regards

      Chaganti

      Author's profile photo Maria Terence
      Maria Terence
      Blog Post Author

      Thanks Sudhakar 🙂

      Author's profile photo Faisal Khan
      Faisal Khan

      Thanks great document

      Faisal

      Author's profile photo Maria Terence
      Maria Terence
      Blog Post Author

      Thanks Faisal 🙂