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.

4 Comments

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

Naresh Aavunuri

November 10, 2020 at 9:34 am

Thanks Pruthvi ,

This has all the ISU extractor's details, nice blog!

Kiran Motapuram

February 5, 2021 at 10:25 am

Thanks Pruthvi,

I was looking for this information. If you know procedure to enhance the ISU data source can you publish.

Santosh VS

March 18, 2021 at 10:41 am

This article was very helpful, thanks a lot Pruthvi!

Malyadri Bapatu

July 14, 2022 at 1:17 pm

Thank Pruthvi . Very good information.

Technical Articles

ISU BW Extractors for Meter2Cash

Assigned Tags