"价格(固定) WITH +DATAAS(SELECTDISTINCT OBJNRFROM @LT_ZPPT413AS LT_DATA) SELECT * FROM COST INNERJOIN +DATAON +DATA~OBJNR= COST~OBJNR AND COST~WRTTP='01' INTO CORRESPONDINGFIELDSOFTABLE @LT_COST. SORT LT_COSTBY OBJNR. DATA:LV_MONTH(2)TYPECVALUE'01'. DATA:LV_TKFXXXTYPE STRING....
with +data as ( select distinct sobid from @lt_1001 as zdata ) select a~objid, "岗位ID a~sobid "人员号 from hrp1001 as a inner join +data as b on b~sobid = a~objid where a~otype = 'S' and a~rsign = 'A' and a~relat = '008' and a~plvar = '01' and a~sclas =...
SELECT DISTINCT 语句会去重,只返回不同的记录。SELECT DISTINCT 语句可以使用 WHERE 子句指定查询条件,也可以使用 GROUP BY 子句和 HAVING 子句进行分组和聚合操作。SELECT DISTINCT 语句的基本语法如下: 代码语言:javascript 代码运行次数:0 运行 AI代码解释 SELECTDISTINCT<fields>INTO<internal table>FROM<data source>...
" 获取成本中心描述 select distinct kostl from @lt_faglflext as t into table @data(lt_cntr). " cost center select c~kostl, c~ktext from cskt as c inner join @lt_cntr as d on c~kostl eq d~kostl where c~kokrs eq '1000' and c~spras eq @sy-langu and c~datbi ge @sy-dat...
loop里不能套select;避免使用select distinct,代替先sort,再delete; ① 抽取数据时,避免使用SELECT *, 尽量使用SELECT A B INTO TABLE ITAB这样的语句。 ② 不要使用SELECT...ENDSELECT语句。 ③ 尽量避免在LOOP中访问数据库。可以在之前先把数据取到内表,在LOOP中用READ TABLE WITH KEY ... BINARY SEARCH....
在ABAP里面,SELECT【DISTINCT】中的DISTINCT是什么意思?能给一个具体点的列子说明下么? distinct 去掉重复的 取唯一。 不过abap里 这个效率不是很高。spfli 是系统(System)内用来做演示的1个表 sql 中DISTINCT使用如:SELECT DISTINCT 列名称 FROM 表名... select distinct empno as 别名 from 表名; 潍坊个人出售...
[DISTINCT]为OPEN SQL中SELECT语句的可选项,若选择则自动删除所查询数据的重复项!在某些场景中,我们需要对查到的数据进行去重的操作,这时候便需要加上DISTINCT可选项! 下面给出一个详细的案例进行讲解: 代码语言:javascript 代码运行次数:0 运行 AI代码解释 DATA:GT_SFLIGHT TYPE TABLE OF SFLIGHT. DATA...
1.总计功能 SELECT MAX|MIN|SUM|AVG|COUNT( [DISTINCT] f1 ) [AS a1]...其中DISTINCT选项将在统计之前先排除相同的选择结果. 2.分组总计 SELECT f1 [AS a1] ... MAX|MIN|SUM|AVG|COUNT( [DISTINCT] fm ) [AS am] ... INTO (s1,...,sm...)|CORRESPONDING FIELDS OF itab... ...
@DATA(lt_mara).SORTlt_maraBYmatnr."查询组件对应的MKAL记录WITH+i AS (SELECTDISTINCT k~matnrFROM@lt_resbd2 AS kLEFTJOIN mara AS aONk~matnrEQa~matnrWHEREa~matklEQ'431001')SELECTi~matnr,a~prfg_f,a~adatu,a~bdatuFROM+i AS iLEFTJOIN mkal AS aONi~matnrEQa~matnrWHEREEXISTS (SELECTmatnr...
table if the month column already exists.readtablegt_componentintogs_componentwithkeyname=wa_zdemo-month.ifsy-subrcne0.* The name of the column would be the month* and the data type would be the same as the amount filed of intenal talegs_component-name=wa_zdemo-month.gs_component-type...