石化bw項目數(shù)據(jù)模型設(shè)計功能說明書-成本主題

1、項目: 中國BW 項目數(shù)據(jù)模型設(shè)計功能書成本02修改客戶確認：目錄1.需求描述4版本日期作者狀態(tài)審核1.02005-9-3寫設(shè)計文檔2.數(shù)據(jù)模型星型結(jié)構(gòu)53.數(shù)據(jù)模型特性 (CH)..時間特性6關(guān)鍵指標(biāo) (KF)7ODS對象8信息立方體..3.Basiccube9MultiCube10RemoteCube103.5.AGGREGATE104.數(shù)據(jù)源系統(tǒng)分析115.BW-DATA FLOW..5.5.DATA FLOW11DATA SOURCE13TRANSFER RULE13UPDATE RULE14E

2、NHANCEMENT176.QUERY177.AUTHORIZATION171. 需求描述附件下列文件詳細描述了本文檔所涉及的各個部門業(yè)務(wù)分析需求:文件名稱狀態(tài)2. 數(shù)據(jù)模型星型結(jié)構(gòu)InfoCube: 裝置成本物料部分023. 數(shù)據(jù)模型特性 (CH)InfoCube: 裝置成本 物料部分02GeneralBexMaster DataInfo-Object (CH)Techn. NameData Type)Daten- length )Display- Attribut?Convert. RoutinText in Spalt headerAuth. Relev.Master Data?Time

3、 Dependent?成本中心0COSTCENTERCHAR10成本要素0COSMNTCHAR10公司代碼0COMP_CODECHAR4物料0MATERIALCHAR18評估類型科目分配批次成本中心成本要素成本要素成本控制范圍成本要素（總部）Fact TableDimenID金額數(shù)量固定數(shù)量可變數(shù)量物料物料財務(wù)會計公司代碼3.1. 時間特性InfoCube: 裝置成本 物料部分02GerneralBexInfo-Object (CH)Techn. NameData- typeData- lengthDisplayAttribut?Convert. RoutinText inSpalt Head

4、erAuth. Relev.Others會計年度/期間0FISCPERNUMC7會計年度變式0FISCVARNTCHAR2AttribompoundingOthersInfo-Object (CH)Attrib ut nameDis Navigat.Time Dependent?Compounding with other Info-objects?Note成本中心成本要素公司代碼物料批次成本控制范圍成本要素（總部）TextHierarchyInfo-Object (CH)Text- SourceTime Dependent?Hierarchy?Time Dependent?Is there

5、different Hierarchy-Ver?成本中心成本要素公司代碼物料批次成本控制范圍成本要素（總部）批次0BATCHCHAR10成本控制范圍0CO_AREACHAR4成本要素（總部）ZCOSTEMNTCHAR103.2. 關(guān)鍵指標(biāo) (KF)InfoCube: 裝置成本 物料部分02Additional PropertiesInfo-Object (KF)Decimal- PlaDisplayBex Description金額數(shù)量固定數(shù)量可變數(shù)量Type / UnitAggregationInfo-Object (KF)Techn. NameKF-TypeUnitAggregation

6、Min, Max, SumException- aggregationAgg. Reference characteristicOthers金額0AMOUNT金額數(shù)量0TY數(shù)量固定數(shù)量0TYFX數(shù)量可變數(shù)量0TYVR數(shù)量記帳期間0FISCPER3NUMC3會計年度0FISCYEARNUMC43.3. ODS 對象3.4. 信息立方體No.InfoCubeTechn. NameInfoAreaBasis- CubeMulti- CubeRemote- Cube1利潤中心行項目ZECA01ZHQFI_COX2CO OM: 成本和分配 (Delta 提取)01ZHQFI_COX3裝置成本 物料部分0

7、2ZHQFI_COX4實際成本/物料帳ZCOCPC01ZHQFI_COXODS ObjectTechn. NameKey-fieldsData- fieldsPSA-ODSUpdateODS-Cube AggregationRemark3.4.1. BasiccubeBasiccube: 裝置成本 物料部分02時間特性CharacteristicsTechn. NameRemark會計年度/期間0FISCPER會計年度變式0FISCVARNT記帳期間0FISCPER3會計年度0FISCYEAR維度特性導(dǎo)航屬性備注科目分配成本中心利潤中心成本要素成本要素成本控制范圍成本要素（總部）財務(wù)會計公司代

