Sunday, August 23, 2009

SAP > Edit RFQ Smartforms, Showing Buyer Name

Posted by Aries Wandari

Today customization I have to show buyer name on print RFQ.
image
Find the Purchasing group and field name at the RFQ form. Purchasing group paramater is found in EKKO-EKGRP.
image
Find the table and field name at Purchasing group configuration (SPRO > SAP Ref IMG > Materials Management > Purchasing > Create Purchasing group)
image
It shows that purchasing group at spro is using database view V_024. Go to SE11 to see which table the view use. The view is using T024 table.
image
At SE11 table T024, field that show buyer name is EKNAM.
Code below do the change.
SELECT SINGLE EKNAM INTO V_NAME_FIRST
FROM T024 WHERE EKGRP = if_ekko-ekgrp.

Result
clip_image002

0 comments:

Post a Comment