Hi Friends,
I'm the BW consultant...
i had written one START ROUTINE.. for the purpose of this is... it was fetching the Product codes data from another DSO .. based on Bill no's
for this i had create one structure..
after that i had create one table..
after that i had create one work area..
but the problem is it was fetching first record from the DSO and loaded into consolidated DSO... not all the product numbers.. each bill contain several products...
for this.. in start routine.. i defined gloabally.. the structure.. and select statement..
TYPES: BEGIN OF ITAB,
/BIC/RBILLNO TYPE /BIC/OIRBILLNO,
/BIC/RPRD_CDE TYPE /BIC/OIRPRD_CDE,
/BIC/RPRD_QTY TYPE /BIC/OIRPRD_QTY,
/BIC/RUNT_PRI TYPE /BIC/OIRUNT_PRI,
/BIC/RPRD_RATE TYPE /BIC/OIRPRD_RATE,
END OF ITAB,
JTAB TYPE STANDARD TABLE OF ITAB WITH NON-UNIQUE DEFAULT KEY.
DATA : KTAB TYPE JTAB ,
KTAB_WA TYPE ITAB,
SELECT /BIC/RBILLNO /BIC/RPRD_CDE /BIC/RPRD_QTY /BIC/RUNT_PRI
/BIC/RPRD_RATE FROM /BIC/ATESTODS100 INTO TABLE KTAB FOR ALL ENTRIES IN SOURCE_PACKAGE WHERE /BIC/RBILLNO = SOURCE_PACKAGE-/BIC/RBILLNO.
And I wrote select statement... it was working fine....
and field level.. i had written the following code...
CLEAR KTAB_WA.
READ TABLE KTAB INTO KTAB_WA with key /BIC/RBILLNO = SOURCE_FIELDS-/BIC/RBILLNO BINARY SEARCH.
IF sy-subrc eq 0 .
RESULT = ktab_wa-/bic/rprd_cde.
ENDIF.
so, how can i put the loop for this... can you plz tell me the solution..
regards
BABU
Bluesky
