Custom table which holds sales order item, item characteristics and values.
i am stuck in the requirement where i have created a ZREPORT(to run in background) to populate a custom table i.e ZTABLE which holds sales order item characteriistics and their values.
i am giving the general idea to the ZTABLE which has the field in the way mentioned below.
|so doc number||item||update date||doc caterory||characteristic 1||characteristic 2|
|201456633||10||20.02.2015||B||characteristic value||characteristic value||characteristic value||characteristic value|
to get the characteristic of sales order item i am fetching the data from the database table in the following way.
step 1. passing VBELN to VBAP and to get CUOBJ(configuration).
step 2. passing CUOBJ to IBIN to get IN_RECNO and INSTANCE i.e equal to CUOBJ
step 3. passing IN_RECNO to IBINVALUES to get SYMBOL_ID.
step 4. passing SYMBOL_ID to IBSYMBOL to get ATINN ATWRT.
step 5. passing ATINN ATWRT to CAWN table to get ATINN ATZHL ADZHL ATWRT
step 6. passing ATINN ATZHL to CAWNT table to get ATWTB (value description).
AND i have 3 internal table IT_TAB_SO and IT_TAB_CHAR and IT_FINAL.
IT_TAB_SO : holds the sales order, item, Doc cat and configuration i.e CUOBJ.
IT_TAB_CHAR: will hold the data fetched from IBIN, IBINVALUES, IBSYMBOL, CAWN, CAWNT
IT_FINAL: combined data of IT_TAB_SO and IT_TAB_CHAR and link is CUOBJ = INSTANCE.
now the problem is i am not able to Populate data in IT_TAB_CHAR internal table.
So kindly guide me how can i achieve this as ATINN have multiple values in CAWNT, then IN_RECNO in IBINVALUES have mutliple symbol_id.
i tried parallel cursor method to populate the data in final internal table IT_TAB_CHAR but no luck!!
i know the function module VC_I_GET_CONFIGURATION by which i can achieve the same..
but i want to get values of 18 specific characteristic in to the ZTABLE using the report which i going to run in background.
and ZTABLE data will be used in other REPORTS.
thanks in advance!!