SAP ABAP Table CRMT_CSDR_BW_PROJ_H (Project Assembly extracted master data details)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-IHT-PDP (Application Component) Partner Design Projects
     CRM_CSDR_BWA_MAP (Package) Project Assembly Extraction for design registration
Basic Data
Table Category INTTAB    Structure 
Structure CRMT_CSDR_BW_PROJ_H   Table Relationship Diagram
Short Description Project Assembly extracted master data details    
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   Partners for the Project / Assembly  
2 DR_BRANCH CMST_PROJ_DR_BRCH BU_PARTNER CHAR 10   0   Channel Partner Branch *
3 CHANNEL_PARTNER CMST_CHANNEL_PARTNER BU_PARTNER CHAR 10   0   Channel Partner *
4 FAE BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
5 CORP_CHANNEL_PARTNER CMST_CORPORATE_CHANNEL_PARTNER BU_PARTNER CHAR 10   0   Corporate Channel Partner *
6 CLAIMING_ACCOUNT CMST_CLAIMING_ACCOUNT BU_PARTNER CHAR 10   0   Claiming Account *
7 INVOICE_RECIPIENT CRMT_INVOICE_RECIPIENT BU_PARTNER CHAR 10   0   Invoice Recipient *
8 ERP_DISP_CASE_PROCESSOR CMST_ERP_DISP_CASE_PROCESSOR BU_PARTNER CHAR 10   0   Corporate Channel Partner *
9 ERP_DISP_CASE_COORDINATOR CMST_ERP_DISP_CASE_PROCESSOR BU_PARTNER CHAR 10   0   Corporate Channel Partner *
10 ERP_DISP_CASE_RESPONSIBLE CMST_ERP_DISP_CASE_RESPONSIBLE BU_PARTNER CHAR 10   0   Corporate Channel Partner *
11 .INCLUDE       0   0   The extra date fields for the Project / Assembly master data  
12 PROD_DATE CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
13 EXP_DATE CRMT_DATE_TIMESTAMP_TO BCOS_TSTMP DEC 15   0   Time stamp (Date and Time) until a Date/Duration  
14 PROT_DATE CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
15 .INCLUDE       0   0   BW Datasource for CRM Opportunities: Header Data  
16 .INCLUDE       0   0   ORDERADM_H Data for BW DataSources  
17 CLIENT MANDT MANDT CLNT 3   0   Client *
18 GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
19 OBJECT_ID CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
20 PROCESS_TYPE CRMT_PROCESS_TYPE CRM_PROCESS_TYPE CHAR 4   0   Business Transaction Type *
21 POSTING_DATE CRMT_POSTING_DATE   DATS 8   0   Posting Date for a Business Transaction  
22 DESCRIPTION_UC CRMT_PROCESS_DESCRIPTION_UC CRM_PROCESS_DESCRIPTION_UC CHAR 40   0   Transaction Description (Upper Case)  
23 DESCR_LANGUAGE CRMT_PROCESS_DESCRIPTION_LANGU SPRAS LANG 1   0   Language Key of Description *
24 LOGICAL_SYSTEM CRMT_LOGSYS LOGSYS CHAR 10   0   Logical System *
25 OBJECT_TYPE CRMT_SUBOBJECT_CATEGORY CRM_OJ_NAME_PROCESS CHAR 10   0   Business Transaction Category CRMC_SUBOB_CAT
26 CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
27 CREATED_BY CRMT_CREATED_BY UNAME CHAR 12   0   User that Created the Transaction  
28 CHANGED_AT CRMT_OPPT_CHANGED_AT DATUM DATS 8   0   Time of Last Change to the Transaction  
29 CHANGED_BY CRMT_CHANGED_BY UNAME CHAR 12   0   Transaction Last Changed By  
30 RECORDMODE RODMUPDMOD RODMUPDMOD CHAR 1   0   BW Delta Process: Record Mode  
31 NUM_OF_HEAD CRMT_NUMBER_OF_H INT4 INT4 10   0   Order Header Number  
32 OCCURRENCE CRMT_OCC_AT_LEAST_ONCE CRM_BOOLEAN CHAR 1   0   Counter: Document Cat. Appears at Least Once in Document  
33 SCENARIO CRMT_SCENARIO CRM_SCENARIO CHAR 10   0   Scenario Identity  
34 TEMPLATE_TYPE CRMT_TEMPLATE_TYPE_DB CRM_TEMPLATE_TYPE CHAR 1   0   Template Type of CRM Transaction  
35 OCCURR_QUOT CRMT_QUO_AT_LEAST_ONCE CRM_BOOLEAN CHAR 1   0   Counter: Document Cat. Appears at Least Once in Document  
36 OCCURR_CONT CRMT_CON_AT_LEAST_ONCE CRM_BOOLEAN CHAR 1   0   Counter: Document Cat. Appears at Least Once in Document  
37 REF_UPDATE CRMT_FLG_REF_UPDATE_BW XFELD CHAR 1   0   Flag: Ref. Update (Extract Structure Only Partially Filled)  
38 INPUT_CHANNEL CRMT_INPUT_CHANNEL CRM_INPUT_CHANNEL CHAR 3   0   Input channel  
39 CREATED_TS COMT_CREATED_AT_USR COM_TSTMP DEC 15   0   Created At (Output in User Time Zone)  
40 CHANGED_TS COMT_CHANGED_AT_USR COM_TSTMP DEC 15   0   Changed At (Output in User Time Zone)  
41 .INCLUDE       0   0   OPPORT_H Data for BW DataSources  
42 OPPT_GUID CDBT_OPPORT_H_GUID SYSUUID RAW 16   0   Opportunity header own guid.  
43 STARTDATE CRMT_STARTDATE DATUM DATS 8   0   Opportunity Start Date  
44 EXPECT_END CRMT_EXPECT_END DATUM DATS 8   0   Expected Closing Date  
45 CURR_PHASE CRMT_CURR_PHASE CRM_PHASE CHAR 3   0   Sales Stage *
46 PHASE_SINCE CRMT_PHASE_SINCE DATUM DATS 8   0   Sales Stage Since  
47 IMPORTANCE CRMT_IMPORTANCE CRM_IMPORTANCE CHAR 1   0   Opportunity/Lead Priority *
48 SALESCYCLE CRMT_SALESCYCLE CRM_SALESCYCLE CHAR 5   0   Sales Cycle *
49 TYPE CRMT_OPPORT_TYPE CRM_OPPORT_TYPE CHAR 4   0   Opportunity Type *
50 CONTROL_PHASE CRMT_CON_PHASE CRM_CON_PHASE CHAR 3   0   Analysis Stage *
51 EXP_REVENUE CRMT_EXP_REVENUE WERTV8 CURR 15   2   Expected Sales Volume  
52 BUDGET_BP CRMT_BUDGET_BP WERTV8 CURR 15   2   Budget Prospect  
53 PROBABILITY CRMT_PROBABILITY CRM_PROBABILITY NUMC 3   0   Chance of Success  
54 DURATION CRMT_DURATION CRM_DURATION NUMC 3   0   Expected Duration of Sales Stage in Days  
55 STATUS_OPPT CRMT_STATUS_OPPORTUNITY CRM_J_STATUS CHAR 5   0   Opportunity Status  
56 STATUS_SINCE CRMT_STATUS_SINCE DATUM DATS 8   0   Status Since  
57 BW_POST_DATE CRMT_BW_POST_DATE CRM_RPRTNG_DATE DATS 8   0   Posting Date for BW Reporting  
58 NUMBER_OF_H CRMT_NUMBER_OF_H INT4 INT4 10   0   Order Header Number  
59 SYS_PROBABILITY CRMT_SYSTEM_PROBABILITY CRM_SYSTEM_PROBABILITY NUMC 3   0   Chance of Success of Opportunity - Calculated by System  
60 SOURCE CRMT_SOURCE CRM_SOURCE CHAR 3   0   Origin of Opportunity/Lead *
61 FORECAST_REL CRMT_FORECAST_REL CRM_FORECAST_REL CHAR 1   0   Forecast Relevance  
62 DESCRIPTION_OPP CRMT_DESCRIPTION_OPP TEXT40 CHAR 40   0   Opportunity Description  
63 .INCLUDE       0   0   PARTNER (General) Data for BW DataSoures  
64 SALES_EMPLOYEE CRMT_SALES_EMPLOYEE BU_PARTNER CHAR 10   0   Employee *
65 PERSON_RESP CRMT_PERSON_RESP BU_PARTNER CHAR 10   0   Employee Responsible *
66 CONTACT_PERSON CRMT_CONTACT_PERSON BU_PARTNER CHAR 10   0   Customer Contact Person *
67 SALESPARTNER CRMT_SALESPARTNER BU_PARTNER CHAR 10   0   Sales Partners *
68 RESP_GROUP_RFW CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
69 PLANNING_ACCOUNT CRMT_PLANNING_ACCOUNT BU_PARTNER CHAR 10   0   Planning Account *
70 .INCLUDE       0   0   PARTNER (Opportunity/Activity) Data for BW DataSoures  
71 COMPETITOR CRMT_COMPETITOR BU_PARTNER CHAR 10   0   Competitors *
72 PROSPECT CRMT_PROSPECT BU_PARTNER CHAR 10   0   Prospect *
73 ACTIVITY_PARTNER CRMT_ACTIVITY_PARTNER BU_PARTNER CHAR 10   0   Activity Partner *
74 .INCLUDE       0   0   PARTNER (Call Center) Data for BW Datasoures  
75 EXECUTING_CC CRMT_EXECUTING_CC BU_PARTNER CHAR 10   0   Executing Interaction Center *
76 RESP_GROUP CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
77 .INCLUDE       0   0   ORGMAN Data for BW DataSources  
78 SALES_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
79 SALES_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
80 SALES_OFFICE OBJEKTID NUM08 NUMC 8   0   Object ID  
81 SALES_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
82 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
83 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
84 SERVICE_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
85 SERVICE_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
86 PURCH_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
87 PURCH_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
88 PURCH_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
89 IC_BD_CCODE CRM_IC_BD_CCODE BUKRS CHAR 4   0   Company Code for a Business Transaction *
90 IC_BD_LOGSYS CRM_IC_BD_LOGSYS LOGSYS CHAR 10   0   Logical System for a Business Transaction *
91 .INCLUDE       0   0   PRICING_H Data for BW DataSources  
92 EXCHG_TYPE CRMT_EXCHG_TYPE KURST CHAR 4   0   Exchange Rate Type *
93 EXCHG_DATE CRMT_EXCHG_DATE CRM_EXCHG_DATE DATS 8   0   Exchange Rate Date  
94 EXCHG_RATE CRMT_EXCHG_RATE CRM_EXCHG_RATE DEC 9   5   Exchange Rate  
95 CURRENCY CRMT_CURRENCY WAERS CUKY 5   0   Currency *
96 PRICE_DATE CRMT_PRICE_DATE CRM_PRICE_DATE DATS 8   0   Pricing Date  
97 REF_CURRENCY CRMT_REF_CURRENCY WAERS CUKY 5   0   Reference Currency *
98 PMNTTRMS CRMT_PMNTTRMS CRM_PMNTTRMS CHAR 4   0   Terms of Payment *
99 CUST_GROUP CRMT_CUST_GROUP CRM_CUST_GROUP CHAR 2   0   Customer Group *
100 CUSTOMER_TYPE CRMT_CUSTOMER_TYPE BU_KIND CHAR 4   0   Business Partner Type *
101 .INCLUDE       0   0   SRV_OSSET Data for BW DataSources  
102 KATALOGART COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
103 CODEGRUPPE QCODEGRP QCODEGRP CHAR 8   0   Code Group *
104 CODE QCODE QCODE CHAR 4   0   Code *
105 ACT_REASON_CAT COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
106 ACT_REASON_GROUP QCODEGRP QCODEGRP CHAR 8   0   Code Group *
107 ACT_REASON_CODE QCODE QCODE CHAR 4   0   Code *
108 EXT_REFOBJ CRMT_EXT_REFOBJ CHAR40 CHAR 40   0   External Reference Object  
109 .INCLUDE       0   0   Time Characteristics for BW Reporting  
110 CALDAY SMOCALDAY DATUM DATS 8   0   Calendar Day  
111 CALDAY_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
112 .INCLUDE       0   0   DOC_FLOW Data for BW DataSources  
113 PREDEC_OBJKEY CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
114 PREDEC_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
115 LOGSYS_PRED CRMT_LOGSYS LOGSYS CHAR 10   0   Logical System *
116 MKT_ELEMENT CRM_MKTPL_MKT_PLAN_TASKID CGPL_EXTID CHAR 24   0   Marketing Plan Element  
117 PRED_LEAD_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
118 LEAD_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
119 PRED_OPPT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
120 OPPT_CREATED_AT CRMT_OPPT_CREATED_AT DATUM DATS 8   0   Transaction Was Created at This Time  
121 PRED_ACT_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
122 ACT_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
123 ACT_DIRECTION CRMT_DIRECTION CRM_DIRECTION CHAR 1   0   Direction of an Activity  
124 QUOTATION_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
125 QUOT_VALID_FROM CRMT_VALID_FROM_DATE CRM_RPRTNG_DATE DATS 8   0   Quotation Valid from Date  
126 PROCESS_CATEGORY CRMT_ACTIVITY_CATEGORY CRM_ACTIVITY_CATEGORY CHAR 3   0   Activity Category (Communication Type) *
127 PROCESS_CATALOG COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
128 PROCESS_CODEGR QCODEGRP QCODEGRP CHAR 8   0   Code Group *
129 PROCESS_CODE QCODE QCODE CHAR 4   0   Code *
130 PROCESS_OBJTYPE CRMT_PRED_OBJECT_TYPE OJ_NAME CHAR 10   0   Object Type of a Preceding Document *
131 PO_NUMBER CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
132 PO_ITEM_NUMBER CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
133 LEAD_CREATED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
134 OPPT_CREATED_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
135 QUOT_VALID_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
136 .INCLUDE       0   0   STATUS GROUPS Data for BW Datasources  
137 BWSTONESYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
138 BWSTONESYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
139 BWSTONESYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
140 BWSTONESYS3 CRMBWST J_STONR NUMC 2   0   BW Status  
141 BWSTONESYS4 CRMBWST J_STONR NUMC 2   0   BW Status  
142 BWSTONESYS5 CRMBWST J_STONR NUMC 2   0   BW Status  
143 BWSTONESYS6 CRMBWST J_STONR NUMC 2   0   BW Status  
144 BWSTONESYS7 CRMBWST J_STONR NUMC 2   0   BW Status  
145 BWSTONESYS8 CRMBWST J_STONR NUMC 2   0   BW Status  
146 BWSTONESYS9 CRMBWST J_STONR NUMC 2   0   BW Status  
147 BWSTONESYSA CRMBWST J_STONR NUMC 2   0   BW Status  
148 BWSTTECSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
149 BWSTTECSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
150 BWSTTECSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
151 BWSTLOCSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
152 BWSTLOCSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
153 BWSTLOCSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
154 BWSTONESYSB CRMBWST J_STONR NUMC 2   0   BW Status  
155 BWSTONESYSC CRMBWST J_STONR NUMC 2   0   BW Status  
156 .INCLUDE       0   0   Territory Data for BW Data Sources (Partner Attribute)  
157 PATH_GUID CRMT_PATH_GUID_32 SYSUUID_C CHAR 32   0   Path GUID of Territory 32  
158 TERR_GUID CRMT_TERR_GUID_32 SYSUUID_C CHAR 32   0   Territory GUID 32  
159 .INCLUDE       0   0   Opportunity Hierarchy Data for BW Data Sources  
160 MAST_OPP_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
161 MAST_OPITEM_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
162 SUB_OPP_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
163 MASTEROPP_FLAG CRMT_MASTEROPP_FLAG CRMT_MASTEROPP_FLAG CHAR 1   0   Flag to indicate master opportunity  
164 .INCLUDE       0   0   Object References for BW DataSources  
165 REF_IOBJECT_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
166 REF_IOBJECT_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
167 REF_CONF_PROD_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
168 REF_CONF_PROD_GU COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
169 REF_PROD_ID COMT_PRODUCT_ID COM_PRODUCT_ID CHAR 40   0   Product ID  
170 REF_PROD_GUID COMT_PRODUCT_GUID SYSUUID RAW 16   0   Internal Unique ID of Product  
171 REF_OBJ_FAM COMT_PRODUCT_OBJECT_FAMILY COM_PRODUCT_OBJECT_FAMILY CHAR 4   0   Object Family *
172 REF_BUAG_ID CRMT_BUAG_ID CRMT_BUAG_ID CHAR 12   0   Number of Business Agreement  
173 REF_BUAG_GUID CRMT_BUAG_GUID_C SYSUUID_C CHAR 32   0   GUID of Business Agreement in Character Format  
174 REF_NO_ITEMS CRMT_NUMBER_OF_I INT4 INT4 10   0   Order Item Number  
175 .INCLUDE       0   0   CUOBJ for BW DataSources  
176 CUOBJ CRMT_INT_OBJ_NO IB_INSTANCE NUMC 18   0   Configuration (Internal Object Number)  
177 .INCLUDE       0   0   PARTNER (Locator) Various Partner Functions  
178 INSTALL_AT CRMT_INSTALL_AT_PART BU_PARTNER CHAR 10   0   Installed At *
179 INSTALL_AT_LIST CRMT_INSTALL_AT_LIST CHAR80 CHAR 80   0   Installed At - Name  
180 RESPONS_AT_PARTNER CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
181 END_CUSTOMER CRMT_END_CUSTOMER BU_PARTNER CHAR 10   0   End Customer (Channel Management) *
182 RESP_AT_PART CRMT_RESPONSIBLE_AT_PARTNER BU_PARTNER CHAR 10   0   Person Responsible at Partners (Channel Management) *
183 .INCLUDE       0   0   Specific Opportunity Header Fields for BW DataSource  
184 BWSTONEOPPT CRMBWST J_STONR NUMC 2   0   BW Status  
185 OEM CRMT_OEM BU_PARTNER CHAR 10   0   Original Equipment Manufacturer *
186 DES_SRV_PROV CRMT_SALESPARTNER BU_PARTNER CHAR 10   0   Sales Partners *
187 MS_TECH_REP CRMT_SALES_EMPLOYEE BU_PARTNER CHAR 10   0   Employee *
188 OEM_PROD_LOC CRMT_SHIP_TO_PART BU_PARTNER CHAR 10   0   Ship-To Party *
189 MS_SALES_MGR CRMT_SALES_EMPLOYEE BU_PARTNER CHAR 10   0   Employee *
190 MS_SALES_REP CRMT_PERSON_RESP BU_PARTNER CHAR 10   0   Employee Responsible *
191 OEM_DES_ENGG CRMT_CONTACT_PERSON BU_PARTNER CHAR 10   0   Customer Contact Person *
192 OEM_DES_LOC CRMT_ACTIVITY_PARTNER BU_PARTNER CHAR 10   0   Activity Partner *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_CSDR_BW_PROJ_H OBJECT_TYPE CRMC_SUBOB_CAT SUBOBJ_CATEGORY    
History
Last changed by/on SAP  20130604 
SAP Release Created in 400