从 DB 表中获取单个字段到 itab 中

发布于 2024-09-25 09:26:18 字数 244 浏览 3 评论 0原文

我想从透明表 z_accounts 中获取 excep_point 字段，以获取 company_code 和 account_number 的组合。我怎样才能在ABAP SQL 中做到这一点？

假设表结构为

|company_code | account_number | excep_point |

原文

I want to fetch the a field say excep_point from a transparent table z_accounts for the combination of company_code and account_number. How can I do this in ABAP SQL?

Assume that table structure is

|company_code | account_number | excep_point |

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

绝不服输 2024-10-02 09:26:18

假设你有完整的主键...

data: gv_excep_point type zaccounts-excep_point.

select single excep_point
into gv_excep_point
from zaccounts 
where company_code = some_company_code
 and account_number = some_account_number.

如果你没有完整的 PK 并且 exceptp_point 可能有多个值

data: gt_excep_points type table of zaccounts-excep_point.

select excep_point
into table gt_excep_points
from zaccounts 
where company_code = some_company_code
 and account_number = some_account_number.

至少还有另一种变体，但这是我最常使用的 2 个。

Assuming you have the full primary key...

data: gv_excep_point type zaccounts-excep_point.

select single excep_point
into gv_excep_point
from zaccounts 
where company_code = some_company_code
 and account_number = some_account_number.

if you don't have the full PK and there could be multiple values for excep_point

data: gt_excep_points type table of zaccounts-excep_point.

select excep_point
into table gt_excep_points
from zaccounts 
where company_code = some_company_code
 and account_number = some_account_number.

There is at least another variation, but those are 2 I use most often.

回复收藏 0 原文

扮仙女 2024-10-02 09:26:18

仅供参考。当您将数据选择到表中时，您可以编写复杂的表达式来组合不同的字段。例如，您有一个包含两个字段“A”和“B”的内部表 (itab)。您将从具有 6 列的数据库表 (dbtab) 中选择数据 - “z”、“x”、“y”、“u”、“v”、“w”。例如，每个字段都是 char2 类型，您的目标是在内部表的“A”字段中合并“z”、“x”、“y”、“u”，在“B”字段中合并“v”、“w”。您可以编写简单的代码：

select z as A+0(2)   
       x as A+2(2)   
       y as A+4(2)  
       u as A+6(2)   
       v as B+0(2)  
       w as B+2(2)  FROM dbtab  
       INTO CORRESPONDING FIELDS OF TABLE itab
          WHERE <where condition>.

这个简单的代码使您的工作完成得非常简单

For information only. When you selects data into table you can write complex expressions to combine different fields. For example, you have internal table (itab) with two fields "A" and "B". And you are going to select data from DB table (dbtab) wich have 6 columns - "z","x","y","u","v","w". And for example each field is type char2 You aim to cimbine "z","x","y","u" in "A" field of internal table and "v","w" in "B" field. You can write simple code:

select z as A+0(2)   
       x as A+2(2)   
       y as A+4(2)  
       u as A+6(2)   
       v as B+0(2)  
       w as B+2(2)  FROM dbtab  
       INTO CORRESPONDING FIELDS OF TABLE itab
          WHERE <where condition>.

This simple code makes you job done very simple

回复收藏 0 原文