Data BI Visuals

For each view, system will create a table whether it might be SAP HANA LIVE view or Calculation view or Attribute view. Those tables will be reside in system schema "_SYS_BIC" Expand the schema -> Column Views. There you can see lot of tables. Tables will be available for each view and each column inside that view. Make sure to get the main view. For example if you take HANA Live View "VBAK_COM". --Main View table select top 10 * from "_SYS_BIC"."sap.hba.ecc/VBAK_COM/" To select view with particular column, follow below select top 10 "SalesDocument" from "_SYS_BIC"."sap.hba.ecc/VBAK_COM" The above table can be access in SQL console, it will give the output which is same as what you have seen in the data preview. The other tables also available for columns select top 10 * from "_SYS_BIC"."sap.hba.ecc/VBAK_COM/SalesDocument/hier/SalesDocument" The above table will give deta...

SAP GUI giving option to create very simple report without using ABAP language, this will help people who are all not familiar with ABAP language. We can’t consider this is only for creating report, because It has lot of information We can use for, 1. To check the relationship between the selected tables (LIKE database diagram in SQL Server) 2. We can check the field description of the table easily Step to create view, Use transaction SQVI Give any name for the view and click create option Insert tables into the view and you can see the joins will be added automatically based on the relationship between the tables. As you can see the options, joins between the tables & field description. Once added all the tables, click the back option there you can save the view after selecting the fields which required for the report. Please let me know, if you have any issue. If you are like this post, please share it. Thanks.