To check if a user has authorization for T-code or not you can use Transaction SUIM. You can manage user permissions using different ways like profile assignment via a single role, collective roles that contain single roles, etc. Below shows SUIM transaction that opens User Information System as below:You can also join tables: AGR_USERS and AGR_1251AGR_USERS is a standard SAP Table which is used to store Assignment of roles to user information. This is available within R/3 SAP systems depending on the version and release level.AGR_1251 is a standard SAP Table which is used to store Authorization data for the activity ... Read More

With table statement, you are able to get a single line of data corresponding to the dictionary structure you specify. The fields of structure can be used as select options and the structure can be passed as variable in the program.

As the name indicates, activity 02 is for intervals while activity 17 is for objects. There can be a different number range interval for a given SAP number range interval.

You have the print program configured in IMG. Run T-code: SPRONext is to assign Shop Papers to “Notification Type” this is used to tell which Shop Paper 4-CHAR code you care about, define Shop Papers has the ABAP Form and Print Program.

You can view Transport request that contains detail about your changes by going to T-Code SE37. You have to enter the name of Function Module and click on Utilities → Versions → Version ManagementAlso note that when you don’t put the changes in $TMP package, the system will ask you to provide a Transport Request to save or activate your changes.You can also check the package by navigating to Goto → Object Directory Entry in Transaction code: SE37 as below:

You can change address independent communication data using Function Modules like BAPI_BUPA_CREATE_FROM_DATA and BAPI_BUPA_CENTRAL_CHANGE and other FM’s in the same category.Function Module: BAPI_BUPA_CREATE_FROM_DATA   Function Group: BUBA_3            Program Name: SAPLBUBA_3   Following are the parameters:Function Module: BAPI_BUPA_CENTRAL_CHANGEFunction Group: BUBA_3            Program Name: SAPLBUBA_3Following are the parameters:Functional Group: BUBA_3You have lot many function modules that comes under function group BUBA_3, Few of them are below and their description:BAPI_BUPA_CREATE_FROM_DATASAP BP, BAPI: Create Business PartnerBAPI_BUPA_ADDRESSES_GETSAP BP, BAPI: Determine All AddressesBAPI_BUPA_EXISTENCE_CHECKSAP BP, BAPI: Check Existence of Business PartnerBAPI_BUPA_GET_NUMBERSSAP BP, BAPI: Read Business Partner NumbersBAPI_BUPA_ADDRESS_GETDETAILSAP BP, BAPI: Read ... Read More

Let me give you a basic info about electronic data interchange, it is used to exchange data (usually structured) between firms.Speaking about GENTRAN, it is one of the available EDI tools which can help you parse data in most of the common formats available. If you want to change the format of data from one to another, GENTRAN can do it for you too.Coming up to the most exciting part of it, it provides a drag and drop interface to you where you can program.Usually, when you need to convert a document from one format to another, you need to ... Read More

Note that an index not necessary to be NOT NULL. You can create an Index in SAP HANA database by using below query:CREATE INDEX IDX_MY_INDEX ON TABLE1 (MY_COLUMN);To know more about SAP HANA database, Modeling, and Administration features, you can refer our SAP HANA Text and Video tutorials:https://www.tutorialspoint.com/sap_hana/https://www.tutorialspoint.com/sap_hana_online_training/index.asp

One line answer - Sub-Queries are not allowed. But if you need to handle your scenario, then you can do the following: Encapsulate your entire query into a stored procedure and then use the stored procedure. Create a view. The view is created to handle either your main query or sub-query. Create a table level variable and store the end results of view in it and then go ahead and fetch the value of table variable in the main query.

You can write an ABAP program for exporting the data from SAP and then use a remote function call which can be invoked my macro to fetch the data. Also, you can go for creating the file itself if that fits the requirement.You can also opt for SAP GUI Scripting as an alternative. The scripting framework allows you to automate the interface for Windows and Java. It can let you perform a lot of activities.Scripting API provides you with the good number of scriptable objects which wraps the SAP GUI objects. You can use these objects from macros. SAP GUI ... Read More