Skip to Content
Technical Articles

ISU BW Extractors for Meter2Cash

Introduction

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)

ERDK, ERCH,

ERCHZ

EBW_DQ_SS
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_PAY Payments DPAYC, DPAYP,
DPAYH, DFKKZK,
DFKKZP &
DFKKEXC
FPBW_EXTRACT
0FC_RET Returns DFKKRH, DFKKRK FPRETBW
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

 

Conclusion

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.

/
1 Comment
You must be Logged on to comment or reply to a post.