Reports

[Former Member]

Hi,

How to develop a report that list out all the purchase order details?

can u plz send me the tables which are required?

[Former Member]

hi,

Purchase order header --> EKKO

Purchase order details --> EKPO

EBELN is the purchase order number in both the tables.

[Former Member]

Hi,

You can use the tables EKKO - PO header table and

EKPO - PO Item table,

EKET - PO Schedule Line table

EKPV- PO Shipping data

EKBE - PO History

Regards,

JLN

[Former Member]

Hi,

Give me your mail Id i will send you an example ...

Tables

TABLES: EKKO, "Purchasing Document Header

EKPO, "Purchasing Document Item

EKKN, "Account Assignment in Purchasing Document

T163, "Item Categories in Pur

LFA1, "Vendor master

LFM1, "Vendor master record purchasing org data

EKET, "Delivery Schedules

EKBE, "History of Purchasing Document

ESSR, "Service Entry Sheet Header Data

Regards,

Santosh

[Former Member]

sudheerkumar_sap@yahoo.co.in

[Former Member]

Thank u very much..

plz send me the same for sales order

[Former Member]

Hi,

For a Sale Order Details,

VBAK - SALE ORDER HEADER

VBAP - SALE ORDER ITEM

VBEP - SALE ORDER SCHEDULE LINE

VBUK - SALE ORDER HEADER STATUS

VBUP - SALE ORDER ITEM STATUS

VBFA - SALE ORDER DOCUMENT FLOW

LIKP - DEILVERY HEADER

LIPS - DELIVERY ITEM

Regards,

JLN

[Former Member]

hi,

The related Tables are-

EINA—- Purchase Info.Record (General Data)(INFNR,MATNR,LIFNR)

EINE-- Purchase Info.Record (Pur.Orgn Data )(INFNR,EKORG)

EKKO-- PO Data (Header)(EBELN,BSTYP,BSART)

EKPO-- PO Data (Header)(EBELN,EBELP,MATNR)

EKBE--PO History Data (EBELN,EBELP,BELNR,BLDAT,MATNR,VGABE)

EKBZ--PO History with delivery Costs(EBELN,BELNR,LIFNR,XBLNR)

EKET--Schedule lines data of a PO (EBELN,EINDT,SLFDT)

Regards,

Richa