SAP ABAP Table CRMT_BW_SRV_REQ_PROBLEM_H (BW Extract Structure for CRM Incident - Hdr Data)
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_BW_SRV_REQ_PROBLEM_H   Table Relationship Diagram
Short Description BW Extract Structure for CRM Incident - Hdr Data    
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 .INCLUDE       0   0   ORDERADM_H Data for BW DataSources  
2 CLIENT MANDT MANDT CLNT 3   0   Client *
3 GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a 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 POSTING_DATE CRMT_POSTING_DATE   DATS 8   0   Posting Date for a Business Transaction  
7 DESCRIPTION_UC CRMT_PROCESS_DESCRIPTION_UC CRM_PROCESS_DESCRIPTION_UC CHAR 40   0   Transaction Description (Upper Case)  
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 OBJECT_TYPE CRMT_SUBOBJECT_CATEGORY CRM_OJ_NAME_PROCESS CHAR 10   0   Business Transaction Category CRMC_SUBOB_CAT
11 CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
12 CREATED_BY CRMT_CREATED_BY UNAME CHAR 12   0   User that Created the Transaction  
13 CHANGED_AT CRMT_OPPT_CHANGED_AT DATUM DATS 8   0   Time of Last Change to the Transaction  
14 CHANGED_BY CRMT_CHANGED_BY UNAME CHAR 12   0   Transaction Last Changed By  
15 RECORDMODE RODMUPDMOD RODMUPDMOD CHAR 1   0   BW Delta Process: Record Mode  
16 NUM_OF_HEAD CRMT_NUMBER_OF_H INT4 INT4 10   0   Order Header Number  
17 OCCURRENCE CRMT_OCC_AT_LEAST_ONCE CRM_BOOLEAN CHAR 1   0   Counter: Document Cat. Appears at Least Once in Document  
18 SCENARIO CRMT_SCENARIO CRM_SCENARIO CHAR 10   0   Scenario Identity  
19 TEMPLATE_TYPE CRMT_TEMPLATE_TYPE_DB CRM_TEMPLATE_TYPE CHAR 1   0   Template Type of CRM Transaction  
20 OCCURR_QUOT CRMT_QUO_AT_LEAST_ONCE CRM_BOOLEAN CHAR 1   0   Counter: Document Cat. Appears at Least Once in Document  
21 OCCURR_CONT CRMT_CON_AT_LEAST_ONCE CRM_BOOLEAN CHAR 1   0   Counter: Document Cat. Appears at Least Once in Document  
22 REF_UPDATE CRMT_FLG_REF_UPDATE_BW XFELD CHAR 1   0   Flag: Ref. Update (Extract Structure Only Partially Filled)  
23 INPUT_CHANNEL CRMT_INPUT_CHANNEL CRM_INPUT_CHANNEL CHAR 3   0   Input channel  
24 CREATED_TS COMT_CREATED_AT_USR COM_TSTMP DEC 15   0   Created At (Output in User Time Zone)  
25 CHANGED_TS COMT_CHANGED_AT_USR COM_TSTMP DEC 15   0   Changed At (Output in User Time Zone)  
26 .INCLUDE       0   0   Service Request Header Data for BW Data Sources  
27 REC_PRIORITY CRMT_SRQM_REC_PRIORITY SC_PRIO NUMC 1   0   Recommended Priority *
28 URGENCY CRMT_SRQM_URGENCY CRM_SRQM_URGENCY NUMC 2   0   Urgency *
29 IMPACT CRMT_SRQM_IMPACT CRM_SRQM_IMPACT NUMC 2   0   Impact *
30 ESCALATION CRMT_SRQM_ESCALATION CRM_SRQM_ESCALATION NUMC 1   0   Escalation  
31 CHANGE_CATEGORY CRMT_SRQM_CHANGE_CAT CRM_SRQM_CHANGE_CAT CHAR 3   0   Change Category *
32 RISK CRMT_SRQM_RISK CRM_SRQM_RISK NUMC 3   0   Risk *
33 PROBLEM_CATEGORY CRMT_SRQM_PROBLEM_CATEGORY CRM_SRQM_PROBLEM_CATEGORY CHAR 3   0   Problem Category *
34 LAST_UPDATED_AT CRMT_SRQM_LAST_UPDATED_AT COM_TSTMP DEC 15   0   Last Updated On  
35 .INCLUDE       0   0   Activities Header Data for BW Data Sources  
36 CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
37 PRIORITY CRMT_PRIORITY SC_PRIO NUMC 1   0   Activity Priority *
38 OBJECTIVE CRMT_OBJECTIVE CRM_OBJECTIVE CHAR 3   0   Goal of an Activity *
39 DIRECTION CRMT_DIRECTION CRM_DIRECTION CHAR 1   0   Direction of an Activity  
40 .INCLUDE       0   0   PARTNER (Sales) Data for BW DataSources  
41 SOLD_TO_PARTY CRMT_SOLD_TO_PART BU_PARTNER CHAR 10   0   Sold-To Party *
42 SHIP_TO_PARTY CRMT_SHIP_TO_PART BU_PARTNER CHAR 10   0   Ship-To Party *
43 BILL_TO_PARTY CRMT_BILL_TO_PART BU_PARTNER CHAR 10   0   Bill-To Party *
44 PAYER CRMT_RP_PAYER BU_PARTNER CHAR 10   0   Payer *
45 SOLD_FROM CRMT_SOLD_FROM_PARTY_ID BU_PARTNER CHAR 10   0   Salesperson ID *
46 .INCLUDE       0   0   PARTNER (General) Data for BW DataSoures  
47 SALES_EMPLOYEE CRMT_SALES_EMPLOYEE BU_PARTNER CHAR 10   0   Employee *
48 PERSON_RESP CRMT_PERSON_RESP BU_PARTNER CHAR 10   0   Employee Responsible *
49 CONTACT_PERSON CRMT_CONTACT_PERSON BU_PARTNER CHAR 10   0   Customer Contact Person *
50 SALESPARTNER CRMT_SALESPARTNER BU_PARTNER CHAR 10   0   Sales Partners *
51 RESP_GROUP_RFW CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
52 PLANNING_ACCOUNT CRMT_PLANNING_ACCOUNT BU_PARTNER CHAR 10   0   Planning Account *
53 .INCLUDE       0   0   PARTNER (Call Center) Data for BW Datasoures  
54 EXECUTING_CC CRMT_EXECUTING_CC BU_PARTNER CHAR 10   0   Executing Interaction Center *
55 RESP_GROUP CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
56 .INCLUDE       0   0   ORGMAN Data for BW DataSources  
57 SALES_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
58 SALES_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
59 SALES_OFFICE OBJEKTID NUM08 NUMC 8   0   Object ID  
60 SALES_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
61 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
62 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
63 SERVICE_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
64 SERVICE_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
65 PURCH_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
66 PURCH_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
67 PURCH_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
68 IC_BD_CCODE CRM_IC_BD_CCODE BUKRS CHAR 4   0   Company Code for a Business Transaction *
69 IC_BD_LOGSYS CRM_IC_BD_LOGSYS LOGSYS CHAR 10   0   Logical System for a Business Transaction *
70 .INCLUDE       0   0   Service Partner for BW Extraction  
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 .INCLUDE       0   0   PRICING_H Data for BW DataSources  
74 EXCHG_TYPE CRMT_EXCHG_TYPE KURST CHAR 4   0   Exchange Rate Type *
75 EXCHG_DATE CRMT_EXCHG_DATE CRM_EXCHG_DATE DATS 8   0   Exchange Rate Date  
76 EXCHG_RATE CRMT_EXCHG_RATE CRM_EXCHG_RATE DEC 9   5   Exchange Rate  
77 CURRENCY CRMT_CURRENCY WAERS CUKY 5   0   Currency *
78 PRICE_DATE CRMT_PRICE_DATE CRM_PRICE_DATE DATS 8   0   Pricing Date  
79 REF_CURRENCY CRMT_REF_CURRENCY WAERS CUKY 5   0   Reference Currency *
80 PMNTTRMS CRMT_PMNTTRMS CRM_PMNTTRMS CHAR 4   0   Terms of Payment *
81 CUST_GROUP CRMT_CUST_GROUP CRM_CUST_GROUP CHAR 2   0   Customer Group *
82 CUSTOMER_TYPE CRMT_CUSTOMER_TYPE BU_KIND CHAR 4   0   Business Partner Type *
83 .INCLUDE       0   0   Time Characteristics for BW Reporting  
84 CALDAY SMOCALDAY DATUM DATS 8   0   Calendar Day  
85 CALDAY_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
86 .INCLUDE       0   0   DOC_FLOW Data for BW DataSources  
87 PREDEC_OBJKEY CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
88 PREDEC_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
89 LOGSYS_PRED CRMT_LOGSYS LOGSYS CHAR 10   0   Logical System *
90 MKT_ELEMENT CRM_MKTPL_MKT_PLAN_TASKID CGPL_EXTID CHAR 24   0   Marketing Plan Element  
91 PRED_LEAD_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
92 LEAD_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
93 PRED_OPPT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
94 OPPT_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
95 PRED_ACT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
96 ACT_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
97 ACT_DIRECTION CRMT_DIRECTION CRM_DIRECTION CHAR 1   0   Direction of an Activity  
98 QUOTATION_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
99 QUOT_VALID_FROM CRMT_VALID_FROM_DATE CRM_RPRTNG_DATE DATS 8   0   Quotation Valid from Date  
100 PROCESS_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
101 PROCESS_CATALOG COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
102 PROCESS_CODEGR QCODEGRP QCODEGRP CHAR 8   0   Code Group *
103 PROCESS_CODE QCODE QCODE CHAR 4   0   Code *
104 PROCESS_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
105 PO_NUMBER CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
106 PO_ITEM_NUMBER CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
107 LEAD_CREATED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
108 OPPT_CREATED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
109 QUOT_VALID_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
110 .INCLUDE       0   0   SRV_SUBJECT Data for BW Extraction  
111 CATALOG_TYPE_C CRMT_CATALOGTYPE CRM_CATALOGTYPE CHAR 1   0   Catalog Category  
112 KATALOGART_C COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
113 CODEGRUPPE_C QCODEGRP QCODEGRP CHAR 8   0   Code Group *
114 CODE_C QCODE QCODE CHAR 4   0   Code *
115 DEFECTCLASS_C CRMT_DEFECTCLASS CRM_DEFECTCLASS CHAR 2   0   Defect Class *
116 QUALITY_C CRMT_QUALITY CRM_BOOLEAN CHAR 1   0   Quality Defect  
117 DEFQUANTITY_C CRMT_DEFQUANTITY CRM_DEFQUANTITY INT4 10   0   Defect Count  
118 COUNTER_C CRMT_NOACT NUMC1 NUMC 1   0   Number of Activities (always 1)  
119 ASP_ID_C CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
120 CAT_ID_C CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
121 CC_CAT_SUBJECT_C CRM_ERMS_CAT_GUID SYSUUID RAW 16   0   Multilevel Cat. - GUID Data Element  
122 CATALOG_TYPE_D CRMT_CATALOGTYPE CRM_CATALOGTYPE CHAR 1   0   Catalog Category  
123 KATALOGART_D COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
124 CODEGRUPPE_D QCODEGRP QCODEGRP CHAR 8   0   Code Group *
125 CODE_D QCODE QCODE CHAR 4   0   Code *
126 DEFECTCLASS_D CRMT_DEFECTCLASS CRM_DEFECTCLASS CHAR 2   0   Defect Class *
127 QUALITY_D CRMT_QUALITY CRM_BOOLEAN CHAR 1   0   Quality Defect  
128 DEFQUANTITY_D CRMT_DEFQUANTITY CRM_DEFQUANTITY INT4 10   0   Defect Count  
129 COUNTER_D CRMT_NOACT NUMC1 NUMC 1   0   Number of Activities (always 1)  
130 ASP_ID_D CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
131 CAT_ID_D CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
132 CC_CAT_SUBJECT_D CRM_ERMS_CAT_GUID SYSUUID RAW 16   0   Multilevel Cat. - GUID Data Element  
133 CATALOG_TYPE_E CRMT_CATALOGTYPE CRM_CATALOGTYPE CHAR 1   0   Catalog Category  
134 KATALOGART_E COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
135 CODEGRUPPE_E QCODEGRP QCODEGRP CHAR 8   0   Code Group *
136 CODE_E QCODE QCODE CHAR 4   0   Code *
137 DEFECTCLASS_E CRMT_DEFECTCLASS CRM_DEFECTCLASS CHAR 2   0   Defect Class *
138 QUALITY_E CRMT_QUALITY CRM_BOOLEAN CHAR 1   0   Quality Defect  
139 DEFQUANTITY_E CRMT_DEFQUANTITY CRM_DEFQUANTITY INT4 10   0   Defect Count  
140 COUNTER_E CRMT_NOACT NUMC1 NUMC 1   0   Number of Activities (always 1)  
141 ASP_ID_E CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
142 CAT_ID_E CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
143 CC_CAT_SUBJECT_E CRM_ERMS_CAT_GUID SYSUUID RAW 16   0   Multilevel Cat. - GUID Data Element  
144 CATALOG_TYPE_T CRMT_CATALOGTYPE CRM_CATALOGTYPE CHAR 1   0   Catalog Category  
145 KATALOGART_T COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
146 CODEGRUPPE_T QCODEGRP QCODEGRP CHAR 8   0   Code Group *
147 CODE_T QCODE QCODE CHAR 4   0   Code *
148 DEFECTCLASS_T CRMT_DEFECTCLASS CRM_DEFECTCLASS CHAR 2   0   Defect Class *
149 QUALITY_T CRMT_QUALITY CRM_BOOLEAN CHAR 1   0   Quality Defect  
150 DEFQUANTITY_T CRMT_DEFQUANTITY CRM_DEFQUANTITY INT4 10   0   Defect Count  
151 COUNTER_T CRMT_NOACT NUMC1 NUMC 1   0   Number of Activities (always 1)  
152 ASP_ID_T CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
153 CAT_ID_T CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
154 CC_CAT_SUBJECT_T CRM_ERMS_CAT_GUID SYSUUID RAW 16   0   Multilevel Cat. - GUID Data Element  
155 CATALOG_TYPE_W CRMT_CATALOGTYPE CRM_CATALOGTYPE CHAR 1   0   Catalog Category  
156 KATALOGART_W COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
157 CODEGRUPPE_W QCODEGRP QCODEGRP CHAR 8   0   Code Group *
158 CODE_W QCODE QCODE CHAR 4   0   Code *
159 DEFECTCLASS_W CRMT_DEFECTCLASS CRM_DEFECTCLASS CHAR 2   0   Defect Class *
160 QUALITY_W CRMT_QUALITY CRM_BOOLEAN CHAR 1   0   Quality Defect  
161 DEFQUANTITY_W CRMT_DEFQUANTITY CRM_DEFQUANTITY INT4 10   0   Defect Count  
162 COUNTER_W CRMT_NOACT NUMC1 NUMC 1   0   Number of Activities (always 1)  
163 ASP_ID_W CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
164 CAT_ID_W CRM_ERMS_CAT_AS_ID CRM_ERMS_CAT_AS_ID_DO CHAR 40   0   Coherent Cat. - Aspect ID  
165 CC_CAT_SUBJECT_W CRM_ERMS_CAT_GUID SYSUUID RAW 16   0   Multilevel Cat. - GUID Data Element  
166 PROFILE_TYPE CRMT_SUBJECT_PROFILE_TYPE CRM_SUBJECT_PROFILE_TYPE CHAR 2   0   Subject Profile Category  
167 CC_CAT_SUBJECT CRM_ERMS_CAT_GUID SYSUUID RAW 16   0   Multilevel Cat. - GUID Data Element  
168 .INCLUDE       0   0   STATUS GROUPS Data for BW Datasources  
169 BWSTONESYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
170 BWSTONESYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
171 BWSTONESYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
172 BWSTONESYS3 CRMBWST J_STONR NUMC 2   0   BW Status  
173 BWSTONESYS4 CRMBWST J_STONR NUMC 2   0   BW Status  
174 BWSTONESYS5 CRMBWST J_STONR NUMC 2   0   BW Status  
175 BWSTONESYS6 CRMBWST J_STONR NUMC 2   0   BW Status  
176 BWSTONESYS7 CRMBWST J_STONR NUMC 2   0   BW Status  
177 BWSTONESYS8 CRMBWST J_STONR NUMC 2   0   BW Status  
178 BWSTONESYS9 CRMBWST J_STONR NUMC 2   0   BW Status  
179 BWSTONESYSA CRMBWST J_STONR NUMC 2   0   BW Status  
180 BWSTTECSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
181 BWSTTECSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
182 BWSTTECSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
183 BWSTLOCSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
184 BWSTLOCSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
185 BWSTLOCSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
186 BWSTONESYSB CRMBWST J_STONR NUMC 2   0   BW Status  
187 BWSTONESYSC CRMBWST J_STONR NUMC 2   0   BW Status  
188 .INCLUDE       0   0   CUMULATED_H Data for BW Data Sources  
189 GROSS_VALUE_H CRMT_GROSS_VALUE_CUM WERTV8 CURR 15   2   Total Gross Value of Document in Document Currency  
190 NET_VALUE_H CRMT_NET_VALUE_CUM WERTV8 CURR 15   2   Total Net Value of Document in Document Currency  
191 NET_VALUE_MAN_H CRMT_NET_VALUE_MAN_CUM WERTV8 CURR 15   2   Expected Total Net Value of Products in Document Currency  
192 .INCLUDE       0   0   Territory Data for BW Data Sources (Partner Attribute)  
193 PATH_GUID CRMT_PATH_GUID_32 SYSUUID_C CHAR 32   0   Path GUID of Territory 32  
194 TERR_GUID CRMT_TERR_GUID_32 SYSUUID_C CHAR 32   0   Territory GUID 32  
195 .INCLUDE       0   0   REFOBJ Data for BW DataSources  
196 GUID_OBJECT CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
197 GUID_OBJ_OBJFAM COMT_PRODUCT_OBJECT_FAMILY COM_PRODUCT_OBJECT_FAMILY CHAR 4   0   Object Family *
198 BOSS_OBJTYP CRMT_TYPE_OBJECT TYPE_OBJECT CHAR 1   0   Object Type for Reference Object in Subject Set  
199 BOSS_IOBJ_GUID CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
200 BOSS_IOBJ_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
201 BOSS_CFPRD_GUID CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
202 BOSS_CFPRD_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
203 BOSS_PROD_GUID CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
204 BOSS_PROD_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
205 .INCLUDE       0   0   Additional Service-Specific Data for BW DataSources  
206 KF_SRV_RREADY CRMT_BW_SRV_DATES CRMT_BW_SRV_DATES INT1 3   0   Data Element for Service - Date Key Figures  
207 KF_SRV_CUST_END CRMT_BW_SRV_DATES CRMT_BW_SRV_DATES INT1 3   0   Data Element for Service - Date Key Figures  
208 CHA_SRV_RREADY CHA_SRV_RREADY CRMT_BW_SRV_CHA_DATES CHAR 1   0   Data Element for Service-Date Characteristic SLA Date  
209 CHA_SRV_CUST_END CHA_SRV_CUST_END CRMT_BW_SRV_CHA_DATES CHAR 1   0   Data Element for Service-Date Char. :Date Requested by Cust.  
210 PLAN_FLAG CRMT_BW_PLAN_FLAG CRMT_BW_PLAN_FLAG CHAR 2   0   Planning Indicator  
211 DISPO_FLG CRMT_SRV_DISPO_FLG FLAG CHAR 1   0   Relevant for Resource Planning  
212 CONFIRM_RELEVANT CRMT_CONFIRM_RELEVANT CRM_BOOLEAN CHAR 1   0   Relevant for Confirmation  
213 AC_INDICATOR CRMT_AC_INDICATOR CRMT_AC_INDICATOR CHAR 2   0   Accounting Indicator *
214 SERVICE_TYPE CRMT_SERVICE_TYPE CRMT_SERVICE_TYPE CHAR 4   0   Service Type *
215 VALUATION_TYPE CRMT_VALUATION_TYPE CRMT_VALUATION_TYPE CHAR 6   0   Valuation Type *
216 SRV_ESCAL CRMT_SRV_ESCAL CRM_SRV_ESCAL CHAR 10   0   Response Profile *
217 SRV_SERWI CRMT_SRV_SERWI CRM_SRV_SERWI CHAR 10   0   Service Profile *
218 DURATION CRMT_SRV_DURATION MENG13 QUAN 13   3   Duration  
219 DURATION_UNIT CRMT_SRV_DURATION_UOM MEINS UNIT 3   0   Unit for Duration of Work *
220 PERSONS CRMT_SRV_PERSONS NUMC3 NUMC 3   0   Number of Persons  
221 STATUS_OPEN_SRV CRMT_BW_STATUS_ASSIGN CRMT_BW_STATUS_ASSIGN INT1 3   0   Status Identifier  
222 STATUS_IP_SRV CRMT_BW_STATUS_ASSIGN CRMT_BW_STATUS_ASSIGN INT1 3   0   Status Identifier  
223 STATUS_RE_SRV CRMT_BW_STATUS_ASSIGN CRMT_BW_STATUS_ASSIGN INT1 3   0   Status Identifier  
224 STATUS_CO_SRV CRMT_BW_STATUS_ASSIGN CRMT_BW_STATUS_ASSIGN INT1 3   0   Status Identifier  
225 LC_SRV_DURATION CRMT_BW_LIFECYCLE CRMT_DAUER_10_3 QUAN 10   3   CRM Service: Lifecycle (Duration)  
226 LC_SRV_DUR_UNIT CRMT_BW_LIFECYCLE_UNIT MEINS UNIT 3   0   CRM Service Lifecycle Unit (Duration) *
227 BILL_RELEVANT CRMT_BILLING_RELEVANT CRM_BILLING_RELEVANT CHAR 1   0   Billing Relevance  
228 WARRANTY CRMT_PRODUCT_GUID_32 SYSUUID_C CHAR 32   0   GUID for Product CHAR32  
229 WARRANTY_ID CRMT_WTY_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Warranty ID  
230 PRED_PSL_OBJKEY CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
231 PRED_TMPL_OBJKEY CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
232 CONTR_OBJ_ID CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
233 .INCLUDE       0   0   Specific Service Process Header Fields for BW DataSource  
234 BWSTONESVTK CRMBWST J_STONR NUMC 2   0   BW Status  
235 .INCLUDE       0   0   Additional Service-Specific Dates for BW DataSources  
236 ESCALATE_1_DATE CRMT_BW_ESCALATION_1_DATE CRM_RPRTNG_DATE DATS 8   0   Escalation Date Level 1  
237 ESCALATE_2_DATE CRMT_BW_ESCALATION_2_DATE CRM_RPRTNG_DATE DATS 8   0   Escalation Date Level 2  
238 WORK_DURATION CRMT_BW_DURATION TIMEDURA DEC 13   0   Duration of Contract/Quotation  
239 WORK_DURA_UNIT CRMT_BW_DURA_UNIT TIMEUNITNA CHAR 12   0   Time Unit for Duration of Contract/Quotation in Days *
240 TOTAL_DURATION CRMT_BW_DURATION TIMEDURA DEC 13   0   Duration of Contract/Quotation  
241 TOTAL_DURA_UNIT CRMT_BW_DURA_UNIT TIMEUNITNA CHAR 12   0   Time Unit for Duration of Contract/Quotation in Days *
242 REQ_START_DATE CRMT_BW_REQ_START_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Requested Start Date/Time  
243 REQ_END_DATE CRMT_BW_REQ_END_DATE BCOS_TSTMP DEC 15   0   Time Stamp: Requested End Date/Time  
244 COMPLETION_DATE CRMT_BW_CLOSE_DATE CRM_RPRTNG_DATE DATS 8   0   Closing Date  
245 DUE_DATE CRMT_BW_DUE_DATE BCOS_TSTMP DEC 15   0   Timestamp: Due Date/Time  
246 COMPLETION_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
247 ESCALATE_1_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
248 ESCALATE_2_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
249 CC_CAT_ACTREASON CRM_ERMS_CAT_GUID SYSUUID RAW 16   0   Multilevel Cat. - GUID Data Element  
250 NO_OF_IR CRMT_NO_OF_IR   INT4 10   0   Number of Interaction Records  
251 ALL_INCIDENTS CRMT_SRV_REQ_ALL_INCI CRM_SRV_REQ_NUM_INCI INT4 10   0   Number of All Incidents Linked to the Problem  
252 LOC_INCIDENTS CRMT_SRV_REQ_LOC_INCI CRM_SRV_REQ_NUM_INCI INT4 10   0   Number of Locked Incidents Linked to the Problem  
253 IN_COMPL_BEFORE CRMT_SRV_REQ_STAT_COMP_BEFORE   INT4 10   0   Status Is In Process but Was Previously Completed  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_BW_SRV_REQ_PROBLEM_H OBJECT_TYPE CRMC_SUBOB_CAT SUBOBJ_CATEGORY    
History
Last changed by/on SAP  20130604 
SAP Release Created in 700