mro數(shù)據(jù)模型預(yù)留儀征2

1、項(xiàng)目: 預(yù)留分析模塊盈科Petro-CyberWorks Information Technology Company Limited修改客戶確認(rèn)：_版本日期作者狀態(tài)審核1.02004-05-17完成2.02004-06-28完成目錄1.需求描述42.數(shù)據(jù)模型星型結(jié)構(gòu)43.數(shù)據(jù)模型特性 (CH)..時(shí)間特性9關(guān)鍵指標(biāo)(KF)9ODS 對(duì)象11INFOCUBE..3.BasisCube12MultiCube14RemoteCube143.5.AGGREGATE14無(wú)AGGREGATE應(yīng)用14數(shù)據(jù)源系統(tǒng)分析144.5.BW-DATA F

2、LOW..DATA FLOW IN INFOCUBE YZ_M_C0215TRANSFER RULE18UPDATE RULE19ENHANCEMENT211. 需求描述附件下列文件詳細(xì)描述了本文檔所涉及的各個(gè)部門業(yè)務(wù)分析需求:簡(jiǎn)要描述:2. 數(shù)據(jù)模型星型結(jié)構(gòu)PM Order物料DimenID工單號(hào) 工單類型需求量 領(lǐng)料數(shù)量領(lǐng)料價(jià)值刪除項(xiàng)目數(shù) 完成的預(yù)留數(shù)預(yù)留項(xiàng)目數(shù) 未完成項(xiàng)目數(shù)anization工廠庫(kù)存地點(diǎn)工廠Custom Time預(yù)留基準(zhǔn)日期預(yù)留需求日期Purchase成本中心成本控制范圍Reservation預(yù)留預(yù)留行項(xiàng)目移動(dòng)類型 資產(chǎn)號(hào)基建項(xiàng)目號(hào)文件名稱

3、狀態(tài)Info-Object (CH)Techn. NameData Type)Daten- length )Display- Attribut?Convert. RoutinText in Spalt headerAuth. Relev.Master Data?Time Dependent?預(yù)留ZM_RESERVCHAR12預(yù)留行項(xiàng)目ZM_RSITEMNUMC4成本中心0COSTCENTERCHAR10成本控制范圍0CO_AREACHAR4移動(dòng)類型0MOVETYPECHAR3采購(gòu)組0PUR_GROUPCHAR3工廠0PLANTCHAR4XX庫(kù)存地點(diǎn)0STOR_LOCCHAR4物料0MATERI

4、ALCHAR18X工單ZM_PMORDERCHAR12工單類型ZM_PMOTYPCHAR4預(yù)留基準(zhǔn)日期ZM_RSDATEDATS8預(yù)留需求日期ZM_RSRDTDATS8資產(chǎn)號(hào)ZM_ASSETCHAR12工廠ZM_SWERKCHAR4基建項(xiàng)目號(hào)ZM_WEMPFCHAR12TextHierarchyInfo-Object (CH)Text- SourceTime Dependent?Hierarchy?Time Dependent?Is there different Hierarchy-Ver?預(yù)留預(yù)留行項(xiàng)目成本中心成本控制范圍移動(dòng)類型采購(gòu)組工廠庫(kù)存地點(diǎn)物料工單工單類型預(yù)留基準(zhǔn)日期預(yù)留需求日期資

5、產(chǎn)號(hào)工廠基建項(xiàng)目號(hào)AttribompoundingOthersInfo-Object (CH)Attribut nameDis Navigat.Time Dependent?Compounding with other Info-objects?Note預(yù)留預(yù)留行項(xiàng)目成本中心成本控制范圍移動(dòng)類型采購(gòu)組工廠庫(kù)存地點(diǎn)物料物料組工單工單類型預(yù)留基準(zhǔn)日期預(yù)留需求日期資產(chǎn)號(hào)工廠基建項(xiàng)目號(hào)3.1. 時(shí)間特性3.2. 關(guān)鍵指標(biāo) (KF)Type / UnitAggregationInfo-Object (KF)Techn. NameKF-TypeUnitAggregation Min, Max, SumEx

