Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Fields for a Purchase order

Former Member
0 Kudos

Hi,

I have got a requirementon smartform, but I have not received Fields.

Could anybody give me the fileds for a Purchase order Like :

SERVICE ORDER - ?

SERVICE Technicain Name - ?

Sales Order - ?

Sold to party - ?

Regards,

Xavier.P

6 REPLIES 6

Former Member
0 Kudos

Hello,

You could start with tables EEKO and EKPO.

Regards

Greg Kern

Former Member
0 Kudos

Hi Xavier,

For a Purchase order we need to have a Goods reciept in MIGO Transaction with movement type 101 or 102.

In mseg table you have Sales order No, & from SO No. you can get the Sold to party.

Thanks & regards,

Dileep .C

Former Member
0 Kudos

Hi,

Get the Sold to party from VBPA table by idetifying partner function.

Former Member
0 Kudos

SERVICE ORDER - u can get service order in table AFIH by passing equipment EQUNR

Sales Order - IN VBAK pass ur purchase order no. and u will get VBELN

Sold to party - pass sales order into vbpa and get KUNNR where PARVW (Partner function) ='RE'

OR IN MSEG TABLE ALSO U WILL GET SALES ORDER, SOLD TO PARTY BY PASSING PURCHASE ORDER.

WHICH SMARTFORM U R DOING?

GauthamV
Active Contributor
0 Kudos

Tables: ESSR,ESSH,VBAK,VBAP.

Former Member
0 Kudos

Hi ,

For po fileds u can refere tbales like

ekko (header),

ekpo-item detail

eket-shedule detail.

For sales:

vbak-header

vbap-detail.

vbep-shedule detail.

Hope this may help u.