Revenue Analysis by Posting Item

DataSource Transactional Data: 0FARR_RA_10

This DataSource extracts posted items from the posting table. Each amount is specific to a posting category.

Direct Access: Supported (without preaggregation)

Real-time Enabled: No

Released for Data Services: No

Technical Data

Application Component	0FARR
Available as of Release	ERP 605
Shipment	SAP Revenue Accounting and Reporting 1.0
Content Versions	RA100
RemoteCube-Capable	Yes
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

Delta Update

This DataSource supports delta processing. The timestamp field from database table FARR_D_POSTING is for delta calculation.

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
GJAHR	Fiscal Year
POPER	Posting period
FISCVAR	Fiscal year variant
COMPANY_CODE	Company Code	FARR_D_POSTING	COMPANY_CODE
ACCT_PRINCIPLE	Accounting Principle	FARR_D_POSTING	ACCT_PRINCIPLE
RECON_KEY	Reconciliation Key	FARR_D_POSTING	RECON_KEY
CONTRACT_ID	Revenue Recognition Contract ID	FARR_D_POSTING	CONTRACT_ID
POB_ID	Performance Obligation ID	FARR_D_POSTING	POB_ID
CONDITION_TYPE	Condition type	FARR_D_POSTING	CONDITION_TYPE
POST_CAT	Category for Posting Document	FARR_D_POSTING	POST_CAT
HKONT	G/L Account Number	FARR_D_POSTING	HKONT
GUID	Replacement of FARR_POSTING_GUID with Char16 in BW	FARR_D_POSTING	GUID
SHKZG	Debit/Credit Indicator	FARR_D_POSTING	SHKZG
BETRW	Amount in Transaction Currency	FARR_D_POSTING	BETRW
WAERS	Currency Key	FARR_D_POSTING	WAERS
BETRH	Amount in Local Currency	FARR_D_POSTING	BETRH
HWAER	Local Currency	FARR_D_POSTING	HWAER
BETR2	Amount in Second Parallel Local Currency	FARR_D_POSTING	BETR2
HWAE2	Currency Key of Second Local Currency	FARR_D_POSTING	HWAE2
BETR3	Amount in Third Parallel Local Currency	FARR_D_POSTING	BETR3
HWAE3	Currency Key of Third Local Currency	FARR_D_POSTING	HWAE3
STATISTIC	Condition is used for statistics	FARR_D_POSTING	STATISTIC
POB_TYPE	Performance Obligation Type	FARR_D_POSTING	POB_TYPE
SPEC_INDICATOR	Deferral Item Special Indicator	FARR_D_POSTING	SPEC_INDICATOR
.INCLUDE
PAOBJNR	Profitability Segment Number (CO-PA)	FARR_D_POSTING	PAOBJNR
FKBER	Functional Area	FARR_D_POSTING	FKBER
GSBER	Business Area	FARR_D_POSTING	GSBER
SEGMENT	Segment for Segmental Reporting	FARR_D_POSTING	SEGMENT
PRCTR	Profit Center	FARR_D_POSTING	PRCTR
KOKRS	Controlling Area		KOKRS
TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	FARR_D_POSTING	TIMESTAMP

Extractor Logic

The basis of extraction is the FARR_D_POSTING table.
The time (change/create) of the transaction data record is set in the TIMESTAMP field in the extractor.
This DataSource provides information about object numbers in Revenue Accounting, which is used for maintaining time-dependent relationships of contracts and performance obligations.
Posted values are categorized by posting category.
CL: Contract Liability

CA: Contract Asset

RA: Receivable Adjustment

RV: Revenue

CC: Cost Correction

DR: Deferred Revenue

UR: Unbilled Receivable

IC: Invoice Correction

CO: Cost

CJ: Cost Adjustment

ED: Exchange Rate Diff.