6、ception- aggregationAgg. Reference characteristicOthers領(lǐng)料價(jià)值ZM_RSCURRAmount0LOC_CURRC Y需求數(shù)量ZM_RSQUANAmount0BASE_UOM領(lǐng)料數(shù)量ZM_WDQUANAmount0BASE_UOM刪除項(xiàng)目數(shù)ZM_RSDNMNumber完成的預(yù)留數(shù)ZM_RSFNMNumber預(yù)留項(xiàng)目數(shù)ZM_RSNUMNumber未完成項(xiàng)目數(shù)ZM_RSLEFNumberGerneralBexInfo-Object (CH)Techn. NameData- typeData- lengthDisplayAttribut?Conv

7、ert. RoutinText inSpalt HeaderAuth. Relev.Others日歷天0CALDAYDATS8日/月0CALMONTHDATS8日度/季度0CALQUARTERDATS8日0CALYEARDATS8Additional PropertiesInfo-Object (KF)Decimal- PlaDisplayBex Description領(lǐng)料價(jià)值2需求數(shù)量3領(lǐng)料數(shù)量3刪除項(xiàng)目數(shù)完成的預(yù)留數(shù)預(yù)留項(xiàng)目數(shù)未完成項(xiàng)目數(shù)3.3. ODS 對(duì)象無(wú)ODS 對(duì)象應(yīng)用3.4. InfoCubeNo.InfoCubeTechn. NameInfoAreaBasis- CubeMul

8、ti- CubeRemote- Cube1儀征化纖 MRO-預(yù)留信息塊YZ_M_C02YZ_PURXODS ObjectTechn. NameKey-fieldsData- fieldsPSA->ODSUpdateODS->Cube AggregationRemark3.4.1. BasisCubeBasisCube: < 儀征化纖 MRO預(yù)留信息塊>CharacteristicsTime CharacteristicsCharacteristicsTechn. NameRemark日歷天0CALDAY日/月0CALMONTH日度/季度0CALQUARTER日0CALY

9、EARDimenCharacteristicsNavigation AttributRemarkanization工廠庫(kù)存地點(diǎn)工廠Purchase采購(gòu)組Cost Center成本中心成本控制范圍PM Order工單工單類型Reservation預(yù)留預(yù)留行項(xiàng)目移動(dòng)類型資產(chǎn)號(hào)基建項(xiàng)目號(hào)Material物料Custom Time預(yù)留基準(zhǔn)日期預(yù)留需求日期Key FirgureNo.Key FiguerTechn. NameTypeUnit1領(lǐng)料價(jià)值ZM_RSCURRAmount0LOC_CURRCY2需求數(shù)量ZM_RSQUANAmount0BASE_UOM3領(lǐng)料數(shù)量ZM_WDQUANAmount0BA

10、SE_UOM4刪除項(xiàng)目數(shù)ZM_RSDNMNumber5完成的預(yù)留數(shù)ZM_RSFNMNumber6預(yù)留項(xiàng)目數(shù)ZM_RSNUMNumber7未完成項(xiàng)目數(shù)ZM_RSLEFNumber3.4.2. MultiCube無(wú) MultiCube 應(yīng)用3.4.3. RemoteCube無(wú)RemoteCube 應(yīng)用3.5. Aggregate無(wú) Aggregate 應(yīng)用4. 數(shù)據(jù)源系統(tǒng)分析DataSource: < YZ_M_T01 >Key Figure/ CharacteristicsTechn. NameSourc- systemTabelField NameRelated Text tabe

11、lCompounding withOthers預(yù)留ZM_RESERVRKPFRSNUM預(yù)留行項(xiàng)目ZM_RSITEMRKPFRS成本中心0COSTCENTERRKPFKOSTL移動(dòng)類型0MOVETYPERKPFBWART采購(gòu)組0PUR_GROUPRESBEKGRP工廠0PLANTRESBWERKS庫(kù)存地點(diǎn)0STOC_LOCRESBLGORTAggregatTechn. NameCubeCharacteristics/ AttributAggregation LevelRemarkRemoteCubeTechn. NameCharacteristicsKey FigureRelated Soury

