I am trying to lookup DSO_1 when Loading from Datasource to DSO_2 to derice a Key_Figure_1 (NETPR_VKM), there are 4 common fields that will uniquely identify a record within these two DSO's
I have the following code in my Start Routine
DATA: it_zdso_1 TYPE STANDARD TABLE OF /BIC/AZDSO_1.
DATA: wa_zdso_1 TYPE /BIC/AZDSO_1.
SELECT DOC_NUMBER S_ORD_ITEM GI_DATE MATERIAL SCHED_LINE NETPR_VKM
INTO CORRESPONDING FIELDS OF TABLE it_zdso_1
FOR ALL ENTRIES IN SOURCE_PACKAGE
WHERE doc_number = SOURCE_PACKAGE-VBELN
AND s_ord_item = SOURCE_PACKAGE-POSNR
AND gi_date = SOURCE_PACKAGE-WADAT
AND material = SOURCE_PACKAGE-MATNR
AND sched_line = SOURCE_PACKAGE-ETENR.
I mapped all the four fields to NETPR_VKM in my transformations and chose routine, what do I do now ?