SAP ABAP Table CRMT_BSP_LAM_OD1_GENERAL (Sales ODC1 - General)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-FIN (Application Component) Financing
     ⤷ CRM_BSP_MODEL_IL_LEASING (Package) Model Implementation: Leasing

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_LAM_OD1_GENERAL	Table Relationship Diagram
Short Description	Sales ODC1 - General

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	Quotation OIC - Date Fields (Object IL Dates)
2	APPT_TYPE1	☐	SC_APPTTYP	SC_APPTTYP	CHAR	12	0	Technical Date Type Name	*
3	IS_DURATION1	☐	CRMT_IS_DURATION	CRM_BOOLEAN	CHAR	1	0	Indicates a Date as Duration in Date Definition
4	APPT_TEXT1	☐	SC_TXT	TEXT40	CHAR	40	0	Description
5	DATE1	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
6	APPT_TYPE2	☐	SC_APPTTYP	SC_APPTTYP	CHAR	12	0	Technical Date Type Name	*
7	IS_DURATION2	☐	CRMT_IS_DURATION	CRM_BOOLEAN	CHAR	1	0	Indicates a Date as Duration in Date Definition
8	APPT_TEXT2	☐	SC_TXT	TEXT40	CHAR	40	0	Description
9	DATE2	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
10	.INCLUDE	☐				0	0	Overview of Partner Fields with Partner Function
11	SALES_EMPLOYEE_LIST	☐	CRMT_SALES_EMPLOYEE_LIST	TEXT80	CHAR	80	0	Sales Representative
12	PERSON_RESP_LIST	☐	CRMT_PERSON_RESP_LIST	TEXT80	CHAR	80	0	Employee Responsible
13	CONTACT_PERSON_LIST	☐	CRMT_CONTACT_PERSON_LIST	TEXT80	CHAR	80	0	Contact Person
14	SOLD_TO_PARTY_LIST	☐	CRMT_SOLD_TO_PART_LIST	TEXT80	CHAR	80	0	Sold-To Party
15	SHIP_TO_PARTY_LIST	☐	CRMT_SHIP_TO_PART_LIST	TEXT80	CHAR	80	0	Ship-To Party: Name
16	BILL_TO_PARTY_LIST	☐	CRMT_BILL_TO_PART_LIST	TEXT80	CHAR	80	0	Bill-To Party: Name
17	PAYER_LIST	☐	CRMT_RP_PAYER_LIST	TEXT80	CHAR	80	0	Payer: Name
18	COMPETITOR_LIST	☐	CRMT_COMPETITOR_LIST	TEXT80	CHAR	80	0	Competitor
19	PROSPECT_LIST	☐	CRMT_PROSPECT_LIST	TEXT80	CHAR	80	0	Sales Prospect
20	SALESPARTNER_LIST	☐	CRMT_SALESPARTNER_LIST	TEXT80	CHAR	80	0	Sales Partner
21	ACTIVITY_PARTNER_LIST	☐	CRMT_ACTIVITY_PARTNER_LIST	TEXT80	CHAR	80	0	Activity Partner
22	SERVICE_TEAM_LIST	☐	CRMT_SERVICE_GROUP_LIST	TEXT80	CHAR	80	0	Service Employee Group
23	SERVICE_EMPLOYEE_LIST	☐	CRMT_SERVICE_EMPLOYEE_LIST	TEXT80	CHAR	80	0	Responsible Service Employee
24	RELEASE_PARTNER_LIST	☐	CRMT_RELEASE_PARTNER_LIST	TEXT80	CHAR	80	0	Authorized Partner
25	PTR_FCT_SALES_EMPLOYEE	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
26	PTR_FCT_PERSON_RESP	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
27	PTR_FCT_CONTACT_PERSON	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
28	PTR_FCT_SOLD_TO_PARTY	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
29	PTR_FCT_SHIP_TO_PARTY	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
30	PTR_FCT_BILL_TO_PARTY	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
31	PTR_FCT_PAYER	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
32	PTR_FCT_COMPETITOR	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
33	PTR_FCT_PROSPECT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
34	PTR_FCT_SALESPARTNER	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
35	PTR_FCT_ACTIVITY_PARTNER	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
36	PTR_FCT_SERVICE_TEAM	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
37	PTR_FCT_SERVICE_EMPLOYEE	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
38	PTR_FCT_RELEASE_PARTNER	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
39	LGL_KEY_SALES_EMPLOYEE	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
40	LGL_KEY_PERSON_RESP	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
41	LGL_KEY_CONTACT_PERSON	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
42	LGL_KEY_SOLD_TO_PARTY	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
43	LGL_KEY_SHIP_TO_PARTY	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
44	LGL_KEY_BILL_TO_PARTY	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
45	LGL_KEY_PAYER	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
46	LGL_KEY_COMPETITOR	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
47	LGL_KEY_PROSPECT	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
48	LGL_KEY_SALESPARTNER	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
49	LGL_KEY_ACTIVITY_PARTNER	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
50	LGL_KEY_SERVICE_TEAM	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
51	LGL_KEY_SERVICE_EMPLOYEE	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
52	LGL_KEY_RELEASE_PARTNER	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
53	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
54	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
55	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
56	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
57	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
58	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
59	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
60	AUTH_SOLD_TO_PARTY	☐	CRMT_AUTH_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Authorized Sold-To Party	*
61	COMPETITOR	☐	CRMT_COMPETITOR	BU_PARTNER	CHAR	10	0	Competitors	*
62	PROSPECT	☐	CRMT_PROSPECT	BU_PARTNER	CHAR	10	0	Prospect	*
63	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
64	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
65	SERVICE_TEAM	☐	CRMT_SERVICE_TEAM	BU_PARTNER	CHAR	10	0	Service Team	*
66	SERVICE_EMPLOYEE	☐	CRMT_SERVICE_EMPLOYEE	BU_PARTNER	CHAR	10	0	Executing Service Employee	*
67	PARTNER_KEY_SALES_EMPLOYEE	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
68	PARTNER_KEY_PERSON_RESP	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
69	PARTNER_KEY_CONTACT_PERSON	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
70	PARTNER_KEY_SOLD_TO_PARTY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
71	PARTNER_KEY_SHIP_TO_PARTY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
72	PARTNER_KEY_BILL_TO_PARTY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
73	PARTNER_KEY_PAYER	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
74	PARTNER_KEY_COMPETITOR	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
75	PARTNER_KEY_PROSPECT	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
76	PARTNER_KEY_SALESPARTNER	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
77	PARTNER_KEY_ACTIVITY_PARTNER	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
78	PARTNER_KEY_SERVICE_TEAM	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
79	PARTNER_KEY_SERVICE_EMPLOYEE	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
80	PARTNER_KEY_RELEASE_PARTNER	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
81	RESP_AT_PARTNER_LIST	☐	CRMT_RESP_AT_PARTNER_LIST	TEXT80	CHAR	80	0	Responsible at Partner
82	PTR_FCT_RESP_AT_PARTNER	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
83	LGL_KEY_RESP_AT_PARTNER	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
84	PARTNER_KEY_RESP_AT_PARTNER	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
85	RESP_AT_PARTNER	☐	CRMT_RESP_AT_PARTNER	BU_PARTNER	CHAR	10	0	Responsible at Partner	*
86	END_CUSTOMER_LIST	☐	CRMT_END_CUSTOMER_LIST	TEXT80	CHAR	80	0	End Customer Name (Channel Management)
87	PTR_FCT_END_CUSTOMER	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
88	LGL_KEY_END_CUSTOMER	☐	CRMT_LOGICAL_KEY	CRM_LOGICAL_KEY	CHAR	42	0	Logical Key for Subobject
89	PARTNER_KEY_END_CUSTOMER	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
90	END_CUSTOMER	☐	CRMT_END_CUSTOMER	BU_PARTNER	CHAR	10	0	End Customer (Channel Management)	*
91	URL_OBJECT_TYPE_CONTACT_PERSON	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
92	.INCLUDE	☐				0	0	Dynamic URL Definition
93	SALES_EMPLOYEE_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
94	SALES_EMPLOYEE_URL_OBJECT_TYPE	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
95	SALES_EMPLOYEE_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
96	PERSON_RESP_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
97	PERSON_RESP_URL_OBJECT_TYPE	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
98	PERSON_RESP_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
99	SOLD_TO_PARTY_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
100	SOLD_TO_PARTY_URL_OBJECT_TYPE	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
101	SOLD_TO_PARTY_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
102	SHIP_TO_PARTY_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
103	SHIP_TO_PARTY_URL_OBJECT_TYPE	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
104	SHIP_TO_PARTY_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
105	BILL_TO_PARTY_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
106	BILL_TO_PARTY_URL_OBJECT_TYPE	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
107	BILL_TO_PARTY_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
108	PAYER_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
109	PAYER_URL_OBJECT_TYPE	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
110	PAYER_NAVIGATION_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
111	COMPETITOR_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
112	COMPETITOR_URL_OBJECT_TYPE	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
113	COMPETITOR_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
114	PROSPECT_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
115	PROSPECT_URL_OBJECT_TYPE	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
116	PROSPECT_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
117	SALESPARTNER_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
118	SALESPARTNER_URL_OBJECT_TYPE	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
119	SALESPARTNER_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
120	ACTIVITY_PARTNER_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
121	ACTIVITY_PARTNER_URL_OBJECT_TY	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
122	ACTIVITY_PARTNER_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
123	RESP_AT_PARTNER_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
124	RESP_AT_PARTNER_URL_OBJECT_TYP	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
125	RESP_AT_PARTNER_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
126	END_CUSTOMER_JUMP_TO_APPL	☐	CRMT_BSP_APPL	CRM_BSP_APPL	CHAR	20	0	Application Scenario	*
127	END_CUSTOMER_URL_OBJECT_TYPE	☐	CRMT_PRT_OTYPE	CRMT_PRT_OTYPE	CHAR	20	0	Object Type for Navigation	*
128	END_CUSTOMER_MTD	☐	CRMT_PRT_MTD	CRMT_PRT_MTD	CHAR	20	0	Method for Navigation	*
129	.INCLUDE	☐				0	0	Name of Partners
130	SALES_EMPLOYEE_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
131	PERSON_RESP_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
132	CONTACT_PERSON_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
133	SOLD_TO_PARTY_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
134	SHIP_TO_PARTY_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
135	BILL_TO_PARTY_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
136	PAYER_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
137	COMPETITOR_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
138	PROSPECT_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
139	SALESPARTNER_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
140	SERVICE_TEAM_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
141	SERVICE_EMPLOYEE_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
142	RELEASE_PARTNER_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
143	ACTIVITY_PARTNER_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
144	RESP_AT_PARTNER_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
145	END_CUSTOMER_NAME	☐	COMT_BSP_BP_PARTNER_NAME	TEXT80	CHAR	80	0	Contains Business Partner's Full Name
146	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
147	.INCLUDE	☐				0	0	BSP LAM: General Data
148	.INCLUDE	☐				0	0	Management of Interface Structures
149	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
150	HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
151	.INCLUDE	☐				0	0	Sales: General Data
152	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
153	.INCLUDE	☐				0	0	Sales: Sales Data
154	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	*
155	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	*
156	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	*
157	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
158	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	*
159	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
160	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date
161	YOUR_REF_SOLD	☐	CRMT_YOUR_REFERENCE_SOLD	TEXT12	CHAR	12	0	Sold-to Party Reference
162	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	*
163	REGION	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
164	PO_NUMBER_SHIP	☐	CRMT_PO_NUMBER_SHIP	TEXT35	CHAR	35	0	Ship-To Party's External Reference Number
165	PO_DATE_SHIP	☐	CRMT_PO_DATE_SHIP	DATUM	DATS	8	0	Ship-To Party's Reference Document Date
166	YOUR_REF_SHIP	☐	CRMT_YOUR_REFERENCE_SHIP	TEXT12	CHAR	12	0	Ship-To Party Reference
167	USAGE_TYPE	☐	CRMT_USAGE	CRM_USAGE	CHAR	3	0	Usage Indicator	*
168	SUBMISSION	☐	CRMT_SUBMISSION	TEXT10	CHAR	10	0	Collective Number for Quotations
169	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
170	PCAT_HDR_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
171	PCAT_VRT_ID	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
172	PCAT_CTY_ID	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
173	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
174	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
175	INT_INSPECTION	☐	CRMT_INT_INSPECTION	CRM_ITEM_INSPECTION	CHAR	4	0	Internal Quality Inspection	CRMC_ITEM_INSP
176	HNDLCODE	☐	CRM_PROD_HNDLCODE	CRM_PROD_HNDLCODE	CHAR	4	0	Handling Indicator	*
177	HNDLCODE_TEXT	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
178	.INCLUDE	☐				0	0	Sales: Delivery Data
179	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	CRMC_INCOTERM
180	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
181	SHIP_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	CRMC_SHIP_COND
182	DELI_UNLIM_TOL	☐	CRMT_DELI_UNLIM_TOL	CRM_BOOLEAN	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
183	OVER_DLV_TOL	☐	CRMT_OVER_DLV_TOL	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
184	UNDER_DLV_TOL	☐	CRMT_UNDER_DLV_TOL	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
185	DLV_PRIO	☐	CRMT_DLV_PRIO	CRM_DLV_PRIO	NUMC	2	0	Delivery Priority	*
186	ORDERCOMBIND	☐	CRMT_ORDERCOMBIND	CRM_BOOLEAN	CHAR	1	0	Indicator: Order Combination
187	PART_DLV	☐	CRMT_PART_DLV	CRM_PART_DLV	CHAR	1	0	Delivery Control
188	DLV_GROUP	☐	CRMT_DLV_GROUP	CRMT_DLV_GROUP	NUMC	3	0	Delivery Group (Items are Delivered Together)
189	PART_DLV_ITM	☐	CRMT_PART_DLV_ITM	CRM_PART_DLV_ITM	CHAR	1	0	Delivery Control (Item)
190	REQ_DATE	☐	CRMT_BSP_REQ_DLV_DATE	DATS	DATS	8	0	Requested Delivery Date: Input/Output Field
191	REQ_TIME	☐	CRMT_BSP_TIME	CHAR6	CHAR	6	0	Time
192	REQ_TIMEVALUE	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
193	REQ_DATE_TZTF	☐	CRMT_REQ_DLV_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Requested Delivery Date: Input/Output Field
194	RULE_REQ_DATE_T	☐	CRMT_RULE_REQ_DATE_T	TIMENAME	CHAR	12	0	Rule Req Delivery Date
195	TRANS_MOT	☐	CRMT_TRANS_MOT	CRM_TRANS_MOT	CHAR	2	0	Mode of Transport	CRMC_TRANS_MOT
196	GEOROUTE	☐	CRMT_GEOROUTE	CRM_GEOROUTE	CHAR	10	0	Route
197	TRANS_MEANS	☐	CRMT_TRANS_MEANS	CRM_TRANS_MEANS	CHAR	10	0	Means of Transport (from SCM System)
198	INV_BEFORE_GI	☐	CRMT_BEFORE_LOADING	CRM_BEFORE_LOADING	CHAR	1	0	Invoice Before Goods Issue (IBGI)
199	.INCLUDE	☐				0	0	Sales: Org. Management
200	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
201	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
202	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
203	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
204	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
205	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
206	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
207	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
208	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
209	SALES_OFFICE_SHORT	☐	CRMT_SALES_OFFICE_SHORT	TEXT12	CHAR	12	0	Sales Office Abbreviation
210	SALES_GROUP_SHORT	☐	CRMT_SALES_GROUP_SHORT	TEXT12	CHAR	12	0	Sales Group Abbreviation
211	SALES_ORG_RESP_SHORT	☐	CRMT_SALES_ORG_RESP_SHORT	TEXT12	CHAR	12	0	Abbreviation: Responsible Organizational Unit (Sales)
212	SERVICE_ORG_SHORT	☐	CRMT_SERVICE_ORG_SHORT	TEXT12	CHAR	12	0	Service Organization Identifier
213	SERVICE_ORG_RESP_SHORT	☐	CRMT_SERVICE_ORG_RESP_SHORT	TEXT12	CHAR	12	0	Abbreviation: Responsible Organizational Unit (Service)
214	SALES_ORG_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
215	SALES_OFFICE_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
216	SALES_GROUP_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
217	SALES_ORG_RESP_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
218	DIS_CHANNEL_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
219	SERVICE_ORG_RESP_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
220	SERVICE_ORG_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
221	DIVISION_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
222	.INCLUDE	☐				0	0	Source Organizational Data Sales
223	SALES_ORG_ORI	☐	CRMT_SALES_ORG_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Organization
224	DIS_CHANNEL_ORI	☐	CRMT_DIS_CHANNEL_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Distribution Channel
225	SALES_OFF_ORI	☐	CRMT_SALES_OFFICE_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Office
226	SALES_GROUP_ORI	☐	CRMT_SALES_GROUP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Group
227	SALES_ORGR_ORI	☐	CRMT_SALES_ORG_RESP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Scenario Organizational Unit
228	DIVISION_ORI	☐	CRMT_DIVISION_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Flag: Division
229	.INCLUDE	☐				0	0	Source Organizational Data for Service
230	SERVICE_ORG_ORI	☐	CRMT_SERVICE_ORG_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Service Organization
231	SERVICE_ORGR_ORI	☐	CRMT_SERVICE_ORG_RESP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Service Scenario Organizational Unit
232	.INCLUDE	☐				0	0	Sales: Cumulated Header Data
233	GROSS_WEIGHT	☐	CRMT_GROSS_WEIGHT_CUM	MENG15	QUAN	15	3	Gross Weight for Total Document
234	NET_WEIGHT	☐	CRMT_NET_WEIGHT_CUM	MENG15	QUAN	15	3	Net Weight of Total Document
235	VOLUME	☐	CRMT_VOLUME_CUM	MENG15	QUAN	15	3	Total Volume of Document
236	VOLUME_UNIT	☐	COMT_VOLUME_UNIT	MEINS	UNIT	3	0	Unit for the Volume of a Product	*
237	WEIGHT_UNIT	☐	COMT_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	*
238	GROSS_VALUE	☐	CRMT_GROSS_VALUE_CUM	WERTV8	CURR	15	2	Total Gross Value of Document in Document Currency
239	NET_VALUE	☐	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
240	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN_CUM	WERTV8	CURR	15	2	Expected Total Net Value of Products in Document Currency
241	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT_CUM	WERTV8	CURR	15	2	Total Tax Amount in Document Currency
242	FREIGHT	☐	CRMT_FREIGHT_CUM	WERTV8	CURR	15	2	Shipment Costs for Document in Total Document Currency
243	NET_WO_FREIGHT	☐	CRMT_NET_WO_FREIGHT_CUM	WERTV8	CURR	15	2	Header sums: Net value without freight
244	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
245	NUMBER_ITEMS	☐	CRMT_NUMBER_ITEMS		INT2	5	0	Number of items in an order
246	.INCLUDE	☐				0	0	Sales Billing Data
247	BILL_DATE	☐	CRMT_BSP_BILL_DATE	DATS	DATS	8	0	Billing Date for Billing Index and Printout
248	BILL_DATE_TZTF	☐	CRMT_BILL_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Date for Billing Index and Printout
249	INVCR_DATE_TZTF	☐	CRMT_INVCR_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Document Creation Date
250	VALUE_DATE_TZTF	☐	CRMT_VALUE_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Fixed Value Date
251	RULE_BILL_DATE_T	☐	CRMT_RULE_BILL_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Next Billing Date
252	RULE_INV_DATE_T	☐	CRMT_RULE_INVCR_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Next Billing Document Creation Date
253	RULE_VAL_DATE_T	☐	CRMT_RULE_VALUE_DATE_T	TIMENAME	CHAR	12	0	Rule for Origin of Next Fixed Value Date
254	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	*
255	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
256	BUAG_TEXT	☐	CRMT_BUAG_TEXT	CHAR30LOW	CHAR	30	0	Text for Business Agreement
257	.INCLUDE	☐				0	0	Sales: PRICING
258	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	CRMC_PMNTTRMS
259	PMNTTRMS_T	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
260	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
261	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
262	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
263	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
264	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	*
265	TAX_DEST_CTY_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
266	TAX_DEST_REG	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
267	TAX_DEST_REG_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
268	VAT_REG_NO	☐	CRMT_VAT_REG_NO		CHAR	20	0	Sales tax registration number
269	TAXJURCODE	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
270	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	*
271	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
272	PRICE_GRP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	*
273	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	*
274	PRICING_PROCEDURE	☐	PRCT_PRIC_PROC	PRC_PRIC_PROC	CHAR	6	0	Pricing Procedure	*
275	ETAX_HAND_TYPE	☐	CRMT_ETAX_HAND_TYPE	CRM_ETAX_HAND_TYPE	CHAR	2	0	Excise Tax Handling Type (Denotes Use of Material)	CRMC_ETAX_HTYP
276	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	CRMC_ETAX_SRC
277	PAYMENT_METHOD	☐	CRMT_BUAG_PAYMETH	CRM_BUAG_PAYMETH	CHAR	1	0	Payment Method	*
278	.INCLUDE	☐				0	0	ATP-Relevant Fields in Schedule Line
279	CONF_RULE	☐	CRMT_CONF_RULE	CRM_CONF_RULE	CHAR	1	0	Confirmation Rule
280	REQ_RULE	☐	CRMT_REQ_RULE	CRM_REQ_RULE	CHAR	1	0	Requirement Rule
281	PAR_ATP_SSTOCK	☐	CRMT_PAR_ATP_SSTOCK	CRM_PAR_ATP_SSTOCK	CHAR	1	0	Parameter-Dependent ATP Safety Stock
282	REASSIGN_ABILITY	☐	CRMT_REASSIGN_ABILITY	CRM_REASSIGN_ABILITY	CHAR	1	0	Reassignment of Order Confirmations
283	ABNORMAL_DEMAND	☐	CRMT_ABNORMAL_DEMAND	CRM_ABNORMAL_DEMAND	CHAR	1	0	Abnormal Demand
284	ROUNDING	☐	CRMT_ROUNDING	CRM_ROUNDING	CHAR	1	0	Round Requirement Quantity
285	DIRECT_SHIP	☐	CRMT_DIRECT_SHIP	FLAG	CHAR	1	0	Direct Delivery Without Consolidation
286	SUBST_EXCL	☐	CRMT_ATP_SUBST_EXCL	CRM_ATP_SUBST_EXCL	CHAR	2	0	Rule Criterion 1	CRMC_SUBST_EXCL
287	SEARCH_PATTERN	☐	CRMT_SEARCH_PATTERN	CRM_SEARCH_PATTERN	CHAR	10	0	Rule Criterion 2	CRMC_ATP_SEARCH
288	.INCLUDE	☐				0	0
289	.INCLUDE	☐				0	0
290	.INCLUDE	☐				0	0
291	.INCLUDE	☐				0	0
292	.INCLUDE	☐				0	0
293	.INCLUDE	☐				0	0
294	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
295	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	TB004
296	SCORE	☐	CRMT_SCORE	CRM_SCORE	CHAR	10	0	Result Value of an Internal Creditworthiness Check
297	.INCLUDE	☐				0	0	BSP: Campaign
298	.INCLUDE	☐				0	0	Sales: Campaigns
299	CAMPAIGN_HE_ID	☐	CAMPAIGN_HE_ID	CGPL_EXTID	CHAR	24	0	Marketing Project Identification
300	CAMPAIGN_HE_ID_T	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
301	CAMPAIGN_GUID	☐	CRMT_MKTPL_CPG_TEMPL	CGPL_PROJECT_GUID	RAW	16	0	Campaign template
302	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_LAM_OD1_GENERAL	CURRENCY	TCURC	WAERS
2	CRMT_BSP_LAM_OD1_GENERAL	CUSTOMER_TYPE	TB004	BPKIND
3	CRMT_BSP_LAM_OD1_GENERAL	ETAX_HAND_TYPE	CRMC_ETAX_HTYP	HAND_TYPE
4	CRMT_BSP_LAM_OD1_GENERAL	ETAX_SOURCE	CRMC_ETAX_SRC	SOURCE
5	CRMT_BSP_LAM_OD1_GENERAL	INCOTERMS1	CRMC_INCOTERM	INCOTERMS1
6	CRMT_BSP_LAM_OD1_GENERAL	INT_INSPECTION	CRMC_ITEM_INSP	ITEM_INSPECTION
7	CRMT_BSP_LAM_OD1_GENERAL	PMNTTRMS	CRMC_PMNTTRMS	PAYMENT_TERMS
8	CRMT_BSP_LAM_OD1_GENERAL	SEARCH_PATTERN	CRMC_ATP_SEARCH	SEARCH_PATTERN
9	CRMT_BSP_LAM_OD1_GENERAL	SHIP_COND	CRMC_SHIP_COND	SHIP_COND
10	CRMT_BSP_LAM_OD1_GENERAL	SUBST_EXCL	CRMC_SUBST_EXCL	SUBST_EXCL
11	CRMT_BSP_LAM_OD1_GENERAL	TRANS_MOT	CRMC_TRANS_MOT	MOT

History

Last changed by/on	SAP	20130604
SAP Release Created in	500