본문 바로가기

Archive/HANADB

HANA DB 스크립트

728x90

1. Virtual Table Refresh - 테이블 정의를 새로 작성하기

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/51826981a2d24e7aa872f4278220b579.html

 

SAP Help Portal

 

help.sap.com

ALTER VIRTUAL TABLE SAPHANADB."V_ZTPOS0123" REFRESH DEFINITION;

 

 

2. Virtual Table 생성하기

https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.01/en-US/b0a833c47f7c438c86f0c011de4c3665.html

 

SAP Help Portal

 

help.sap.com

CREATE VIRTUAL TABLE SAPHANADB.V_ZCDS_BI_MATNR01 AT HANA_RB1."NULL".SAPHANADB.ZCDS_BI_MATNR01

728x90