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

A Fresher needs help in reporting fields

Hi,

I am a new SAP BW person and have been given a report to write for SD. I am having trouble identifying the following naming fields and would grately appreciate your help..

The client likes the report by the following naming fields:

Order Type,

Sales Group responsible for the order,

Customer Group,

Document Currency and Base Currency (USD),

Sold To,

Ship To Party,

Inco Terms,

Payment Terms,

Account Assignment Group,

Transmission Type (Way the order is transmitted to customer),

Complete Delivery Indicator,

Fiscal Year/Period (Created on Date)

The values they would like to see are :

Open Orders,

Order Quantity,

Gross Value,

Cost,

Number Of Orders,

Number Of Order Items,

Number Of Transmission Types,

Count Of Complete Deliveries Required

Any help will be much appreciated..

Regards,

Munir

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 10:09 PM

    hi,

    if you want to know the filedname just place the cursor on the field and press f1 and in f1 help select technical information where you can see the table name and the field name.

    regards,

    krishna prasad

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 02:45 AM

    Hi

    If you feel this answer solve your query please reward with points.

    For this go to transaction code va05n it will display order list in this you can find all the fileds like open orders list and complete order list in this just you press f1 on each filed you will get an window in that just go in to technical information or else press f9 you will get the result what ever you are looking for

    Thanks & Regards

    reward points if its helpful

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Being a BW person, I dont yet have access to some R3 transactions.. Hence I was wondering if there was like a data dictionary or some sort of preset field mappings which I could use/look at...

      Thanks,

      Munir

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 09:20 AM

    Hi,

    Please use tables VBAK and VBAP tables where you can see all these fiels with technical names as well as funcitonal names...

    Regards

    sankar

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sankar,

      Its interesting that these two tables have been mentioned to me by some or my peers, however they were not able to tell me ( or point me in the right direction) in getting the specific field names from these.. Is there a way to see all the fields and may be from your experience, know which of the required fields will be the ones from the field list I mentioned..

      Thanks,

      Munir

  • author's profile photo Former Member
    Former Member
    Posted on Jun 19, 2008 at 08:16 AM

    Dear Munir,

    Go to transaction code VF05.

    There you can find all the fields which you have mentioned.

    Select a field whichyou want and right click, you will get a screen where you can see a field technical, click on that you will get all the information relavant to that field.

    If you have any querries revert back the same to me.

    Amjath

    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.