It could be cumbersome for BW developers while trying to find appropriate InfoObjects to use in InfoProviders. BW developers often ask themselves if there are any standard InfoObjects that they can use for mapping with SAP ERP fields and therefore, use in the InfoProviders such as DSO.

In this blog post, I’m going to teach a way to find the mappings of SAP ERP fields with SAP BW/4HANA InfoObjects. The process I will talk about works also on SAP BW classic (3.X and 7.x).

At the end of this blog post, you’ll know how to find the standard InfoObject (if there are any) mappped with a SAP field and use in your InfoProvider.

In SAP BW classic versions, it was easier to find the right mapping for ERP fields, thanks to tables such as:

• Table RSTRFIELDSH (Shadow table: Transfer Structure Fields)
• Table RSOSFIELDMAP (Mapping Between OLTP Source Fields and InfoObjects)
• Table RSTSFIELD (Transfer structure fields)

Since these tables don’t exist anymore in SAP BW/4HANA, I started thinking about utilizing the assignment rules in BI Content Transformations. These help us to find out what InfoObjects are used to be mapped with the source fields in the standard transformations.

I created a Program named ZMAP_FIELD_INFOOBJECT for this purpose. Create the same in your SAP BW/4HANA system. I suggest that you execute this program once in background and insert the output in a table for easier and faster access.

Based on the output of my Program, I designed a helper report. You can do the same for yourself or write your email for me in comments, if you want me to send this excel report to you.
To explain how this report works, I’m giving you an example. Let’s take MATNR for instance. Here, we see that the InfoObject 0MATERIAL is used 119 times in transformation rules to be mapped with MATNR.

Source of Program:

*&---------------------------------------------------------------------*
*& Report ZMAP_FIELD_INFOOBJECT
*&---------------------------------------------------------------------*
*&
*&---------------------------------------------------------------------*
REPORT ZMAP_FIELD_INFOOBJECT.

TABLES: RSTRAN, RSTRANRULE, RSTRANFIELD.

TYPES: BEGIN OF ST_RESULT,
         ZFIELDNM      TYPE RSFIELDNM, 
         ZIOBJNM       TYPE RSIOBJNM, 
         SOURCETYPE    TYPE RSO_TLOGO_SUBTYPE,
         SOURCENAME    TYPE SOBJ_NAME,
         TARGETTYPE    TYPE RSTLOGO,
         TARGETNAME    TYPE SOBJ_NAME,
         TRANID        TYPE RSTRANID,
         OBJVERS       TYPE RSOBJVERS,
         RULEID        TYPE RSTRAN_RULEID,
         SEQNR         TYPE RSTRAN_SEQNR,
         GROUPID       TYPE RSTRAN_GROUPID,
         GROUPTYPE     TYPE RSTRAN_GROUPTYPE,
         RULETYPE      TYPE RSTRAN_RULETYPE,
         SEGID         TYPE RSTRAN_SEGID,
         STEPID        TYPE RSTRAN_STEPID,
         PARAMTYPE     TYPE RSTRAN_PARAMTYPE,
         PARAMNM       TYPE RSFIELDNM,
         FIELDTYPE     TYPE RSTRAN_FIELDTYPE,
         RULEPOSIT     TYPE RSPOSIT,
         ZSOURCE_POSIT TYPE RSPOSIT,
         ZTARGET_POSIT TYPE RSPOSIT,
       END OF ST_RESULT.

DATA: WA_RESULT  TYPE ST_RESULT,
      WA_RESULT1 TYPE ST_RESULT,
      WA_RESULT2 TYPE ST_RESULT,
      IT_RESULT  TYPE TABLE OF ST_RESULT,
      IT_RESULT1 TYPE TABLE OF ST_RESULT,
      IT_RESULT2 TYPE TABLE OF ST_RESULT,
      LV_COUNT   TYPE I,
      GR_TABLE   TYPE REF TO CL_SALV_TABLE.

SELECT-OPTIONS: P_FIELD     FOR RSTRANFIELD-FIELDNM.


