HOW TO FIND THE PAYMENT DOCUMENT NO USING THE PURCHASE ORDER NUMBER IN SAP

Real time/Important Interview questions in SAP :-

How to find the Payment Document Number (SAP FI) using the purchase order Number (SAP MM)?

Or

How do you solve the MM issues?  Do you have any technique to find FI ' PD' no based on MM 'PO' no?

Answer:

To explain the solution as a sap consultant we must have basic knowledge  regards Tables and Fields .

for this question we need to know TABLE -BKPF  and EKBE

TABLES AND SOME IMPORTANT FIELDS

EKBE- Purchasing History Data table

BKPF-Purchasing Document Header table

EKBE

EBELN-pur .doc.no EBELP-PO.item .no GJAHR-year BELNR-Mat.doc.no BUZEI-Item no BEWTP-E-Goods receipt no BEWTP-Q-Invoice receipt no BUDAT-Posting date

BKPF

BUKRS- company code BELNR- Accounting doc no/payment doc GJAHR- Fiscal year BUDAT- Accounting doc.posting date BLDAT-Accounting  doc  Date AWKEY- Reference key XBLNR- Reference doc

{Note :- For More Understanding find below links too

HOW TO FIND THE GOODS RECEIPT NUMBER USING THE PURCHASE ORDER NUMBER IN SAP ? 

HOW TO FIND THE INVOICE RECEIPT NO BASED ON PO NO  ? }

step 1: enter table EKBE in the field

 pass the purchase order no(EBELN) , item Number (EBELP)  and BEWTP-Q (Invoice receipt no)In the Table EKBE

execute 

Double click on any item to get full view of the document

note the material document no(BELNR-5105604179) and year(GJAHR-2000)

TIP : how to change the field label to Field(technical) name

          just click the 'F5' or go to menu------- settings----user parameters(f5)

select field name

enter

Now  field label is changed as field (technical) name

 go back ......

step 2:

Enter table name BKPF in the field

Execute

now  add year to   Invoice receipt number and pass the combined number in field AWKEY  in BKPF table .then we get the BELNR as Payment DOC.NO .

Invoice receipt number  & year = 51056041792000 (reference key)

enter

now we got the payment doc no (BELNR-BKPF)=510000032