SAP ECC Revenue Accounting and Reporting data extraction to BW

[former_member191571]

Hi All,

We are planning to implement Revenue Accounting and Reporting Module(1.0 SP01)    in SAP ECC.     

Our users are requesting reporting out of BW. There are standard datasources available (e.g. 0FARR_RA_10)

Would like to know if anyone has ideas on data extraction to BW for Rev. Accounting & Reporting module. Can we have continuous data extracts from ECC to BW (every 2 to 3 hours)?

Any suggestions?

Thanks,

PS

[Former Member]

Hi,

Yes there is a possibility to pull the data ever 2hours once.

Thanks & Regards,

Srinu.Rapolu

[former_member191571]

This message was moderated.

[former_member200518]

Prasad,

Thanks a lot for your valuable inputs on master data usage . do we have any bi content info obj or dso/cube for this rar ?? or should we go with zobjects..

Thanks in advance,

Dinesh

[former_member191571]

Dinesh

There are no standard BI Contents available as of now.

Currently we are creating custom info-objects.

Which Rev. Recognition version are you implementing in ECC?

Do you have any BI specific reporting requirements?

Thanks,

Prasad

[former_member200518]

Prasad,

We are implementing revrec 1.1 version.. As of now we are planning to create seperate flows for SD and RAR , but if am not wrong RAR will be tied up with SD- Billing ..I have one question regarding master data objects in RAR

Lets say you are creating zobjects for 0FARR_CONTR_ATTR datasource.

It has the following fields listed below so while creating zobjects which one do you take as Primary info object what others do u consider as its attributes. Can you guide me on this.

Field in ECC	Description	Table Of Origin	Data type	Length	Decimal
ACCT_PRINCIPLE	Accounting Principle	FARR_D_CONTRACT	CHAR	4	0
ALLOC_DIFFER	Contract Allocation Effect	FARR_D_CONTRACT	CURR	23	2
ASSET_ACCOUNT	Contract Asset Account	FARR_D_CONTRACT	CHAR	10	0
COMPANY_CODE	Company Code	FARR_D_CONTRACT	CHAR	4	0
COMPLETION_DATE	Completion Date	FARR_D_CONTRACT	DATS	8	0
CONTRACT_CAT	Contract Category	FARR_D_CONTRACT	CHAR	4	0
CONTRACT_ID	Revenue Recognition Contract ID	FARR_D_CONTRACT	NUMC	14	0
CONTR_CREATED_ON	The datetime for contract created	FARR_D_CONTRACT	DEC	15	0
CONTR_EEW_DUMMY	Dummy function in length 1	FARR_D_CONTRACT	CHAR	1	0
CREATED_BY	Name of Person who Created the Object	FARR_D_CONTRACT	CHAR	12	0
CREATED_ON	Date on Which Record Was Created	FARR_D_CONTRACT	DATS	8	0
CUSTOMER_GRP	Group key	FARR_D_CONTRACT	CHAR	10	0
CUSTOMER_ID	Customer Number	FARR_D_CONTRACT	CHAR	10	0
DESCRIPTION	Description of Revenue Accounting Items	FARR_D_CONTRACT	CHAR	60	0
EXCHANGE_RATE	Exchange rate	FARR_D_CONTRACT	DEC	9	5
EXCHANGE_RATE2	Exchange Rate for the Second Local Currency	FARR_D_CONTRACT	DEC	9	5
EXCHANGE_RATE3	Exchange Rate for the Third Local Currency	FARR_D_CONTRACT	DEC	9	5
HAS_TM_POB	Contract Contains Time-Based Performance Obligations	FARR_D_CONTRACT	CHAR	1	0
LAST_CHANGED_BY	Name of Person Who Changed Object	FARR_D_CONTRACT	CHAR	12	0
LAST_CHANGED_ON	Changed On	FARR_D_CONTRACT	DATS	8	0
LIABILITY_ACCOUNT	Contract Liability Account	FARR_D_CONTRACT	CHAR	10	0
MANUAL_ALLOCATED	Price was allocated manually on the Contract	FARR_D_CONTRACT	CHAR	1	0
MANUAL_CHANGED	Manually Changed	FARR_D_CONTRACT	CHAR	1	0
MANUAL_CREATED	Manually Created	FARR_D_CONTRACT	CHAR	1	0
MANUAL_DELETED	Manually Deleted	FARR_D_CONTRACT	CHAR	1	0
NUM_OF_POB	Number of Performance Obligations	FARR_D_CONTRACT	INT4	10	0
PARTNER	Business Partner Number	FARR_D_CONTRACT	CHAR	10	0
PENDING_CONFLICT	Pending Conflict Resolution	FARR_D_CONTRACT	CHAR	1	0
PRICE_ADJUSTED	Price Adjustment Occurred on the Contract	FARR_D_CONTRACT	CHAR	1	0
RECEIVABLE_ACCOUNT	Receivables Account	FARR_D_CONTRACT	CHAR	10	0
RECEI_ADJ_ACCOUNT	Receivable Adjustment Account	FARR_D_CONTRACT	CHAR	10	0
REFUND_LIABILITY_ACCT	Refund Liability Account	FARR_D_CONTRACT	CHAR	10	0
SALES_ORG	Sales Organization (for Example, Compatible with SD or CRM)	FARR_D_CONTRACT	CHAR	20	0
SOFT_DELETED	Soft Deleted	FARR_D_CONTRACT	CHAR	1	0
STATUS	Contract Status	FARR_D_CONTRACT	CHAR	1	0
TRX_PRICE	Transaction Price	FARR_D_CONTRACT	CURR	25	2
TRX_PRICE_CURK	Currency Key	FARR_D_CONTRACT	CURR	25	2
VALIDATE_RESULT	Validation Result	FARR_D_CONTRACT	CHAR	1	0

[former_member191571]

The extractor is based on FARR_D_CONTRACT table and Contract ID is the primary key in that table.

[former_member200518]

Thanks a ton for ur time Prasad, if u find time can u share the list of master data objects created by you for RAR and also for each object attributes if any ??

[sander_vanwilligen]

Hi,

I suggest to try it. I don't see a reason why it would not be possible.

Please be aware of a possible "safety time interval", e.g. data created the last hour won't be extracted.

Best regards,

Sander

[jason_shao]

Dear PS,

I guess you have reported the incident in a wrong community and this should be why no respone from CO area expert. You may report in in BW relevant community in case you still have the same problem.

Best regards,

Jason