SELECT RSTRAN~TRANID
       RSTRAN~OBJVERS
       RSTRAN~SOURCETYPE
       RSTRAN~SOURCENAME
       RSTRAN~TARGETTYPE
       RSTRAN~TARGETNAME
       RSTRANRULE~RULEID
       RSTRANRULE~SEQNR
       RSTRANRULE~GROUPID
       RSTRANRULE~GROUPTYPE
       RSTRANRULE~RULETYPE
       RSTRANFIELD~SEGID
       RSTRANFIELD~STEPID
       RSTRANFIELD~PARAMTYPE "0=Importing - 1=Exporting
       RSTRANFIELD~PARAMNM
       RSTRANFIELD~FIELDTYPE "F=Field - I=InfoObject
       RSTRANFIELD~RULEPOSIT
  INTO CORRESPONDING FIELDS OF TABLE IT_RESULT1
  FROM RSTRAN
  INNER JOIN RSTRANRULE  ON RSTRAN~TRANID      = RSTRANRULE~TRANID
                        AND RSTRAN~OBJVERS     = RSTRANRULE~OBJVERS
  INNER JOIN RSTRANFIELD ON RSTRANRULE~TRANID  = RSTRANFIELD~TRANID
                        AND RSTRANRULE~OBJVERS = RSTRANFIELD~OBJVERS
                        AND RSTRANRULE~RULEID  = RSTRANFIELD~RULEID
  WHERE RSTRAN~OBJVERS      = 'D' "Content
    AND RSTRAN~SOURCETYPE   = 'RSDS' "DataSource
    AND RSTRANRULE~RULETYPE IN ('DIRECT' , 'TIME').


APPEND LINES OF IT_RESULT1 TO IT_RESULT.
DELETE IT_RESULT WHERE PARAMNM   NOT IN P_FIELD.
DELETE IT_RESULT WHERE PARAMTYPE NE 0
                   AND FIELDTYPE NE 'F'.
SORT IT_RESULT BY TRANID RULEID.


CLEAR: WA_RESULT.
LOOP AT IT_RESULT INTO WA_RESULT.
  WA_RESULT-ZSOURCE_POSIT = WA_RESULT-RULEPOSIT.
  WA_RESULT-ZFIELDNM = WA_RESULT-PARAMNM.

  CLEAR: WA_RESULT1, LV_COUNT, IT_RESULT2.
  LOOP AT IT_RESULT1 INTO WA_RESULT1 WHERE TRANID = WA_RESULT-TRANID
                                       AND RULEID = WA_RESULT-RULEID
                                       AND PARAMTYPE = 1
                                       AND FIELDTYPE = 'I'.
    APPEND WA_RESULT1 TO IT_RESULT2.
  ENDLOOP.

  IF SY-SUBRC NE 0.
  ENDIF.

  DESCRIBE TABLE IT_RESULT2 LINES LV_COUNT.
  IF LV_COUNT = 1.
    WA_RESULT-ZTARGET_POSIT = WA_RESULT1-RULEPOSIT.
    WA_RESULT-ZIOBJNM = WA_RESULT1-PARAMNM.
  ENDIF.

  MODIFY IT_RESULT FROM WA_RESULT.
ENDLOOP.

DELETE IT_RESULT WHERE ZIOBJNM IS INITIAL.
SORT IT_RESULT BY ZFIELDNM ZIOBJNM SOURCETYPE TARGETTYPE SOURCENAME TARGETNAME.


CALL METHOD CL_SALV_TABLE=>FACTORY
  IMPORTING
    R_SALV_TABLE = GR_TABLE
  CHANGING
    T_TABLE      = IT_RESULT.

CALL METHOD GR_TABLE->DISPLAY.

Now, the Program ZMAP_FIELD_INFOOBJECT is at your service to help you find out which InfoObjects are mapped to SAP ERP fields in BI Content Transformations. So creation of InfoProviders gets faster by knowing what InfoObjects to include in the structure.

I hope that you find this post helpful. I’d appreciate if you share your feedback or thought in a comment.

Best regards,

Hadi