1、項(xiàng)目:Petro-CyberWorks Information Technology Company Limited修改版本日期作者狀態(tài)審核1.02004-05-17編寫(xiě)中目錄1.需求描述52.數(shù)據(jù)模型星型結(jié)構(gòu)53.數(shù)據(jù)模型..3.5.特性 (CH)7時(shí)間特性12關(guān)鍵指標(biāo) (KF)12ODS 對(duì)象14INFOCUBE143.5.1.BasisCube15MultiCube18RemoteCube.. AGGREGATE184. 數(shù)據(jù)源系統(tǒng)分析185. BW-DATA FLOW.5.3.DATA FLOW IN IN

2、FOCUBEXX_C0120TRANSFER RULE22UPDATE RULE221. 需求描述附件下列文件詳細(xì)描述了本文檔所涉及的各個(gè)部門(mén)業(yè)務(wù)分析需求:簡(jiǎn)要描述:2. 數(shù)據(jù)模型星型結(jié)構(gòu)采購(gòu)部分文件名稱(chēng)狀態(tài)VendorFact TablePurchase Requisition供應(yīng)商DimenID采購(gòu)申請(qǐng)?jiān)u估類(lèi)型項(xiàng)目號(hào)采購(gòu)訂單數(shù)量用訂單貨幣計(jì)算的凈訂單值收貨數(shù)量 收貨價(jià)值 期末庫(kù)存 采購(gòu)申請(qǐng)量采購(gòu)需求中的價(jià)格值Material物料 物料組anization公司工廠庫(kù)存地點(diǎn)PurchasePurchase采購(gòu)憑證采購(gòu)憑證類(lèi)型采購(gòu)組織采購(gòu)組TimeUnitData Request申請(qǐng)創(chuàng)建日期訂單

3、日期申請(qǐng)要求供貨日期訂單計(jì)劃交貨日期訂單基本數(shù)據(jù)請(qǐng)求包6預(yù)留部分Fact TablePM OrderMaterial物料DimenID工單工單類(lèi)型物料組需求量 領(lǐng)料數(shù)量需求價(jià)值Reservation預(yù)留anization公司工廠庫(kù)存地點(diǎn)Cost Center成本中心TimeUnitData Request預(yù)留基準(zhǔn)日期訂單數(shù)據(jù)請(qǐng)求包基本3. 數(shù)據(jù)模型特性 (CH)GeneralBexMaster DataInfo-Object (CH)Techn. NameData Type)Daten- length )Display- Attribut?Convert. RoutinText in Spal

4、t headerAuth. Relev.Master Data?Time Dependent?公司代碼0COMP_CODECHAR4X工廠0PLANTCHAR4XX庫(kù)存地點(diǎn)0STOR_LOCCHAR4采購(gòu)組織0PURCH_CHAR4采購(gòu)組0PUR_GROUPCHAR3采購(gòu)申請(qǐng)ZM_PURREQCHAR10評(píng)估類(lèi)型0VAL_TYPECHAR10項(xiàng)目號(hào)ZM_RTRACKCHAR10采購(gòu)憑證0DOC_NUMCHAR10采購(gòu)憑證類(lèi)型0DOCTYPECHAR4物料0MATERIALCHAR18X供應(yīng)商0VENDORCHAR10X預(yù)留ZM_RESERVCHAR12成本中心0COSTCENTERCHAR10

5、工單ZM_PMORDERCHAR12工單類(lèi)型ZM_PMOTYPCHAR4TextHierarchyInfo-Object (CH)Text- SourceTime Dependent?Hierarchy?Time Dependent?Is there different Hierarchy-Ver?公司代碼工廠庫(kù)存地點(diǎn)采購(gòu)組織采購(gòu)組采購(gòu)申請(qǐng)?jiān)u估類(lèi)型項(xiàng)目號(hào)采購(gòu)憑證采購(gòu)憑證類(lèi)型物料X供應(yīng)商X預(yù)留成本中心工單工單類(lèi)型AttribompoundingOthersInfo-Object (CH)Attribut nameDis Navigat.Time Dependent?Compounding wit

