Need a report with po,gr,ir values in LC and FC

[Former Member]

Dear experts,

How can I develop this custom report  with po,gr,ir values in LC and FC with the following fields

is their any standard sap report .Please advise

PO NO

PO DATE

GRNO

GR DT

IR NO

IR DATE

VENDOR

GR VALUE

IR VALUE

GR VALUE IN FC

IR VALUE IN FC

STATUS

Rgds

Naresh

[Former Member · Accepted solution]

Hello Naresh,

Create a query by joining the following tables: EKKO, EKPO, EKBE, with additional fields for Goods Receipt, Invoice Receipt etc.  Additional fields example: ZGR_MENGE (Goods Receipt).  Put these additional fields under extras with reference EKBE-MENGE.

Regards,

Elias

[Former Member · Accepted solution]

Thanks Elias,

Please helpme how to add the Additional fields example: ZGR_MENGE (Goods Receipt).  Put these additional fields under extras with reference EKBE-MENGE.

Rgds

Naresh

[Former Member · Accepted solution]

After joining the tables, or in the info set screen where you join the tables, you will see 'Extras'.  Click on it and use the create tab to set up ZGR_MENGE (Goods Receipt) and ZIR_MENGE (Invoice Receipt). 

Define long texts and header descriptions.  Under format, enter 'P' for type, '007' for output length and '03' for decimals.  Enter EKBE-MENGE for LIKE Reference.  Sequence for code '1'.

For Invoice Receipt, enter 017 for output length.

Just to add, your abaper would have to put in a simple code based on the specifications you give him/her.

Best of luck.

Elias