topic Reports in Application Development and Automation Discussions

Reports

Former Member — Wed, 29 Nov 2006 10:41:10 GMT

Hi,

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

can u plz send me the tables which are required?

Re: Reports

Former Member — Wed, 29 Nov 2006 10:42:56 GMT

hi,

Purchase order header --> EKKO

Purchase order details --> EKPO

EBELN is the purchase order number in both the tables.

Re: Reports

Former Member — Wed, 29 Nov 2006 10:43:59 GMT

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

Re: Reports

Former Member — Wed, 29 Nov 2006 10:44:21 GMT

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

Re: Reports

Former Member — Wed, 29 Nov 2006 10:46:31 GMT

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

Re: Reports

Former Member — Wed, 29 Nov 2006 10:59:47 GMT

sudheerkumar_sap@yahoo.co.in

Re: Reports

Former Member — Wed, 29 Nov 2006 11:16:57 GMT

Thank u very much..

plz send me the same for sales order

Re: Reports

Former Member — Wed, 29 Nov 2006 11:28:18 GMT

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