Topic:
The purpose of these articles is to
Back ground :
this article will help developer to build Hierarchy within BW for data coming from
2. Debugging a custom hierarchy.
System:
SAP BI 7.x.
General Concept:
The target Info object has to be made as Export DS and reconnect the info object as self loop.
In self loop: Look up has to be done on DSO/Provider and update the Hierarchy with DSO/provider Data.
Data Flow Diagram:
Requirement Specification 1 : Data coming from NON SAP System and stored in Transaction DSO
Key fields
Data Fields
IO Data Source: 8ZTEST_IOHHierarchy DSO: TESTHIER CASE I_DATASOURCE.WHEN '8ZTEST_IOH'.
FIELD-SYMBOLS:
<ZFS_T_HIENODE> TYPE ROSHIENODE.
TYPES: BEGIN OF TY_TESTHIER,
/BIC/ZNODEID TYPE /BIC/OIZNODEID,
/BIC/ZIOBJNM TYPE /BIC/OIZIOBJNM,
/BIC/ZNODENAME TYPE /BIC/OIZNODENAME,
/BIC/ZTLEVEL TYPE /BIC/OIZTLEVEL,
/BIC/ZLINK TYPE /BIC/OIZLINK,
/BIC/ZPARENTID TYPE /BIC/OIZPARENTID,
/BIC/ZCHILDID TYPE /BIC/OIZCHILDID,
/BIC/ZNEXTID TYPE /BIC/OIZNEXTID,
DATEFROM TYPE /BI0/OIDATEFROM,
DATETO TYPE /BI0/OIDATETO,
/BIC/ZLANGU TYPE /BIC/OIZLANGU,
/BIC/ZTXTSH TYPE /BIC/OIZTXTSH,
/BIC/ZTXTMD TYPE /BIC/OIZTXTMD,
/BIC/ZTXTLG TYPE /BIC/OIZTXTLG,END OF TY_TESTHIER.
DATA: WA_T_HIENODE TYPE ROSHIENODE,
IT_T_HIENODE TYPE STANDARD TABLE OF ROSHIENODE,
IT_TESTHIER TYPE STANDARD TABLE OF TY_TESTHIER,
WA_TESTHIER TYPE TY_TESTHIER.
SELECT /BIC/ZNODEID
/BIC/ZIOBJNM
/BIC/ZNODENAME
/BIC/ZTLEVEL
/BIC/ZLINK
/BIC/ZPARENTID
/BIC/ZCHILDID
/BIC/ZNEXTID
DATEFROM
DATETO
/BIC/ZLANGU
/BIC/ZTXTSH
/BIC/ZTXTMD
/BIC/ZTXTLGFROM /BIC/ATESTHIER00INTO TABLE IT_TESTHIER.
CLEAR WA_T_HIENODE.
LOOP AT IT_TESTHIER INTO WA_TESTHIER.
WA_T_HIENODE-NODEID = WA_TESTHIER-/BIC/MNODEID.
WA_T_HIENODE-IOBJNM = WA_TESTHIER-/BIC/MIOBJNM.
WA_T_HIENODE-TLEVEL = WA_TESTHIER-/BIC/MTLEVEL.
WA_T_HIENODE-LINK = WA_TESTHIER-/BIC/MLINK.
WA_T_HIENODE-PARENTID = WA_TESTHIER-/BIC/MPARENTID.
WA_T_HIENODE-CHILDID = WA_TESTHIER-/BIC/MCHILDID.
WA_T_HIENODE-NEXTID = WA_TESTHIER-/BIC/MNEXTID.
WA_T_HIENODE-DATEFROM = WA_TESTHIER-DATEFROM.
WA_T_HIENODE-DATETO = WA_TESTHIER-DATETO.
APPEND WA_T_HIENODE TO IT_T_HIENODE.
ENDLOOP.
SORT IT_T_HIENODE BY NODEID.
REFRESH C_T_HIENODE[].
C_T_HIENODE[] = IT_T_HIENODE[].
REFRESH IT_T_HIENODE[].ENDCASE.
Requirement Specification 2 : Hierarchy Data coming from SAP / NON SAP System and stored in Master Data.
SELECT * FROM /BIC/HINFOOBJ2
Part 2 will explain how to debug this code at run time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
36 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |