I'm attempting to create a VBScript that will login to my companies SAP and basically run a report that outputs an HTM file for use with some other reports. Reading previous threads, it seems it is not possible, but is it just impossible with the current audit universe or is it not possible to record object level detail from the servers? Is there any way to collect this information? Are there settings that you can update to record which objects are being used? Are there any alternative universes that allow you to query this information? Are there any alternative applications that I could use? Does it make sense to approach my database administrator and see if he has a way to observe how many times a particular column has been queried?Īny advice on how to collect this information would be really helpful. I want to look at these objects and find out how many documents are using which objects in a universe. The objects become available for a report then after you complete the query. This approach requires additional preliminary work (like explicit casting of all DB fields) but I see no other way to make formatted TXT output.Is there any way to see the usage of individual objects within a document? When I say the word objects, I am referring to the fields that you drag over to the results or filter windows. The trick that is used in the above snippet: target internal table is created dynamically making all the fields char unlike real DB table, then the dummy line is added at the top of the table and all the headings are put there. Though, it is not that simple, but it definitely does the job " reserving line for headersĬAST( aedat_kost AS CHAR( 8 ) ) AS aedat_kost,ĬAST( aenam_kost AS CHAR( 12 ) ) AS aenam_kost,ĬAST( lstar_ref AS CHAR( 12 ) ) AS lstar_ref,ĪPPENDING CORRESPONDING FIELDS OF TABLE writing headersĪSSIGN COMPONENT -fieldname OF STRUCTURE TO FIELD-SYMBOL().
Lref_struct = cl_abap_structdescr=>create( components ).ĭATA(o_ref_table) = cl_abap_tabledescr=>create( p_line_type = lref_struct p_table_kind = cl_abap_tabledescr=>tablekind_std ).ĬREATE DATA o_table TYPE HANDLE o_ref_table.ĪPPEND INITIAL LINE TO. MODIFY components FROM VALUE abap_componentdescr( type = components-type ) TRANSPORTING type WHERE name ''. " making all types as char by replacing with existing PRZ char field Lref_struct ?= cl_abap_structdescr=>describe_by_name( 'CRCO' ).ĭATA(components) = lref_struct->get_components( ).ĭATA(fields) = VALUE ddfields( FOR line IN lref_struct->get_ddic_field_list( ) ( line ) ). Here is a quick-n-dirty workaround how to make an aligned output of itab with header into text: FIELD-SYMBOLS: TYPE STANDARD TABLE.ĭATA: lref_struct TYPE REF TO cl_abap_structdescr,
0 kommentar(er)
