Tags: SAP

Default field lengths for address fields in databases

Posted by Raffael on Posted in Programming, SQL, Test, Wiki Tagged , , , ,

Standard lengths for address fields in databasesToday, we will dive into some more theoretical stuff. The topic of this article will be field lengths of database fields for addresses. For every second database I create, I am faced with the same problem: How long / “big” do I actually make the database fields for addresses? So fields, such as first name, surname, street, e-mail address, etc.
So far I have oriented myself to given requirements or old databases. But now I wanted to work up the topic once for all right. So the question is: Is there actually a standard for address field lengths?
Looking for standards for address field lengths
A search for “address field lengths for databases” spits a huge amount of hits. Unfortunately there are only opinions and experiences […]

Open SAP GUI from HTML out of your webbrowser

Posted by Raffael on Posted in HTML, JavaScript, SAP Tagged , , ,

SAP aus Browser aufrufenSome time ago I got into a discussion about whether it is possible to open transactions in the SAP GUI out of the browser. The opinion of the colleagues was unanimous – start SAP GUI from browser is something not be done.
However I have maintained and created a small proof-of-concept. Because it works. Ok, it’s not pretty, but it works. And that’s how to call the SAP GUI from the browser.
sapshcut.exe and what you can do with it
The solution works (among other things) using the sapshcut.exe (short for SAP Shortcut). This .exe file allows to start the SAP GUI parameterized. The possible parameters ranging from user via logon language up to the executed transaction. A complete list of possible parameters can be obtained by calling the sapshcut.exe with the parameter -?. (See screenshots below.)
sapshcut.exe - help from cmd  

How to use C# Web Service Client with BasicAuth (for SAP)

Posted by Raffael on Posted in C#.Net, SAP, Tutorials Tagged , , , , , , , , ,

SAP Webservice with .NET Webservice Client and BasicAuthNo matter how frumpy SAP may look most of the time, nevertheless you can build such modern things like web services inside the SAP system. Even the WSDL (Web Service Description File) file can be generated in SAP. I read about this feature (WSDL generation) just at the right time, because recent days I should write a web service in SAP which should be triggered by a C# application.
In .NET web services can easily integrated via their WSDL file by using the WebReference feature of Visual Studio. Therefore Visual Studio generates a so-called proxy class from the given WSDL file which can be used to call all functions of the webservice without thinking too much.
As far as in theory. In practice I had to choose the security mode for the web service in […]

How to reset the spreadsheet export format in ALV

Posted by Raffael on Posted in SAP Tagged , , , ,

When working with the ALV (ABAP List Viewer), the records/result-set displayed can be exported in various formats including those for spreadsheet programs.
alv_save_choice_excel_export_enIf you use this feature more often and always export your data into the same format, there does exist an option called “Always Use Selected Format”  in the spreadsheet-export-dialog. If you check this option after selecting an export format, so in subsequent exports always the specified format is preselected and you won’t see the format selection dialog anymore.
However, if you would like to change the format or want to get asked for he format again before every re-export, most users recognize that it isn’t such easy to revoke the “Always Use Selected Format” option.
No products found.In the following I would like to briefly point out two approaches to […]