![]() Wa_field_cat-reptext_ddic = 'FIELD NAME'.Get Example source ABAP code based on a different SAP tableĪBAP Syntax. Wa_field_cat-reptext_ddic = 'ROUTINE TYPE'. Wa_field_cat-reptext_ddic = 'TRANSFORMATION DESCRIPTION'. Wa_field_cat-reptext_ddic = 'OBJECT VERSION'. Wa_field_cat-reptext_ddic = 'TRANSFORMATION ID'. SORT itab BY tranid objvers routtyp fieldnm lineno ASCENDING. READ TABLE it_trantxt INTO wa_trantxt WITH KEY tranid = wtab-tranid. READ TABLE it_tran INTO wa_tran WITH KEY glbcode2 = wa_tran1-codeid. READ TABLE it_tran INTO wa_tran WITH KEY glbcode = wa_tran1-codeid. READ TABLE it_tran INTO wa_tran WITH KEY edrout = wa_tran1-codeid. ![]() READ TABLE it_tran INTO wa_tran WITH KEY strout = wa_tran1-codeid. READ TABLE it_tran_rout INTO wa_tran_rout WITH KEY codeid = wa_tran1-codeid. READ TABLE it_tran INTO wa_tran WITH KEY exprout = wa_tran1-codeid. SELECT tranid txtlg FROM rstrant INTO TABLE it_trantxt. SELECT tranid objvers objstat startroutine endroutine expert glbcode glbcode2 FROM rstran INTO TABLE it_tran. SELECT tranid objvers codeid paramtype fieldnm FROM rstranroutmap INTO TABLE it_tran_rout WHERE paramtype = 1. * DELETE ADJACENT DUPLICATES FROM it_tran1 COMPARING codeid. SELECT codeid objvers line_no line FROM rsaabap INTO TABLE it_rs_abap WHERE objvers = 'A' AND line LIKE target. PARAMETER: target1(30) TYPE c LOWER CASE.ĭATA: it_tran_rout TYPE TABLE OF ty_tran_rout,ĭATA: it_rs_abap TYPE TABLE OF ty_rs_abap,ĭATA: it_trantxt TYPE TABLE OF ty_trantxt,ĭATA : it_field_cat TYPE slis_t_fieldcat_alv , ![]() *select-options: INFOPROV for no intervals. *selection-screen begin of block b1 with frame title text-001. Program (can be used in any SAP-BW system): For example, if you want to delete a DSO but you are not aware which transformation uses the relevant DSO Active data table /BIC/AXXXX00 in routines, then this tool can be used to locate the relevant transformation. This will help SAP-BW consultants to make better decisions, in case of deleting master data or the object itself. The Transformation Routine Reference Finder tool can be used in any SAP-BW system to find the transformation routines where-ever the table or other pattern references are used. Since the input is pattern based, any name can be given as an input (such as ‘itab’, ‘lt_vendor’, ‘ZMATERIAL’, ‘/BIC/AZPC0100’, etc).įor example, if we would like to find the transformations wherever the Master data table ‘/BI0/PPLANT’ is used, this table name can be provided as an input and the resulting screen displays all the relevant information.This program does not impact the performance of the system.The program utilizes standard tables to find the results, therefore the program can be used in any SAP-BW system (Global/Universal tool).Field Name (Wherever Field Routines are implemented).Routine Type (Start Routine/End Routine/Field Routine/Global code/Global Code 2).The Output of this report contains the following fields: It shows the following details which will help to easily locate the line within the routines in all the relevant transformations. ![]() It takes the input of any technical name in SAP-BW as a ‘Pattern’ and renders the list of all transformations wherever the reference table/pattern is used. Therefore, this tool serves the purpose to identify the transformations wherever the table (or any other pattern) references are used. The Where-used list in any Info-provider renders the Object references but never yields the Code references used within any transformation. SAP-BW Consultants encounter situations to identify the list of Transformations where the references to Master Data Tables (Example – /BI0/PMATERIAL, /BI0/PRT_LOCATIO), DSO Active Data tables (Example – /BI0/AFIAP_O0300), Fiscal Year Variants (Example – ZA, ZB, ZM), etc. This tool can be used to find the usage/reference of any Master Data tables, Info-provider, Fiscal Year Variants, etc in transformation routines. Transformation Routine References Tool Usage: In order to find the Transformation routines in which the tables/Infoproviders are referred to, I have developed the tool called as ‘SAP-BW Transformation Routine References Tool’. This table might be used in many routine codes under multiple Transformations. While clicking on the ‘where used list’ of 0MATERIAL, it doesn’t show the Code Line where this table has been referred in a Transformation. For example, the 0MATERIAL master data table /BI0/PMATERIAL might be called in a Start Routine code (Example Code: SELECT * FROM /BI0/PMATERIAL) under a Transformation. However, it doesn’t show the Transformation routines/codes (Start Routine/End Routine/Field Routine/Expert Routine) where the Info-Object tables are referred to. While checking the ‘Where-used List’ of any Info-Objects in SAP-BW, the result shows the relevant Infocubes, DSOs, Queries, Transformations, etc.
0 Comments
Leave a Reply. |