报表数据参考文献源.doc

报表名称

模型(ODS/Cube)

数据源(DataSource)

数据流(DataFlow)

说明

产品销售利润报表

0SD_C03

0FIGL_C01

2LIS_13_VDHDR

2LIS_13_VDITM

0FI_GL_1

2LIS_13_VDHDR-0SD_C03

2LIS_13_VDITM-0SD_C03

0FI_GL_1-0FIGL_C01

每个订单的销售成本需从表CKMLHD和CKMLCR取.

规格特性:从批次特性中取,在MCH1中通过批次、物料号查得CUOBJ_BM，再用CUOBJ_BM去读AUSP表，值存在ATWRT和ATFLV字段中

本月跟上月销售对比影响分析

同销售利润表

本月比上年月均销售对比影响分析

同销售利润表

本年累计比上年累计销售对比影响分析

同销售利润表

借贷项订单执行对比表

0SD_C03

2LIS_13_VDHDR

2LIS_13_VDITM

2LIS_11_VAHDR

0SD_C03

2LIS_13_VDHDR-0SD_C03

2LIS_13_VDITM-0SD_C03

2LIS_11_VAHDR

-0SD_C03

借贷项订单明细表

0SD_C03

2LIS_13_VDHDR

2LIS_13_VDITM

2LIS_11_VAHDR

0SD_C03

2LIS_13_VDHDR-0SD_C03

2LIS_13_VDITM-0SD_C03

2LIS_11_VAHDR

-0SD_C03

XXXX年XX月产品入库、出库、结算、收入情况表

0SD_C03

0IC_C03

2LIS_13_VDHDR

2LIS_13_VDITM

2LIS_03_BF

2LIS_13_VDHDR-0SD_C03

2LIS_13_VDITM-0SD_C03

2LIS_03_BF-0IC_C03

成品库收拨存报表

0SD_C03

0IC_C03

2LIS_12_VCHDR

2LIS_12_VCITM

2LIS_03_BF

2LIS_12_VCHDR-0SD_C03

2LIS_12_VCITM-0SD_C03

2LIS_03_BF-0IC_C03

外设销售公司XXXX年XX月份收拨存表

0SD_C03

0IC_C03

2LIS_12_VCHDR

2LIS_12_VCITM

2LIS_03_BF

2LIS_12_VCHDR-0SD_C03

2LIS_12_VCITM-0SD_C03

2LIS_03_BF-0IC_C03

价格要素分析

0SD_C03

2LIS_13_VDHDR

2LIS_13_VDITM

2LIS_13_VDHDR-0SD_C03

2LIS_13_VDITM-0SD_C03

重点品种销售完成情况表

0SD_C03

2LIS_13_VDHDR

2LIS_13_VDITM

2LIS_13_VDHDR-0SD_C03

2LIS_13_VDITM-0SD_C03

重点品种的分类必须逐行定义,每一行项目都有不同的条件.

不锈钢销售情况表

0SD_C03

2LIS_13_VDHDR

2LIS_13_VDITM

2LIS_13_VDHDR-0SD_C03

2LIS_13_VDITM-0SD_C03

销售计划数量必须通过excel导入.

各车间、客户钢材合同兑现率表

0SD_C03

2LIS_11_VAHDR

2LIS_11_VAITM

2LIS_12_VCHDR

2LIS_12_VCITM

2LIS_11_VAHDR-0SD_C03

2LIS_11_VAITM

0SD_C03

2LIS_12_VCHDR-0SD_C03

2LIS_12_VCITM-0SD_C03

年度钢材客户协议逐月执行情况表

0SD_C03

2LIS_13_VDHDR

2LIS_13_VDITM

2LIS_13_VDHDR-0SD_C03

2LIS_13_VDITM-0SD_C03

“品种”从物料主数据“基本物料”取,标准字段.

MARA-WRKST

年度钢材客户协议逐月执行认定情况表

0SD_C03

2LIS_11_VAHDR

2LIS_11_VAITM

2LIS_13_VDHDR

2LIS_13_VDITM

2LIS_13_VDHDR-0SD_C03

2LIS_13_VDITM-0SD_C03

2LIS_11_VAHDR-0SD_C03

2LIS_11_VAITM

0SD_C03

库存量报表

0IC_C03

2LIS_03_BF

2LIS_03_BF-0IC_C03

各车间月度交货周期统计表

0SD_C03

0IC_C03

2LIS_12_VCHDR

2LIS_12_VCITM

2LIS_03_BF

2LIS_12_VCHDR-0SD_C03

2LIS_12_VCITM-0SD_C03

2LIS_03_BF-0IC_C03

钢材销