6、h other Info-objects?Note公司代碼工廠庫(kù)存地點(diǎn)采購(gòu)組織采購(gòu)組采購(gòu)申請(qǐng)?jiān)u估類(lèi)型項(xiàng)目號(hào)采購(gòu)憑證采購(gòu)憑證類(lèi)型物料物料組供應(yīng)商預(yù)留成本中心工單工單類(lèi)型3.1. 時(shí)間特性*) bei Kundeneigenen Objekten3.2. 關(guān)鍵指標(biāo) (KF)Type / UnitAggregationInfo-Object (KF)Techn. NameKF-TypeUnitAggregation Min, Max, SumException- aggregationAgg. Reference characteristicOthers采購(gòu)訂單數(shù)量0ORDER_QUANtyORDE

7、R_QUAN用訂單貨幣計(jì)算的凈訂單值0NET_PO_VALtyORDER_CURR收貨數(shù)量0NET_VALUEAmount0BASE_UOM收貨價(jià)值0VALUE_LCty0LOC_CURRC Y期末庫(kù)存0NETVAL_INVAmount0S_CURR采購(gòu)申請(qǐng)量ZM_PRQUANtyORDER_QUAN采購(gòu)需求中的價(jià)格ZM_PRCURRtyORDER_CURR值0INVCD_AMNTAmount0LOC_CURRC Y需求數(shù)量ZM_RESVQUANAmountORDER_QUAN領(lǐng)料數(shù)量ZM_WDQUANAmountORDER_QUAN需求價(jià)值ZM_RESVCURRAmountORDER_CUR

8、RGerneralBexInfo-Object (CH)Techn. NameData- typeData- lengthDisplayAttribut?Convert. RoutinText inSpalt HeaderAuth. Relev.Others申請(qǐng)下達(dá)日期ZM_PRRELDAT EDATS8訂單日期0ENTRY_DATEDATS8申請(qǐng)要求供貨日期ZM_PRDELDAT EDATS8訂單計(jì)劃交貨日期0PRICE_DATEDATS8預(yù)留的基準(zhǔn)日期ZM_RESDATEDATS8Additional PropertiesInfo-Object (KF)Decimal- PlaDispla

9、yBex Description采購(gòu)訂單數(shù)量3用訂單貨幣計(jì)算的凈訂單值2收貨數(shù)量3收貨價(jià)值2期末庫(kù)存2采購(gòu)申請(qǐng)量3采購(gòu)需求中的價(jià)格2值2需求數(shù)量3領(lǐng)料數(shù)量3需求價(jià)值23.3. ODS 對(duì)象Es wird kein ODS verwendet.3.4. InfoCubeNo.InfoCubeTechn. NameInfoAreaBasis- CubeMulti- CubeRemote- CubeODS ObjectTechn. NameKey-fieldsData- fieldsPSA-ODSUpdateODS-Cube AggregationRemark3.4.1. BasisCubeBasi

10、sCube: CharacteristicsTime CharacteristicsCharacteristicsTechn. NameRemark申請(qǐng)下達(dá)日期ZM_PRRELDATE訂單日期0ENTRY_DATEDimenCharacteristicsNavigation AttributRemarkanization公司代碼anization工廠anization庫(kù)存地點(diǎn)Purchase采購(gòu)組織Purchase采購(gòu)組Purchase Requisition采購(gòu)申請(qǐng)Purchase Requisition采購(gòu)申請(qǐng)行項(xiàng)目Purchase Requisition評(píng)估類(lèi)型Purchase Requ

11、isition項(xiàng)目號(hào)Purchase PurchaseMaterial采購(gòu)憑證采購(gòu)憑證類(lèi)型物料Vendor供應(yīng)商申請(qǐng)要求供貨日期ZM_PRDELDATE訂單計(jì)劃交貨日期0SCHED_DATEKey FirgureNo.Key FiguerTechn. NameUnit1采購(gòu)訂單數(shù)量0PO_QTY0BASE_UOM2用訂單貨幣計(jì)算的凈訂單值0ORDER_VAL0LOC_CURRCY3收貨數(shù)量0GR_QTY0BASE_UOM4收貨價(jià)值0GR_VAL0LOC_CURRCY5期末庫(kù)存0NETVAL_INV0S_CURR6采購(gòu)申請(qǐng)量ZM_PRQUAN0BASE_UOM7采購(gòu)需求中的價(jià)格ZM_PRCURR

