ISU BW Extractors for Meter2Cash
Few years back when I started with my first IS-U project, I had to go through the process of learning how the extraction takes place from IS-U source system? Over the last few years working in different IS-U projects I gathered information on difference extractors in IS-U specifically for meter2cash Business Process. I am sharing that information in this blog.
Typical SAP BW business content extractors falls under one of the below categories:
- LO extraction (SD,MM,PM,QM etc)
- Timestamp based Extraction (FI)
- BDoc based Extration (CRM)
- Info type based Extraction (HR)
In case of IS-U extractors, the approach followed is different. Most of the extractors in IS-U follows an additional prerequisite step called Mass Activity.
ISU BW Extractors
Below is the list of ISU specific extractors (except 0FI_GL_10) and their corresponding application tables & mass activities for meter2cash scenario.
Note: Few extractors do not have mass activity as the update to delta queue takes place within the update function module of application table.
|Functional Area||BW Extractor||Description||Key Tables||Mass Activity (Transaction Codes)|
|Meter Reading Order||0UC_MTR_DOC||IS-U Meter Reading Document (EABL)||EABL||Direct update to Delta queue, No mass activity required|
|Bill Order||0UC_BILLORD||ISU Billing Order (ETRG)||ETRG||Direct update to Delta queue, No mass activity required|
|Billing & Invoicing||0UC_INSTFACTS||Installation Facts||ETTIFN||Direct update to Delta queue, No mass activity required|
|0UC_SALES_SIMU_01||IS-U Mass Simulation for Billing||ERCH, ERCHZ||EAMS00
(EAMS20 – Define Simulation period
EAMS10- Define Simulation index)
|0UC_SALES_STATS_02||IS-U Sales Statistics (Delta created by Mass Activity)||
|FICA||0FC_BP_ITEMS||FI-CA Business Partner Items||DFKKOP||FPBW_EXTRACT|
|0FC_OP_01||FI-CA Open Items at Key Date||DFKKOPBW||FPBW|
|0FC_CI_01||FICA Cleared Items for Interval||DFKKCIBW||FPCIBW|
|0FC_IPL_HEAD_01||Installment Plan Header Data for Business Warehouse||FKK_INSTPL_HEAD||FPIPBW|
|0FC_IPL_ITEM_01||Installment Plan Items for Business Warehouse||DFKKOP|
|0FC_IPL_ORIG_01||Installment Plan Original Items for Business Warehouse||DFKKOP|
|0FC_DUN_ACTIVITIES||FI-CA Dunning Activities||FKKMACTIVITIES||Direct update to Delta queue, No mass activity required|
|0FC_DUN_HEADER||Header Data of FI-CA Dunning History||FKKMAKO|
|0FC_DUN_ITEMS||Items of FI-CA Dunning History||FKKMAZE|
|0FC_RDI||FI-CA Revenue Distribution||DFKKRDI||FP60BW|
|FIGL||0FI_GL_10||General Ledger: Leading Ledger Balances||FAGLFLEXT||Direct update to Delta queue, Timestamp based|
BW consultants getting into IS-U (SAP Utilities) project for the first time needs to know about different IS-U extractors. And this blog is to kick start that learning process.