Scribd
Upload
77 views9 pages

Value Table in SAP

This document describes two methods for identifying the source table for fields in an SAP table that are populated from a value table. Method 1 involves using F1 and technical information to find the value table referenced for a given field. Method 2 looks up the field in transaction SE11 to view the value table. It provides the example of sales fields in table VBAK being populated from value table TVK0. Maintaining both key and text for a field also indicates it comes from a lookup table, as shown for field VBTYP.

Uploaded by

Eugene
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
77 views9 pages

Value Table in SAP

This document describes two methods for identifying the source table for fields in an SAP table that are populated from a value table. Method 1 involves using F1 and technical information to find the value table referenced for a given field. Method 2 looks up the field in transaction SE11 to view the value table. It provides the example of sales fields in table VBAK being populated from value table TVK0. Maintaining both key and text for a field also indicates it comes from a lookup table, as shown for field VBTYP.

Uploaded by

Eugene
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 9

Value Table in SAP:

In SAP Tables, for some fields data we can see in different color (Green) as shown below.

Ex:
➢ Table: VBAK
➢ Fields: Sales Type, Sales Org, Division, Distribution Channel

If we see any fields information appearing in different color, that means these fields are
getting filled from some other Table.

Method 1:
Steps:
❖ Put a Cursor on that field and Press F1 ( Fn + F1 )
❖ Click on Technical Information

❖ Double click on Data Element ( in this case it is VKORG )


❖ Double Click on DOMAIN (in this case it is VKORG)
❖ Go to Value Range Tab

❖ Below we can see the Option called – Value Table

For Sales Org field in VBAK table, we are getting data from TVK0
If we go go TVK0 we can see the information about Sales Org

Method 2:

Go To SE11 – provide the table VBAK and find the filed VKORG

❖ Double Click on Data Element – VKROG


❖ Double Click on DOMAIN
❖ Go To Value Range Tab

❖ Below we can see the Value Table


And sometimes filed is not appearing in Green Color but for that field Key and Text both are
maintained.

For example in VBAK we have Document Category (VBTYP ) field and for this value information
is maintained
❖ GO TO SE11 – VBAK Table – SEARCH FOR VBTYP Filed and double click on Data element

❖ Double Click on Domain - VBTYP


❖ Under Single Values section we can see the data maintained for each value.

Hope this document will be useful.


Vijay Mutyala. (https://www.linkedin.com/in/vijay-mutyala/)

You might also like