12、0LOC_CURRCY8值0INVCD_AMNT0LOC_CURRCYBasisCube: CharacteristicsTime CharacteristicsCharacteristicsTechn. NameRemark預(yù)留的基準(zhǔn)日期ZM_RESDATEDimenCharacteristicsNavigation AttributRemarkReservation預(yù)留Reservation移動(dòng)類(lèi)型Cost Center成本中心Purchase Group采購(gòu)組XMaterial物料PM Order工單PM Order工單類(lèi)型Key Firgure3.4.2. MultiCube3.4.3

13、. RemoteCube3.5. Aggregate4. 數(shù)據(jù)源系統(tǒng)分析DataSource: AggregatTechn. NameCubeCharacteristics/ AttributAggregation LevelRemarkRemoteCubeTechn. NameCharacteristicsKey FigureRelated SourystemRemarkMultiCubeTechn. NameCharacteristicsKey FigureRelated Basis-CubeRemarkNo.Key FiguerTechn. NameUnit1需求數(shù)量ZM_RESVQUA

14、N0BASE_UOM2領(lǐng)料數(shù)量ZM_WDQUAN0BASE_UOM3需求價(jià)值ZM_RESVCURR0LOC_CURRC YKey Figure/ CharacteristicsTechn. NameSourc- systemTabelField NameAdditional TexttabelleCompounding withOthers公司代碼0COMP_CODE工廠0PLANT庫(kù)存地點(diǎn)0STOR_LOC采購(gòu)組織0PURCH_采購(gòu)組0PUR_GROUP采購(gòu)申請(qǐng)ZM_PURREQ采購(gòu)申請(qǐng)行項(xiàng)目ZM_PRITEM評(píng)估類(lèi)型0VAL_TYPE項(xiàng)目號(hào)ZM_RTRACK采購(gòu)憑證0DOC_NUM采購(gòu)憑證

15、類(lèi)型0DOCTYPE物料0MATERIAL供應(yīng)商0VENDOR采購(gòu)訂單數(shù)量0PO_QTY用訂單貨幣計(jì)算的凈訂單值0ORDER_VAL收貨數(shù)量0GR_QTY收貨價(jià)值0GR_VAL值0INVCD_AMNTDataSource:DataSource:DataSource:Key Figure/ CharacteristicsTechn. NameSourc- systemTabelField NameRelated Text tabelCompounding withOthers物料0MATERIAL物料組0M_GROUPKey Figure/ CharacteristicsTechn. NameS

16、ourc- systemTabelField NameRelated Text tabelCompounding withOthers采購(gòu)申請(qǐng)ZM_PURREQEBANBANFN評(píng)估類(lèi)型0VAL_TYPEEBANBWTAR項(xiàng)目號(hào)ZM_REQTRACKEBANBEDNR采購(gòu)申請(qǐng)量ZM_PRQUANEBANMENGE采購(gòu)需求中的價(jià)格ZM_PRCURREBANPREISKey Figure/ CharacteristicsTechn. NameSourc- systemTabelField NameRelated Text tabelCompounding withOthers預(yù)留ZM_RESERV

17、RKPFRSNUM成本中心0COSTCENTERRKPFKOSTL移動(dòng)類(lèi)型0MOVETYPERKPFBWART采購(gòu)組0PUR_GROUPRESBEKGRP工廠0PLANTRESBWERKS庫(kù)存地點(diǎn)0STOC_LOCERSBLGORT物料0MATERIALRESBMATNR工單ZM_PMORDERRESBAUFNR工單類(lèi)型ZM_PMOTYPAUFKAUART需求數(shù)量ZM_RESVQUANRESBBDMNG領(lǐng)料數(shù)量ZM_WDQUANRESBENMNG需求價(jià)值ZM_RESVCURRRESBENWRTDataSource: BW-Data FlowData Flow in InfoCubeXX_C01

