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