Skip to Content
0
Former Member
Jun 30, 2009 at 02:19 PM

start routine with a lookup

104 Views

Hi everyone,

I'm coming back for help from experts here.

I am just learning all this and completely confused about all source_packages and source_fields and other terms,

could anyone please help me just with some bit of code.

I guess it is not difficult what I am trying to do.

I have 2 transformations into the cube, first one fills all basic data,

and then in the second one i need to check the reference number and batch number in the cube, and if it matches reference and batch number on the source DSO, then I need to insert the vendor name field from DSO into the existing cube record.

Could anyone help me, please? I can't figure out how do I refer to the existing records in cube?

So far I have this code which doesn't work, by looking at somebody else's work, but i don't completely understand the use of all those internal variables... (error message i get is: E:Field "/BIC/ZBATCH" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement. "DATA" statement.)

+

DATA: t_source TYPE STANDARD TABLE OF tys_sc_1,

l_source LIKE LINE OF t_source,

l_package LIKE LINE OF t_source.

.....

LOOP AT SOURCE_PACKAGE INTO l_package.

IF l_package-/BIC/ZBATCH = /BIC/ZBATCH

AND l_package-/BIC/ZREF = /BIC/Z_AP_REF.

MOVE l_package-/BIC/ZVEND TO l_source-/BIC/ZVEND.

ENDIF.

+