Skip to Content
0
Former Member
May 07, 2010 at 05:52 AM

Using query for fetching values

46 Views

Hi All,

I am new to ABAP and need your inputs for the below requirement.

Requirement:

*************

Tables: EKES,EKPO,EKBE_SC

EKES-ebeln,vbeln

EKPO-werks,ebeln,insmk

EKBE_SCu2014werks,erfme,ebeln

EBELN is the primary key.

PO # will be coming from Legacy system and this will be mapped to E1BP2017_GM_ITEM_CREATE-PO_Number field.( IDOC Type is MBGMCR03).We go for a customized IDOC as ZMBGMCR03. Now this PO # should be replaced by the Inbound delivery document number.( Table :EKES)

One PO # may have more than one line item and have same or different delivery document number also.

Example:

PO # Item # Delivery #

100 10 3000

100 20 4000

250 10 4578

250 20 4578

WERKS,INSMK and ERFME should be fetched for the relevant PO ( Table :EKES ) and populate in the relevant IDOC segment before IDOC creation ( BAPI_GOODSMVT_CREATE) in the FM IDOC_INPUT_MBGMCR.

E1BP2017_GM_ITEM_CREATE-Plant

E1BP2017_GM_ITEM_CREATE--STCK_TYPE

E1BP2017_GM_ITEM_CREATE--ENTRY_UOM

Function Module name is ZIDOC_INPUT_MBGMCR ( copy of standard FM: IDOC_INPUT_MBGMCR)

How will I write a query (WERKS,INSMK and ERFME ) for replacement of PO # and fetching corresponding valued fro the relevant PO#?

Thanks..

Edited by: Dheepa on May 8, 2010 1:59 PM