topic Re: Please reply in Application Development and Automation Discussions

Please reply

vasanth_rajagopal — Thu, 12 Mar 2009 05:24:27 GMT

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

Re: Please reply

Former Member — Thu, 12 Mar 2009 05:26:18 GMT

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.

Re: Please reply

Former Member — Thu, 12 Mar 2009 05:27:22 GMT

Get Sales Order Header details from Table VBAK

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

Re: Please reply

Former Member — Thu, 12 Mar 2009 05:28:00 GMT

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

Re: Please reply

Former Member — Thu, 12 Mar 2009 05:28:09 GMT

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к

Re: Please reply

Former Member — Thu, 12 Mar 2009 05:32:07 GMT

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

Re: Please reply

Former Member — Thu, 12 Mar 2009 05:33:22 GMT

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

Re: Please reply

Former Member — Thu, 12 Mar 2009 05:34:03 GMT

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

Re: Please reply

Former Member — Thu, 12 Mar 2009 05:35:01 GMT

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

Re: Please reply

Former Member — Thu, 12 Mar 2009 05:40:16 GMT

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

Re: Please reply

matt — Thu, 12 Mar 2009 06:15:39 GMT

Please use informative subject in future

Re: Please reply

Former Member — Thu, 12 Mar 2009 06:17:23 GMT

Vasanth,

Have you got the solution?

If not, please get back to me

Re: Please reply

Former Member — Thu, 12 Mar 2009 08:28:02 GMT

Hi,

Check the below Link

Hope this helps you.

Regards,

Anki Reddy

Re: Please reply

vasanth_rajagopal — Thu, 12 Mar 2009 09:33:37 GMT

hi frendz..

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

vasanth

Re: Please reply

vasanth_rajagopal — Thu, 12 Mar 2009 09:34:03 GMT

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