How to create Financial Reports by States for Tax Purposes
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
- Go to RSA6.
- Select your data Source 0FI_GL_40.
- Select the "Enhance Extraction structure"
- Give the Append Structure name. In our example we used ZZFIGL40APPEND. Note: you will need new append structure for each extractor.
- 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.
- Goto CMOD
- Give the project name-->Display. In our example we used ZBWEX
- Click Create à Component à enter RSAP0001
- 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.
- Double click on ZXRSAU01
- You can write the code under the exist.
***Enhance 0FI_GL_40 Extract with Functional Location
DATA: l_tabix like sy-tabix,
- L_S_FAGL_S_SREP_LINE_ITEMS like FAGL_S_SREP_LINE_ITEMS.
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.
- Save and activate the Code
- go to Rsa3 select 0FI_GL_40--> unselect the ZZTXJCD under Hide column (by defalult new added fields goes under HIDE)
- Save the datasource à generate Data Source
- Check the data in RSA3.
Step 2: Enhance BW 0FIGL_D40
- Replicate the datasource into BI side.
- Go to BW, Create Xregion and add to 0FIGL_D40. In the transformation edit the rule. Create a substring formula. Note you can not use Left(right) logic because the value is text. In this case we have to use substring forumla.
- Now you should be able to write a bex report on GL based on States.
There you have it. Follow the guide and we shall know how to create financial reports.If you still have further questions about your system, we offer professional advice and service.