Goods Receipt - Flag/Un-flag

[Former Member]

Hi All,

in my organization the buyer has the ability to manually flag/un-flag the field "Goods Receipt".

Is there a way to track what POs had this field manually changed?

Something like this:

PO#1 changed

PO#2 not changed

...

Thanks

[anand_sagarsethi · Accepted solution]

Tcode: ME22N  Go to Environment -> Item changes you will be able to see who changed it.

or if you want to see in the list You have to build a custom report that will query CDHDR & CDPOS

and provide you report you suggested above

Thanks

Anand

[Former Member · Accepted solution]

Hi Anand,

can you clarify the steps to create the report?

Also please note that I would like the report to provide the answer for multiple PO numbers.

Thanks

[anand_sagarsethi · Accepted solution]

CDHDR - OBJECTID is PO number

CDPOS- OBJECTID = CDHDR-OBJECTID

CDPOS-FNAME = WEPOS ( Goods Receipt Indicator )

CDPOS-CHNGIND  = 'U' if updated

If that value  New = "X' its been changed to have goods receipt

if the new value = " " it been change not to have goods receipt.

Thanks

Anand

[JL23]

If they do it after the initial creation then it is possible , if they change it directly when creating the order then it is not possible via change history

But in general is this flag defaulted from customizing of account assignment category, so you just need to compare the customizing with the PO and you know that it was changed.

[Former Member]

Based on your response I have two questions:

1) Is there a table with the information for the account assignment?

2) Can I plug a list which tells me PO number / Good Receipt (flag/unflag)

I can then do a vlookup of what is in (2) against what is in (1).

thanks

[JL23]

Anything is stored in tables, account assignment category customizing is in T163K

[Former Member]

How do you retrieve a list that contains?

Supplier 1 GR (Y/N)

Supplier 2 GR (Y/N)

anyone?

[JL23]

You can get a list per purchase order using a query or a quickviewer

you basically need the table EKPO which has the information about the used account assignment category and the GR indicator.

This table needs to be joined with table T163K based on the account assignment category and from here you take the customizing value for the GR indicator.

And to add the supplier you need to join table EKKO purchase order header which has the supplier number.