12、stemRemarkMultiCubeTechn. NameCharacteristicsKey FigureRelated Basis-CubeRemarkDataSource: < 0MATERIAL >5. BW-Data Flow5.1. Data Flow in InfoCube YZ_M_C02Key Figure/ CharacteristicsTechn. NameSourc- systemTabelField NameRelated Text tabelCompounding withOthers物料0MATERIAL物料組0M_GROUP物料0MATERIALR

13、ESBMATNR資產(chǎn)號(hào)ZM_ASSETRKPFANLN1工單ZM_PMORDERRESBAUFNR工單類型ZM_PMOTYPAUFKAUART預(yù)留基準(zhǔn)日期ZM_RSDATERKPFRSDAT預(yù)留需求日期ZM_RSRDTRKPFBDTER領(lǐng)料價(jià)值ZM_RSCURRRESBENWRT需求數(shù)量ZM_RSQUANRESBBDMNG領(lǐng)料數(shù)量ZM_WDQUANRESBENMNGInfoCubeInfoSourourystemKey FigureDimenCharacteristicsAttribute/ Navigationsattr.Update Rule.InfoSourceTransfer Rule

14、Source SystemSourceExtraction領(lǐng)料價(jià)值領(lǐng)料價(jià)值YZ_M_T01YZ_M_T01CLNT800T10ZOXT100013需求數(shù)量需求數(shù)量YZ_M_T01CLNT800ZOXT100013領(lǐng)料數(shù)量領(lǐng)料數(shù)量YZ_M_T01CLNT800ZOXT100013刪除項(xiàng)目數(shù)刪除項(xiàng)目數(shù)YZ_M_T01CLNT800ZOXT100013完成的預(yù)留數(shù)完成的預(yù)留數(shù)YZ_M_T01CLNT800ZOXT100013預(yù)留項(xiàng)目數(shù)預(yù)留項(xiàng)目數(shù)YZ_M_T01CLNT800ZOXT100013未完成項(xiàng)目數(shù)未完成項(xiàng)目數(shù)YZ_M_T01CLNT800ZOXT100013anization工廠YZ_M_T

15、01CLNT800ZOXT100013庫(kù)存地點(diǎn)YZ_M_T01CLNT800ZOXT100013工廠YZ_M_T01CLNT800ZOXT100013Purchase采購(gòu)組YZ_M_T01CLNT800ZOXT100013Cost Center成本中心YZ_M_T01CLNT800ZOXT100013成本控制范圍YZ_M_T01CLNT800ZOXT100013PM Order工單YZ_M_T01CLNT800ZOXT100013工單類型YZ_M_T01CLNT800ZOXT100013Reservation預(yù)留YZ_M_T01CLNT800ZOXT100013預(yù)留行項(xiàng)目YZ_M_T01CLN

16、T800ZOXT100013移動(dòng)類型YZ_M_T01CLNT800ZOXT100013資產(chǎn)號(hào)YZ_M_T01CLNT800ZOXT100013基建項(xiàng)目號(hào)YZ_M_T01CLNT800ZOXT100013Material物料物料組YZ_M_T01CLNT800ZOXT100013Custom Time預(yù)留基準(zhǔn)日期YZ_M_T01CLNT800ZOXT100013預(yù)留需求日期YZ_M_T01CLNT800ZOXT1000135.2. Transfer RuleInfoSourceInfoObjectTech. NameMethodF= Trans.-Field C= Constante R = R

17、outineField Name/ ConstantRoutin DescriptionYZ_M_T01預(yù)留ZM_RESERVFZM_RESERV預(yù)留行項(xiàng)目ZM_RSITEMZM_RSITEM成本中心0COSTCENTER0COSTCENTE R成本控制范圍0CO_AREA0CO_AREA移動(dòng)類型0MOVETYPE0MOVETYPE采購(gòu)組0PUR_GROUP0PUR_GROUP工廠0PLANT0PLANT庫(kù)存地點(diǎn)0STOR_LOC0STOR_LOC物料0MATERIAL0MATERIAL工單ZM_PMORDERZM_PMORDE R工單類型ZM_PMOTYPZM_PMOTYP預(yù)留基準(zhǔn)日期ZM_

