今天用 BW 标准数据源 0CO_PC_ACT_10 提取数据时,发现物料有一项数据【没有被分摊】无法取到。
根据SAP的解释,此项不在后台存数,通过前台动态生成。
For the virtual cumulative inventory and for the Not Distributed line, there are no records in the database,
which is why the extractor cannot extract them. In transaction CKM3(N), these lines are generated
dynamically.
【没有被分摊】= 【消耗】+ 【期末库存】- 【初始库存】- 【收据】。
In BW, you can calculate these lines as follows as needed:
1. Calculate the cumulative stock line from the ending inventory and the consumptions.
2. Then calculate the Not Distributed line as follows:
Not Distributed = cumulative inventory - goods receipts - beginning inventory.