Found 11 Questions for SAP APO

Use of _SYS_REPO in SAP HANA database

John SAP
Updated on 24-Feb-2020 09:26:06
In SAP HANA system _SYS_REPO user is required to create run time objects that are saved in HANA database under _SYS_BIC schema. When you activate modeling views in HANA, SYS REPO provides the read access to users on these modeling views. That is why it is required to grant _SYS_REPO with SELECT with GRANT privilege to user schemas.GRANT SELECT ON SCHEMA "SCHEMA_NAME" TO _SYS_REPO WITH GRANT OPTIONThis is required when you use objects of a table/view of a schema to build HANA Modeling Views. You need to grant _SYS_REPO the SELECT WITH GRANT privilege on this schema.Read More

Using Attribute view in SAP HANA

Updated on 18-Jun-2020 08:37:28
In SAP HANA Modeling, Attribute View is developed on the top of Dimension tables. They are used to join Dimension tables or other Attribute Views. It is also possible to create a copy of an existing Attribute View from already existing Attribute Views inside other Packages but you can’t edit the view in this case. Following are the key characteristics of Attribute View:Attribute Views in HANA are used to join Dimension tables or other Attribute Views.Attribute Views are used in Analytical and Calculation Views for analysis to pass master data.They are similar to Characteristics in BM and contain master data.Attribute ... Read More

Checking System limits in SAP HANA

Anil SAP Gupta
Updated on 12-Mar-2020 10:26:47
M_SYSTEM_LIMITS is a view to getting SAP HANA system limits. You can query this view to find the limitations of HANA system −SELECT * FROM M_SYSTEM_LIMITS;It will provide you details about Database Limitation Schema Limitations Tables and View Limitation Indexes and Constraints SQL SQL Script

Maximum number of columns in a table in SAP HANA

SAP Developer
Updated on 12-Mar-2020 10:15:15
The maximum number of columns in a table is 1000.

Key characteristics of using Analytic Privilege in SAP HANA Modeling

SAP Developer
Updated on 12-Mar-2020 08:15:08
Analytic Privilege is created inside packages under Content tab.Analytic Privileges are only applied to attributes in an Information View. We cannot add measures to restrict access to Analytic privileges.Analytic Privileges are used to control read access to SAP HANA Information views. You can also hide an information from the specific time period.

Count distinct entries in SAP BusinessObjects

John SAP
Updated on 06-Mar-2020 05:22:37
Your requirement is not clear but I think you should use AND operator and count on this in the third column. Your formula should be like this=([First_Seen] = 1) and ([Authorized] = 1)Consuming Graphical calculation view via SDA

Inserting rows to an internal table through debug in SAP ABAP

Sai Subramanyam
Updated on 12-Mar-2020 12:35:38
This can be done using any of the below methods −In the Tools window → Navigate to Service menu → you can add a new rowThis can also be done by using T-Code SE11 → Select the relevant table. Navigate to Table Content → DisplayMake sure Debug mode is ON. Click on Pencil to get Edit mode.Type Edit in Value column to edit the table in Debug mode. Press F8 (Continue).Note that for edition it is EDIT and for deletion, it is DELE as shown in below snapshot.This will open the record. You can change the value and save it.

Using ABAP, changing a value in itab by getting data from database table

Sai Subramanyam
Updated on 30-Jul-2019 22:30:22
You should do this using a Modify statement as in below − LOOP AT itab. SELECT SINGLE matnr INTO itab-matnr FROM zlldet WHERE palet = itab-palet. MODIFY itab. ENDLOOP. Also note that when you have an internal table itab with a header line, it means that you have a table itab and structure itab and usage of this depends on the situation. Few of the commands like MODIFY and LOOP AT uses both at the same time. DATA itab TYPE TABLE OF [something]. DATA wa ... Read More

Using table parameter in SAP RFC Function module

Sharon Christine
Updated on 30-Jul-2019 22:30:20
RFC enabled function modules, you should use a structure as line type for the table.  You should declare a dictionary structure Z_MY_PARTS_DATA with a single field DESCRIPTION TYPE CGPL_TEXT2.Declare a data dictionary table type Z_MY_PARTS_TABLE using this structure.Next is to use the table type in Function module.

Implementing tree structure in Sapui5 and restricting parent property

Nikitha N
Updated on 17-Dec-2019 06:51:18
Note that “sap.ui.model.ClientTreeBinding” which is used by TreeTable in JSONModel or XMLModel supports the parameter arrayNames. You need to pass an array of the model property names to create a sublevel. I would suggest to try below:In XML view:      ... In JSON view:treeTable.bindRows({path: '/pathToData', parameters: { arrayNames: ['children'] }});For more details about SAPui5 tree structure, you can navigate to following link: