事务码AS03查看
下划线为视情况使用
anla 资产主记录段(公司代码、主资产号、资产次级编号)
SELECT a~bukrs,a~anln1,a~anln2,a~aktiv,a~anlkl,a~gdlgrp,a~txt50,
a~txa50,a~lifnr,a~meins,a~menge,a~deakt
INTO TABLE @DATA(gt_item_anla)
FROM anla AS a
anlb 折旧期限(公司代码、主资产号、资产次级编号、实际折旧范围、有效日期结束)
1. DEAKT_B 完全报废日期
2.AFABG 折旧计算开始日期
3.AFASL 折旧码 ,折旧规则按照折旧码计算,折旧码描述可从T090NAT获取
SELECT bukrs anln1 anln2 afabe bdatu afabg afasl ndjar ndper afasl deakt_b
INTO CORRESPONDING FIELDS OF TABLE gt_anlb
FROM anlb.
anlc 资产值字段 (公司代码、主资产号、资产次级编号、财年、实际折旧范围、资产购置年(目前未被使用)、资产购置的子类(当前未被使用))
1.净值 = kansw + answl +knafa + nafag + nafal + nafav
2.购入金额 = kansw + answl
SELECT bukrs anln1 anln2 gjahr afabe zujhr zucod kansw knafa nafag answl nafav nafal
INTO CORRESPONDING FIELDS OF TABLE gt_anlc
FROM anlc
anlp 资产期间价值(BUKRS、GJAHR、PERAF(折旧的过账期间)、AFBNR、ANLN1、ANLN2、AFABER(实际折旧范围)、ZUJHR、ZUCOD)
1.nafaz 对应期间的实际折旧金额
SELECT bukrs,gjahr,peraf,afbnr,anln1,anln2,afaber,zujhr,zucod,nafaz
INTO TABLE @DATA(gt_item_anlp)
FROM anlp