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.
+