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

Real time/Important Interview questions in SAP :-

How to find the  Goods 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 GR 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  .....

enter the no(3000000020) 

and

Execute

 

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

Here we get complete Details

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

Come back...

STEP2:

Open table MSEG and

enter the PUR.DOC.NO  and Item no in the MSEG table.......

enter the numbers and execute

then we get the Goods Receipt (MBLNR) number

                                        

                                                              (OR)

Enter the purchase order no and item  number  in EKBE table and enter BEWTP-E  .....then we get the Goods Receipt (BELNR) number

enter table -EKBE

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

 Now we get the Goods receipt no(BELNR)