Help regarding report

[Former Member]

I want to create reports for sales order and purchase order

so i need is that which tables and fields will be added in the report

and which are all key fields and their purpose

thank you,

Regards,

Jagrut Bharatkumar Shukla

[Former Member]

hi jagrut,

for purchase order tables used are: vbak, vbap,

for sales order : ekko , ekpo.

with regards,

Suresh Aluri.

[Former Member]

Hi,

For PO, generally we use table EKKO (PO Header) and EKPO (PO Item). Go to SE11 to see what fields are in those tables.

[Former Member]

HI Jagrut

Sales order Header is 'VBAK' , Sales order Detail is 'VBAP'.

the key field for VBAK is VBELN (Sales Doc)

VBAP is VBELN (Sales Doc) and POSNR (item no)

Relation between VBAK and VBAP is VBAK-VBELN = VBAP-VBELN

Purchase order Header is 'EKKO' , Purchase order Detail is 'EKPO'.

the key field for EKKO is VBELN (Pur Doc)

EKPO is EBELN (Pur Doc) and EBELP (item no)

Relation between EKKO and EKPO is EKKO-EBELN = EKPO-EBELN

Regards

Wiboon

Message was edited by:

Wiboon Chaiyabutsakul

[Former Member]

Hi,

Use the tables EKKO,EKPO,VBAK, VBAP.

check out the field BSTNK in VBAK table .. which is PO number for that SO....

Reward Points if it is Useful.

Thanks,

Manjunath MS

[Former Member]

hi jagrut,

for purchase order tables used are: vbak, vbap,

for sales order : ekko , ekpo.

with regards,

Suresh Aluri.