Please reply

[vasanth_rajagopal]

Please use informative subject in future

hi guyz..

I am new to ABAP., i have been given a scenario asking to write a program for displaying sales order

specifying the line items.,

• The number of line items are more than 2

1. How do i know which table holds the fields of Sales orders and other fields like line items.

2. how do i go by choosing which is the line item field ., Is it POSNR field present in the table or something else.

please guide..

vasanth

Edited by: Matt on Mar 12, 2009 7:15 AM

[Former Member]

Hi,

• Use relevant subject line*

As for your requirements, use the tables VBAK, and VBAP for all the relevant field values u need for your report.

Regards,

Mansi.

[Former Member]

As you are new to ABAP, first of all I would recommend you to go through the following important tables

1)VBAK

2)VBAP

3)LIKP

4)LIPS

5)VBRK

6)VBRP

7)EKKO

8)EKPO

First 6 tables are related to the Sales Order to Cash Process

Last two tables are related to Procurement....I mean Purachase Orders.

There are many more tables that are useful.I have mentioned only the important ones.

Answering your question, there will always be a common field which will be useful to find the lineitems related to the header.

In case of VBAK and VBAP, it is the filed VBELN which is common.

So, for all the entries of VBAK-VBELN field , you will have different number of entries in VBAP-VBELN

For example....

Go to table VBAK in SE16 transaction.

Press F8

Select any sales order number which you get it in VBELN field.

Now go tot SE16 and select VBAP table

Put the sales order number which you have selected from VBAK table.

You will get the list of line items for that sales order.

Hope this is clear...

Please let me know if you have questions.

I will provide with example code if you need.

Please get back to me

[Former Member]

Get Sales Order Header details from Table VBAK

Get Item details from Table VBAP . VBAK-VBELN = VBAP-VBELN

[Former Member]

Hi,

To dispaly the details of sales order use table VBAK whcih is header table,

VBAP which is item table.

First put selct quary on VBAK, then accourding to VBAK , put select quary on VBAP table.

Put loop on VBAP, so that u got all item details.

Thanks & Regards,

Anagha Deshmukh

[Former Member]

the table for sales doc header is VBAK use vbeln from here as "for all entries" into VBAP to get line item details.yes the field is POSNR for item details.

Next time Search the forum and do some research on your own, then get back to sdn if faced with issues.

кu03B1ятu03B9к

[Former Member]

Hi,

Use tables VBAK and VBAP with the proper filter as per the sclection screen inputs. Do not select entire data as these are very huge tables.

Regards,

Pranaya

[Former Member]

Hi:

Use the function module BS01_SALESORDER_GETDETAIL by passing VBELN - sales order, the entire informations would be given by the this function module.

how to use it, go in se37 and click on where used list - it would give the list

select anyone and find the way to use it.

Regards

Shashi

[Former Member]

Hi..,

For sales order

1) VBAK is the header table and VBAP is the item table.

2) VBAK and VBAP contains VBELN(Sales document) field ... You can choose line items using like this vbak-vbeln = vbap-vbeln ...

Hope this helpful to u...

Cheers

[Former Member]

Hi Vasanth,

Kindly go through this link,

http://www.erpgenie.com/utilities/564

Here all the sales order tables are listed with their descriptions.

Hope it helps

Regrds

Mansi

[matt]

Please use informative subject in future

[Former Member]

Vasanth,

Have you got the solution?

If not, please get back to me

[vasanth_rajagopal]

thanks babu..am going thru it..will get back to u if any..thanks..

[Former Member]

Hi,

Check the below Link

Hope this helps you.

Regards,

Anki Reddy

[vasanth_rajagopal]

hi frendz..

thanks for all ur pouring replies..it was useful..

vasanth