Financial Services Quotations and Contracts 
DataSource Transactional Data: 0CRM_FS_QUOT_CNTR_I
This DataSource contains the fields required to extract all the relevant data for FS quotations and contracts from the CRM system.
Note
To use this DataSource, you have to activate the business function Reporting Extractors for Contingent Liabilities
(CRM_FS_REPT_1
).
Technical Data
Application Component | Financial Services (0CRM_FS) |
|---|---|
Available as of Release | SAP enhancement package 1 for SAP CRM 7.0 |
Shipment | SAP NetWeaver 7.0 BI Content Add-On 5 |
Content Versions | There are no content versions. |
RemoteCube-Capable | No |
Delta-Capable | Yes |
Extraction from Archives | No |
Verifiable | No |
Data Modeling
Delta Update
This DataSource is delta compatible. Delta process: AIMD, After Images with Deletion Indicators Using Delta Queue (such as BtB)
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
| Base Unit of Measure of Product |
|
|
| Contract Start Date |
|
|
| Business Partner (CRM): Billing Block Reason |
|
|
| Billing Date |
|
|
| Bill-to Party |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| BW Status |
|
|
| Category ID |
|
|
| Calendar Day |
|
|
| Time of Last Change to the Transaction |
|
|
| Transaction Last Changed By |
|
|
| Change Process |
|
|
| Customer Contact Person |
|
|
| Transaction Was Created at this Time |
|
|
| User that Created the Transaction |
|
|
| Currency |
|
|
| Business Partner Type |
|
|
| Customer Group |
|
|
| Customer Group 1 |
|
|
| Distribution Channel |
|
|
| Division |
|
|
| Contract End Date |
|
|
| Exchange Rate Date |
|
|
| Exchange Rate |
|
|
| Exchange Rate Type |
|
|
| Gross Order Value in PO Currency |
|
|
| Total Gross Value of Document in Document Currency |
|
|
| GUID for a Transaction |
|
|
| Billed Quantity for an Item |
|
|
| Billed Value of an Item |
|
|
| Time of Last Change to the Transaction |
|
|
| Transaction Last Changed By |
|
|
| Transaction Was Created at this Time |
|
|
| User that Created the Transaction |
|
|
| GUID for a Transaction |
|
|
| CRM Item Object Type |
|
|
| Item Category |
|
|
| Item Category Usage |
|
|
| Logical System |
|
|
| Logical System |
|
|
| Distribution CRM -> R/3: Material |
|
|
| Net Price |
|
|
| Net Value |
|
|
| Total Net Value of Document in Document Currency |
|
|
| Item Number in Document |
|
|
| Order Item Number |
|
|
| Order Header Number |
|
|
| Transaction ID |
|
|
| Business Transaction Category |
|
|
| Counter: Document Cat. Appears at Least Once in Document |
|
|
| CRM: Order Quantity |
|
|
| CRM: Order Quantity |
|
|
| GUID for a Transaction |
|
|
| Product Number of Business Partner |
|
|
| Payer |
|
|
| Employee Responsible |
|
|
| Posting Date for a Business Transaction |
|
|
| Item Number in Document |
|
|
| Transaction ID |
|
|
| Product Group 1 |
|
|
| Product Group 2 |
|
|
| Product Group 3 |
|
|
| Product Group 4 |
|
|
| Product Group 5 |
|
|
| GUID for a Transaction |
|
|
| Object Type of a Preceding Document |
|
|
| Pricing Date |
|
|
| Object Type of a Preceding Document |
|
|
| Unit of Measure in Which the Product Is Sold |
|
|
| Business Transaction Type |
|
|
| GUID for Product CHAR32 |
|
|
| Product ID |
|
|
| Product Group |
|
|
| GUID for a Transaction |
|
|
| BW Delta Process: Record Mode |
|
|
| Reference Currency |
|
|
| Flag: Ref. Update (Extract Structure Only Partially Filled) |
|
|
| Cancellation Reason Code |
|
|
| Reason for Rejection |
|
|
| Employee |
|
|
| Object ID |
|
|
| Object ID |
|
|
| Object ID |
|
|
| Object ID |
|
|
| Sales Partners |
|
|
| Scenario Identity |
|
|
| Object ID |
|
|
| Object ID |
|
|
| Ship-to Party |
|
|
| Product Description in Uppercase for BW |
|
|
| Sold-To Party |
|
|
| Subtotal 1 from Pricing Procedure for Condition |
|
|
| Subtotal 2 from Pricing Procedure for Condition |
|
|
| Subtotal 3 from Pricing Procedure for Condition |
|
|
| Subtotal 4 from Pricing Procedure for Condition |
|
|
| Subtotal 5 from Pricing Procedure for Condition |
|
|
| Subtotal 6 from Pricing Procedure for Condition |
|
|
| Tax Amount in Document Currency |
|
|
| Quotation: Valid From Date |
|
|
| Quotation: Valid To Date |
|
|