Sales Order VA03

[Former Member]

Hi ,

For Sales Order --- > Shedule Line Item (icon at bottom) ---> Account Assignment (tab) -

---

> Order

Need to pick this order for a sales order/ line item .

May i know the tables involved to display this order for a sales order/line item

Thxs,

Vind

[Former Member]

check table s

<b>VBAK --sales header

VBAP --sales item

VBEP -->sales item scheduling</b>

regards,

vijay

[Former Member]

Hi vind,

i use: VBAK, VBKD, VBAP, VBBE.

Look via SE16 (or SE11) with VB*

Regards, Dieter

[ferry_lianto]

Hi Vind,

The order is stored in table VBAP and field AUFNR.

Regards,

Ferry Lianto

[Former Member]

hi Vind,

data IT_VBAK type table of VBAK with header line.  "refine structure with only necessary fields
data IT_VBAP type table of VBAP with header line. "refine structure with only necessary fields
data IT_VBEP type table of VBEP with header line. "refine structure with only necessary fields

select * from VBAK into table it_VBAK where <condition>.

select * from VBAP into corresponding fields of table it_VBAP for all entries in it_VBAK where 
                  VBELN = it_VBAK-vbeln.

select * from VBEP into corresponding fields of table 
it_VBEP for all entries in it_VBAP where 
              VBELN = it_VBAP-VBELN and 
              POSNR = it_VBAP-POSNR and 
              ETENR = <schedule line item>.

loop at it_VBEP.
   write:/ it_vbep-vbeln,
             it_vbep-posnr,
             it_vebp-etenr,
             it_vbep-aufnr. "Order
endloop.

Hope this helps.

Sajan Joseph.

[Former Member]

Hi Vind,

Let me explain the relationship among teh tables used in the VA03 for schedule line items.

VBAK: It is a Sales Header table which stores the sales order header data.

VBAP: It is a Sales Order line item table whichc stores the line item infomation

VBEP: It is a schedule line item table stores for scheduleing of the line item

Now Relationship between VBAK and VBAP..

VBAK-VBELN = VBAP-VBELN.

and relationship between vbap and vbep is

VBAP-VBELN = VBEP-VBELN and VBAP-POSNR = VBEP-POSNR..