topic Re: reports in Application Development and Automation Discussions

reports

Former Member — Fri, 01 Dec 2006 08:27:55 GMT

can someone plz tell me what are the tables used to generate the following reports

· Report for Sales Orders due for delivery.

· Revenue Reports based on Order Types.

Report for list of Pending Purchase Orders, Cancel Purchase

orders.

thanks & regards

seenu

Re: reports

Former Member — Fri, 01 Dec 2006 08:30:26 GMT

hi,

Check

Regards,

Santosh

Re: reports

Former Member — Fri, 01 Dec 2006 08:32:23 GMT

hi seenu,

check these tables may be useful for you

KONV Conditions for Transaction Data

KONP Conditions for Items

LIKP Delivery Header Data

LIPS Delivery: Item data

VBAK Sales Document: Header Data

VBAP Sales Document: Item Data

VBBE Sales Requirements: Individual Records

VBEH Schedule line history

VBEP Sales Document: Schedule Line Data

VBFA Sales Document Flow

VBLB Sales document: Release order data

VBLK SD Document: Delivery Note Header

VBPA Sales Document: Partner

VBRK Billing: Header Data

VBRP Billing: Item Data

VBUK Sales Document: Header Status and Administrative Data

VBUP Sales Document: Item Status

VEKP Handling Unit - Header Table

VEPO Packing: Handling Unit Item (Contents)

VEPVG Delivery Due Index

SD important tables are

VBFA Document flow (alg.)

VTFA Flow shipping documents

Sales order :

VBAK Header data

VBAP Item data

VBPA Partners in sales order

VBKD Sales district data

VBEP Data related to line items, delivery lines

Billing document :

VBRK header data

VBRP Item data

Shipping :

VTTK Shipment header

VTTP Shipment item

VTTS Stage in transport

VTSP Stage in transport per shipment item

VTPA Shipment partners

VEKP Handling Unit - Header Table

VEPO Packing: Handling Unit Item (Contents)

Delivery :

LIKP Delivery header

LIPS Delivery item

Pricing :

KONH Conditions header

KONP Conditions items

KONV Procedure ( billing doc or sales order)

KOND

contracts :

VEDA Contract data

Regards,

GNK.

Re: reports

Former Member — Fri, 01 Dec 2006 08:33:55 GMT

Hi,

FOR SALES ORDER:

VBAK Header data

VBAP Item data

VBPA Partners in sales order

VBKD Sales district data

VBEP Data related to line items, delivery lines

FOR PURCHASE ORDER:

KONH Conditions header

KONP Conditions items

KONV Procedure ( billing doc or sales order)

KOND

Regards,

Kumar

Re: reports

Former Member — Fri, 01 Dec 2006 08:35:16 GMT

HI Seenu

Please find below details:

· Report for Sales Orders due for delivery.

VBAK & VBUK will do the task.

· Revenue Reports based on Order Types.

VBAK, VBAP, VBFA, VBRK, VBRP, BKPF, BSEG...

-Report for list of Pending Purchase Orders, Cancel Purchase

orders.

EKKO, EKPO, EKET & FM: CHANGE_DOCUMENTS_READ or Tables: CDHDR & CDPOS

Kind Regards

Eswar