Man pages for takewiki/rbupkg
Report Base Unit for Report system.

rbu_api_detail_hana向BW报表写入明细数据至hana
rbu_api_detail_rds将过程表写入至RDS
rbu_api_res_hana向BW报表写入结果数据至hana
rbu_api_res_rds写入结果表至RDS T_FI_RPA rds_vw_T_FI_RPA_all
rbu_autoCheck_rpa_vs_target管报自动化处理差异表
rbu_calc_level_ALL计算结果表强制为万元 vw_mrpt_res_level_ALL
rbu_calc_level_ALL2计算结果结果,最接近结果的内容
rbu_calc_level_ALL3计算结果增加了执行预算数据 vw_mrpt_res_level_ALL3
rbu_calc_level_ALL4计算结果增加了同比数据,19与20年数据 vw_mrpt_res_level_ALL4
rbu_calc_level_ALL_original结果表的处理内容,扣除报表项目为空的问题...
rbu_calc_level_ALL_zero按报表项目进行张量补全
rbu_calc_level_I06_profit计算指标I06
rbu_calc_level_I07_profitRate计算指标I07
rbu_calc_level_I08_salesFee计算指标I08
rbu_calc_level_I26_Salesprofit计算指标I26
rbu_calc_level_I27_marketFee计算指标I27
rbu_calc_level_I44_marketProfit计算指标I44
rbu_calc_level_level1计算结果从明细表到汇总表部分
rbu_calc_level_level12结果表,增加了零售额及回款信息 使用得不是很规范,
rbu_ds_adjTitle t_mrpt_adj
rbu_ds_sapt_mrpt_data_sap
rbu_feeAllcation1、费用分配明细表 rbu_feeAllcation_all_Allocated 同名的函数
rbu_feeAllcation_all_Allocated费用分析明细表 mrpt2_vw_ds_all_Allocated 视图...
rbu_feeAllocation_all_TeTongTotal_detail费用分配处理特通数据 mrpt2_vw_ds_all_TeTongTotal_detail
rbu_feeAllocation_cost费用分配市场费用
rbu_feeAllocation_costTotal品牌所有渠道营业成本汇总表 vw_mrpt_res_costTotal
rbu_feeAllocation_marketRatio市场费用分配率 vw_mrpt_res_marketRatio
rbu_feeAllocation_market_toChannel市场费用已分配到各渠道 vw_mrpt_res_MartetFee_toChannel
rbu_feeAllocation_marktNot非市场费用 mrpt2_vw_ds_all_unAllocated_marketNot
rbu_feeCollection费用归集所有明细 mrpt2_vw_ds_all_unAllocated
rbu_feeCollection_adj费用归集-手调凭证 mrpt2_vw_ds_adj_all
rbu_feeCollection_adj_allTitle
rbu_feeCollection_all_biorrierYaoFang_RevenueMinus费用分配药房冲减收入...
rbu_feeCollection_all_kaTotal_detail费用分配明细KA数据 mrpt2_vw_ds_all_kaTotal_detail
rbu_feeCollection_all_unAllocated费用归集明细表 mrpt2_vw_ds_all_unAllocated
rbu_feeCollection_all_unAllocated_market市场费用待分配 mrpt2_vw_ds_all_unAllocated_market
rbu_feeCollection_all_unAllocated_withSuperCustomers费用待分配包括KA,特通及大客户–...
rbu_feeCollection_all_unAllocated_withSuperCustomers_brandChannel匹配了品牌渠道费用及品牌渠道基础表
rbu_feeCollection_bw费用归集-BW mrpt2_vw_ds_bw_all
rbu_feeCollection_bw_allTitle mrpt2_vw_ds_bw_all
rbu_feeCollection_bw_rpa_ruledBW写入的结果表 这应该是BW核对核法写入的结果...
rbu_feeCollection_sap费用归集-SAP mrpt2_vw_ds_sap_all
rbu_feeCollection_sap_all1.1.01费用归集SAP凭证 mrpt2_vw_ds_sap_all
rbu_feeCollection_sap_BrandChannel_allTitle mrpt2_vw_data_sap_BrandChannel_all
rbu_feeCollection_sap_BrandChannel_chandoEcomTitle mrpt2_vw_data_sap_BrandChannel_chandoEcom
rbu_feeCollection_sap_BrandChannel_GeneralOthers除自然堂电商的费用...
rbu_feeCollection_sap_BrandChannel_notnullTitle
rbu_feeCollection_sap_FeeName_generalOthers_allTitle mrpt2_vw_data_sap_FeeName_generalOthers_all
rbu_feeCollection_sap_FeeName_generalOthers_notNullTitle mrpt2_vw_data_sap_FeeName_generalOthers_notNull
rbu_feeCollection_sap_rptItem_all1.1.01.03、SAP凭证项目—
rbu_feeCollection_sap_rptItem_all_allocatedSAP费用分配表 mrpt2_vw_data_sap_rptItem_all_allocated
rbu_feeCollection_sap_rptItem_all_sharedSAP凭证共享成本中心费用待分配...
rbu_feeCollection_sap_rptItem_all_unique独占的费用 mrpt2_vw_data_sap_rptItem_all_unique
rbu_feeCollection_sap_rptItem_chandoEcom_allTitle mrpt2_vw_data_sap_rptItem_chandoEcom_all
rbu_feeCollection_sap_rptItem_chandoEcom_notnullTitle mrpt2_vw_data_sap_rptItem_chandoEcom_notnull
rbu_feeCollection_sap_rptItem_GeneralOthers_allTitle mrpt2_vw_data_sap_rptItem_GeneralOthers_all
rbu_feeCollection_sap_rptItem_GeneralOthers_notNull除自然堂电商外的内容...
rbu_feeCollection_sap_rptItem_shared_allocatedSAP 凭证费用-分配部分 mrpt2_vw_data_sap_salesFee_allocated
rbu_md_brandChannel基础资料品牌渠道表 t_mrpt2_md_brandChannel
rbu_md_costCenter_directFeeTitle
rbu_md_costCenter_marketFeeTitle
rbu_md_costCenter_salesFee_totalTitle
rbu_md_costCenter_shared_salesFee共享成本中心的渠道费用分配比例
rbu_md_costCenter_total成本中心 mrpt2_vw_md_costCenter_total
rbu_md_rptItem报表项目基础表 t_mrpt_rptItem
rbu_normalize_rpa针对管报的RPA结果进行标准化
rbu_normalize_target针对手工管报数据进行标准化处理
rbu_rollup_actual针对历史数据进行处理 mrpt_calc_runAll_actual
rbu_rollup_actual_cumSum计算历史数据累计数 mrpt_calc_cumSum_Period
rbu_rollup_budget针对执行预算进行处理 mrpt_calc_runAll_budget
rbu_rollup_budget_sumSum计算累计数_执行预算 mrpt_calc_cumSum_Period_budget
rbu_rollup_res_all计算结果表,整合当期及累计期间数据 基本不用这个方法了...
rbu_rollup_res_rpa计划结果计算-RPA数据 从7月开始计算,保留6月数据...
rbu_rollup_res_sumSum计算累计数_实际数 mrpt_calc_cumSum_Period_res
rbu_rollup_res_target计划结果计算-手工管报数据-当期数据...
rbu_rollup_ytdCumsum计算累计数,意义不大,整体做的计算 rds_t_mrpt_res_cumsum_rpa
takewiki/rbupkg documentation built on Dec. 23, 2021, 7:43 a.m.