topic Re: Help regarding report in Application Development and Automation Discussions

Help regarding report

Former Member — Wed, 19 Sep 2007 10:01:34 GMT

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 — Wed, 19 Sep 2007 10:12:05 GMT

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 — Wed, 19 Sep 2007 10:15:01 GMT

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 — Wed, 19 Sep 2007 10:15:05 GMT

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 — Wed, 19 Sep 2007 11:24:06 GMT

hi jagrut,

for purchase order tables used are: vbak, vbap,

for sales order : ekko , ekpo.

with regards,

Suresh Aluri.