GRN Reference document number table

[Former Member]

Dear All,

This is a basic question i think, have searched and tried in system but did not get any solution.

How to confirm that user has created GRN with respect to PO or Inbound delivery?

Any standard report available? which table contains this information?

Regards,

Priti.

[Former Member]

Hi again,

I have observed one more thing, For confirmation control key setting as  MR - relavant is ticked, GR-Relevant is ticked but GR- assignment is not ticked. When inbound delivery is created and if GRN is created with respect to Inbound delivery then in VL33N under 'status overview' 'GM' field is blank.

And if i use another confirmation key where  MR - relavant , GR-Relevant and GR- assignment all are ticked. Inbound delivery is created. If GRN is created with respect to inbound delivery then in VL33N,  under 'status overview' 'GM' field is 'C' that means it is completed.

Why is system behaving like this.

Please help.

Regards,

Priti.

[former_member183424]

Are you doing PGR through VL32N, if yes the it will save in table VBFA

Please check the thread..

Find list of inbound delivery for whic GR is no... | SCN

[Former Member]

Hi,

No i am doing through tcode: MIGO --> GR with respect to inbound delivery.

KIndly check these both cases in your system. You will also get the same. Just want to know why system is not updating goods movement in VL33N.

[former_member183424]

I have checked that in both cases.

In my system the delivery note quantity is updated in EKBE table only when we do GR against inbound delivery or outbound delivery.

As you can see my previous screen shot.

I have given two material document

One for GR against PO and One for GR against inbound delivery.

[Former Member]

Have you done this with two different confirmation control key...Plz check

I got to know that it is standard process. When GR- assignment is ticked then only IBDN status gets updated. If GR-assignment is not ticked thne the IBDN status does not gets updated in VL33N.

[Former Member]

Any help plz...??

[ajitkumar]

I didnt read the full thread. If it is inbound del, you can see the data in LIPS. for Item category ELN ( std ) or any copy you may be using in your system,

[former_member183424]

I have checked in my system,

In EKBE table, The Del. Note Quantity is updated when you have done a goods receipt via inbound delivery.

For PO it will not updated..

You can try with table EKBE and field LSMNG

If the field is blank, the goods receipt is posted without inbound delivery,

If the field is updated with quantity, then the goods receipt is posted against inbound delivery.

[Former Member]

Hi Dev,

It is showing quantity for both GRN.

Actually, we have done some change sin confirmation control key such that IBDN is non mandatory and in settings we have MR - relavant is ticked, GR-Relevant is ticked but GR- assignment is not ticked. In this case i am unable to track.

[Former Member]

You can check in MB51 report and also in MSEG table in field MSEG-EBELN for PO and for Inbound delivery you need to enter the Inbound delivery number in delivery note field while performing GRN so you can trace the same or you need to refer the PO got saved in the field MSEG-EBELN and get the inbound delivery.

[Former Member]

How canyou see in MB51 that GRN is created with respect to PO or IBDN?

Can u explain plz?

[Former Member]

If GRN is done in ref to PO you can see in field PO in MB51 and for Inbound as mentioned earlier you need to enter Inbound delivery number in delivery note to trace the same in Ref field in MB51.

[former_member212941]

Hi

EKBE  , purchase order history table

Regards

Leo