CRM Tracking of Document Processing Lifecycles 
DataSource Transactional Data: 0CRM_TSS_DTRACK
This DataSource is used to extract the records. The data in these records are used to analyze the processing lifecycle of CRM business documents.
Technical Data
Application Component | 0CRM_SERVICEComponent ID |
|---|---|
Available as of Release | CRM 5.0 |
Shipment | NW 2004s |
Content Versions | BI Content Add-On 2 |
RemoteCube-Capable | No |
Delta-Capable | No |
Extraction from Archives | No |
Verifiable | No |
Prerequisites
You have performed the required Customizing settings using the following business transaction:
Integration with Other mySAP Components
—> Data
Transfer to the SAP Business Information Warehouse
—> Settings
for Application-Specific DataSources (CRM)
—> Settings
for Extracting CRM Objects
—> Define Extraction
to Track the Document Processing Lifecycle
Data Modeling
Delta Update
This DataSource is delta-enabled, using the delta method AIED (after images with delete indicator) in combination with a generic delta that is based on the timestamp REC_UPDATED.
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
|
Client |
|
|
|
GUID for a Transaction |
|
|
|
GUID for a Transaction |
|
|
|
Creation date |
|
|
|
Creation date |
|
|
|
Duration |
|
|
|
Unit for Duration of Work |
|
|
|
Creation date |
|
|
|
BW Delta Process: Update Mode |
|
|
|
General Header Data - Structure of External Fields |
|
|
|
Transaction Number |
|
|
|
Business Transaction Type |
|
|
|
Posting Date for a Business Transaction |
|
|
|
Transaction Description |
|
|
|
Language Key of Description |
|
|
|
Logical System |
|
|
|
SAP R/3 Release |
|
|
|
Scenario Identity |
|
|
|
Template Type of CRM Transaction |
|
|
|
Time and User of Last Transaction Processing |
|
|
|
Transaction was Created at this Time |
|
|
|
User that Created the Transaction |
|
|
|
Time of Last Change to the Transaction |
|
|
|
Transaction Last Changed By |
|
|
|
Time of Last Change to the Transaction |
|
|
|
EEW Extension |
|
|
|
Dummy function in length 1 |
|
|
|
- |
|
|
|
General Header Data - Structure of System Fields |
|
|
|
Business Trans. Cat. |
|
|
|
Indicator Whether the Business Transaction Can Be Archived |
|
|
|
Transaction Description (Upper Case) |
|
|
|
Indicator Whether Business Transaction Number is Correct |
|
|
|
Time Period of Last Archiving Attempt |
|
|
|
Time of Last Change in CRM Online |
|
|
|
Item Number in Document |
|
|
|
External Item Number |
|
|
|
PARTNER (General) Data for BW DataSoures |
|
|
|
Employee |
|
|
|
Employee Responsible |
|
|
|
Customer Contact Person |
|
|
|
Sales Partners |
|
|
|
PARTNER (Sales) Data for BW DataSources |
|
|
|
Sold-To Party |
|
|
|
Ship-To Party |
|
|
|
Bill-To Party |
|
|
|
Payer |
|
|
|
Salesperson ID |
|
|
|
PARTNER (Call Center) Data for BW Datasoures |
|
|
|
Executing Interaction Center |
|
|
|
Service Partner for BW Extraction |
|
|
|
Service Team |
|
|
|
Executing Service Employee |
|
|
|
ORGMAN Data for BW DataSources |
|
|
|
Object ID |
|
|
|
Object ID |
|
|
|
Object ID |
|
|
|
Object ID |
|
|
|
Distribution Channel |
|
|
|
Division |
|
|
|
Object ID |
|
|
|
Object ID |
|
|
|
Object ID |
|
|
|
Object ID |
|
|
|
Object ID |
|
|
|
STATUS GROUPS Data for BW Datasources |
|
|
|
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 |
|
|
Extractor Logic
Archive-enabled object: CRM_DURATR
Records with the system status Completed are not updated to the base table of the DataSource CRMD_TSS_DTRACK