Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

AP detail reports

FakhriSCR
Explorer

‎03-05-2024 6:10 AM

0 Kudos

I need report which contained below information.

Vendor

Contract

Contract invoice

Payments

Closing balance of every invoice.

I used several reports in order to get information.But there is a  problem i coulnd find any report which show only payments YFIMM_REPORT to contracts but i could get a list.i I have to write per contract numbers i need list.Also i couldnt find invoices under which contract reports.

Could anyone help me?

Thank is advance

Labels:
1 REPLY 1

raymond_giuseppi
Active Contributor

‎03-05-2024 9:51 AM

Program/Transaction starting with Z or Y are custom program defined in your systems

Else

  • Contracts are in EKKO (EKPO, etc.) where document category is K
  • Purchase order (released contract) are in the same table where document category is F (EKKO-KONNR to join)
  • Invoices are in RBKP (RSEG, etc.) contain PO information and are linked to FI document BKPF (BSEG, etc.) thru BKPF-AWTYP (RBKP) and AWKEY reference
  • Payment can be found thru Clearing document (BSEG/BSIK-AUGBL, etc.)
  • etc.

What did you already code and where are you stuck?