HOW TO FIND THE INVOICE RECEIPT NO BASED ON PO NO

Real time/Important Interview questions in SAP :-

How to find the Invoice receipt  no using the purchase  order no ?

or

How do you solve the MM issues ? do you have any technique to find the process of PR no and IR 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 -EKPO ,MSEG  and EKBE

TABLES AND SOME IMPORTANT FIELDS

EKPO- Purchasing Doc. item level  table

MSEG- Material Doc. Segment table

EKBE- Purchasing History Data table

EKPO	MSEG	EKBE
EBELN-pur.doc.no EBELP- po item no MATNR-material doc no MENGE-po quantity NETPR-net price BANFN- PR no BNFPO- PR item no	MBLNR-mat.doc.no /Goods  receipt no MJAHR-year ZE1LE -mat.doc. item no BWART-movement type MATNR-material no WERKS- plant no LGORT-storage location CHARG-batch no	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

step1:-

Go to SE16  -------- Enter

enter TABLE name-EKPO 

  click table content ICON-

Select the fields- EBELN 

(-to find the fields use search icon        )

enter

Now enter purchase order doc no(EBELN) no in the field.

(real time end user will provide the number   or  we can find purchase order no by passing the Purchase requisition(BANFN) number. but this is IDES system not available PR no)

now  Iam taking sap provided  PR DOC Number to continue explain .....

enter the no(3000000020) and execute

find the item no ...double click on any item no...to view complete details

Note the purchase order doc.no and item no(00001/00002).

Come back...

STEP2:     TO FIND THE  IR NO BASED ON PO NO

             

   Enter the purchase order no and item number in EKBE table and enter BEWTP-Q..... Then we get the BELNR as Invoice Receipt (BELNR) number

Enter table -EKBE

Enter purchase order(EBELN),Item no(EBELP)  and BEWTP-Q -----------  Enter

Now we get the Invoice receipt no(BELNR)