SAP ABAP Table CRMT_REPORT_LOCATORLIST (Reporting Structure for Locator)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     CRM_REPORT (Package) Operative Reporting in CRM
Basic Data
Table Category INTTAB    Structure 
Structure CRMT_REPORT_LOCATORLIST   Table Relationship Diagram
Short Description Reporting Structure for Locator    
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 GUID CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
2 CLIENT MANDT MANDT CLNT 3   0   Client *
3 .INCLUDE       0   0   General Output Fields for CRM_Transaction  
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 TEMPLATE_TYPE CRMT_TEMPLATE_TYPE CRM_TEMPLATE_TYPE CHAR 1   0   CRM Transaction: Template Type  
7 DESCRIPTION CRMT_PROCESS_DESCRIPTION CRM_PROCESS_DESCRIPTION CHAR 40   0   Transaction Description  
8 DESCR_LANGUAGE CRMT_PROCESS_DESCRIPTION_LANGU SPRAS LANG 1   0   Language Key of Description *
9 LOGICAL_SYSTEM CRMT_LOGSYS LOGSYS CHAR 10   0   Logical System *
10 POSTING_DATE CRMT_POSTING_DATE   DATS 8   0   Posting Date for a Business Transaction  
11 CHANGED_AT CRMT_CHANGED_AT_USR CRM_TSTMP DEC 15   0   Changed On (Output in User Time Zone)  
12 CHANGED_BY CRMT_CHANGED_BY UNAME CHAR 12   0   Transaction Last Changed By  
13 CREATED_AT CRMT_CREATED_AT_USR CRM_TSTMP DEC 15   0   Created On (Output in User Time Zone)  
14 HEAD_CHANGED_AT CRMT_CHANGED_AT BCOS_TSTMP DEC 15   0   Time of Last Change to the Transaction  
15 CHANGED_AT_DATE CRMT_CHANGED_AT_DATE SYDATS DATS 8   0   Date on Which Transaction Was Last Changed  
16 CREATED_AT_DATE CRMT_CREATED_AT_DATE SYDATS DATS 8   0   Transaction Was Created on This Date  
17 CONCATSTAT J_STEXT TEXT40 CHAR 40   0   System status line  
18 CONCATSTATUSER CRMT_REPORT_USERSTATUS TEXT40 CHAR 40   0   User Status  
19 PROCESS_TYPE_TXT CRMT_REPORT_PROCESS_TYPE_TXT DDTEXT CHAR 60   0   Text Description for Transaction Category  
20 CREATED_BY CRMT_CREATED_BY UNAME CHAR 12   0   User that Created the Transaction  
21 KURZTEXT QKTEXTGRCD QKURZTEXT80 CHAR 80   0   Code Group Short Text  
22 ACT_TEXT QKTEXTGRCD QKURZTEXT80 CHAR 80   0   Code Group Short Text  
23 NET_VALUE_MAN CRMT_NET_VALUE_MAN WERTV8 CURR 15   2   Total Expected Net Value Products in Document Currency  
24 GROSS_VALUE_H CRMT_GROSS_VALUE_CUM WERTV8 CURR 15   2   Total Gross Value of Document in Document Currency  
25 .INCLUDE       0   0   PARTNER (General) Data for BW DataSoures  
26 SALES_EMPLOYEE CRMT_SALES_EMPLOYEE BU_PARTNER CHAR 10   0   Employee *
27 PERSON_RESP CRMT_PERSON_RESP BU_PARTNER CHAR 10   0   Employee Responsible *
28 CONTACT_PERSON CRMT_CONTACT_PERSON BU_PARTNER CHAR 10   0   Customer Contact Person *
29 SALESPARTNER CRMT_SALESPARTNER BU_PARTNER CHAR 10   0   Sales Partners *
30 RESP_GROUP_RFW CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
31 PLANNING_ACCOUNT CRMT_PLANNING_ACCOUNT BU_PARTNER CHAR 10   0   Planning Account *
32 CLAIMING_ACCOUNT CMST_CLAIMING_ACCOUNT BU_PARTNER CHAR 10   0   Claiming Account *
33 INVOIC_RECIPIENT CRMT_INVOICE_RECIPIENT BU_PARTNER CHAR 10   0   Invoice Recipient *
34 SALES_EMPLOYEE_LIST CRMT_SALES_EMPLOYEE_LIST TEXT80 CHAR 80   0   Sales Representative  
35 PERSON_RESP_LIST CRMT_PERSON_RESP_LIST TEXT80 CHAR 80   0   Employee Responsible  
36 PERSON_RESP_NAME CRMT_PERSON_RESP_NAME BU_TEXT50 CHAR 50   0   Employee Responsible - Name (Name Only Without Address)  
37 CONTACT_PERSON_LIST CRMT_CONTACT_PERSON_LIST TEXT80 CHAR 80   0   Contact Person  
38 OBJECT_TYPE_TXT SAEOBJTEXT SADC40 CHAR 40   0   Object text for language-dependent table  
39 FROM CRMT_DATES_START_DATE DATUM DATS 8   0   Start Date  
40 TO CRMT_DATES_END_DATE DATS DATS 8   0   End Date  
41 FROM_TIME CRMT_BSP_TIME_HHMM_FROM CRM_BSP_TIME_HHMM TIMS 6   0   From  
42 TO_TIME CRMT_BSP_TIME_HHMM_TO CRM_BSP_TIME_HHMM TIMS 6   0   To  
43 OBJECT_TYPE SWO_OBJTYP OJ_NAME CHAR 10   0   Object Type *
44 VALID_FROM CRMT_DATES_START_DATE DATUM DATS 8   0   Start Date  
45 VALID_TO CRMT_DATES_END_DATE DATS DATS 8   0   End Date  
46 VALID_FROM_TIME CRMT_BSP_TIME_HHMM_FROM CRM_BSP_TIME_HHMM TIMS 6   0   From  
47 VALID_TO_TIME CRMT_BSP_TIME_HHMM_TO CRM_BSP_TIME_HHMM TIMS 6   0   To  
48 DATE_1 CRMT_VALID_FROM BCOS_TSTMP DEC 15   0   Time Dependency: Validity Start Date  
49 DATE_2 CRMT_VALID_TO BCOS_TSTMP DEC 15   0   Time Dependency: Validity End Date  
50 DATE_3 CRMT_CONTACT_FROM BCOS_TSTMP DEC 15   0   Time Stamp: Start of Customer Contact  
51 DATE_4 CRMT_CONTACT_TO BCOS_TSTMP DEC 15   0   Time Stamp: End of Customer Contact  
52 STATUS CRM_J_STATUS CRM_J_STATUS CHAR 5   0   Object Status  
53 STATUS_SYSTEM CRM_J_STATUS CRM_J_STATUS CHAR 5   0   Object Status  
54 USER_STAT_PROC CRM_J_STSMA CRM_J_STSMA CHAR 8   0   Status Profile *
55 PROCESS J_VORGANG J_VORGANG CHAR 4   0   Business Transaction *
56 KIND CRMT_OBJECT_KIND CRM_OBJECTKIND CHAR 1   0   Object Type  
57 TXT04 J_TXT04 TEXT4 CHAR 4   0   Individual status of an object (short form)  
58 TXT30 J_TXT30 TEXT30 CHAR 30   0   Object status  
59 COMPETITOR_LIST CRMT_COMPETITOR_LIST TEXT80 CHAR 80   0   Competitor  
60 PROSPECT_NAME CRMT_PROSPECT_NAME BU_TEXT50 CHAR 50   0   Prospect - Name (Name Only, Without Address)  
61 PROSPECT_LIST CRMT_PROSPECT_LIST TEXT80 CHAR 80   0   Sales Prospect  
62 SALESPARTNER_LIST CRMT_SALESPARTNER_LIST TEXT80 CHAR 80   0   Sales Partner  
63 ACTIVITY_PARTNER_LIST CRMT_ACTIVITY_PARTNER_LIST TEXT80 CHAR 80   0   Activity Partner  
64 SOLD_TO_PARTY_NAME CRMT_SOLD_TO_PARTY_NAME BU_TEXT50 CHAR 50   0   Sold-To Party Name (Name Only, Without Address)  
65 SOLD_TO_PARTY_LIST CRMT_SOLD_TO_PART_LIST TEXT80 CHAR 80   0   Sold-To Party  
66 SHIP_TO_PARTY_LIST CRMT_SHIP_TO_PART_LIST TEXT80 CHAR 80   0   Ship-To Party: Name  
67 BILL_TO_PARTY_LIST CRMT_BILL_TO_PART_LIST TEXT80 CHAR 80   0   Bill-To Party: Name  
68 PAYER_LIST CRMT_RP_PAYER_LIST TEXT80 CHAR 80   0   Payer: Name  
69 SERVICE_TEAM_LIST CRMT_SERVICE_GROUP_LIST TEXT80 CHAR 80   0   Service Employee Group  
70 SERVICE_EMPLOYEE_LIST CRMT_SERVICE_EMPLOYEE_LIST TEXT80 CHAR 80   0   Responsible Service Employee  
71 SERVICE_TEAM CRMT_SERVICE_TEAM BU_PARTNER CHAR 10   0   Service Team *
72 SERVICE_EMPLOYEE CRMT_SERVICE_EMPLOYEE BU_PARTNER CHAR 10   0   Executing Service Employee *
73 RESPONS_AT_PARTNER CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
74 RESP_AT_PARTNER CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
75 CHANNEL_PARTNER CMST_CHANNEL_PARTNER BU_PARTNER CHAR 10   0   Channel Partner *
76 CHANNEL_PARTNER_LIST CMST_CHANNEL_PARTNER_LIST TEXT80 CHAR 80   0   Channel Partner  
77 CORP_CHANNEL_PARTNER CMST_CORPORATE_CHANNEL_PARTNER BU_PARTNER CHAR 10   0   Corporate Channel Partner *
78 RESPONS_AT_PARTNER_LIST CRMT_RESPONS_AT_PARTNER_LIST TEXT80 CHAR 80   0   Person Responsible at Partners - Name (Channel Management)  
79 END_CUSTOMER CRMT_END_CUSTOMER BU_PARTNER CHAR 10   0   End Customer (Channel Management) *
80 END_CUSTOMER_LIST CRMT_END_CUSTOMER_LIST TEXT80 CHAR 80   0   End Customer Name (Channel Management)  
81 PLANNING_ACCOUNT_LIST CRMT_PLANNING_ACCOUNT_LIST TEXT80 CHAR 80   0   Planning Account Text  
82 STAT_QUOT CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
83 STAT_OPEN CRMT_STATUS_OPEN CRM_BOOLEAN CHAR 1   0   Transaction is Still Open  
84 STAT_PLANNED CRMT_STATUS_PLANNED CRM_BOOLEAN CHAR 1   0   Status: Planned  
85 STAT_CREDIT CRMT_STATUS_CRED CRMT_STATUS_CRED CHAR 1   0   Credit Block on Transaction  
86 STAT_RFC_APPROVD CRMT_STATUS_RFC_APPROVED BOOLEAN CHAR 1   0   Request for Change Approved or Awaiting Approval  
87 STAT_RFCWAPPROVD CRMT_STATUS_RFC_APPROVED BOOLEAN CHAR 1   0   Request for Change Approved or Awaiting Approval  
88 STAT_RFC_REJECTD CRMT_STATUS_RFC_REJECTED BOOLEAN CHAR 1   0   Request for Change Rejected  
89 STAT_REJECTED CRMT_STATUS_REJECTED BOOLEAN CHAR 1   0   Status: Rejected  
90 STAT_LOCK CRMT_STATUS_LOCK BOOLEAN CHAR 1   0   Locked  
91 PATH_ID CRMT_TERRITORY_PATH_ID CRM_TERRITORY_PATH_ID CHAR 30   0   Territory Hierarchy ID  
92 TERR_ID CRMT_TERRITORY_ID CRM_TERRITORY_ID CHAR 30   0   Territory ID  
93 TERR_DESCRIP CRMT_TERRITORY_DESCRIPTION TEXT40 CHAR 40   0   Territory Description  
94 PATH_GUID CRMT_TERRITORY_PATH_GUID SYSUUID RAW 16   0   Territory Path GUID  
95 TERR_GUID CRMT_TERRITORY_GUID SYSUUID RAW 16   0   Territory GUID  
96 INPUT_CHANNEL CRMT_INPUT_CHANNEL CRM_INPUT_CHANNEL CHAR 3   0   Input channel  
97 BTX_CLASS CRMT_TRANSACTION_CLASSIFICATN CRM_TRANSACTION_CLASSIFICATION CHAR 1   0   CRM Business Transaction Classification  
98 AUTH_SCOPE CRM_AUTH_SCOPE CRM_AUTH_SCOPE NUMC 6   0   Authorization Scope *
99 DESCRIPTION_UC CRMT_PROCESS_DESCRIPTION_UC CRM_PROCESS_DESCRIPTION_UC CHAR 40   0   Transaction Description (Upper Case)  
100 .INCLUDE       0   0   organizational Data Sales Part 2  
101 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
102 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
103 .INCLUDE       0   0   Organizational Data (Service)  
104 SERVICE_ORG CRMT_SERVICE_ORG HROBJEC_14 CHAR 14   0   Service Organization  
105 SERVICE_ORG_RESP CRMT_SERVICE_ORG_RESP HROBJEC_14 CHAR 14   0   Organizational Unit (Service)  
106 .INCLUDE       0   0   Purchasing Organizational Data  
107 PURCH_ORG CRMT_PURCH_ORG HROBJEC_14 CHAR 14   0   Purchasing Organization  
108 PURCH_GROUP CRMT_PURCH_GROUP HROBJEC_14 CHAR 14   0   Purchasing Group  
109 PURCH_ORG_RESP CRMT_PURCH_ORG_RESP HROBJEC_14 CHAR 14   0   Organizational Unit (Purchasing)  
110 .INCLUDE       0   0   Sales Organization Data Part 1  
111 SALES_ORG CRMT_SALES_ORG HROBJEC_14 CHAR 14   0   Sales Organization ID  
112 SALES_OFFICE CRMT_SALES_OFFICE HROBJEC_14 CHAR 14   0   Sales Office  
113 SALES_GROUP CRMT_SALES_GROUP HROBJEC_14 CHAR 14   0   Sales Group  
114 SALES_ORG_RESP CRMT_SALES_ORG_RESP HROBJEC_14 CHAR 14   0   Organizational Unit (Sales)  
115 HOSTING_ORG CRMT_HOSTING_ORG HROBJEC_14 CHAR 14   0   Hosting Org. Unit  
116 .INCLUDE       0   0   Company code and Logical system for Business Document.  
117 IC_BD_CCODE CRM_IC_BD_CCODE BUKRS CHAR 4   0   Company Code for a Business Transaction *
118 IC_BD_LOGSYS CRM_IC_BD_LOGSYS LOGSYS CHAR 10   0   Logical System for a Business Transaction *
119 .INCLUDE       0   0   Abbreviation Organizational Data Sales  
120 SALES_ORG_SHORT CRMT_SALES_ORG_SHORT TEXT12 CHAR 12   0   Sales Organization: Description of Department  
121 SALES_OFFICE_SHORT CRMT_SALES_OFFICE_SHORT TEXT12 CHAR 12   0   Sales Office Abbreviation  
122 SALES_GROUP_SHORT CRMT_SALES_GROUP_SHORT TEXT12 CHAR 12   0   Sales Group Abbreviation  
123 SALES_ORG_RESP_SHORT CRMT_SALES_ORG_RESP_SHORT TEXT12 CHAR 12   0   Abbreviation: Responsible Organizational Unit (Sales)  
124 .INCLUDE       0   0   Cancellation set: Structure with external fields  
125 CANCPROC CRMT_CANC_PROCEDURE CRM_CANCPROCEDURE CHAR 4   0   Cancellation Procedure  
126 CANCPARTY CRMT_CANC_PARTY CRM_CANC_PARTY CHAR 4   0   Cancelling Party  
127 CANC_REASON CRMT_SRV_CANCEL_REASON QCODE CHAR 4   0   CRM Service : Reason for Cancellation *
128 .INCLUDE       0   0   External Fields for External References  
129 REFERENCE_TYPE CRMT_EXT_REF_TYPE CRM_EXT_REF_TYPE CHAR 4   0   Type of External Reference *
130 REFERENCE_NUMBER CRMT_EXT_REF_NUM TEXT35 CHAR 35   0   External Reference Number  
131 .INCLUDE       0   0   Law Reference Header Segment External Fields  
132 HEADER_GUID CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
133 LAW_ID CRM_ICM_LAW_ID CRM_ICM_LAW_ID CHAR 32   0   Legal Reference ID  
134 LAW_GRP_ID CRM_ICM_LAW_GRPID CRM_ICM_LAW_GRPID CHAR 22   0   Legal Reference Group ID  
135 MAIN_REF CRM_LAWREF_MAIN CRM_BOOLEAN CHAR 1   0   Legal Reference Main Reference Flag  
136 ATTEMPT_FLAG CRM_LAWREF_ATTEMPT CRM_BOOLEAN CHAR 1   0   Legal Reference Attempt Flag  
137 .INCLUDE       0   0   Extensibility Include for ICM Law Reference  
138 LAWREF DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
139 .INCLUDE       0   0   EEW Extension  
140 ORDERADM_H_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
141 .INCLUDE       0   0    
142 .INCLUDE       0   0   Payment Service Provider Data  
143 PAYM_SRV_PROV COM_WEC_PAYMENT_SRV_PROVIDER COM_WEC_PAYMENT_SRV_PROVIDER CHAR 4   0   Payment Service Provider *
144 PAYM_TRANS_GUID COM_WEC_TRANSACTION_GUID COM_WEC_TRANSACTION_GUID RAW 16   0   Payment Transaction Reference GUID  
145 PSP_TRANS_ID COM_WEC_PSP_TRANSACTION_ID COM_WEC_PSP_TRANSACTION_ID CHAR 35   0   ID of the Payment Transaction in the PSP System  
146 PSP_TRANS_AMT COM_WEC_TRANSACTION_AMOUNT WERTV8 CURR 15   2   Payment Transaction Amount  
147 PSP_TRANS_CURR COM_WEC_TRANSACTION_CURRENCY WAERS CUKY 5   0   Payment Transaction Currency *
148 PSP_STATUS_PF COM_WEC_TRANSACTION_PROFILE COM_WEC_TRANSACTION_PROFILE CHAR 4   0   Payment Status Profile *
149 PSP_STATUS COM_WEC_TRANSACTION_STATUS COM_WEC_TRANSACTION_STATUS CHAR 4   0   Payment Transaction Status *
150 .INCLUDE       0   0   Output Fields: Activity for CRM_Transaction  
151 EXTERN_ACT_ID CRMT_EXTERNAL_ACTIVITY_ID CRM_EXTERNAL_ACTIVITY_ID CHAR 20   0   External Business Transaction Number  
152 PRIVATE_FLAG CRMT_PRIVAT CRM_BOOLEAN CHAR 1   0   Indicator: Task is Private  
153 COMPLETION CRMT_COMPLETION CRM_COMPLETION NUMC 3   0   Completion Rate in Percent  
154 ADDRESS_ID CRMT_ADDRESS AD_ADDRNUM CHAR 10   0   Location where Activity takes place *
155 ACT_LOCATION CRMT_ACTIVITY_LCTN CRM_ACTIVITY_LOCATION CHAR 100   0   Location  
156 CLASS CRMT_ACTIVITY_CLASS CRM_ACTIVITY_CLASS CHAR 1   0   Activity Class  
157 CALENDAR CRMT_CALENDAR CRM_BOOLEAN CHAR 1   0   Include Activity in Calendar  
158 CATEGORY_TXT CRMT_REPORT_CATEGORY_TXT DDTEXT CHAR 60   0   Texts for Category  
159 PRIORITY_TXT CRMT_REPORT_PRIORITY_TXT DDTEXT CHAR 60   0   Text Description for Priority  
160 OBJECTIVE_TXT CRMT_REPORT_OBJECTIVE_TXT DDTEXT CHAR 60   0   Text Description for Goal of an Activity  
161 DIRECTION_TXT CRMT_REPORT_DIRECTION_TXT DDTEXT CHAR 60   0   Text Description for Direction  
162 IO_ICON CRMT_IO_ICON ICON CHAR 4   0   Icon for Interaction Object/Contact *
163 FROMDATE CRMT_DATES_START_DATE DATUM DATS 8   0   Start Date  
164 TODATE CRMT_DATES_END_DATE DATS DATS 8   0   End Date  
165 ACT_TOT_DURA TIMEDURA TIMEDURA DEC 13   0   Numerical Value of Duration  
166 ACT_TOT_UNIT TIMEUNITDU TIMEUNITNA CHAR 12   0   Default Value for Time Unit *
167 KATALOGART_ACT COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
168 CODEGRUPPE_ACT QCODEGRP QCODEGRP CHAR 8   0   Code Group *
169 CODE_ACT QCODE QCODE CHAR 4   0   Code *
170 SUBJECT_PROF_ACT CRMT_SUBJECT_PROFILE CRM_SUBJECT_PROFILE CHAR 9   0   Subject Profile *
171 KATALOGART_ACT_ST COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
172 CODEGRUPPE_ACT_ST QCODEGRP QCODEGRP CHAR 8   0   Code Group *
173 CODE_ACT_ST QCODE QCODE CHAR 4   0   Code *
174 SUBJECT_PROF_ACT_ST CRMT_SUBJECT_PROFILE CRM_SUBJECT_PROFILE CHAR 9   0   Subject Profile *
175 SUB_CATGUID_ACT CRM_ERMS_CAT_GUID SYSUUID RAW 16   0   Multilevel Cat. - GUID Data Element  
176 .INCLUDE       0   0   All Keys (<> Texts) in the Output List  
177 CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
178 PRIORITY CRMT_PRIORITY SC_PRIO NUMC 1   0   Activity Priority *
179 OBJECTIVE CRMT_OBJECTIVE CRM_OBJECTIVE CHAR 3   0   Goal of an Activity *
180 DIRECTION CRMT_DIRECTION CRM_DIRECTION CHAR 1   0   Direction of an Activity  
181 TASK CRMT_TASK CRM_BOOLEAN CHAR 1   0   Indicator: Activity is a Task  
182 PARTNER_FCT CRMT_PARTNER_FCT COM_PARTNER_FCT CHAR 8   0   Partner Function CRMC_PARTNER_FCT
183 .INCLUDE       0   0   PARTNER (Opportunity/Activity) Data for BW DataSoures  
184 COMPETITOR CRMT_COMPETITOR BU_PARTNER CHAR 10   0   Competitors *
185 PROSPECT CRMT_PROSPECT BU_PARTNER CHAR 10   0   Prospect *
186 ACTIVITY_PARTNER CRMT_ACTIVITY_PARTNER BU_PARTNER CHAR 10   0   Activity Partner *
187 .INCLUDE       0   0   Output Fields: Opportunity for CRM_Transaction  
188 .INCLUDE       0   0   Header Data Opportunity - Structure of External Fields  
189 EXP_REVENUE CRMT_REPORT_EXP_REVENUE WERTV8 CURR 15   2   Expected Sales Revenue  
190 BUDGET_BP CRMT_BUDGET_BP WERTV8 CURR 15   2   Budget Prospect  
191 STARTDATE CRMT_STARTDATE DATUM DATS 8   0   Opportunity Start Date  
192 EXPECT_END CRMT_EXPECT_END DATUM DATS 8   0   Expected Closing Date  
193 CURR_PHASE CRMT_CURR_PHASE CRM_PHASE CHAR 3   0   Sales Stage CRMC_PHASE
194 PHASE_SINCE CRMT_PHASE_SINCE DATUM DATS 8   0   Sales Stage Since  
195 PROBABILITY CRMT_PROBABILITY CRM_PROBABILITY NUMC 3   0   Chance of Success  
196 FORECAST_REL CRMT_FORECAST_REL CRM_FORECAST_REL CHAR 1   0   Forecast Relevance  
197 SOURCE CRMT_SOURCE CRM_SOURCE CHAR 3   0   Origin of Opportunity/Lead CRMC_SOURCE
198 IMPORTANCE CRMT_IMPORTANCE CRM_IMPORTANCE CHAR 1   0   Opportunity/Lead Priority CRMC_OPPIMPOR
199 SALESCYCLE CRMT_SALESCYCLE CRM_SALESCYCLE CHAR 5   0   Sales Cycle CRMC_CYCLE
200 ADDRESS_NO CRMT_OPP_ADDRESS AD_ADDRNUM CHAR 10   0   Opportunity Address *
201 TYPE CRMT_OPPORT_TYPE CRM_OPPORT_TYPE CHAR 4   0   Opportunity Type CRMC_OPPT_TYPE
202 STATUS_SINCE CRMT_STATUS_SINCE DATUM DATS 8   0   Status Since  
203 SYS_PROBABILITY CRMT_SYSTEM_PROBABILITY CRM_SYSTEM_PROBABILITY NUMC 3   0   Chance of Success of Opportunity - Calculated by System  
204 DESCRIPTION_OPP CRMT_DESCRIPTION_OPP TEXT40 CHAR 40   0   Opportunity Description  
205 DESCR_OPP_UC CRMT_DESCRIPTION_OPP_UC TEXT40 CHAR 40   0   Opportunity Description in UC  
206 CUSTOMER_STATUS CRMT_CUSTSTAT CRM_CUSTSTAT CHAR 4   0   Design Registration Project Phase *
207 .INCLUDE       0   0   EEW Include  
208 OPPORT_H_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
209 .INCLUDE       0   0    
210 IMPORTANCE_TXT CRMT_REPORT_IMPORTANCE_TXT DDTEXT CHAR 60   0   Texts for Priority  
211 CURR_PHASE_TXT CRMT_REPORT_PHASE_TXT DDTEXT CHAR 60   0   Texts for Phase  
212 SALESCYCLE_TXT CRMT_REPORT_SALESCYCLE_TXT DDTEXT CHAR 60   0   Texts for Sales Cycle  
213 TYPE_TXT CRMT_REPORT_TYPE_TXT DDTEXT CHAR 60   0   Texts for Opportunity Group  
214 SOURCE_TXT CRMT_REPORT_SOURCE_TXT DDTEXT CHAR 60   0   Texts on Origin  
215 CODETEXT QTXT_CODE QKURZTEXT CHAR 40   0   Short Text for Code  
216 KATALOGART_OPP COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
217 CODEGRUPPE_OPP QCODEGRP QCODEGRP CHAR 8   0   Code Group *
218 CODE_OPP QCODE QCODE CHAR 4   0   Code *
219 LISTCODE_OPP CRMT_SRV_OPP_RESULT_LIST CHAR14 CHAR 14   0   CRM Service: Opportunity Status Reason  
220 CONTROL_PHASE CRMT_CON_PHASE CRM_CON_PHASE CHAR 3   0   Analysis Stage *
221 .INCLUDE       0   0   Output Fields: Sales for CRM_Transaction  
222 PO_NUMBER_UC CRMT_PO_NUMBER_UC CHAR35 CHAR 35   0   Sold-to Party's External Reference No. (in Capital Letters)  
223 NET_VALUE CRMT_NET_VALUE_CUM WERTV8 CURR 15   2   Total Net Value of Document in Document Currency  
224 CURRENCY CRMT_CURRENCY WAERS CUKY 5   0   Currency *
225 .INCLUDE       0   0   PARTNER (Sales) Data for BW DataSources  
226 SOLD_TO_PARTY CRMT_SOLD_TO_PART BU_PARTNER CHAR 10   0   Sold-To Party *
227 SHIP_TO_PARTY CRMT_SHIP_TO_PART BU_PARTNER CHAR 10   0   Ship-To Party *
228 BILL_TO_PARTY CRMT_BILL_TO_PART BU_PARTNER CHAR 10   0   Bill-To Party *
229 PAYER CRMT_RP_PAYER BU_PARTNER CHAR 10   0   Payer *
230 SOLD_FROM CRMT_SOLD_FROM_PARTY_ID BU_PARTNER CHAR 10   0   Salesperson ID *
231 CUST_GROUP1 CRMT_CUST_GROUP1 CRM_CUST_GROUP1 CHAR 3   0   Customer Group 1 CRMC_CUSTGRP1
232 CUST_GROUP2 CRMT_CUST_GROUP2 CRM_CUST_GROUP2 CHAR 3   0   Customer Group 2 CRMC_CUSTGRP2
233 CUST_GROUP3 CRMT_CUST_GROUP3 CRM_CUST_GROUP3 CHAR 3   0   Customer Group 3 CRMC_CUSTGRP3
234 CUST_GROUP4 CRMT_CUST_GROUP4 CRM_CUST_GROUP4 CHAR 3   0   Customer Group 4 CRMC_CUSTGRP4
235 CUST_GROUP5 CRMT_CUST_GROUP5 CRM_CUST_GROUP5 CHAR 3   0   Customer Group 5 CRMC_CUSTGRP5
236 PO_NUMBER_SOLD CRMT_PO_NUMBER_SOLD TEXT35 CHAR 35   0   Sold-To Party's External Reference Number  
237 PO_DATE_SOLD CRMT_PO_DATE_SOLD DATUM DATS 8   0   Reference Document Date  
238 YOUR_REF_SOLD CRMT_YOUR_REFERENCE_SOLD TEXT12 CHAR 12   0   Sold-to Party Reference  
239 PO_NUMBER_SHIP CRMT_PO_NUMBER_SHIP TEXT35 CHAR 35   0   Ship-To Party's External Reference Number  
240 PO_DATE_SHIP CRMT_PO_DATE_SHIP DATUM DATS 8   0   Ship-To Party's Reference Document Date  
241 YOUR_REF_SHIP CRMT_YOUR_REFERENCE_SHIP TEXT12 CHAR 12   0   Ship-To Party Reference  
242 USAGE_TYPE CRMT_USAGE CRM_USAGE CHAR 3   0   Usage Indicator CRMC_USAGE
243 SUBMISSION CRMT_SUBMISSION TEXT10 CHAR 10   0   Collective Number for Quotations  
244 REJECTION CRMT_REJECTION_CODE CRM_REJECTION_CODE CHAR 2   0   Cancellation Reason Code CRMC_REJECTION
245 REQ_DLV_DATE CRMT_REQ_DLV_DATE BCOS_TSTMP DEC 15   0   Requested Delivery Date Header  
246 REQ_TIMEZONE CRMT_REQ_DATE_TIMEZONE TZNZONE CHAR 6   0   Time Zone Requested Delivery Date Header *
247 RULE_REQ_DATE CRMT_RULE_REQ_DATE TIMERULEID RAW 16   0   Rule Reqested Delivery Date Header *
248 .INCLUDE       0   0   PARTNER (Purchasing) Data for BW DataSoures  
249 VENDOR CRMT_VENDOR BU_PARTNER CHAR 10   0   Vendor *
250 PLANT CRMT_PLANT BU_PARTNER CHAR 10   0   Purchasing: Plant Represented as Partner (Ship-To Party) *
251 VENDOR_LIST CRMT_VENDOR_LIST CHAR80 CHAR 80   0   Vendor: Name  
252 PLANT_LIST CRMT_PLANT_LIST CHAR80 CHAR 80   0   Plant: Name  
253 .INCLUDE       0   0   Output Fields: Lead for CRM Trans. (W/Out Duplicate w. Opp.)  
254 .INCLUDE       0   0   Lead Hdr Data: Structure with Fields for Reporting Framework  
255 DATE_START CRMT_LEAD_DATE_START DATUM DATS 8   0   Start of Business Transaction Lead  
256 DATE_END CRMT_LEAD_DATE_END_EXPECTED DATUM DATS 8   0   Expected End Date of Business Transaction Lead  
257 LEAD_TYPE CRMT_LEAD_TYPE CRM_LEAD_TYPE CHAR 4   0   Lead Group CRMC_LEAD_TYPE
258 QUAL_LEVEL_MAN CRMT_LEAD_QUAL_LEVEL_MAN CRM_LEAD_QUAL_LEVEL CHAR 2   0   Lead Qualification Level CRMC_LEAD_QL
259 QUAL_LEVEL_AUTO CRMT_LEAD_QUAL_LEVEL_AUTO CRM_LEAD_QUAL_LEVEL CHAR 2   0   Lead Qualification Level (Automatic) CRMC_LEAD_QL
260 LEAD_TYPE_TXT CRMT_REPORT_LEAD_TYPE_TXT DDTEXT CHAR 60   0   Texts for Lead Group  
261 QUAL_LEVEL_SVY CRMT_LEAD_QUAL_LEVEL_AUTO_SVY CHAR32 CHAR 32   0   Questionnaire that Q-Level Sets (Automatically)  
262 QUAL_LEVEL_MAN_TXT CRMT_REPORT_QUAL_LEVEL_MAN_TXT DDTEXT CHAR 60   0   Texts for Lead Qualification Level (Manual)  
263 QUAL_LEVEL_AUTO_TXT CRMT_REPORT_QUAL_LEVEL_AUT_TXT DDTEXT CHAR 60   0   Texts for Lead Qualification Level (Automatic)  
264 .INCLUDE       0   0   Output fields for billing_set CRM_transaction  
265 BUAG_ID CRMT_BUAG_ID CRMT_BUAG_ID CHAR 12   0   Number of Business Agreement  
266 BUAG_GUID CRMT_BUAG_GUID SYSUUID RAW 16   0   GUID of the Business Agreement  
267 BUAG_TEXT CRMT_BUAG_TEXT CHAR30LOW CHAR 30   0   Text for Business Agreement  
268 EXECUTING_CC CRMT_EXECUTING_CC BU_PARTNER CHAR 10   0   Executing Interaction Center *
269 EXECUTING_CC_LIST CRMT_EXECUTING_CC_LIST CHAR80 CHAR 80   0   Executing Interaction Center Name  
270 .INCLUDE       0   0   Output Fields: Product Summary  
271 PRODUCT_SUMMARY CRMT_REPORT_PRODUCT_SUM_TA   TTYP 0   0    
272 .INCLUDE       0   0   Collective Pricing Output Fields for CRM_Transaction  
273 CUST_GROUP CRMT_CUST_GROUP CRM_CUST_GROUP CHAR 2   0   Customer Group *
274 AC_INDICATOR CRMT_AC_INDICATOR CRMT_AC_INDICATOR CHAR 2   0   Accounting Indicator *
275 PRICE_DATE CRMT_PRICE_DATE CRM_PRICE_DATE DATS 8   0   Pricing Date  
276 EXCHG_RATE CRMT_EXCHG_RATE CRM_EXCHG_RATE DEC 9   5   Exchange Rate  
277 .INCLUDE       0   0   Pricing: Only Internally Determined Fields  
278 EXCHG_TYPE CRMT_EXCHG_TYPE KURST CHAR 4   0   Exchange Rate Type TCURV
279 EXCHG_DATE CRMT_EXCHG_DATE CRM_EXCHG_DATE DATS 8   0   Exchange Rate Date  
280 TAXJURCODE CRMT_TAXJURCODE TXJCD CHAR 15   0   Tax Jurisdiction Code (Structure for tax calculation) *
281 CUST_PRIC_PROC CRMT_CUST_PRIC_PROC CRM_CUST_PRIC_PROC CHAR 1   0   Customer Pricing Procedure *
282 REF_CURRENCY CRMT_REF_CURRENCY WAERS CUKY 5   0   Reference Currency TCURC
283 ENT_STRATEGY CRMT_ENT_STRATEGY CRM_ENT_STRATEGY CHAR 1   0   Entitlement Strategy  
284 .INCLUDE       0   0   Header: Structure of System Fields  
285 CUSTOMER_INT DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
286 .INCLUDE       0   0   Header: Structure of External Fields  
287 CUSTOMER_EXT DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
288 .INCLUDE       0   0   EEW Include  
289 CUSTOMER_H_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
290 .INCLUDE       0   0    
291 .INCLUDE       0   0   Output Fields: Project for CRM_Transaction  
292 OEM CRMT_OEM BU_PARTNER CHAR 10   0   Original Equipment Manufacturer *
293 OEM_LIST CRMT_OEM_PART_LIST TEXT80 CHAR 80   0   OEM: Name  
294 OEM_GUID CRMT_PARTNER_GUID SYSUUID RAW 16   0   GUID for an Individual Partner  
295 .INCLUDE       0   0   Shared Fields for Web Request  
296 REQ_TYPE CRMT_REQ_TYPE CRM_REQ_TYPE CHAR 10   0   Request Category *
297 TYPE_NAME CRMT_WEBREQ_DESCR TEXT40 CHAR 40   0   Description  
298 .INCLUDE       0   0   Subject Reference Object Fields for Service  
299 SUBJECT_PROF_SRV CRMT_SUBJECT_PROFILE CRM_SUBJECT_PROFILE CHAR 9   0   Subject Profile *
300 PROFILE_TYPE_SRV CRMT_SUBJECT_PROFILE_TYPE CRM_SUBJECT_PROFILE_TYPE CHAR 2   0   Subject Profile Category  
301 KATALOGART_SRV COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
302 CODEGRUPPE_SRV QCODEGRP QCODEGRP CHAR 8   0   Code Group *
303 CODE_SRV QCODE QCODE CHAR 4   0   Code *
304 CODEGRUPPE_SRV_TXT QKTEXTGR QKURZTEXT CHAR 40   0   Code Group Description  
305 CODE_SRV_TXT QTXT_CODE QKURZTEXT CHAR 40   0   Short Text for Code  
306 .INCLUDE       0   0   Reference Object header Fields  
307 REFOBJ_IBASE IB_IBASE IB_INSTANCE NUMC 18   0   IBase: Number of the Installed Base/IBase  
308 REFOBJ_INSTANCE IB_INSTANCE IB_INSTANCE NUMC 18   0   IB: Component (instance)  
309 REFOBJ_PRODUCTID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
310 GUID_OBJECT CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
311 SERIAL_NUMBER CRMT_SERIAL_NUMBER CHAR40 CHAR 40   0   Product Serial Number  
312 EXT_REFOBJ CRMT_EXT_REFOBJ CHAR40 CHAR 40   0   External Reference Object  
313 MAIN_OBJECT CRMT_SRV_MAIN_OBJECT BOOLEAN CHAR 1   0   Main Reference Object  
314 REF_OBJECT_TYPE CRMT_TYPE_OBJECT TYPE_OBJECT CHAR 1   0   Object Type for Reference Object in Subject Set  
315 REF_TEXT_OBJECT CRMT_TEXT_OBJECT SM_CHAR40 CHAR 40   0   Reference Object Text  
316 REF_TEXT_IB_COMP IB_INST_DESCR TEXT40 CHAR 40   0   IB: Component Description  
317 .INCLUDE       0   0   Coherent Catgory level GUID  
318 CATLVLGUID01_01 CRM_REP_CAT_GUID_LEV01_S1 SYSUUID RAW 16   0   Category GUID 1- schema 1  
319 CATLVLGUID02_01 CRM_REP_CAT_GUID_LEV02_S1 SYSUUID RAW 16   0   Category GUID 2- schema 1  
320 CATLVLGUID03_01 CRM_REP_CAT_GUID_LEV03_S1 SYSUUID RAW 16   0   Category GUID 3- schema 1  
321 CATLVLGUID04_01 CRM_REP_CAT_GUID_LEV04_S1 SYSUUID RAW 16   0   Category GUID 4- schema 1  
322 CATLVLGUID05_01 CRM_REP_CAT_GUID_LEV05_S1 SYSUUID RAW 16   0   Category GUID 5- schema 1  
323 CATLVLGUID06_01 CRM_REP_CAT_GUID_LEV06_S1 SYSUUID RAW 16   0   Category GUID 6- schema 1  
324 CATLVLGUID07_01 CRM_REP_CAT_GUID_LEV07_S1 SYSUUID RAW 16   0   Category GUID 7- schema 1  
325 CATLVLGUID08_01 CRM_REP_CAT_GUID_LEV08_S1 SYSUUID RAW 16   0   Category GUID 8- schema 1  
326 CATLVLGUID09_01 CRM_REP_CAT_GUID_LEV09_S1 SYSUUID RAW 16   0   Category GUID 9- schema 1  
327 CATLVLGUID10_01 CRM_REP_CAT_GUID_LEV10_S1 SYSUUID RAW 16   0   Category GUID 10- schema 1  
328 CATLVLGUID01_02 CRM_REP_CAT_GUID_LEV01_S2 SYSUUID RAW 16   0   Category GUID 1- schema 2  
329 CATLVLGUID02_02 CRM_REP_CAT_GUID_LEV02_S2 SYSUUID RAW 16   0   Category GUID 2- schema 2  
330 CATLVLGUID03_02 CRM_REP_CAT_GUID_LEV03_S2 SYSUUID RAW 16   0   Category GUID 3- schema 2  
331 CATLVLGUID04_02 CRM_REP_CAT_GUID_LEV04_S2 SYSUUID RAW 16   0   Category GUID 4- schema 2  
332 CATLVLGUID05_02 CRM_REP_CAT_GUID_LEV05_S2 SYSUUID RAW 16   0   Category GUID 5- schema 2  
333 CATLVLGUID06_02 CRM_REP_CAT_GUID_LEV06_S2 SYSUUID RAW 16   0   Category GUID 6- schema 2  
334 CATLVLGUID07_02 CRM_REP_CAT_GUID_LEV07_S2 SYSUUID RAW 16   0   Category GUID 7- schema 2  
335 CATLVLGUID08_02 CRM_REP_CAT_GUID_LEV08_S2 SYSUUID RAW 16   0   Category GUID 8- schema 2  
336 CATLVLGUID09_02 CRM_REP_CAT_GUID_LEV09_S2 SYSUUID RAW 16   0   Category GUID 9- schema 2  
337 CATLVLGUID10_02 CRM_REP_CAT_GUID_LEV09_S2 SYSUUID RAW 16   0   Category GUID 9- schema 2  
338 CATLVLGUID01_03 CRM_REP_CAT_GUID_LEV01_S3 SYSUUID RAW 16   0   Category GUID 1- schema 3  
339 CATLVLGUID02_03 CRM_REP_CAT_GUID_LEV02_S3 SYSUUID RAW 16   0   Category GUID 2- schema 3  
340 CATLVLGUID03_03 CRM_REP_CAT_GUID_LEV03_S3 SYSUUID RAW 16   0   Category GUID 3- schema 3  
341 CATLVLGUID04_03 CRM_REP_CAT_GUID_LEV04_S3 SYSUUID RAW 16   0   Category GUID 4- schema 3  
342 CATLVLGUID05_03 CRM_REP_CAT_GUID_LEV05_S3 SYSUUID RAW 16   0   Category GUID 5- schema 3  
343 CATLVLGUID06_03 CRM_REP_CAT_GUID_LEV06_S3 SYSUUID RAW 16   0   Category GUID 6- schema 3  
344 CATLVLGUID07_03 CRM_REP_CAT_GUID_LEV07_S3 SYSUUID RAW 16   0   Category GUID 7- schema 3  
345 CATLVLGUID08_03 CRM_REP_CAT_GUID_LEV08_S3 SYSUUID RAW 16   0   Category GUID 8- schema 3  
346 CATLVLGUID09_03 CRM_REP_CAT_GUID_LEV09_S3 SYSUUID RAW 16   0   Category GUID 9- schema 3  
347 CATLVLGUID10_03 CRM_REP_CAT_GUID_LEV10_S3 SYSUUID RAW 16   0   Category GUID 10- schema 3  
348 CATLVLGUID01_04 CRM_REP_CAT_GUID_LEV01_S4 SYSUUID RAW 16   0   Category GUID 1- schema 4  
349 CATLVLGUID02_04 CRM_REP_CAT_GUID_LEV02_S4 SYSUUID RAW 16   0   Category GUID 2- schema 4  
350 CATLVLGUID03_04 CRM_REP_CAT_GUID_LEV03_S4 SYSUUID RAW 16   0   Category GUID 3- schema 4  
351 CATLVLGUID04_04 CRM_REP_CAT_GUID_LEV04_S4 SYSUUID RAW 16   0   Category GUID 4- schema 4  
352 CATLVLGUID05_04 CRM_REP_CAT_GUID_LEV05_S4 SYSUUID RAW 16   0   Category GUID 5- schema 4  
353 CATLVLGUID06_04 CRM_REP_CAT_GUID_LEV06_S4 SYSUUID RAW 16   0   Category GUID 6- schema 4  
354 CATLVLGUID07_04 CRM_REP_CAT_GUID_LEV07_S4 SYSUUID RAW 16   0   Category GUID 7- schema 4  
355 CATLVLGUID08_04 CRM_REP_CAT_GUID_LEV08_S4 SYSUUID RAW 16   0   Category GUID 8- schema 4  
356 CATLVLGUID09_04 CRM_REP_CAT_GUID_LEV09_S4 SYSUUID RAW 16   0   Category GUID 9- schema 4  
357 CATLVLGUID10_04 CRM_REP_CAT_GUID_LEV10_S4 SYSUUID RAW 16   0   Category GUID 10- schema 4  
358 CATLVLGUID01_05 CRM_REP_CAT_GUID_LEV01_S5 SYSUUID RAW 16   0   Category GUID 1- schema 5  
359 CATLVLGUID02_05 CRM_REP_CAT_GUID_LEV02_S5 SYSUUID RAW 16   0   Category GUID 2- schema 5  
360 CATLVLGUID03_05 CRM_REP_CAT_GUID_LEV03_S5 SYSUUID RAW 16   0   Category GUID 3- schema 5  
361 CATLVLGUID04_05 CRM_REP_CAT_GUID_LEV04_S5 SYSUUID RAW 16   0   Category GUID 4- schema 5  
362 CATLVLGUID05_05 CRM_REP_CAT_GUID_LEV05_S5 SYSUUID RAW 16   0   Category GUID 5- schema 5  
363 CATLVLGUID06_05 CRM_REP_CAT_GUID_LEV06_S5 SYSUUID RAW 16   0   Category GUID 6- schema 5  
364 CATLVLGUID07_05 CRM_REP_CAT_GUID_LEV07_S5 SYSUUID RAW 16   0   Category GUID 7- schema 5  
365 CATLVLGUID08_05 CRM_REP_CAT_GUID_LEV08_S5 SYSUUID RAW 16   0   Category GUID 8- schema 5  
366 CATLVLGUID09_05 CRM_REP_CAT_GUID_LEV09_S5 SYSUUID RAW 16   0   Category GUID 9- schema 5  
367 CATLVLGUID10_05 CRM_REP_CAT_GUID_LEV10_S5 SYSUUID RAW 16   0   Category GUID 10- schema 5  
368 .INCLUDE       0   0   Coherent Catgory level of SRV OneOrder  
369 ASP_ID_01 CRM_REP_ASP_ID_LEVEL_01 CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   ASP ID - Schema 1  
370 CAT_ID_01_LOWEST CRM_REP_CAT_ID_S1_LOWEST CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category - lowest level - schema 1  
371 CATLEVEL01_01 CRM_REP_CAT_ID_LEV01_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 1- schema 1  
372 CATLEVEL02_01 CRM_REP_CAT_ID_LEV02_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 2- schema 1  
373 CATLEVEL03_01 CRM_REP_CAT_ID_LEV03_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 3- schema 1  
374 CATLEVEL04_01 CRM_REP_CAT_ID_LEV04_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 4- schema 1  
375 CATLEVEL05_01 CRM_REP_CAT_ID_LEV05_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 5 - Schema 1  
376 CATLEVEL06_01 CRM_REP_CAT_ID_LEV06_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 6 - Schema 1  
377 CATLEVEL07_01 CRM_REP_CAT_ID_LEV07_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 7 - Schema 1  
378 CATLEVEL08_01 CRM_REP_CAT_ID_LEV08_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 8 - Schema 1  
379 CATLEVEL09_01 CRM_REP_CAT_ID_LEV09_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 9 - Schema 1  
380 CATLEVEL10_01 CRM_REP_CAT_ID_LEV10_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 10 - Schema 1  
381 ASP_ID_02 CRM_REP_ASP_ID_LEVEL_02 CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   ASP ID - Schema 2  
382 CAT_ID_02_LOWEST CRM_REP_CAT_ID_S2_LOWEST CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category - lowest level - schema 2  
383 CATLEVEL01_02 CRM_REP_CAT_ID_LEV01_S2 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 1- schema 2  
384 CATLEVEL02_02 CRM_REP_CAT_ID_LEV02_S2 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 2- schema 2  
385 CATLEVEL03_02 CRM_REP_CAT_ID_LEV03_S2 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 3- schema 2  
386 CATLEVEL04_02 CRM_REP_CAT_ID_LEV04_S2 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 4- schema 2  
387 CATLEVEL05_02 CRM_REP_CAT_ID_LEV05_S2 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 5 - Schema 2  
388 CATLEVEL06_02 CRM_REP_CAT_ID_LEV06_S2 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 6 - Schema 2  
389 CATLEVEL07_02 CRM_REP_CAT_ID_LEV07_S2 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 7 - Schema 2  
390 CATLEVEL08_02 CRM_REP_CAT_ID_LEV08_S2 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 8 - Schema 2  
391 CATLEVEL09_02 CRM_REP_CAT_ID_LEV09_S2 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 9 - Schema 2  
392 CATLEVEL10_02 CRM_REP_CAT_ID_LEV10_S2 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 10 - Schema 2  
393 ASP_ID_03 CRM_REP_ASP_ID_LEVEL_03 CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   ASP ID - Schema 3  
394 CAT_ID_03_LOWEST CRM_REP_CAT_ID_S3_LOWEST CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category - lowest level - schema 3  
395 CATLEVEL01_03 CRM_REP_CAT_ID_LEV01_S3 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 1- schema 3  
396 CATLEVEL02_03 CRM_REP_CAT_ID_LEV02_S3 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 2- schema 3  
397 CATLEVEL03_03 CRM_REP_CAT_ID_LEV03_S3 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 3- schema 3  
398 CATLEVEL04_03 CRM_REP_CAT_ID_LEV04_S3 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 4 - Schema 3  
399 CATLEVEL05_03 CRM_REP_CAT_ID_LEV05_S3 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 5 - Schema 3  
400 CATLEVEL06_03 CRM_REP_CAT_ID_LEV06_S3 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 6 - Schema 3  
401 CATLEVEL07_03 CRM_REP_CAT_ID_LEV07_S3 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 7 - Schema 3  
402 CATLEVEL08_03 CRM_REP_CAT_ID_LEV08_S3 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 8 - Schema 3  
403 CATLEVEL09_03 CRM_REP_CAT_ID_LEV09_S3 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 9 - Schema 3  
404 CATLEVEL10_03 CRM_REP_CAT_ID_LEV10_S3 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 10 - Schema 3  
405 ASP_ID_04 CRM_REP_ASP_ID_LEVEL_04 CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   ASP ID - Schema 4  
406 CAT_ID_04_LOWEST CRM_REP_CAT_ID_S4_LOWEST CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category - lowest level - schema 4  
407 CATLEVEL01_04 CRM_REP_CAT_ID_LEV01_S4 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 1- schema 4  
408 CATLEVEL02_04 CRM_REP_CAT_ID_LEV02_S4 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 2- schema 4  
409 CATLEVEL03_04 CRM_REP_CAT_ID_LEV03_S4 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 3- schema 4  
410 CATLEVEL04_04 CRM_REP_CAT_ID_LEV04_S4 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 4- schema 4  
411 CATLEVEL05_04 CRM_REP_CAT_ID_LEV05_S4 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 5 - Schema 4  
412 CATLEVEL06_04 CRM_REP_CAT_ID_LEV06_S4 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 6 - Schema 4  
413 CATLEVEL07_04 CRM_REP_CAT_ID_LEV07_S4 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 7 - Schema 4  
414 CATLEVEL08_04 CRM_REP_CAT_ID_LEV08_S4 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 8 - Schema 4  
415 CATLEVEL09_04 CRM_REP_CAT_ID_LEV09_S4 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 9 - Schema 4  
416 CATLEVEL10_04 CRM_REP_CAT_ID_LEV10_S4 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 10 - Schema 4  
417 ASP_ID_05 CRM_REP_ASP_ID_LEVEL_05 CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   ASP ID - Schema 5  
418 CAT_ID_05_LOWEST CRM_REP_CAT_ID_S5_LOWEST CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category - lowest level - schema 5  
419 CATLEVEL01_05 CRM_REP_CAT_ID_LEV01_S5 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 1- schema 5  
420 CATLEVEL02_05 CRM_REP_CAT_ID_LEV02_S5 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 2- schema 5  
421 CATLEVEL03_05 CRM_REP_CAT_ID_LEV03_S5 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 3- schema 5  
422 CATLEVEL04_05 CRM_REP_CAT_ID_LEV04_S5 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 4- schema 5  
423 CATLEVEL05_05 CRM_REP_CAT_ID_LEV05_S5 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 5 - Schema 5  
424 CATLEVEL06_05 CRM_REP_CAT_ID_LEV06_S5 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 6 - Schema 5  
425 CATLEVEL07_05 CRM_REP_CAT_ID_LEV07_S5 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 7 - Schema 5  
426 CATLEVEL08_05 CRM_REP_CAT_ID_LEV08_S5 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 8 - Schema 5  
427 CATLEVEL09_05 CRM_REP_CAT_ID_LEV09_S5 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 9 - Schema 5  
428 CATLEVEL10_05 CRM_REP_CAT_ID_LEV10_S5 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 10 - Schema 5  
429 .INCLUDE       0   0   Reporting Coherent Catgory level GUID for interaction record  
430 CATLVLGUID01_IR CRM_REP_CAT_GUID_LEV01_S1 SYSUUID RAW 16   0   Category GUID 1- schema 1  
431 CATLVLGUID02_IR CRM_REP_CAT_GUID_LEV02_S1 SYSUUID RAW 16   0   Category GUID 2- schema 1  
432 CATLVLGUID03_IR CRM_REP_CAT_GUID_LEV03_S1 SYSUUID RAW 16   0   Category GUID 3- schema 1  
433 CATLVLGUID04_IR CRM_REP_CAT_GUID_LEV04_S1 SYSUUID RAW 16   0   Category GUID 4- schema 1  
434 CATLVLGUID05_IR CRM_REP_CAT_GUID_LEV05_S1 SYSUUID RAW 16   0   Category GUID 5- schema 1  
435 CATLVLGUID06_IR CRM_REP_CAT_GUID_LEV06_S1 SYSUUID RAW 16   0   Category GUID 6- schema 1  
436 CATLVLGUID07_IR CRM_REP_CAT_GUID_LEV07_S1 SYSUUID RAW 16   0   Category GUID 7- schema 1  
437 CATLVLGUID08_IR CRM_REP_CAT_GUID_LEV08_S1 SYSUUID RAW 16   0   Category GUID 8- schema 1  
438 CATLVLGUID09_IR CRM_REP_CAT_GUID_LEV09_S1 SYSUUID RAW 16   0   Category GUID 9- schema 1  
439 CATLVLGUID10_IR CRM_REP_CAT_GUID_LEV10_S1 SYSUUID RAW 16   0   Category GUID 10- schema 1  
440 .INCLUDE       0   0   Coherent Catgory level of Interaction record  
441 CAT_ID_IR_LOWEST CRM_REP_CAT_ID_S1_LOWEST CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category - lowest level - schema 1  
442 CATLEVEL01_IR CRM_REP_CAT_ID_LEV01_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 1- schema 1  
443 CATLEVEL02_IR CRM_REP_CAT_ID_LEV02_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 2- schema 1  
444 CATLEVEL03_IR CRM_REP_CAT_ID_LEV03_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 3- schema 1  
445 CATLEVEL04_IR CRM_REP_CAT_ID_LEV04_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 4- schema 1  
446 CATLEVEL05_IR CRM_REP_CAT_ID_LEV05_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 5 - Schema 1  
447 CATLEVEL06_IR CRM_REP_CAT_ID_LEV06_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 6 - Schema 1  
448 CATLEVEL07_IR CRM_REP_CAT_ID_LEV07_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 7 - Schema 1  
449 CATLEVEL08_IR CRM_REP_CAT_ID_LEV08_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 8 - Schema 1  
450 CATLEVEL09_IR CRM_REP_CAT_ID_LEV09_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 9 - Schema 1  
451 CATLEVEL10_IR CRM_REP_CAT_ID_LEV10_S1 CRM_ERMS_CAT_CA_ID_DO CHAR 40   0   Category 10 - Schema 1  
452 .INCLUDE       0   0   Reporting Structure for Partner Attributes  
453 COUNTRY CRMT_COUNTRY LAND1 CHAR 3   0   Country *
454 INDUSTRY CRMT_INDUSTRY CRM_INDUSTRY CHAR 4   0   Industry Sector *
455 REGION CRMT_REGION REGIO CHAR 3   0   Region (State, Province, County) *
456 SOLD_TO_COUNTRY CRMT_COUNTRY LAND1 CHAR 3   0   Country *
457 SOLD_TO_REGION CRMT_REGION REGIO CHAR 3   0   Region (State, Province, County) *
458 CP_PROGRAM CHM_PARTNER_PROGRAM CHM_PARTNER_PROGRAM CHAR 4   0   Channel Management - Channel Partner Programm *
459 CP_TYPE CHM_PARTNER_TYPE CHM_PARTNER_TYPE CHAR 4   0   Channel Management - Channel Partner Type *
460 CP_STATUS CHM_PARTNER_STATUS CHM_PARTNER_STATUS CHAR 4   0   Channel Management - Channel Partner Status *
461 .INCLUDE       0   0   EEW Include  
462 ACTIVITY_H_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
463 .INCLUDE       0   0    
464 .INCLUDE       0   0   EEW Include  
465 LEAD_H_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
466 .INCLUDE       0   0    
467 .INCLUDE       0   0   EEW Extension  
468 SALES_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
469 .INCLUDE       0   0    
470 .INCLUDE       0   0   EEW Extension  
471 SHIPPING_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
472 .INCLUDE       0   0    
473 .INCLUDE       0   0   EEW Include  
474 BILLING_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
475 .INCLUDE       0   0    
476 .INCLUDE       0   0   EEW Include  
477 ORGMAN_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
478 .INCLUDE       0   0    
479 .INCLUDE       0   0   EEW Include  
480 PRICING_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
481 .INCLUDE       0   0    
482 .INCLUDE       0   0   Fund Header Segment Internal Fields  
483 FUNDPLAN_TYPE CRM_FM_FND_FUNDPLAN_TYPE CHAR4 CHAR 4   0   Funds Plan Type  
484 FUND_TYPE CRM_FM_FND_FUND_TYPE CHAR4 CHAR 4   0   Fund Type  
485 FISCAL_PERIOD_FR CRM_FM_FND_FISPER_FROM CRM_FM_FISCPER NUMC 7   0   Fiscal Period From  
486 FISCAL_PERIOD_TO CRM_FM_FND_FISPER_TO CRM_FM_FISCPER NUMC 7   0   Fiscal Period From  
487 FIXED_EXP_PRD CRM_FM_FND_BEX_PER CRM_FM_FISCPER NUMC 7   0   Fixed Budget Expiration Period  
488 NO_OF_PRD_TO_EXP CRM_FM_FND_PER_TO_BEX POPER NUMC 3   0   Number of periods to Budget Expiration  
489 .INCLUDE       0   0   EEW extension for Fund  
490 FUND_H_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
491 .INCLUDE       0   0    
492 .INCLUDE       0   0   Fund Header Segment External Fields  
493 FUND_ATTR_GUID CRM_FM_FND_FUND_ATTR_GUID SYSUUID RAW 16   0   Fund Attributes GUID  
494 .INCLUDE       0   0   Reporting list out put structure for Claim Header  
495 CLA_PRIORITY CRMT_CLA_PRIORITY CRM_CLA_PRIORITY CHAR 4   0   Claim Priority *
496 IS_CORRECTION CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
497 SCHEDULING CRMT_CLA_SCHEDULING_INDICATOR CRM_CLA_SCHEDULING_INDICATOR CHAR 1   0   Scheduling Indicator  
498 .INCLUDE       0   0   Extension Include - Claim Header  
499 CLA_H_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
500 .INCLUDE       0   0    
501 .INCLUDE       0   0   Claim Amounts  
502 CLAIMED_AMOUNT CRMT_CLA_CLAIMED_AMOUNT CRM_COND_VALUE CURR 19   2   Claimed Amount  
503 VALIDATED_AMOUNT CRMT_CLA_VALIDATED_AMOUNT CRM_COND_VALUE CURR 19   2   Validated Amount  
504 SETTLED_AMOUNT CRMT_CLA_SETTLED_AMOUNT CRM_COND_VALUE CURR 19   2   Settled Amount  
505 REJECTED_AMOUNT CRMT_CLA_REJECTED_AMOUNT CRM_COND_VALUE CURR 19   2   Rejected Amount  
506 CHARGEB_AMOUNT CRMT_CLA_CHARGEBACK_AMOUNT CRM_COND_VALUE CURR 19   2   Chargeback Amount  
507 RECOVERED_AMOUNT CRMT_CLA_RECOVERED_AMOUNT CRM_COND_VALUE CURR 19   2   Recovered Amount  
508 CARR_OVER_AMOUNT CRMT_CLA_CARRIED_OVER_AMOUNT CRM_COND_VALUE CURR 19   2   Carried-Over Amount  
509 COLLECTBL_AMOUNT CRMT_CLA_COLLECTIBLE_AMOUNT CRM_COND_VALUE CURR 19   2   Collectible Amount  
510 UNCOLL_AMOUNT CRMT_CLA_UNCOLLECTIBLE_AMOUNT CRM_COND_VALUE CURR 19   2   Uncollectible Amount  
511 PP_ORIG_AMOUNT CRMT_CLA_ORIGINAL_AMOUNT CRM_COND_VALUE CURR 19   2   Validated Amount  
512 PP_CHB_AMOUNT CRMT_CLA_CHARGEBACK_AMOUNT CRM_COND_VALUE CURR 19   2   Chargeback Amount  
513 PP_WR_OFF_AMOUNT CRMT_CLA_WRITEOFF_AMOUNT CRM_COND_VALUE CURR 19   2   Write-Off Amount  
514 UNRESOLVD_AMOUNT CRMT_CLA_UNRESOLVED_AMOUNT CRM_COND_VALUE CURR 19   2   Unresolved Amount  
515 REQUESTED_AMOUNT CRMT_CLA_REQUESTED_AMOUNT CRM_COND_VALUE CURR 19   2   Requested Amount  
516 PP_REMAIN_AMOUNT CRMT_CLA_REMAINING_AMOUNT CRM_COND_VALUE CURR 19   2   Requested Amount  
517 UNASS_AMOUNT CRMT_CLA_UNASSIGNED_AMOUNT CRM_COND_VALUE CURR 19   2   Unassigned Amount  
518 CLA_COST_AMOUNT CRMT_CLA_COST_AMOUNT CRM_COND_VALUE CURR 19   2   Costs  
519 REL_EXP_AMOUNT CRMT_CLA_REL_EXP_AMOUNT CRM_COND_VALUE CURR 19   2   Amount released after expiration of claim  
520 PAID_AMOUNT CRMT_CLA_PAID_AMOUNT CRM_COND_VALUE CURR 19   2   Paid Amount  
521 CLEARED_AMOUNT CRMT_CLA_AMOUNT CRM_COND_VALUE CURR 19   2   Amount in Claims Management  
522 UNCLEAR_REJ_AMNT CRMT_CLA_UNCLEAR_REJ_AMOUNT CRM_COND_VALUE CURR 19   2   Amount for unclear rejections  
523 CHARGEB_SUM_AMNT CRMT_CLA_CHARGEB_SUM_AMOUNT CRM_COND_VALUE CURR 19   2   Chargeback sum amount  
524 WROFF_SUM_AMOUNT CRMT_CLA_WR_OFF_SUM_AMOUNT CRM_COND_VALUE CURR 19   2   Write-off Sum Amount  
525 CAROVER_SUM_AMNT CRMT_CLA_CARR_OVER_SUM_AMOUNT CRM_COND_VALUE CURR 19   2   Carried-Over Sum Amount  
526 UNASS_NET_AMOUNT CRMT_CLA_UNASS_NET_AMOUNT CRM_COND_VALUE CURR 19   2   Unassigned Net Amount  
527 UNRESOL_NET_AMNT CRMT_CLA_UNRESOLVD_NET_AMOUNT CRM_COND_VALUE CURR 19   2   Unresolved Net Amount  
528 CHARGEB_NET_AMNT CRMT_CLA_CHARGEBACK_NET_AMOUNT CRM_COND_VALUE CURR 19   2   Chargeback Net Amount  
529 PP_NET_AMOUNT CRMT_CLA_PREPAYMENT_NET_AMOUNT CRM_COND_VALUE CURR 19   2   Prepayment Net Amount  
530 PEND_RECOV_AMNT CRMT_CLA_PEND_RECOVERED_AMOUNT CRM_COND_VALUE CURR 19   2   Pending Recovered Amount  
531 .INCLUDE       0   0   Claims & Funds: Header Sum Status  
532 CF_APPROVED CRMT_STATUS_H_APPROVED CRM_STATUS_H_APPROVED CHAR 1   0   StatusH: Approved  
533 CF_REJECTED CRMT_STATUS_H_REJECTED CRM_STATUS_H_REJECTED CHAR 1   0   StatusH: Rejected  
534 CF_TO_BE_APPR CRMT_STATUS_H_TO_BE_APPROVED CRM_STATUS_H_TO_BE_APPROVED CHAR 1   0   StatusH: To Be Approved  
535 CF_SETTLED CRMT_STATUS_H_SETTLED CRM_STATUS_H_SETTLED CHAR 1   0   StatusH: Settled  
536 CF_CANCELED CRMT_STATUS_H_CANCELED CRM_STATUS_H_CANCELED CHAR 1   0   StatusH: Canceled  
537 CF_OPEN CRMT_STATUS_H_OPEN CRM_STATUS_H_OPEN CHAR 1   0   StatusH: Open  
538 CF_RETURNED CRMT_STATUS_H_RETURNED CRM_STATUS_H_RETURNED CHAR 1   0   StatusH: Returned  
539 CF_WRITTEN_OFF CRMT_STATUS_H_WRITTEN_OFF CRM_STATUS_H_WRITTEN_OFF CHAR 1   0   StatusH: Written-Off  
540 CF_IN_PROCESS CRMT_STATUS_H_IN_PROCESS CRM_STATUS_H_IN_PROCESS CHAR 1   0   StatusH: In Process  
541 .INCLUDE       0   0   General docflow data for Transaction Reporting  
542 FUNDS_PLAN_ID CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
543 FUNDS_PLAN_DESC CRMT_PROCESS_DESCRIPTION CRM_PROCESS_DESCRIPTION CHAR 40   0   Transaction Description  
544 CLA_SUBM_SETTLE_ID CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
545 CLA_SUBM_SETTLE_TYPE CRMT_SUBOBJECT_CATEGORY_DB CRM_OJ_NAME_PROCESS CHAR 10   0   Business Trans. Cat. *
546 DISPUTE_CASE_ID SCMG_EXT_KEY SCMG_EXT_KEY CHAR 12   0   Case ID  
547 PREDECESSOR_SRV CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
548 OPP_SUCCES_SLSO CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
549 SLSO_SUCCES_LEAD CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
550 OPP_SUCCES_LEAD CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
551 NUMSLSO_SUCC_CON CRMT_NUMSLSO_SUCC_CON INT4 INT4 10   0   No. of Sales Orders Succeeding Customer Contract  
552 PREQUO_SRVORDGUD CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
553 PREQUO_SRVORDID CRMT_OBJECT_ID_DB CRM_OBJECT_ID CHAR 10   0   Transaction ID  
554 PREQUO_SRVORDOPN CRMT_STATUS_OPEN CRM_BOOLEAN CHAR 1   0   Transaction is Still Open  
555 PRESRVORD_CNFGUD CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
556 PRESRVORD_CONFID CRMT_OBJECT_ID_DB CRM_OBJECT_ID CHAR 10   0   Transaction ID  
557 .INCLUDE       0   0   Reporting Framework Document Flow Data for BW DataSources  
558 PREDEC_OBJKEY CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
559 PREDEC_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
560 LOGSYS_PRED CRMT_LOGSYS LOGSYS CHAR 10   0   Logical System *
561 MKT_ELEMENT CRM_MKTPL_MKT_PLAN_TASKID CGPL_EXTID CHAR 24   0   Marketing Plan Element  
562 PRED_LEAD_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
563 LEAD_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
564 PRED_OPPT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
565 OPPT_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
566 PRED_ACT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
567 ACT_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
568 ACT_DIRECTION CRMT_DIRECTION CRM_DIRECTION CHAR 1   0   Direction of an Activity  
569 QUOTATION_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
570 QUOT_VALID_FROM CRMT_VALID_FROM_DATE CRM_RPRTNG_DATE DATS 8   0   Quotation Valid from Date  
571 PROCESS_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
572 PROCESS_CATALOG COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
573 PROCESS_CODEGR QCODEGRP QCODEGRP CHAR 8   0   Code Group *
574 PROCESS_CODE QCODE QCODE CHAR 4   0   Code *
575 PROCESS_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
576 PO_NUMBER CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
577 PO_ITEM_NUMBER CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
578 REF_IOBJECT_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
579 REF_IOBJECT_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
580 REF_CONF_PROD_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
581 REF_CONF_PROD_GU COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
582 REF_PROD_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
583 REF_PROD_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
584 REF_OBJ_FAM COMT_PRODUCT_OBJECT_FAMILY COM_PRODUCT_OBJECT_FAMILY CHAR 4   0   Object Family *
585 REF_BUAG_ID CRMT_BUAG_ID CRMT_BUAG_ID CHAR 12   0   Number of Business Agreement  
586 REF_BUAG_GUID CRMT_BUAG_GUID_C SYSUUID_C CHAR 32   0   GUID of Business Agreement in Character Format  
587 .INCLUDE       0   0   Opportunity Hierarchy Data for BW Data Sources  
588 MAST_OPP_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
589 MAST_OPITEM_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
590 SUB_OPP_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
591 MASTEROPP_FLAG CRMT_MASTEROPP_FLAG CRMT_MASTEROPP_FLAG CHAR 1   0   Flag to indicate master opportunity  
592 .INCLUDE       0   0   CRM Service Header: Structure of External Fields  
593 SERVICE_H_EXT DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
594 SERVICE_ID CRMT_TSRV_SERVICE_ID CRM_TSRV_SERVICE_ID CHAR 54   0   Template Search Term  
595 .INCLUDE       0   0   EEW Include  
596 SERVICE_H_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
597 .INCLUDE       0   0    
598 .INCLUDE       0   0   Reporting structure for service index fields  
599 KATALOG_TYPE CRMT_CATALOGTYPE CRM_CATALOGTYPE CHAR 1   0   Catalog Category  
600 SORT CRMT_SORT CRM_SORT INT2 5   0   Sort Field  
601 .INCLUDE       0   0   srv index data  
602 ASP_ID CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
603 CAT_ID CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
604 .INCLUDE       0   0   Service Request, Request for change and service time fields  
605 SRQ_WORK_DURA TIMEDURA TIMEDURA DEC 13   0   Numerical Value of Duration  
606 SRQ_WORK_UNIT TIMEUNITDU TIMEUNITNA CHAR 12   0   Default Value for Time Unit *
607 SRQ_TOT_DURA TIMEDURA TIMEDURA DEC 13   0   Numerical Value of Duration  
608 SRQ_TOT_UNIT TIMEUNITDU TIMEUNITNA CHAR 12   0   Default Value for Time Unit *
609 SRV_REQ_END_DAT CRMT_REPORT_ENDDATE DATUM DATS 8   0   End Date  
610 SRV_RSP_FRST_DAT CRMT_REPORT_STARTDATE DATUM DATS 8   0   Start Date  
611 .INCLUDE       0   0   Report structure for Service Request Header Extension  
612 .INCLUDE       0   0   SRQM structure Internal Fields  
613 DUMMY CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
614 REC_PRIORITY CRMT_SRQM_REC_PRIORITY SC_PRIO NUMC 1   0   Recommended Priority SCPRIO
615 .INCLUDE       0   0   SRQM Structure of External Fields  
616 URGENCY CRMT_SRQM_URGENCY CRM_SRQM_URGENCY NUMC 2   0   Urgency CRMC_SRQM_URGENC
617 IMPACT CRMT_SRQM_IMPACT CRM_SRQM_IMPACT NUMC 2   0   Impact CRMC_SRQM_IMPACT
618 ESCALATION CRMT_SRQM_ESCALATION CRM_SRQM_ESCALATION NUMC 1   0   Escalation  
619 CHANGE_CATEGORY CRMT_SRQM_CHANGE_CAT CRM_SRQM_CHANGE_CAT CHAR 3   0   Change Category CRMC_SRQM_CHGCAT
620 RISK CRMT_SRQM_RISK CRM_SRQM_RISK NUMC 3   0   Risk CRMC_SRQM_RISK
621 PROBLEM_CATEGORY CRMT_SRQM_PROBLEM_CATEGORY CRM_SRQM_PROBLEM_CATEGORY CHAR 3   0   Problem Category CRMC_SRQM_PRBCAT
622 IS_UPDATED CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
623 LAST_UPDATED_AT CRMT_SRQM_LAST_UPDATED_AT COM_TSTMP DEC 15   0   Last Updated On  
624 CHKLST_ID CRMT_SRQM_CHKLST_ID CRM_SRQM_CHKLST_ID CHAR 8   0   Checklist ID  
625 SEND_EMAIL CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
626 WP_FIXVAL CRMT_SRQM_WP_FIXVAL CRM_SRQM_WP_FIXVAL DEC 5   0   Fix value for Transaction Ranking determination  
627 .INCLUDE       0   0   Reporting include for Approval Step control data  
628 APPROVAL_RESULT J_ISTAT J_ISTAT CHAR 5   0   System status *
629 APPROVED_AT CRMT_APPROVED_AT BCOS_TSTMP DEC 15   0   Approval At Time Stamp  
630 ENTERED_BY CRMT_APRV_PARTNER_NUMBER CRM_PARTNER_NUMBER CHAR 20   0   Partner ID (Change Document Indicator Is On)  
631 APPROVAL_PARTNER CRMT_APRV_PARTNER_NUMBER CRM_PARTNER_NUMBER CHAR 20   0   Partner ID (Change Document Indicator Is On)  
632 STEP_ID CRMT_STEP_ID CRM_STEP_ID CHAR 10   0   Approval Step ID *
633 STEP_NO CRMT_STEP_NO CRM_STEP_NO NUMC 2   0   Internal Approval Step No.  
634 STEP_SEQUENCE CRMT_STEP_SEQUENCE CRM_STEP_SEQUENCE NUMC 3   0   Approval Step Sequence  
635 STEP_TYPE CRMT_APPROVAL_STEP_TYPE CRM_APPROVAL_STEP_TYPE CHAR 1   0   Approval Step Type  
636 APRV_STATUS_PF CRMT_APRV_APRV_STATUS_PF J_STSMA CHAR 8   0   Status Profile *
637 APRV_ACT CRMT_APRV_APRV_ACT J_ESTAT CHAR 5   0   User Status *
638 EXECUTION_STATUS CRMT_APRV_EXECUTION_STATUS J_ISTAT CHAR 5   0   System Status *
639 .INCLUDE       0   0   DATES Data for BW DataSources  
640 PLANNED_FROM CRMT_PLANNED_FROM CRM_RPRTNG_DATE DATS 8   0   Planned Date from  
641 PLANNED_TO CRMT_PLANNED_TO CRM_RPRTNG_DATE DATS 8   0   Planned Date to  
642 ACTUAL_FROM CRMT_ACTUAL_FROM CRM_RPRTNG_DATE DATS 8   0   Actual Date from  
643 ACTUAL_TO CRMT_ACTUAL_TO CRM_RPRTNG_DATE DATS 8   0   Actual Date to  
644 ACTUTOTAL_DURA CRMT_ACTUALTOTAL_DURA TIMEDURA DEC 13   0   Actual Total Value of Duration  
645 ACTOT_TIME_UNIT TIMEUNITDU TIMEUNITNA CHAR 12   0   Default Value for Time Unit *
646 FACE2FACE_DURA CRMT_FACE2FACE_DURA TIMEDURA DEC 13   0   Face to Face Value of Duration  
647 F2F_TIME_UNIT TIMEUNITDU TIMEUNITNA CHAR 12   0   Default Value for Time Unit *
648 CAL_ACT_TIME CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
649 .INCLUDE       0   0   Reporting Output requested objects  
650 ET_APPOINTMENT CRMT_REPORT_APPOINTMENTS_TA   TTYP 0   0    
651 ET_STATUS CRMT_REPORT_STATUSS_TA   TTYP 0   0    
652 ET_PARTNER CRMT_REPORT_PARTNER_TA   TTYP 0   0    
653 ET_LANGU_SYSSTAT SLANSPRAST   TTYP 0   0    
654 ET_LANGU_USERSTAT SLANSPRAST   TTYP 0   0    
655 ET_TEXT CRMT_REPORT_TEXT_TA   TTYP 0   0    
656 ET_CONC_SYSSTAT CRMT_REPORT_CONC_SYS_STAT_TA   TTYP 0   0    
657 ET_CONC_USERSTAT CRMT_REPORT_CONC_USER_STAT_TA   TTYP 0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_REPORT_LOCATORLIST CHANGE_CATEGORY CRMC_SRQM_CHGCAT CHANGE_CAT    
2 CRMT_REPORT_LOCATORLIST CURR_PHASE CRMC_PHASE PHASE    
3 CRMT_REPORT_LOCATORLIST CUST_GROUP1 CRMC_CUSTGRP1 CUST_GROUP1 REF C CN
4 CRMT_REPORT_LOCATORLIST CUST_GROUP2 CRMC_CUSTGRP2 CUST_GROUP2 REF C CN
5 CRMT_REPORT_LOCATORLIST CUST_GROUP3 CRMC_CUSTGRP3 CUST_GROUP3 REF C CN
6 CRMT_REPORT_LOCATORLIST CUST_GROUP4 CRMC_CUSTGRP4 CUST_GROUP4 REF C CN
7 CRMT_REPORT_LOCATORLIST CUST_GROUP5 CRMC_CUSTGRP5 CUST_GROUP5 REF C CN
8 CRMT_REPORT_LOCATORLIST EXCHG_TYPE TCURV KURST    
9 CRMT_REPORT_LOCATORLIST IMPACT CRMC_SRQM_IMPACT IMPACT    
10 CRMT_REPORT_LOCATORLIST IMPORTANCE CRMC_OPPIMPOR IMPORTANCE    
11 CRMT_REPORT_LOCATORLIST LEAD_TYPE CRMC_LEAD_TYPE LEAD_TYPE    
12 CRMT_REPORT_LOCATORLIST PARTNER_FCT CRMC_PARTNER_FCT PARTNER_FCT    
13 CRMT_REPORT_LOCATORLIST PROBLEM_CATEGORY CRMC_SRQM_PRBCAT PROBLEM_CATEGORY    
14 CRMT_REPORT_LOCATORLIST QUAL_LEVEL_AUTO CRMC_LEAD_QL QUAL_LEVEL    
15 CRMT_REPORT_LOCATORLIST QUAL_LEVEL_MAN CRMC_LEAD_QL QUAL_LEVEL    
16 CRMT_REPORT_LOCATORLIST REC_PRIORITY SCPRIO PRIORITY    
17 CRMT_REPORT_LOCATORLIST REF_CURRENCY TCURC WAERS    
18 CRMT_REPORT_LOCATORLIST REJECTION CRMC_REJECTION REJECTION_CODE    
19 CRMT_REPORT_LOCATORLIST RISK CRMC_SRQM_RISK RISK    
20 CRMT_REPORT_LOCATORLIST SALESCYCLE CRMC_CYCLE SALESCYCLE    
21 CRMT_REPORT_LOCATORLIST SOURCE CRMC_SOURCE SOURCE    
22 CRMT_REPORT_LOCATORLIST TYPE CRMC_OPPT_TYPE TYPE    
23 CRMT_REPORT_LOCATORLIST URGENCY CRMC_SRQM_URGENC URGENCY    
24 CRMT_REPORT_LOCATORLIST USAGE_TYPE CRMC_USAGE CALL_USAGE REF C CN
History
Last changed by/on SAP  20140802 
SAP Release Created in 30A