topic Re: tables,fields in Application Development and Automation Discussions

tables,fields

Former Member — Wed, 25 Oct 2006 09:42:32 GMT

with reference to the Purchase order i need to develop delivery note program.

the fields i needed init are from address, to address, po number, quantity, item id, description, and package weight.

what are the tables i should look into it an dfields.

regards..

Re: tables,fields

Former Member — Wed, 25 Oct 2006 09:44:18 GMT

VBAK, VBAP, EKKO, EKPO, KNA1, ADRC, MAKT, VBFA, VBRK, VBRP

regards,

Sandeep Josyula

*Mark helpful answers

Re: tables,fields

Former Member — Wed, 25 Oct 2006 09:49:02 GMT

PO number = EKKO-EBELN

Qty = EKPO-MENGE

from address = KNA1 & ADRC

To address == KNA1 & ADRC

item id = EKPO-MATNR

description = MAKT

package weight EKPO-NETGW

Since you need it for PO the tables should be EKKO and EKPO

Message was edited by: Anurag Bankley

Re: tables,fields

Former Member — Wed, 25 Oct 2006 09:54:13 GMT

Hi,

use table as ekko,ekpo,lips,likp,

ekko-ebeln = vbak-bstnk->vbak-vbeln(sales order)

vbak-vbeln = lips-vgbel->lips-vbeln(delivery no}

ekpo-menge(qty)

ekpo-ebeln(purchase no)

ekpo-posnr(item id)

ekpo-TXZ01(description)

Regards

amole

Re: tables,fields

Former Member — Wed, 25 Oct 2006 10:21:33 GMT

Hi , Nihi .

first of all try to pick one delivery number which is processed (i mean not open ) ..

u 'll find this in likp header ,, open and see the delivery number ..with some items

take this delivery number goto lips for items ..

for this delivery u'll find a sales order number.

likp-vbeln = lips-vbeln.

lips-vgbel = vbap-vbeln

lips-vgpos = vbap-posnr

3.vbap-vbeln = vbak-vbeln.

in that take the sales order number ,, goto vbak--vbeln

and execute ,, it will give u a list of details

in here take the purchase order number ...

now goto ekko -po header

give the po number and execute ..

this will give u po details at header level.

now for the items levels goto ekko and eket for the item and scheduled lines for the items ..

po number , quantity , item number in ekpo/eket

material is avaliabe over here ..

material description from makt maktx.

package weight from lips or ekpo/eket

first of all try to come in the reverse manner and then understand the flow ..

for open and closed goto vbuk , vbup etc..

in addition to this go to vbuk for status ..

hope this helps ,

regards,

vijay

Re: tables,fields

Former Member — Wed, 25 Oct 2006 10:53:16 GMT

Go thru this link.

http://www.sapfans.com/sapfans/repos/saptips.htm

Thanks

Sunil