18、InfoCubeInfoSourourystemKey FigureDimenCharacteristicsAttribute/ Navigationsattr.Update Rule.InfoSourceTransfer RuleSource SystemSourceExtraction采購(gòu)訂單數(shù)量mm_menge2LIS_02_SCL /0CPQUAOUCLNT80 0用訂單貨幣計(jì)算的凈訂單值mm_effwr2LIS_02_SCL /0ORDER_VALCLNT80 0收貨數(shù)量mm_wemng2LIS_02_SCL /0CPQUAOUCLNT80 0收貨價(jià)值mm_wewrt2LIS_02_

19、SCL /0CPPVLCCLNT80 0期末庫(kù)存CLNT80 0采購(gòu)申請(qǐng)量YZ_M_T02/ ZM_PRQUANCLNT80 0采購(gòu)需求中的價(jià)格YZ_M_T02/ ZM_PRCURRCLNT80 0值CLNT80 0Key Figure/ CharacteristicsTechn. NameSourc- systemTabelField NameRelated Text tabelCompounding withOthers供應(yīng)商0VENDOR供應(yīng)商帳戶(hù)組T_GRPV國(guó)家代碼0COUNTRY一（二）級(jí)資源市場(chǎng)ZM_VLEVELLFA1BAHNSanization公司代碼2LIS_02_SCL/

20、CLNT80 0anization工廠2LIS_02_SCL/0PLANTCLNT80 0anization庫(kù)存地點(diǎn)2LIS_02_SCL/0STOR_LOCCLNT80 0Purchase采購(gòu)組織2LIS_02_SCL/0PURCH_CLNT80 0Purchase采購(gòu)組2LIS_02_SCL/0PUR_GROUPCLNT80 0Purchase Requisition采購(gòu)申請(qǐng)YZ_M_T02/ZM_PURREQCLNT80 0Purchase Requisition評(píng)估類(lèi)型YZ_M_T02/0VAL_TYPECLNT80 0Purchase Requisition項(xiàng)目號(hào)YZ_M_T02/

21、ZM_REQTRACKCLNT80 0Purchase Purchase Material采購(gòu)憑證2LIS_02_SCL/0DOC_NUMCLNT80 0采購(gòu)憑證類(lèi)型2LIS_02_SCL/0DOCTYPECLNT80 0物料物料組2LIS_02_SCL/0MATERIAL2LIS_02_SCL/0M_GROU PCLNT80 0Vendor供應(yīng)商供應(yīng)商帳戶(hù)組國(guó)別列車(chē)站（一、二級(jí)資源市場(chǎng)）2LIS_02_SCL/0VENDORCLNT80 05.2. Transfer RuleInfoSourceInfoObjectTech. NameMethodF= Trans.-Field C= Cons

22、tante R = RoutineField Name/ ConstantRoutin DescriptionYZ_M_T01ZM_RSNUM預(yù)留項(xiàng)目數(shù)RRESULT 恒為 1YZ_M_T01ZM_RSDNM刪除項(xiàng)目數(shù)RTRAN_STRUCTU RE- XLOEK如果預(yù)留的刪除標(biāo)記為X，則返回 1；否則返回 0YZ_M_T01ZM_RSFNM完成項(xiàng)目數(shù)RTRAN_STRUCTU RE-KZEAR如果完成標(biāo)志為X，則返回 1；否則返回 0YZ_M_T01ZM_RSLEF未完成項(xiàng)目數(shù)RTRAN_STRUCTU RE-KZEAR/ TRAN_STRUCTU RE-KZEAR如果預(yù)留的刪除標(biāo)志和完成標(biāo)