18、RSDATEZM_RSDATE預(yù)留需求日期ZM_RSRDTZM_RSRDT資產(chǎn)號(hào)ZM_ASSETZM_ASSET領(lǐng)料價(jià)值ZM_RSCURRZM_RSCURR需求數(shù)量ZM_RSQUANZM_RSQUAN領(lǐng)料數(shù)量ZM_WDQUANZM_WDQUAN刪除項(xiàng)目數(shù)ZM_RSDNMRZM_RSDNMif TRAN_STRUCTURE-XLOEK = 'X' . RESULT = 1 .else .RESULT = 0 .endif .完成的預(yù)留數(shù)ZM_RSFNMZM_RSFNMif TRAN_STRUCTURE-KZEAR = 'X' . RESULT = 1 .else

19、.5.3. Update RuleKey FigureCube/ODSUpdate RuleKey FigureMethodC = ConstanteM = Master Attribute R = RoutineI = Initial ValueField Name/ ConstantRoutin DescriptionYZ_M_C02YZ_M_T01ZM_RSCURRRZM_RSCURRif COMM_STRUCTURE-MOVETYPE = '202' or COMM_STRUCTURE-MOVETYPE = '242' or COMM_STRUCTURE

20、-MOVETYPE = '302' or COMM_STRUCTURE-MOVETYPE = 'Z42' or COMM_STRUCTURE-MOVETYPE = 'Z64' . RESULT = - COMM_STRUCTURE-/BIC/ZM_RSCURR .else .RESULT = COMM_STRUCTURE-/BIC/ZM_RSCURR .endif .InfoSourceInfoObjectTech. NameMethodF= Trans.-Field C= Constante R = RoutineField Name/ Con

21、stantRoutin DescriptionRESULT = 0 .endif .預(yù)留項(xiàng)目數(shù)ZM_RSNUMZM_RSNUMRESULT = 1 .未完成項(xiàng)目數(shù)ZM_RSLEFZM_RSLEFif TRAN_STRUCTURE-XLOEK = space and TRAN_STRUCTURE-KZEAR = space .RESULT = 1 .else .RESULT = 0 .endif .Cube/ODSUpdate RuleKey FigureMethodC = ConstanteM = Master Attribute R = RoutineI = Initial ValueFie

22、ld Name/ ConstantRoutin DescriptionZM_RSQUANZM_RSQUANif COMM_STRUCTURE-MOVETYPE = '202' or COMM_STRUCTURE-MOVETYPE = '242' or COMM_STRUCTURE-MOVETYPE = '302' or COMM_STRUCTURE-MOVETYPE = 'Z42' or COMM_STRUCTURE-MOVETYPE = 'Z64' . RESULT = - COMM_STRUCTURE-/BIC

23、/ZM_RSQUAN .else .RESULT = COMM_STRUCTURE-/BIC/ZM_RSQUAN .endif .ZM_WDQUANZM_WDQUANif COMM_STRUCTURE-MOVETYPE = '202' or COMM_STRUCTURE-MOVETYPE = '242' or COMM_STRUCTURE-MOVETYPE = '302' or COMM_STRUCTURE-MOVETYPE = 'Z42' or COMM_STRUCTURE-MOVETYPE = 'Z64' .

24、RESULT = - COMM_STRUCTURE-/BIC/ZM_WDQUAN .else .RESULT = COMM_STRUCTURE-/BIC/ZM_WDQUAN .endif .ZM_RSDNMIZM_RSDNMZM_RSFNMZM_RSFNMZM_RSNUMZM_RSNUMZM_RSLEFZM_RSLEFCharacteristics and Time Characteristics5.4. EnhancementBW SYSTEM:PROJEsignmentsFunctionField NameCodeCode DescriptionZYZBWRSR00001EXIT_SAPL

