Reg. data pick

[Former Member]

Hi,

I have the requirement with the below fields in MM.

Date when the PO was entered

Vendor Name

Purchasing Group of the PO

Purchase Order Number

Purchase Order Date

Change Order Amt

Change Order Date

Reason Code

Version

Vendor Number

Currency

Please tell me how to pick this from which table it has to be.

Regards

Reddy.

User Id for PO creation

User Id for PO change

[RichHeilman]

You can get this data from the PO tables, EKKO, EKPO, EKET, EKBE.

Regards,

Rich Heilman

[RichHeilman]

Vendor name will be from LFA1.

Regards

Rich Heilman

[Former Member]

Hi,

Date when the PO was entered - EKKO-AEDAT

Vendor Name - LFA1-NAME1

Purchasing Group of the PO - EKKO-EKGRP

Purchase Order Number - EKKO-EBELN

Purchase Order Date - EKKO-BEDAT

Change Order Amt

Change Order Date

Reason Code - EKKO-ABSGR

Version

Vendor Number - EKKO-LIFNR

Currency - EKKO-WAERS

User Id for PO creation - EKKO-ERNAM

User Id for PO change -

Thanks,

Naren

[Former Member]

HI,

U can get the field version from

<b>BBPEKET-VERSION</b>.

Regards,

Kishore Reddy