2009 Mar 31 8:28 PM
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
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
2009 Mar 31 8:30 PM
Hello,
You could start with tables EEKO and EKPO.
Regards
Greg Kern
2009 Apr 01 2:30 AM
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
2009 Apr 01 4:38 AM
Hi,
Get the Sold to party from VBPA table by idetifying partner function.
2009 Apr 01 5:26 AM
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?
2009 Apr 01 5:36 AM
2009 Apr 01 5:56 AM
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.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |