SAP ABAP Table CRMT_REPORT_LOC_GEN (General Output Fields for CRM_Transaction)
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_LOC_GEN   Table Relationship Diagram
Short Description General Output Fields for CRM_Transaction    
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_ID CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
2 PROCESS_TYPE CRMT_PROCESS_TYPE CRM_PROCESS_TYPE CHAR 4   0   Business Transaction Type *
3 TEMPLATE_TYPE CRMT_TEMPLATE_TYPE CRM_TEMPLATE_TYPE CHAR 1   0   CRM Transaction: Template Type  
4 DESCRIPTION CRMT_PROCESS_DESCRIPTION CRM_PROCESS_DESCRIPTION CHAR 40   0   Transaction Description  
5 DESCR_LANGUAGE CRMT_PROCESS_DESCRIPTION_LANGU SPRAS LANG 1   0   Language Key of Description *
6 LOGICAL_SYSTEM CRMT_LOGSYS LOGSYS CHAR 10   0   Logical System *
7 POSTING_DATE CRMT_POSTING_DATE   DATS 8   0   Posting Date for a Business Transaction  
8 CHANGED_AT CRMT_CHANGED_AT_USR CRM_TSTMP DEC 15   0   Changed On (Output in User Time Zone)  
9 CHANGED_BY CRMT_CHANGED_BY UNAME CHAR 12   0   Transaction Last Changed By  
10 CREATED_AT CRMT_CREATED_AT_USR CRM_TSTMP DEC 15   0   Created On (Output in User Time Zone)  
11 HEAD_CHANGED_AT CRMT_CHANGED_AT BCOS_TSTMP DEC 15   0   Time of Last Change to the Transaction  
12 CHANGED_AT_DATE CRMT_CHANGED_AT_DATE SYDATS DATS 8   0   Date on Which Transaction Was Last Changed  
13 CREATED_AT_DATE CRMT_CREATED_AT_DATE SYDATS DATS 8   0   Transaction Was Created on This Date  
14 CONCATSTAT J_STEXT TEXT40 CHAR 40   0   System status line  
15 CONCATSTATUSER CRMT_REPORT_USERSTATUS TEXT40 CHAR 40   0   User Status  
16 PROCESS_TYPE_TXT CRMT_REPORT_PROCESS_TYPE_TXT DDTEXT CHAR 60   0   Text Description for Transaction Category  
17 CREATED_BY CRMT_CREATED_BY UNAME CHAR 12   0   User that Created the Transaction  
18 KURZTEXT QKTEXTGRCD QKURZTEXT80 CHAR 80   0   Code Group Short Text  
19 ACT_TEXT QKTEXTGRCD QKURZTEXT80 CHAR 80   0   Code Group Short Text  
20 NET_VALUE_MAN CRMT_NET_VALUE_MAN WERTV8 CURR 15   2   Total Expected Net Value Products in Document Currency  
21 GROSS_VALUE_H CRMT_GROSS_VALUE_CUM WERTV8 CURR 15   2   Total Gross Value of Document in Document Currency  
22 .INCLUDE       0   0   PARTNER (General) Data for BW DataSoures  
23 SALES_EMPLOYEE CRMT_SALES_EMPLOYEE BU_PARTNER CHAR 10   0   Employee *
24 PERSON_RESP CRMT_PERSON_RESP BU_PARTNER CHAR 10   0   Employee Responsible *
25 CONTACT_PERSON CRMT_CONTACT_PERSON BU_PARTNER CHAR 10   0   Customer Contact Person *
26 SALESPARTNER CRMT_SALESPARTNER BU_PARTNER CHAR 10   0   Sales Partners *
27 RESP_GROUP_RFW CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
28 PLANNING_ACCOUNT CRMT_PLANNING_ACCOUNT BU_PARTNER CHAR 10   0   Planning Account *
29 CLAIMING_ACCOUNT CMST_CLAIMING_ACCOUNT BU_PARTNER CHAR 10   0   Claiming Account *
30 INVOIC_RECIPIENT CRMT_INVOICE_RECIPIENT BU_PARTNER CHAR 10   0   Invoice Recipient *
31 SALES_EMPLOYEE_LIST CRMT_SALES_EMPLOYEE_LIST TEXT80 CHAR 80   0   Sales Representative  
32 PERSON_RESP_LIST CRMT_PERSON_RESP_LIST TEXT80 CHAR 80   0   Employee Responsible  
33 PERSON_RESP_NAME CRMT_PERSON_RESP_NAME BU_TEXT50 CHAR 50   0   Employee Responsible - Name (Name Only Without Address)  
34 CONTACT_PERSON_LIST CRMT_CONTACT_PERSON_LIST TEXT80 CHAR 80   0   Contact Person  
35 OBJECT_TYPE_TXT SAEOBJTEXT SADC40 CHAR 40   0   Object text for language-dependent table  
36 FROM CRMT_DATES_START_DATE DATUM DATS 8   0   Start Date  
37 TO CRMT_DATES_END_DATE DATS DATS 8   0   End Date  
38 FROM_TIME CRMT_BSP_TIME_HHMM_FROM CRM_BSP_TIME_HHMM TIMS 6   0   From  
39 TO_TIME CRMT_BSP_TIME_HHMM_TO CRM_BSP_TIME_HHMM TIMS 6   0   To  
40 OBJECT_TYPE SWO_OBJTYP OJ_NAME CHAR 10   0   Object Type *
41 VALID_FROM CRMT_DATES_START_DATE DATUM DATS 8   0   Start Date  
42 VALID_TO CRMT_DATES_END_DATE DATS DATS 8   0   End Date  
43 VALID_FROM_TIME CRMT_BSP_TIME_HHMM_FROM CRM_BSP_TIME_HHMM TIMS 6   0   From  
44 VALID_TO_TIME CRMT_BSP_TIME_HHMM_TO CRM_BSP_TIME_HHMM TIMS 6   0   To  
45 DATE_1 CRMT_VALID_FROM BCOS_TSTMP DEC 15   0   Time Dependency: Validity Start Date  
46 DATE_2 CRMT_VALID_TO BCOS_TSTMP DEC 15   0   Time Dependency: Validity End Date  
47 DATE_3 CRMT_CONTACT_FROM BCOS_TSTMP DEC 15   0   Time Stamp: Start of Customer Contact  
48 DATE_4 CRMT_CONTACT_TO BCOS_TSTMP DEC 15   0   Time Stamp: End of Customer Contact  
49 STATUS CRM_J_STATUS CRM_J_STATUS CHAR 5   0   Object Status  
50 STATUS_SYSTEM CRM_J_STATUS CRM_J_STATUS CHAR 5   0   Object Status  
51 USER_STAT_PROC CRM_J_STSMA CRM_J_STSMA CHAR 8   0   Status Profile *
52 PROCESS J_VORGANG J_VORGANG CHAR 4   0   Business Transaction *
53 KIND CRMT_OBJECT_KIND CRM_OBJECTKIND CHAR 1   0   Object Type  
54 TXT04 J_TXT04 TEXT4 CHAR 4   0   Individual status of an object (short form)  
55 TXT30 J_TXT30 TEXT30 CHAR 30   0   Object status  
56 COMPETITOR_LIST CRMT_COMPETITOR_LIST TEXT80 CHAR 80   0   Competitor  
57 PROSPECT_NAME CRMT_PROSPECT_NAME BU_TEXT50 CHAR 50   0   Prospect - Name (Name Only, Without Address)  
58 PROSPECT_LIST CRMT_PROSPECT_LIST TEXT80 CHAR 80   0   Sales Prospect  
59 SALESPARTNER_LIST CRMT_SALESPARTNER_LIST TEXT80 CHAR 80   0   Sales Partner  
60 ACTIVITY_PARTNER_LIST CRMT_ACTIVITY_PARTNER_LIST TEXT80 CHAR 80   0   Activity Partner  
61 SOLD_TO_PARTY_NAME CRMT_SOLD_TO_PARTY_NAME BU_TEXT50 CHAR 50   0   Sold-To Party Name (Name Only, Without Address)  
62 SOLD_TO_PARTY_LIST CRMT_SOLD_TO_PART_LIST TEXT80 CHAR 80   0   Sold-To Party  
63 SHIP_TO_PARTY_LIST CRMT_SHIP_TO_PART_LIST TEXT80 CHAR 80   0   Ship-To Party: Name  
64 BILL_TO_PARTY_LIST CRMT_BILL_TO_PART_LIST TEXT80 CHAR 80   0   Bill-To Party: Name  
65 PAYER_LIST CRMT_RP_PAYER_LIST TEXT80 CHAR 80   0   Payer: Name  
66 SERVICE_TEAM_LIST CRMT_SERVICE_GROUP_LIST TEXT80 CHAR 80   0   Service Employee Group  
67 SERVICE_EMPLOYEE_LIST CRMT_SERVICE_EMPLOYEE_LIST TEXT80 CHAR 80   0   Responsible Service Employee  
68 SERVICE_TEAM CRMT_SERVICE_TEAM BU_PARTNER CHAR 10   0   Service Team *
69 SERVICE_EMPLOYEE CRMT_SERVICE_EMPLOYEE BU_PARTNER CHAR 10   0   Executing Service Employee *
70 RESPONS_AT_PARTNER CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
71 RESP_AT_PARTNER CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
72 CHANNEL_PARTNER CMST_CHANNEL_PARTNER BU_PARTNER CHAR 10   0   Channel Partner *
73 CHANNEL_PARTNER_LIST CMST_CHANNEL_PARTNER_LIST TEXT80 CHAR 80   0   Channel Partner  
74 CORP_CHANNEL_PARTNER CMST_CORPORATE_CHANNEL_PARTNER BU_PARTNER CHAR 10   0   Corporate Channel Partner *
75 RESPONS_AT_PARTNER_LIST CRMT_RESPONS_AT_PARTNER_LIST TEXT80 CHAR 80   0   Person Responsible at Partners - Name (Channel Management)  
76 END_CUSTOMER CRMT_END_CUSTOMER BU_PARTNER CHAR 10   0   End Customer (Channel Management) *
77 END_CUSTOMER_LIST CRMT_END_CUSTOMER_LIST TEXT80 CHAR 80   0   End Customer Name (Channel Management)  
78 PLANNING_ACCOUNT_LIST CRMT_PLANNING_ACCOUNT_LIST TEXT80 CHAR 80   0   Planning Account Text  
79 STAT_QUOT CRMT_BOOLEAN CRM_BOOLEAN CHAR 1   0   Logical Variable  
80 STAT_OPEN CRMT_STATUS_OPEN CRM_BOOLEAN CHAR 1   0   Transaction is Still Open  
81 STAT_PLANNED CRMT_STATUS_PLANNED CRM_BOOLEAN CHAR 1   0   Status: Planned  
82 STAT_CREDIT CRMT_STATUS_CRED CRMT_STATUS_CRED CHAR 1   0   Credit Block on Transaction  
83 STAT_RFC_APPROVD CRMT_STATUS_RFC_APPROVED BOOLEAN CHAR 1   0   Request for Change Approved or Awaiting Approval  
84 STAT_RFCWAPPROVD CRMT_STATUS_RFC_APPROVED BOOLEAN CHAR 1   0   Request for Change Approved or Awaiting Approval  
85 STAT_RFC_REJECTD CRMT_STATUS_RFC_REJECTED BOOLEAN CHAR 1   0   Request for Change Rejected  
86 STAT_REJECTED CRMT_STATUS_REJECTED BOOLEAN CHAR 1   0   Status: Rejected  
87 STAT_LOCK CRMT_STATUS_LOCK BOOLEAN CHAR 1   0   Locked  
88 PATH_ID CRMT_TERRITORY_PATH_ID CRM_TERRITORY_PATH_ID CHAR 30   0   Territory Hierarchy ID  
89 TERR_ID CRMT_TERRITORY_ID CRM_TERRITORY_ID CHAR 30   0   Territory ID  
90 TERR_DESCRIP CRMT_TERRITORY_DESCRIPTION TEXT40 CHAR 40   0   Territory Description  
91 PATH_GUID CRMT_TERRITORY_PATH_GUID SYSUUID RAW 16   0   Territory Path GUID  
92 TERR_GUID CRMT_TERRITORY_GUID SYSUUID RAW 16   0   Territory GUID  
93 INPUT_CHANNEL CRMT_INPUT_CHANNEL CRM_INPUT_CHANNEL CHAR 3   0   Input channel  
94 BTX_CLASS CRMT_TRANSACTION_CLASSIFICATN CRM_TRANSACTION_CLASSIFICATION CHAR 1   0   CRM Business Transaction Classification  
95 AUTH_SCOPE CRM_AUTH_SCOPE CRM_AUTH_SCOPE NUMC 6   0   Authorization Scope *
96 DESCRIPTION_UC CRMT_PROCESS_DESCRIPTION_UC CRM_PROCESS_DESCRIPTION_UC CHAR 40   0   Transaction Description (Upper Case)  
97 .INCLUDE       0   0   organizational Data Sales Part 2  
98 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
99 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
100 .INCLUDE       0   0   Organizational Data (Service)  
101 SERVICE_ORG CRMT_SERVICE_ORG HROBJEC_14 CHAR 14   0   Service Organization  
102 SERVICE_ORG_RESP CRMT_SERVICE_ORG_RESP HROBJEC_14 CHAR 14   0   Organizational Unit (Service)  
103 .INCLUDE       0   0   Purchasing Organizational Data  
104 PURCH_ORG CRMT_PURCH_ORG HROBJEC_14 CHAR 14   0   Purchasing Organization  
105 PURCH_GROUP CRMT_PURCH_GROUP HROBJEC_14 CHAR 14   0   Purchasing Group  
106 PURCH_ORG_RESP CRMT_PURCH_ORG_RESP HROBJEC_14 CHAR 14   0   Organizational Unit (Purchasing)  
107 .INCLUDE       0   0   Sales Organization Data Part 1  
108 SALES_ORG CRMT_SALES_ORG HROBJEC_14 CHAR 14   0   Sales Organization ID  
109 SALES_OFFICE CRMT_SALES_OFFICE HROBJEC_14 CHAR 14   0   Sales Office  
110 SALES_GROUP CRMT_SALES_GROUP HROBJEC_14 CHAR 14   0   Sales Group  
111 SALES_ORG_RESP CRMT_SALES_ORG_RESP HROBJEC_14 CHAR 14   0   Organizational Unit (Sales)  
112 HOSTING_ORG CRMT_HOSTING_ORG HROBJEC_14 CHAR 14   0   Hosting Org. Unit  
113 .INCLUDE       0   0   Company code and Logical system for Business Document.  
114 IC_BD_CCODE CRM_IC_BD_CCODE BUKRS CHAR 4   0   Company Code for a Business Transaction *
115 IC_BD_LOGSYS CRM_IC_BD_LOGSYS LOGSYS CHAR 10   0   Logical System for a Business Transaction *
116 .INCLUDE       0   0   Abbreviation Organizational Data Sales  
117 SALES_ORG_SHORT CRMT_SALES_ORG_SHORT TEXT12 CHAR 12   0   Sales Organization: Description of Department  
118 SALES_OFFICE_SHORT CRMT_SALES_OFFICE_SHORT TEXT12 CHAR 12   0   Sales Office Abbreviation  
119 SALES_GROUP_SHORT CRMT_SALES_GROUP_SHORT TEXT12 CHAR 12   0   Sales Group Abbreviation  
120 SALES_ORG_RESP_SHORT CRMT_SALES_ORG_RESP_SHORT TEXT12 CHAR 12   0   Abbreviation: Responsible Organizational Unit (Sales)  
121 .INCLUDE       0   0   Cancellation set: Structure with external fields  
122 CANCPROC CRMT_CANC_PROCEDURE CRM_CANCPROCEDURE CHAR 4   0   Cancellation Procedure  
123 CANCPARTY CRMT_CANC_PARTY CRM_CANC_PARTY CHAR 4   0   Cancelling Party  
124 CANC_REASON CRMT_SRV_CANCEL_REASON QCODE CHAR 4   0   CRM Service : Reason for Cancellation *
125 .INCLUDE       0   0   External Fields for External References  
126 REFERENCE_TYPE CRMT_EXT_REF_TYPE CRM_EXT_REF_TYPE CHAR 4   0   Type of External Reference *
127 REFERENCE_NUMBER CRMT_EXT_REF_NUM TEXT35 CHAR 35   0   External Reference Number  
128 .INCLUDE       0   0   Law Reference Header Segment External Fields  
129 HEADER_GUID CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
130 LAW_ID CRM_ICM_LAW_ID CRM_ICM_LAW_ID CHAR 32   0   Legal Reference ID  
131 LAW_GRP_ID CRM_ICM_LAW_GRPID CRM_ICM_LAW_GRPID CHAR 22   0   Legal Reference Group ID  
132 MAIN_REF CRM_LAWREF_MAIN CRM_BOOLEAN CHAR 1   0   Legal Reference Main Reference Flag  
133 ATTEMPT_FLAG CRM_LAWREF_ATTEMPT CRM_BOOLEAN CHAR 1   0   Legal Reference Attempt Flag  
134 .INCLUDE       0   0   Extensibility Include for ICM Law Reference  
135 LAWREF DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
136 .INCLUDE       0   0   EEW Extension  
137 ORDERADM_H_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
138 .INCLUDE       0   0    
139 .INCLUDE       0   0   Payment Service Provider Data  
140 PAYM_SRV_PROV COM_WEC_PAYMENT_SRV_PROVIDER COM_WEC_PAYMENT_SRV_PROVIDER CHAR 4   0   Payment Service Provider *
141 PAYM_TRANS_GUID COM_WEC_TRANSACTION_GUID COM_WEC_TRANSACTION_GUID RAW 16   0   Payment Transaction Reference GUID  
142 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  
143 PSP_TRANS_AMT COM_WEC_TRANSACTION_AMOUNT WERTV8 CURR 15   2   Payment Transaction Amount  
144 PSP_TRANS_CURR COM_WEC_TRANSACTION_CURRENCY WAERS CUKY 5   0   Payment Transaction Currency *
145 PSP_STATUS_PF COM_WEC_TRANSACTION_PROFILE COM_WEC_TRANSACTION_PROFILE CHAR 4   0   Payment Status Profile *
146 PSP_STATUS COM_WEC_TRANSACTION_STATUS COM_WEC_TRANSACTION_STATUS CHAR 4   0   Payment Transaction Status *
History
Last changed by/on SAP  20130604 
SAP Release Created in 20C