对于一些物料特性或者分类特性,需要获取特性值对应的文本描述,这个时候需要相关联的表有AUSP、CAWNT、CAWN,关联方式如下:
"特性值文本
SELECT
cawn~atinn,
atwrt,
cawn~atzhl,
atwtb
FROM cawnt
INNER JOIN cawn
ON cawn~atinn = cawnt~atinn
AND cawn~atzhl = cawnt~atzhl
INNER JOIN cabn
ON cabn~atinn = cawnt~atinn
WHERE cabn~atnam = '特性名'
INTO TABLE @DATA(lt_ausp_t).