Skip to Content
Author's profile photo Tengran Liu

How to create Financial Reports by States for Tax Purposes

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.


Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo CH Raman
      CH Raman

      Useful information and good presentation.

      Thanks for sharing with us.

      Raman

      Author's profile photo Phani KV
      Phani KV

      Hi Liu,

      Useful document.

      Thanks,

      Phani.

      Author's profile photo Shanthi Bhaskar
      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...

      Author's profile photo Tengran Liu
      Tengran Liu
      Blog 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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Tengran Liu
      Tengran Liu
      Blog Post Author

      Haha that's for reminding!

      Just changed it:)

      Best Regards,

      Tengran

      Author's profile photo Former Member
      Former Member

      Useful info. Thanks for sharing Liu.. 🙂

      Regards,

      Poorna