HANA多行多列合并
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
/********* Begin Procedure Script ************/ --本视图的作用:将一个客户的多个联系人信息(多行多列)合并到一个单元格. --实现方式:var_out是一个结构,右边自己定义和左边返回的结构名称和类型一样的字段,右边就获得值了. BEGIN var_out = SELECT "CustID", STRING_AGG("EMP_INFO", '; ') as ZCUST_INFO FROM (select "CustID", "EmpID" || ' / ' || "EmpName" || ' / ' || "MobilePhone" as EMP_INFO FROM "zcrm"."custinfo") group by "CustID" ; END /********* End Procedure Script ************/ |
如若转载,请注明出处:https://www.gavindong.com/2645.html
相关推荐
-
ABAP 7.5巩固之SAP NetWeaver Overview
看了下ABAP 7.5认证内容的SAP NetWeaver Overview章节,还是有新的发现的,简单做下总结。 1.一个SAP实例只能有一个Spool进程,可以有多个Enq进程…
2021.03.2762 0 -
What does SAP HANA Live mean for reporting and analytics?
SAP HANA Live allows users to easily access real-time data using pre-developed calculation…
-
SAP HANA 2 – The Next Generation Platform Optimized for Innovation
Continuing the innovation on providing effective Data Management Solution, SAP is releasin…
-
HANA数据库查询重复行
–查询重复行 select “CustID” from “DW2″.”Customer” where “CustID” in(select “CustID” from “DW2″…
-
How to connect HANA STUDIO WITH ECC (FIGL)
To connect an ECC(ABAP) system to HANA studio, you need to install ABAP Development Tool i…
-
SAP通过SDI Agent操作MySQL数据库的方式
MySQL是互联网领域是非常流行的,但在SAP生态圈却不太受待见,2019年的S4 HANA还是没有原生支持通过DBCO直连MySQL。如下图所示,DBCO中没有MySQL的选项,…
2020.10.20413 0 -
从A库表重复更新B库表的两种思路
从A库表重复更新B库表的两种思路 思路1:每次清空B库表中的数据再insert; 思路2:每次都drop掉表再insert; 由于业务需求频繁变化,A库中的表可能会经常调整结构,因…
-
更改SAPABAP1 HANA Schema密码的步骤
This article will show you the steps to take when changing the SAPABAP1 HANA database sche…
2020.10.22360 0 -
The various Data Provisioning Options for Hana
An often asked question is how to get data into Hana as there are so many different option…
2018.03.101.3K 0 -
SAP HANA死锁检测的思路
关于死锁 死锁,英文deadlock,指两个或多个事物在同一资源上相互占用,并请求锁定对方占用的资源,从而大致恶性循环的现象,可查阅文章《什么是数据库死锁》。 HANA数据库如果发…
2021.02.18163 0 -
DBSQL_SQL_DEADLOCK_DETECTED
SM21和ST22报错Runtime error “DBSQL_SQL_DEADLOCK_DETECTED” occurred. 分析某张数据库表发生死锁,…
2021.03.17102 0 -
SAP HANA Live Overview
简要:HANA Live是类似BW里的BI Content的一个补丁包。HANA Live and BW on HANA are 2 different things. HANA …
2018.03.02827 0 -
安装SAP HANA SDI Agent注意事项
1.必须关闭SDI Agent所在的操作系统的防火墙;2.必须在SDI Agent和HANA服务器的host中都配置自身及对方的主机名映射;3.SDI Agent所在的操作系统中请…
2018.03.091.5K 0 -
dpagent连接HANA多租户模式
Prerequisites The Agent Admin HANA User must have the following roles or privileges. Actio…
-
Some Q/A about SAP HANA
1. Why is HANA fast as compared to other databases? Ans: HANA is an in-memory database and…
-
SAP on HANA数据库执行 DB13概览中报警告及报错消息的解决笔记
#The last data backup is 12 days old. This will increase downtime in a recovery situation….
2017.05.172.4K 0 -
通过ABAP程序模拟CCMS对S4 HANA的数据库进行监控并邮件提醒异常
S4 HANA的CCMS中找不到HANA Database的监控节点(MTE),如何在SAP中实现对HANA数据库的监控呢? 其实SAP Note有对这个问题进行说明,解决的思路包…
2020.11.17194 0 -
HANA 2.0建模后查询视图报SQL JDBC 258错误
HANA创建的分析视图,自己可以保存、验证和激活,然而自己没有权限查看,真实神奇了,为了排查这个错误我连HANA trace都用上了,然而trace里并没有什么详细的实质性的信息。…
2021.04.0453 0 -
SAP HANA永久License的类型
SAP HANA永久License又分为两种类型:非强制和强制,因为Non-Enforced和Enforced。 强制型(Enforced)的授权,授权大小是多少就是多少,当实际使…
2021.03.01121 0