Skip to Content
author's profile photo Former Member
Former Member

please help me to find the fields from different tables

I have to fetch values of the fields given below from different tables depending on the sales order number(vbeln). The value of the vbeln is taken from LIKP table.

please tell me the fields and the tables from where we can get the values as much as possible.

Order No

Sales Org

Sales Org desc

Order Date

Purchase Order #

Order Reason code

Order Reason desc

Customer Support Administrator

First Line Support Indicator

Partner Type

Partner Type Desc

Partner no

Partner Name

Partner Address 1

Partner Address 2

Partner Address 3

Partner Address 4

City

Country

Post Code

Partner email

Material no

Material Division

Product Line and Edition code -TVM1T-BEZEI

Product Line and Edition Desc

Product Name code - TVM2T-BEZEI

ProductName Desc

Product Version Code - TVM3T-BEZEI

Product Version Desc - TVM3T-BEZEI

Product Platform Code - TVM4T-BEZEI

Product Platform Desc - TVM4T-BEZEI

Product App Server Code - TVM4T-BEZEI

Product App Server Desc

Compiler Code

Compiler Desc

LanguageCode

LanguageDesc

Runtime Band Code

Runtime Band Desc

Support Start Date

Support End Date

Support Level Code

Support Level Desc

Order Quantity

Net Price

Currency

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 04, 2007 at 11:17 AM

    Hi,

    For the tables, descriptions and fields you can refer to the following tables:

    DD02L : ALL SAP TABLE NAMES

    DD02T : DESCRIPTION OF TABLE NAMES

    DD03L : FIELDS IN A TABLE.

    reward if helpful.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 11:44 AM

    Hi JD,

    another solution to this is, which will always help you

    go to the filed in the screen and find F1 help for it

    for example in VA01 place cursor in sales_org and press F1.

    a help screen will popup

    select the tools pushbutton and another subscreen will pop up

    in this screen you see appropriate field and tables for the slect options.

    reward if useful

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.