25、RRS0_00 1DATA: ls_range LIKE LINE OF e_t_range. DATA: l_date_char(8) TYPE n,l_dateTYPE d, l_month(60) ,l month2(2) type n ,變量定義Cube/ODSUpdate RuleInfoObjectMethodC = ConstantM = Master Attribut R = RoutineI = Initial ValueField Name/ ConstantRoutin DescriptionYZ M C02YZ M T01ZM RESERVIZM RESERVZM RS

26、ITEMZM RSITEM0COSTCENTER0COSTCENTER0CO AREA0CO AREA0MOVETYPE0MOVETYPE0PUR_GROUP0PUR_GROUP0PLANT0PLANT0STOR_LOC0STOR_LOC0MATERIAL0MATERIALZM_PMORDERZM_PMORDERZM_PMOTYPZM_PMOTYPZM_RSDATEZM_RSDATEZM_RSRDTZM_RSRDTZM_ASSETZM_ASSET0CALDAYI0CALDAY0CALMONTHR0CALMONTHRESULT = COMM_STRUCTURE-/BIC/ZM_RSRDT(6).

27、0CALYEAR0CALYEARRESULT = COMM_STRUCTURE-/BIC/ZM_RSRDT(4).PROJEsignmentsFunctionField NameCodeCode Descriptionl_day2(2) type n , l_date_l TYPE d, l_date_h TYPE d, l_month_l(6) type n , l_month_h(6) type n , l_year(4) type n ,l_day TYPE i.DATA: l_day_char(4) TYPE n.DATA: lt_var_range TYPE rrs0_t_var_r

28、ange, ls_var_range LIKE LINE OF lt_var_range.ZYZBWRSR00001EXIT_SAPLRRS0_00 1:E?+'8when 'T_YEAR' . if i_step = 2 .READ TABLE i_t_var_rangeO ls_var_range WITH KEY vnam = '0I_CMNTH'.l_year = ls_var_range-low(4) . ls_range-low = l_year .INSERT ls_rangeO TABLE e_t_range. endif .本年：將查詢

29、月當(dāng)年作為時(shí)間限制的范圍。2'9:E?when 'LAST_Y' . if i_step = 2 .READ TABLE i_t_var_rangeO ls_var_range WITH KEY vnam = '0I_CMNTH'.l_year = ls_var_range-low(4) . l_year = l_year - 1 .ls_range-low = l_year .INSERT ls_rangeO TABLE e_t_range. endif .上年：將查詢?cè)碌那耙荒曜鳛闀r(shí)間限制的范圍2'9:?E3when 'LASTY_M

30、' . if i_step = 2 .READ TABLE i_t_var_rangeO ls_var_range WITH KEY vnam = '0I_CMNTH'.l month l = ls var range-low .上年同期：將查詢?cè)碌那耙荒暝撛伦鳛闀r(shí)間限制SOURSYSTEM:PROJEsignmentsFunctionField NameCodeCcode DescriptionZYZBWRSAP0001EXIT_SAPLRSAP_00 1data : begin of tab_cont occurs 0 ,doc_number like MC11VA

31、0ITM-vbeln , contract_no like MC11VA0ITM-OICONTNR ,end of tab_cont .data : ds struct like MC11VA0ITM ,變量類型PROJEsignmentsFunctionField NameCodeCode Descriptionl_year = l_month_l(4) . l_year = l_year - 1 .concatena_year l_month_l+4(2) o l_month_l .ls_range-low = l_month_l .INSERT ls_rangeO TABLE e_t_r

32、ange. endif .的范圍。2'9:E3when 'LAST_M' . IF i_step = 2.READ TABLE i_t_var_rangeO ls_var_range WITH KEY vnam = '0I_CMNTH'.l_month_l = ls_var_range-low . l_month2 = l_month_l+4(2) . l_year = l_month_l(4) .if l_month = '01' . l_year = l_year - 1 .concatena_year '12'o l_month_l . else .l_month2 = l_month2 - 1 .concatena_year l_month2o l_month_l . endif .ls_range-low = l_month_l .INSERT ls_rangeO TABLE e_t_range. ENDIF.上月：將查詢?cè)碌那耙辉伦鳛闀r(shí)間限制的范圍。PROJEsignmentsFunctionField NameCodeC