8、碼物料物料評估類型批次關(guān)鍵指標(biāo)InfoCube: 裝置成本 物料部分023.4.2. MultiCube無 MultiCube 應(yīng)用3.4.3. RemoteCube無 RemoteCube 應(yīng)用3.5. Aggregate無 Aggregate 應(yīng)用AggregatTechn. NameCubeCharacteristics/ AttributAggregation LevelRemarkRemoteCubeTechn. NameCharacteristicsKey FigureRelated SourystemRemarkMultiCubeTechn. NameCharacteristic

9、sKey FigureRelated Basis-CubeRemark序號關(guān)鍵指標(biāo)技術(shù)名稱1金額0AMOUNT2數(shù)量0TY3固定數(shù)量0TYFX4可變數(shù)量0TYVR4. 數(shù)據(jù)源系統(tǒng)分析DataSource:BW-Data FlowData FlowInfoCube:02Key Figure/ CharacteristicsTechn. NameSourc- systemTabelField Name數(shù)據(jù)源中的字段描述Related Text tabelCompounding withOthers公司代碼0COMP_CODEBUKRS公司代碼會計年度0FISCYEARGJAHR會計年度記帳期間0F

10、ISCPER3MONAT會計期間成本中心0COSTCENTERKOSTL成本中心#N/A0VAL_TYPEBWTAR評估類型批量0BATCHSORT三字節(jié)字段數(shù)量0TYPRD_MENGE數(shù)量計量的0UNITMEINS基本計量固定數(shù)量0TYFXMENGE數(shù)量#N/A0BASE_UOMMEINS001基本計量可變數(shù)量0TYVRBMENG基本數(shù)量#N/ABMEIN基本計量#N/AZIFFR權(quán)數(shù)金額0AMOUNTDMBTR按本位幣計的金額貨幣0CURRENCYWAERS貨幣代碼物料0MATERIALMATNR物料號碼5.2. Data Source5.3. Transfer RuleData Sour

11、ceTypeB = BCTS = inforsite V = viewF = function modulInforsite/Vie w/Function modul nameField NameDescriptionAttribute S = select H = hide D = delta02_T01SZFRYP016BMEIN基本計量BMENG基本數(shù)量BUKRS公司代碼SBWTAR評估類型DMBTR按本位幣計的金額GJAHR會計年度SKOSTL成本中心SMATNR物料號碼SMEINS基本計量MEINS001基本計量MENGE數(shù)量MONAT會計期間SPRD_MENGE數(shù)量SORT三字節(jié)字

12、段TEXT_ZFRYP016_BU公司碼或公司的名稱HTEXT_ZFRYP016_MA物料描述HWAERS貨幣代碼ZIFFR權(quán)數(shù)5.4. Update RuleKey FigureCube/ODSUpdate RuleKey FigureMethodC = ConstanteM = Master Attribute R = RoutineI = Initial ValueField Name/ ConstantRoutin DescriptionInfoSourceInfoObjectTech. NameMethodF= Trans.-Field C= Constante R = Routin

13、eField Name/ ConstantRoutin Description02_T01公司代碼0COMP CODEBUKRS會計年度0FISCYEARGJAHR記帳期間0FISCPER3MONAT成本中心0COSTCENTERKOSTL#N/A0VAL_TYPEBWTAR批量0BATCHSORT數(shù)量0TYPRD_MENGE計量的0UNITMEINS固定數(shù)量0TYFXMENGE#N/A0BASE_UOMMEINS001可變數(shù)量0TYVRBMENG#N/ABMEIN#N/AZIFFR金額0AMOUNTDMBTR貨幣0CURRENCYWAERS物料0MATERIALMATNRCube/ODSUpdate RuleKey FigureMethodC = ConstanteM = Master Attribute R = RoutineI = Initial ValueField Name/ ConstantRoutin Description0202_T010AMOUNT 金額0AMOUNT 金額0TY 數(shù)量0TY 數(shù)量0TYFX 固定數(shù)量0TYFX 固定數(shù)量0TYVR 可變數(shù)量0TYVR 可變數(shù)量Characteristics and Time Characteris