Skip to Content

Tax season again 😉 We are using logic in the tax jurisdiction code to USTX77705XXXXX. We are going to use Left(Right(Tax Jurisdiction,2),4) to get TX.

Step 1:

Enhance extractor with functional module 0FI_GL_40 enhancement

1. Go to RSA6.

2. Select your data Source 0FI_GL_40.

3. Select the “Enhance Extraction structure”

4. Give the Append Structure name. In our example we used ZZFIGL40APPEND.

Note: you will need new append structure for each extractor.

5. Append the fields to extract structure (ZZ*). In our example we use ZZTXJCD.

Note: use se11 to check the component type of the fields you are trying to append.

/wp-content/uploads/2014/01/1_374321.png

6. Goto CMOD

7. Give the project name–>Display. In our example we used ZBWEX

/wp-content/uploads/2014/01/2_374322.png

8.Click Create Component enter RSAP0001

/wp-content/uploads/2014/01/3_374323.png

9. Double Click on EXIT_SAPLARSAP_001 since we are enhancing transaction data extractor

EXIT_SAPLRSAP_001 -> Transaction Data

EXIT_SAPLRSAP_002 -> masterdata attributes

EXIT_SAPLRSAP_003 -> Master data Texts

EXIT_SAPLRSAP_004 -> Masterdata Hirarchies

/wp-content/uploads/2014/01/4_374330.png

10. Double click on ZXRSAU01

11. You can write the code under the exist.

***Enhance 0FI_GL_40 Extract with Functional Location

DATA:  l_tabix like sytabix,

      L_S_FAGL_S_SREP_LINE_ITEMS like FAGL_S_SREP_LINE_ITEMS.

CASE I_DATASOURCE.

WHEN ‘0FI_GL_40’.

LOOP AT C_T_DATA INTO L_S_FAGL_S_SREP_LINE_ITEMS.

   l_tabix = sy-tabix.

SELECT SINGLE TXJCD From Bseg into L_S_FAGL_S_SREP_LINE_ITEMS-ZZTXJCD

     WHERE BELNR = L_S_FAGL_S_SREP_LINE_ITEMS-BELNR

           AND

BUZEI = L_S_FAGL_S_SREP_LINE_ITEMS-BUZEI.

MODIFY c_t_data From L_S_FAGL_S_SREP_LINE_ITEMS INDEX l_tabix.

     Endloop.

  1. ENDCASE.

12. Save and activate the Code

13. go to Rsa6 select 0FI_GL_40–> unselect the ZZTXJCD under Hide column (by defalult new added fields goes under HIDE)

14. Save the datasource generate Data Source

15. Check the data in RSA3.


Step 2:

Enhance BW 0FIGL_D40

1. Replicate the datasource into BI side.

2. Go to BW, Create XRegion and add to 0FIGL_D40. In the transformation edit the rule. Create a substring formula. Note you cannot use Left(right) logic because the value is text. In this case we have to use substring formula.

/wp-content/uploads/2014/01/5_374331.png

/wp-content/uploads/2014/01/6_374332.png

3. Now you should be able to write a Bex report on GL based on States.


To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Shanthi Bhaskar

    Hi Liu,

    Good Information.

    One minor comment, I see your trying to get the Juridication from BSEG where you didnt use your Comp.code & Year in the where clause..which would adversely slow down your extraction as BSEG is being a cluster table…

    (0) 
    1. Tengran Liu Post author

      Thanks for your advise. I changed to FI_GL_4 because it is delta enabled.

      Can you give me more info on “use Comp.code & Year in the where clause”?

      Thanks & Regards,

      Tengran

      (0) 
  2. Dong Lee

    In your step 13

    13. go to Rsa3 select 0FI_GL_40–> unselect the ZZTXJCD under Hide column (by defalult new added fields goes under HIDE)

    The transaction code shuold be RSA6 as i see,

    Please rectify it.

    🙂

    Best Regards!

    Lee Do

    (0) 

Leave a Reply