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