SAP ABAP Table /CRMBW/OLTP_EXT_LEAD (Extract Structure for OLTP Lead Reporting)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-ANA (Application Component) CRM Analytics
⤷ /CRMBW/OP_REPORTING (Package) Operational Reporting with local NetWeaver BI
⤷ CRM-ANA (Application Component) CRM Analytics
⤷ /CRMBW/OP_REPORTING (Package) Operational Reporting with local NetWeaver BI
Basic Data
Table Category | INTTAB | Structure |
Structure | /CRMBW/OLTP_EXT_LEAD | Table Relationship Diagram |
Short Description | Extract Structure for OLTP Lead Reporting |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | OBJECT_KEY | CRMT_BSP_OBJECTKEY | CHAR | 100 | 0 | Object Key | |||
2 | GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
3 | .INCLUDE | 0 | 0 | Extract Structure for OLTP Lead Internal (ObjLayer) Fields | |||||
4 | OBJECT_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
5 | PROCESS_TYPE | CRMT_PROCESS_TYPE | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
6 | SALES_ORG_RESP | CRMT_SALES_ORG_RESP | HROBJEC_14 | CHAR | 14 | 0 | Organizational Unit (Sales) | ||
7 | IMPORTANCE | CRMT_IMPORTANCE | CRM_IMPORTANCE | CHAR | 1 | 0 | Opportunity/Lead Priority | * | |
8 | LEAD_TYPE | CRMT_LEAD_TYPE | CRM_LEAD_TYPE | CHAR | 4 | 0 | Lead Group | * | |
9 | SOURCE | CRMT_SOURCE | CRM_SOURCE | CHAR | 3 | 0 | Origin of Opportunity/Lead | * | |
10 | DATE_START | CRMT_LEAD_DATE_START | DATUM | DATS | 8 | 0 | Start of Business Transaction Lead | ||
11 | DATE_END | CRMT_LEAD_DATE_END_EXPECTED | DATUM | DATS | 8 | 0 | Expected End Date of Business Transaction Lead | ||
12 | QUAL_LEVEL_MAN | CRMT_LEAD_QUAL_LEVEL_MAN | CRM_LEAD_QUAL_LEVEL | CHAR | 2 | 0 | Lead Qualification Level | * | |
13 | PERSON_RESP | CRMT_PERSON_RESP | BU_PARTNER | CHAR | 10 | 0 | Employee Responsible | * | |
14 | PROSPECT | CRMT_PROSPECT | BU_PARTNER | CHAR | 10 | 0 | Prospect | * | |
15 | SALES_ORG | CRMT_SALES_ORG | HROBJEC_14 | CHAR | 14 | 0 | Sales Organization ID | ||
16 | SALES_OFFICE | CRMT_SALES_OFFICE | HROBJEC_14 | CHAR | 14 | 0 | Sales Office | ||
17 | SALES_GROUP | CRMT_SALES_GROUP | HROBJEC_14 | CHAR | 14 | 0 | Sales Group | ||
18 | STAT_OPEN | CRMT_STATUS_OPEN | CRM_BOOLEAN | CHAR | 1 | 0 | Transaction is Still Open | ||
19 | STATUS | CRM_J_STATUS | CRM_J_STATUS | CHAR | 5 | 0 | Object Status | ||
20 | USER_STAT_PROC | CRM_J_STSMA | CRM_J_STSMA | CHAR | 8 | 0 | Status Profile | * | |
21 | PATH_ID | CRMT_TERRITORY_PATH_ID | CRM_TERRITORY_PATH_ID | CHAR | 30 | 0 | Territory Hierarchy ID | ||
22 | TERR_ID | CRMT_TERRITORY_ID | CRM_TERRITORY_ID | CHAR | 30 | 0 | Territory ID | ||
23 | SLSO_SUCCES_LEAD | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
24 | OPP_SUCCES_LEAD | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
25 | .INCLUDE | 0 | 0 | EEW Include | |||||
26 | EEW_R_LEAD_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
27 | .INCLUDE | 0 | 0 | ||||||
28 | .INCLUDE | 0 | 0 | ADVS Selection fields for Local BI Reporting | |||||
29 | USERNAME | USERNAME | USERNAME | CHAR | 12 | 0 | User name | ||
30 | SELECTION_ID | NUMC4 | NUMC4 | NUMC | 4 | 0 | Count parameters | ||
31 | LOG_SYSTEM | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | * | |
32 | APP_SERVER | SYHOST | HOST_ID | CHAR | 32 | 0 | Application Server | ||
33 | STATUS_COMMON | CRMT_STATUS_COMMON | CHAR | 13 | 0 | General Status (User, System, Area) | |||
34 | CAMPAIGN_ID | CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
35 | CAMPAIGN_NAME | CRMT_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Description | ||
36 | NUM_OF_HEAD | CRMT_NUMBER_OF_H | INT4 | INT4 | 10 | 0 | Order Header Number |
History
Last changed by/on | SAP | 20140802 |
SAP Release Created in | 520 |