Table name and Field names

[Former Member]

pls tell me the Table name and field names for the following.

i want to create a purchase order, so that i want to get the following fields:

sender address

receiver address

purchase order date

order no:

payment terms:

port of loading

port of discharge

terms of delivery

And the line items are:

item name

packing

cases

quantity

price

[Former Member]

Try the below tables:

ekko, " Purchasing Document Header

EKPO, " Purchasing Document Item

EORD,

LFA1,KNVP,EIKP,EIPO,EKPA,EKKN,A016,KONP.

Reward points..

[former_member387317]

Hi Sanil,

Pls hv a look on

EKKO

EKPO

Also see for other EK* tables

Hope it will solve your problem..

Reward points if useful..

Thanks & Regards

ilesh 24x7

[Former Member]

Hi,

See tables : EKKO : header

EKPO : Item.

Reward if helpful....................

[Former Member]

Hi Sanil,

U get the Header Details From EKKO Table and

Item Details from EKPO Table

if u want address u need to know the VENDOR Number and then with that Number u get the address from ADRC Table.

Hope this helps...

Best regards,

raam

[p291102]

sender address - EKKO-KUNNR

receiver address - EKKO-LBLIF

purchase order date - EKKO-AEDAT

order no: - EKKO-EBELN

payment terms: - EKKO-ZTERM

port of loading - EKPO-EGLKZ

port of discharge -

terms of delivery -

And the line items are:

item name - EKPO-EBELP

packing - LIPS-PCKPF

cases -

quantity - EKPO-MENGE

price - EKPO-NETPR