on 2022 Oct 07 8:14 AM
Hi community,
I have a question concerning a task which is a little bit tedious and annoying.
Maybe someone has the "magic trick" for the following task:
I sometimes need to copy such tabular views and edit them with Excel. The way I do it is either rowwise per hand (ctrl+c, ctrl+v) or if to much lines: minimize the view, print into a PDF and transform via online tool into Excel.
BR
Andreas
Request clarification before answering.
Hello Andreas,
Option 1 : Standard Export
Some Business configuration activities supports the excel Export option for the data that is maintained. ( For example Charts of account ** --> Edit Chart of account. Here you can export the list of GL.
Option 2 : with SAP
If export option is not available -- then check if activity as version control. In some business configuration activity, you can click on you can also and select view previous versions. ( For example : Profit Center Derivation --> Profit Center Derivation by Product Category for Inventory ) in such case, I remember SAP can also extract the information from the backend and provide.
However here you will need support form SAP.
Option 3 : Change History
Go to Business Configuration
Reports view
Open Configuration Change History Report
Go to Fine-Tune Settings
Select the period or all Activity
Search for the Fine tune activity ( in your case would be Supplier) Using column filter - on top table.
make sure that you select the row with appropriate the last deployment date.
Remove the flag for Changes Only ( On top table again) or remove the flag Changes only ( Details table on bottom part of screen)
Click on Download Change Details.
this will download Zip file ( depending on volume of data - you need to wait for the processing and even then sometime file is of 0KB or txt file without name --> then do steps above again.
Once you have Zip file with the data (Excel within Zip)
Open the Excel from the zip that you downloaded.
Look for the excel Sheet : All Keys - All Values
In here all the values stored within the fine tune would be available. ( So there might be several tables in the file each marked with the deployed date / Changed date.
Look for the table which corresponds to the sub link (Payment Terms) related table or tables Depending on what information you are looking to export.
Copy and paste
it in your excel Since you might want to filter out different language descriptions for the payment terms.
Option 4 : Cloud Application Studio :
Go to Repository explorer
Look for the data type ( if you are not sure, look for the BO where you maintain the value, Find the node and find the data type)
Once you find the correct data type, select it, this will open the documentation on the right side.
in this document, Appendix would contain all the values for that data type.
Hope this helps.
Regards,
Harshal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
116 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.