Found 1039 Articles for SAP

Taking schema wise backup in SAP HANA

vanithasree
Updated on 14-Feb-2020 08:11:37

564 Views

Data backup in any RDBMS system comes under Data Persistence layer. SAP HANA holds the bulk of its data in memory for maximum performance, but it still uses persistent storage to provide a fallback in case of failure.When you refer a schema in database, it refers to a namespace in the database. It is not possible to take backup schema wise as you do for complete database.However it is possible to export a schema using below command −EXPORT "MY_SCHEMA".* AS BINARY INTO '/tmp/my_schema' WITH REPLACE;SyntaxEXPORT AS INTO [WITH ] [ ]Note that you shouldn’t take schema ... Read More

Sorting an already sorted internal table in ABAP

radhakrishna
Updated on 14-Feb-2020 08:06:16

2K+ Views

If you leave 2nd sort, it would be quicker as itab will be there in right order.SORT itab by f1 f2 f3. READ TABLE itab WITH KEY f1 = 'A'    f2 = 'B'    f3 = 'C' BINARY SEARCH. READ TABLE itab WITH KEY f1 = 'A' BINARY SEARCH.When 2nd READ TABLE is by f2, you should leave the SORT and BINARY SEARCH as well. In best case scenario, SORT + BINARY SEARCH speed is n+log(n).Also note that worst case of sort is n log n.

Moving TABKEY from CDPOS table into field structure in ABAP

mkotla
Updated on 30-Jul-2019 22:30:20

551 Views

I would suggest you make use of Function Module CHANGEDOCU_KEY_ANY2CHAR and other FM’s of function group SCD8. This function module performs the reverse function.Function Module: CHANGEDOCU_KEY_ANY2CHARFunction Group: SCD8Program Name: SAPLSCD8You can refer this SAP link to see all Function modules available and their description under this Function Group:https://help.sap.com/viewer/c14d25a8f471453590980dbb47a2aa0e/7.40.15/en-US/48d8fd10f63a3e49e10000000a421937.html

Retrieve list of linked documents in SAP

Sharon Christine
Updated on 10-Dec-2019 10:24:23

195 Views

There are lots of RFC present to fetch the list of documents. You can try any permutation and combination to identify which suits your requirementBAPI_MATERIAL_GETLISTBAPI_DOCUMENT_GETOBJECTDOCSBAPI_DOCUMENT_GETOBJECTLINKSBAPI_DOCUMENT_GETDETAIL I prefer that you better try with BAPI_DOCUMENT_GETOBJECTDOCS, I have used it to achieve something similar in the past.

Edit report generated from SAP Crystal Reports

Sai Subramanyam
Updated on 30-Jul-2019 22:30:20

409 Views

It does not seem to be feasible to edit the report once generated. You cannot add a constraint or logic to allow your report to be editable.But there does exist a work around, what you can do is: First export the report and then you can change the mode of the document toRestrict Change or Editing. You can write custom code to perform this operation.

Use existing authentication along with SAP BO

usharani
Updated on 30-Jul-2019 22:30:20

169 Views

It is one of the most common extension points in an existing ecosystem. With the latest release of BO, you can use active directory based logins mapped under windows server.

Generate Database diagram within SAP

varun
Updated on 30-Jul-2019 22:30:20

902 Views

Generating the database diagram completely as generated in SQL server or other DBMS is not possible over here. But there are couples of ways that can be of small help in your case. Firstly, you can refer to Object Model guide present in the SAP market place. This guide will explain you the most common relations between the most popular and common business objects It does not cover each and every bit of the database but the most common bad highly usage one are covered. Secondly, if required you can generate diagram of a single table by displaying it in ABAP transaction ... Read More

Read a date filter as input in WEBI report in SAP BO

Prabhas
Updated on 14-Feb-2020 08:03:12

525 Views

Your requirement is one of its kinds but can be achieved. What you can try out is first create a brand new object in the context. Let's say you provided the date as first input and 5 as a weekly slice in the second input. [Date+5]=DATEADD(@prompt('Slice','X'{'Day','Month','Year'},mono,constrained,persistent),5,@prompt('Date','date',mono,free,persistent))Here X refers to your slice and date refers to the date input.Then you can just add another filter to the report using this.

Use IFrame and read cookie in ABAP

seetha
Updated on 30-Jul-2019 22:30:20

244 Views

I think it is possible and can be simply achieved. You can do the following:Firstly, create a business server pages application on the server. Make sure the application contains a frameset and two IFrames as a part of the frameset.Then you need to split up the implementation between these two IFrames. First IFrame will contain the third party component and second component will contain the view and JS part of the application that we just created. Make sure the second frame does not have any height as it should be invisible to the user.Then you can write client-side code in ... Read More

Need to schedule script in PowerShell from SAP

vanithasree
Updated on 30-Jul-2019 22:30:20

233 Views

I had experienced a similar issue and it was because the scheduler did not have permissions of the file. The scheduler is unable to read the contents basically the login credentials from the file.As a work around what I did was I created a separate job altogether to capture the password in the form of a secure string and then ran the job with the service Id. In this manner, the service has required access of password.And just because it is the Id which is responsible for executing the job, it always ran well.

Advertisements