Opportunity Header
Technical Name: 0CRM_OPPT_H
Technical Data
DataSource Type |
Transactional Data |
Application Components |
Customer Relationship Management - Opportunity Management (CRM-BTX-OPP) |
Available as from OLTP Release |
CRM 2.0C |
Available as from PlugIn Release |
N/A |
RemoteCube-Capable |
Use
This DataSource contains the fields necessary for extracting information from the CRM opportunity header to the equivalent BW InfoSource ( CRM Opportunities Header Data ).
Delta Update
You can run an initial, complete, and delta upload for this DataSource.
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 |
ACTIVITY_PARTNER |
Activity partner |
PARTNER |
PARTNER_NO |
ACT_CATEGORY |
Activity category |
ORDERADM_H |
PROCESS_TYPE |
ACT_DIRECTION |
Activity direction |
ACTIVITY_H |
DIRECTION |
ACT_REASON_CAT |
Activity reason (catalog) |
SRV_SUBJECT |
KATALOGART |
ACT_REASON_CODE |
Activity reason (code) |
SRV_SUBJECT |
CODE |
ACT_REASON_GROUP |
Activity reason (code group) |
SRV_SUBJECT |
CODEGRUPPE |
BUDGET_BP |
Business partner's budget |
OPPORT_H |
BUDGET_BP |
BWSTONESYS0 |
BW Status |
STATUS |
STATUS |
BWSTONESYS4 |
BW Status |
STATUS |
STATUS |
BWSTTECSYS2 |
BW Status |
STATUS |
STATUS |
CALDAY |
Calendar day |
ORDERADM_H |
CREATED_AT |
CHANGED_AT |
Time of last change to opportunity |
ORDERADM_H |
CHANGED_AT |
CHANGED_BY |
Person who made last change to opportunity |
ORDERADM_H |
CHANGED_BY |
CODE |
Code |
SRV_SUBJECT |
CODE |
CODEGRUPPE |
Code group |
SRV_SUBJECT |
CODEGRUPPE |
COMPETITOR |
Competitor |
PARTNER |
PARTNER_NO |
CONTACT_PERSON |
Contact person |
PARTNER |
PARTNER_NO |
CONTROL_PHASE |
Current sales cycle phase |
OPPORT_H |
CURR_PHASE |
CONTROL_PHASE |
Analysis phase |
OPPORT_H |
SALESCYCLE |
CREATED_AT |
Date on which opportunity was created |
ORDERADM_H |
CREATED_AT |
CREATED_BY |
Person by whom opportunity was created |
ORDERADM_H |
CREATED_BY |
CURRENCY |
Currency |
PRICING |
CURRENCY |
CURR_PHASE |
Current sales cycle phase |
OPPORT_H |
CURR_PHASE |
DESCRIPTION_UC |
Description |
ORDERADM_H |
DESCRIPTION_UC |
DIS_CHANNEL |
Distribution channel |
ORGMAN |
DIS_CHANNEL |
DIVISION |
Division |
ORGMAN |
DIVISION |
DURATION |
Duration of opportunity |
OPPORT_H |
EXPECT_END |
DURATION |
OPPORT_H |
PHASE_SINCE |
|
DURATION |
STATUS |
STATUS |
|
EXCHG_DATE |
Exchange rate date |
PRICING |
EXCHG_DATE |
EXCHG_RATE |
Exchange rate |
PRICING |
EXCHG_RATE |
EXCHG_TYPE |
Exchange rate type |
PRICING |
EXCHG_TYPE |
EXECUTING_CC |
Executing interaction center |
PARTNER |
PARTNER_NO |
EXPECT_END |
Expected end date of opportunity |
OPPORT_H |
EXPECT_END |
EXP_REVENUE |
Expected revenue |
OPPORT_H |
EXP_REVENUE |
FORECAST_REL |
Forecast-relevant (indicates whether opportunity values should be included in any forecasts) |
OPPORT_H |
FORECAST_REL |
GUID |
Opportunity GUID |
ORDERADM_H |
ORDERADM_H_GUID |
IMPORTANCE |
Importance of opportunity |
OPPORT_H |
IMPORTANCE |
KATALOGART |
Catalog type |
SRV_SUBJECT |
KATALOGART |
LEAD_CREATED_AT |
Date on which lead was created |
ORDERADM_H |
CREATED_AT |
LOGICAL_SYSTEM |
Logical system |
ORDERADM_H |
LOGICAL_SYSTEM |
LOGSYS_PRED |
Logical system of preceding document(s) |
DOC_FLOW |
LOGSYS_A |
MKT_ELEMENT |
Marketing plan element |
DOC_FLOW |
OBJKEY_A |
MKT_ELEMENT |
ORDERADM_H |
ORDERADM_H_GUID |
|
OBJECT_ID |
Object ID |
ORDERADM_H |
OBJECT_ID |
OBJECT_TYPE |
Object type |
ORDERADM_H |
OBJECT_TYPE |
OPPT_CREATED_AT |
Date on which opportunity was created |
ORDERADM_H |
CREATED_AT |
PERSON_RESP |
Person responsible |
PARTNER |
PARTNER_NO |
PHASE_SINCE |
Start date of phase |
OPPORT_H |
PHASE_SINCE |
POSTING_DATE |
Posting date |
ORDERADM_H |
POSTING_DATE |
PREDEC_OBJKEY |
Object key of preceding document |
DOC_FLOW |
OBJKEY_A |
PREDEC_OBJTYPE |
Object type of preceding document |
DOC_FLOW |
OBJTYPE_A |
PRED_ACT_GUID |
Preceding activity GUID |
DOC_FLOW |
OBJKEY_A |
PRED_LEAD_GUID |
Preceding lead GUID |
DOC_FLOW |
OBJKEY_A |
PRED_OPPT_GUID |
Preceding opportunity GUID |
DOC_FLOW |
OBJKEY_A |
PRICE_DATE |
Pricing date |
PRICING |
PRICE_DATE |
PROBABILITY |
Probability that opportunity will end in a sale (calculated by employee) |
OPPORT_H |
PROBABILITY |
PROCESS_CATALOG |
Catalog |
SRV_SUBJECT |
KATALOGART |
PROCESS_CATEGORY |
Activity category (communication type) |
ACTIVITY_H |
CATEGORY |
PROCESS_CODE |
Code |
SRV_SUBJECT |
CODE |
PROCESS_CODEGR |
Code group |
SRV_SUBJECT |
CODEGRUPPE |
PROCESS_OBJTYPE |
Object type of preceding document |
DOC_FLOW |
OBJTYPE_A |
PROCESS_TYPE |
Business transaction type |
ORDERADM_H |
PROCESS_TYPE |
PROSPECT |
Prospect |
PARTNER |
PARTNER_NO |
QUOTATION_GUID |
Quotation GUID |
DOC_FLOW |
OBJKEY_A |
QUOT_VALID_FROM |
Quotation valid-from date |
APPOINTMENT |
TIMESTAMP_FROM |
RECORDMODE |
BW delta procedure: update mode |
ORDERADM_H |
TASK |
REF_CURRENCY |
Reference currency |
PRICING |
REF_CURRENCY |
SALESCYCLE |
Sales cycle |
OPPORT_H |
SALESCYCLE |
SALESPARTNER |
Sales partner |
PARTNER |
PARTNER_NO |
SALES_EMPLOYEE |
Sales employee |
PARTNER |
PARTNER_NO |
SALES_GROUP |
Sales group |
ORGMAN |
SALES_GROUP |
SALES_EMPLOYEE |
Sales employee |
PARTNER |
PARTNER_NO |
SALES_GROUP |
Sales group |
ORGMAN |
SALES_GROUP |
SALES_OFFICE |
Sales office |
ORGMAN |
SALES_OFFICE |
SALES_ORG |
Sales organization |
ORGMAN |
SALES_ORG |
SALES_ORG_RESP |
Responsible sales organization |
ORGMAN |
SALES_ORG_RESP |
SERVICE_ORG_RESP |
Responsible service organization |
ORGMAN |
SERVICE_ORG_RESP |
SOURCE |
Source |
OPPORT_H |
SOURCE |
STARTDATE |
Start date |
OPPORT_H |
STARTDATE |
STATUS_OPPT |
Opportunity status |
STATUS |
STATUS |
STATUS_SINCE |
Status since |
OPPORT_H |
STATUS_SINCE |
SYS_PROBABILITY |
Probability that opportunity will end in sale (calculated by system) |
OPPORT_H |
SYS_PROBABILITY |
TYPE |
Type |
OPPORT_H |
TYPE |