SAP ABAP Expert has Published 141 Articles

Form a dynamic Query in SAP ABAP

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Jun-2020 09:15:33

376 Views

You can indeed achieve it. You just follow the below steps:Step 1 − Define the input parametersDATA:   table_name  TYPE string VALUE  ‘TABLE’, column_name TYPE string VALUE  'COLBNAME', name_value  TYPE string VALUE  'COLVALUE'Step 2 − Create a table type to hold the output results.DATA:   results TYPE ... Read More

Filter output columns in Table in SAP application

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Jun-2020 09:04:29

147 Views

I think there can be a better option to do this. What you can try is fetch only the fields of the table which match the fields present in the table. Do not fetch all the fields of the table but the selected fields.// Here Table refers to the JCo.Table ... Read More

Export Data from a SAP system

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Jun-2020 09:03:49

579 Views

Your question seems to be uncertain. SAP stores data in database and SAP database structure is not conventional and quite complex.  You need to code separately on top of SAP to support export data to outside world and you are free to choose format of your choice.Identify the user specific ... Read More

Differentiate dynamic parameter from others in SAP

SAP ABAP Expert

SAP ABAP Expert

Updated on 12-Jun-2020 09:02:48

413 Views

It’s a straight forward way to do the same.You have to go to the transaction RZ11 for the parameter, if the dynamic field checkbox is checked it means that the parameter is a dynamic parameter otherwise it is not a dynamic parameter meaning it is a static parameter.Read More

Changing Ownership of schema in SAP HANA Database

SAP ABAP Expert

SAP ABAP Expert

Updated on 13-Mar-2020 07:56:00

1K+ Views

I don’t think you can change ownership of schema in database. Easiest way to change ownership of schema is by exporting a schema, drop it from the database and then recreate the schema owned by the target user and import the objects back into the database.In recent version, you can ... Read More

Checking SAP HANA Schema owner name

SAP ABAP Expert

SAP ABAP Expert

Updated on 13-Mar-2020 07:55:07

918 Views

To check schema owner, you need access on “SYS” schema. Open SAP HANA SQL console and run the following SQL query −SELECT * FROM "SYS"."SCHEMAS";

Checking schema creation in SAP HANA database

SAP ABAP Expert

SAP ABAP Expert

Updated on 13-Mar-2020 07:54:21

886 Views

To check this detail, you should have access on “SYS” schema. Run the following SQL query and it will fetch the following columns −SELECT * FROM "SYS"."SCHEMAS";Schema_NameSchema_OwnerHAS_PRIVILEGESCreate_Time

Authoring schema vs Physical schema in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 13-Mar-2020 07:53:14

561 Views

In SAP HANA system, schema is used to group logical objects tables, Stored procedures and database views. When objects are moved from one system to other, you can consider involvement of following schema types −Authoring SchemaThis schema is used in design time views. This schema is used in creating objects ... Read More

Using Package specific default schema in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 13-Mar-2020 07:45:39

391 Views

 In SAP HANA, you can define package specific default schema as an authoring schema in your schema mapping definition and maintain it in the table M_PACKAGE_DEFAULT_SCHEMA.To perform this, navigate to SAP HANA Modeler perspective →; Maintain Package Specific Default SchemaSelect HANA system and it will show you schema names mapping ... Read More

Setting schema mapping in SAP HANA

SAP ABAP Expert

SAP ABAP Expert

Updated on 13-Mar-2020 07:44:32

921 Views

Schema mapping in SAP HANA is used to move objects from one system to other system i.e. from Development system to Test or Test system to production system.To open schema mapping, navigate to SAP HANA Modeler → Schema Mapping → Select system you want to perform operationIn next window, you ... Read More

Advertisements