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