Skip to Content
0
Former Member
Jan 27, 2009 at 12:08 PM

Routine - BI transformation

26 Views

Hi,

I need to read Item Category to field in Infocube from ODS where 0MATERIAL match each other.

I'm getting an error that SOURCE_FIELDS do not contain MATERIAL but is loaded.

The code on the Item Category Routine:

TYPES : BEGIN OF TYITAB,

MATERIAL TYPE /BI0/ASD_O0100-MATERIAL,

ITEM_CATEG TYPE /BI0/ASD_O0100-ITEM_CATEG,

END OF TYITAB.

DATA: itab TYPE STANDARD TABLE OF TYITAB,

WA_itab TYPE TYITAB.

READ TABLE Itab INTO WA_Itab

WITH KEY MATERIAL = SOURCE_FIELDS-MATERIAL.

IF SY-SUBRC = 0.

RESULT = WA_itab-ITEM_CATEG.

ENDIF.

Br,

Sonni