ABAP 740的新語法 - 使用BO association的方式進行內表連線操作
ABAP Mesh is also a new feature in 740. Let’s use an example to demonstrate how it works: I have defined two types for developers and managers. developer type has a field manager which points to his manager, while manager type does not have any reference to his managing employee.
types: begin of t_manager,
name type char10,
salary type int4,
end of t_manager,
tt_manager type sorted table of t_manager with unique key name.types: begin of t_developer,
name type char10,
salary type int4,
manager TYPE char10,
end of t_developer,
tt_developer type sorted table of t_developer with unique key name.
I also use the new grammar – inline data declaration to fill developer and manager table. So far nothing special.
DATA: lt_developer TYPE tt_developer,
lt_manager TYPE tt_manager.
DATA(Jerry) = VALUE t_developer( name = 'Jerry' salary = 1000 manager = 'Jason' ).
DATA(Tom) = VALUE t_developer( name = 'Tom' salary = 2000 manager = 'Jason' ).
DATA(Bob) = VALUE t_developer( name = 'Bob' salary = 2100 manager = 'Jason' ).
DATA(Jack) = VALUE t_developer( name = 'Jack' salary = 1000 manager = 'Thomas' ).
DATA(David) = VALUE t_developer( name = 'David' salary = 2000 manager = 'Thomas' ).
DATA(John) = VALUE t_developer( name = 'John' salary = 2100 manager = 'Thomas' ).
DATA(Jason) = VALUE t_manager( name = 'Jason' salary = 3000 ).
DATA(Thomas) = VALUE t_manager( name = 'Thomas' salary = 3200 ).
INSERT Jerry INTO TABLE lt_developer.
INSERT Tom INTO TABLE lt_developer.
INSERT Bob INTO TABLE lt_developer.
INSERT Jack INTO TABLE lt_developer.
INSERT David INTO TABLE lt_developer.
INSERT John INTO TABLE lt_developer.
INSERT Jason INTO TABLE lt_manager.
INSERT Thomas INTO TABLE lt_manager.
Now I define one ABAP mesh t_team with two component managers and developers. With association ‘my_employee’, I connect the internal table managers to developers, so that I could easily find all developers of a given manager. The association ‘my_manager’ just enables the connection in opposite direction: find out the manager of a given developer.
You can compare how I find Jerry’s manager and find all developers whose manager are Thomas using new ABAP mesh and the traditional way.
The result are exactly the same.
要獲取更多Jerry的原創文章,請關注公眾號"汪子熙":
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24475491/viewspace-2712211/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ABAP 740裡的新語法 - LET表示式
- ABAP中對內表進行clear操作時的注意點
- ABAP 740新的OPEN SQL增強特性SQL
- mybatis使用association的resultMap方式進行對映少資料問題MyBatis
- ABAP READ內表新老語法對比
- 對列進行連線操作會影響索引的使用索引
- Oracle 表連線方式詳解(外連結、內連線、自連線)Oracle
- MYSQL語法:左連線、右連線、內連線、全外連線MySql
- power 740 p740 連線遠端管理模組
- Oracle優化器內部處理的表連線方式Oracle優化
- 表連線方式及使用場合
- 幾種表的連線方式(SQL)SQL
- Oracle的三種表連線方式Oracle
- java操作Oracle 方式一 ( 連線-》操作-》斷開連線 )JavaOracle
- ORACLE 表連線方式Oracle
- oracle表連線方式Oracle
- SAP ABAP CDS view Association 引入的緣由View
- FTP,FTP連線的辦法,配置方式FTP
- 行連線的處理方式指引
- SAP ABAP資料表的操作
- Oracle資料庫中的表連線方式及使用場合Oracle資料庫
- 利用ABAP 740的新關鍵字REDUCE完成一個實際工作任務
- ORACLE表連線方式的分析與優化Oracle優化
- 行的儲存(塊內連線與塊外連線)
- 如何用ABAP讀取CDS view association的資料View
- Python 連線mysql資料庫進行操作PythonMySql資料庫
- SQL的外連線對內部表的限制SQL
- 表連線的執行步驟
- 一些 Next Generation ABAP Platform 的新語法用例Platform
- 【SQL】表連線七種方式SQL
- SQL表連線方式詳解SQL
- document.write()輸出的標籤需要進行字串連線操作字串
- 資料庫表的連線方式及用法(一)資料庫
- 【SQL 效能優化】表的三種連線方式SQL優化
- pgsql 連表更新語法SQL
- mysql 的連線方式MySql
- proxool連線池如何使用SSL方式連線?
- SAP ABAP CDS view 裡 INNER JOIN 和 Association 的區別View