BI Data Extraction

SAP ERP delivers Data Sources for the open and cleared Items for Public Sector Collections and Disbursements ( PSCD ) and Accounts Payable and Accounts Receivable (AP/AR).

For Grantor Management (GM- GTR ) the extractor structures of the Data Sources are enhanced by the following fields:

Field name	Description
AGREEMENT_ID	CRM Agreement ID
CLAIM_ID	CRM Claim ID
BRI_GUID	CRM BRI item GUID
PROGRAM_GUID	CRM Program GUID

These fields are filled during the extraction of the open and cleared items.

PSCD (Full Upload):

Data Source	Description
0 PSCD _OP_01	PSCD Open Items for Key Date
0 PSCD _CI_01	PSCD Cleared Items

All additional fields are delivered active (property =” “).

PSCD (Delta Upload):

Data Source	Description
0FC_BP_ITEMS	FI-CA Business Partner Items

All additional fields are delivered active (property = “ “).

AP/AR :

Data Source	Description
0FI_AP_3	Vendors: Line Items
0FI_AP_4	Vendors: Line Items with Delta Extraction
0FI_AR_3	Customers: Line Items
0FI_AR_4	Customers: Line Items with Delta Extraction
0FI_GL_4	General Ledger: Line Items with Delta Extraction

All additional fields are delivered inactive (property = “4”) and must be activated using transaction RSA8 (DataSource Repository).

For more information on BI content in GM- GTR , see the relevant documentation.