23、志同時(shí)為空，則返回1；否則返回 05.3. Update Rule儀征化纖 MRO-采購(gòu)信息塊從 2.0B 開(kāi)始的采購(gòu)數(shù)據(jù)（憑證計(jì)劃行級(jí)別）Key FigureCube/ODSKey FigureMethodC = ConstanteM = Master Attribute R = RoutineI = Initial ValueField Name/ ConstantRoutin DescriptionYZ_M_C02領(lǐng)料價(jià)值R：領(lǐng)料價(jià)值COMM_STRUCTURE-/BIC/ZM_RSCURR判斷預(yù)留的移動(dòng)類(lèi)型 COMM_STRUCTURE-MOVETYPE是否為 202、242、Z42、

24、Z64 其中之一，如果是則返回負(fù)值；如果為 201、241、Z41、Z63 其中之一，則返回正值YZ_M_C02需求數(shù)量R：需求數(shù)量COMM_STRUCTURE-/BIC/ZM_RSQUAN判斷預(yù)留的移動(dòng)類(lèi)型 COMM_STRUCTURE-MOVETYPE是否為 202、242、Z42、Z64 其中之一，如果是則返回負(fù)值；如果為 201、241、Z41、Z63 其中之一，則返回正值YZ_M_C02領(lǐng)料數(shù)量R：領(lǐng)料數(shù)量COMM_STRUCTURE-/BIC/ZM_WDQUAN判斷預(yù)留的移動(dòng)類(lèi)型 COMM_STRUCTURE-MOVETYPE是否為 202、242、Z42、Z64 其中之一，如果是

25、則返回負(fù)值；如果為 201、241、Z41、Z63 其中之一，則返回正值YZ_M_C02刪除項(xiàng)目數(shù)C刪除項(xiàng)目數(shù)YZ_M_C02完成的預(yù)留數(shù)C完成的預(yù)留數(shù)YZ_M_C02預(yù)留項(xiàng)目數(shù)C預(yù)留項(xiàng)目數(shù)YZ_M_C02未完成項(xiàng)目數(shù)C未完成項(xiàng)目數(shù)Characteristics and Time CharacteristicsAppendix1、 自定義數(shù)據(jù)源 YZ_M_T01創(chuàng)建方法：根據(jù)視圖提取視圖名稱(chēng)：ZYZ_M_T01提取結(jié)構(gòu)：ZOXT100013視圖名稱(chēng)：ZYZ_M_T01，事務(wù)代碼 SE11Cube/ODSInfoObjectMethodC = ConstantM = Master Attribu

26、t R = RoutineI = Initial ValueField Name/ ConstantRoutin Description日歷天C 預(yù)留需求日期COMM_STRUCTURE-/BIC/ZM_RSRDT日/月需求年月COMM_STRUCTURE-/BIC/ZM_RSRDTCOMM_STRUCTURE-/BIC/ZM_RSRDT (6),即為預(yù)留需求日期的年+月日需求年COMM_STRUCTURE-/BIC/ZM_RSRDTCOMM_STRUCTURE-/BIC/ZM_RSRDT (4),即為預(yù)留需求日期的年選擇條件2、 Enhancement字段增強(qiáng)：因?yàn)镮nfoCube 中需要工

27、單的類(lèi)型（大修、中），而視圖無(wú)法實(shí)現(xiàn)表RKPF/RESB 和表 AUFK 的外連接（LEFT OUTER JOIN），因此需要在表 RKPF 中附加一個(gè)字段：工單類(lèi)型，然后在視圖中選中，在客戶(hù)退出中獲取相應(yīng)的值。事務(wù)代碼SE11 Append Structure代碼增強(qiáng)：創(chuàng)建客戶(hù)退出項(xiàng)目ZYZBW，事務(wù)代碼cmod其中組件EXIT_SAPLRSAP_001 用于交易數(shù)據(jù)的增強(qiáng)，EXIT_SAPLRSAP_002 用于主數(shù)據(jù)的增強(qiáng)組件EXIT_SAPLRSAP_001中對(duì)以下提取結(jié)構(gòu)中的數(shù)據(jù)進(jìn)行了補(bǔ)充YZ_M_T01代碼段用于從工單中獲取相應(yīng)的工單類(lèi)型，以補(bǔ)充提取結(jié)構(gòu)ZOXT100013中的數(shù)據(jù)對(duì)于提取結(jié)構(gòu)中