SAP ABAP Table BTSQ_CUSTQTEUPDRQ_SCUSTQTE (A Customer Quote is an offer by a seller to a customer for t)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-SLO-QUT (Application Component) Customer Inquiries / Quotations
     ⤷ CRM_BT_SLSQ_XI_PROXY (Package) Generated Proxies Customer Quote

Basic Data

Table Category	INTTAB	Structure
Structure	BTSQ_CUSTQTEUPDRQ_SCUSTQTE	Table Relationship Diagram
Short Description	A Customer Quote is an offer by a seller to a customer for t

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	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
2	ID	☐	CRMSEF_CUSTOMER_QUOTE_ID		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	SCHEME_AGENCY_ID	☐			CHAR	60	0
5	CONTENT	☐	CRMSEF_CUSTOMER_QUOTE_ID_CONTE		CHAR	10	0	Proxy Data Element (generated)
6	BUYER_ID	☐	CRMSEF_BUSINESS_TRANSACTION_D1		STRU	0	0
7	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
8	SCHEME_ID	☐			CHAR	60	0
9	SCHEME_AGENCY_ID	☐			CHAR	60	0
10	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
11	CONTENT	☐	CRMSEF_BUSINESS_TRANSACTION_DO		CHAR	35	0	Proxy Data Element (Generated)
12	CHANGE_STATE_ID	☐	CRMSEF_CHANGE_STATE_ID		CHAR	40	0	Proxy Data Element (generated)
13	DATA_ORIGIN_CATEGORY_CODE	☐	CRMSEF_CUSTOMER_TRANSACTION_D7		STRU	0	0
14	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
15	LIST_ID	☐			CHAR	60	0
16	LIST_VERSION_ID	☐			CHAR	15	0
17	LIST_AGENCY_ID	☐			CHAR	60	0
18	AGENCY_SCHEME_ID	☐			CHAR	60	0
19	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
20	CONTENT	☐	CRMSEF_CUSTOMER_TRANSACTION_D8		CHAR	4	0	Proxy Data Element (generated)
21	DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
22	BUYER_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
23	NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
24	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
25	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
26	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
27	STATUS	☐	BTSQ_CUSTQTEUPDRQ_SSTS		STRU	0	0
28	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
29	OBJECT	☐	CRMSEF_STATUS_OBJECT		STRU	0	0
30	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
31	USER_STATUS_PROFILE_CODE	☐	CRMSEF_USER_STATUS_PROFILE_CO1		STRU	0	0
32	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
33	LIST_ID	☐			CHAR	60	0
34	LIST_VERSION_ID	☐			CHAR	15	0
35	LIST_AGENCY_ID	☐			CHAR	60	0
36	AGENCY_SCHEME_ID	☐			CHAR	60	0
37	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
38	CONTENT	☐	CRMSEF_USER_STATUS_PROFILE_COD		CHAR	8	0	Proxy Data Element (generated)
39	USER_STATUS_PROFILE_NAME	☐	CRMSEF_LEN30_NAME		STRU	0	0
40	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
41	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
42	CONTENT	☐	CRMSEF_LEN30_NAME_CONTENT		CHAR	30	0	Proxy Data Element (generated)
43	SYSTEM_STATUS	☐	CRMSEF_SYSTEM_STATUS_TAB		TTYP	0	0
44	USER_STATUS	☐	CRMSEF_USER_STATUS_TAB		TTYP	0	0
45	SALES_AND_SERVICE_BUSINES_AREA	☐	BTSQ_CUSTQTEUPDRQ_SSLSSRVBUSAR		STRU	0	0
46	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
47	SALES_ORGANISATION_ID	☐	CRMSEF_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Proxy Data Element (Generated)
48	DISTRIBUTION_CHANNEL_CODE	☐	CRMSEF_DISTRIBUTION_CHANNEL_C1		STRU	0	0
49	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
50	LIST_ID	☐			CHAR	60	0
51	LIST_VERSION_ID	☐			CHAR	15	0
52	LIST_AGENCY_ID	☐			CHAR	60	0
53	AGENCY_SCHEME_ID	☐			CHAR	60	0
54	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
55	CONTENT	☐	CRMSEF_DISTRIBUTION_CHANNEL_CO		CHAR	2	0	Proxy Data Element (Generated)
56	DIVISION_CODE	☐	CRMSEF_DIVISION_CODE		STRU	0	0
57	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
58	LIST_ID	☐			CHAR	60	0
59	LIST_VERSION_ID	☐			CHAR	15	0
60	LIST_AGENCY_ID	☐			CHAR	60	0
61	AGENCY_SCHEME_ID	☐			CHAR	60	0
62	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
63	CONTENT	☐	CRMSEF_DIVISION_CODE_CONTENT		CHAR	2	0	Proxy Data Element (Generated)
64	SALES_OFFICE_ID	☐	CRMSEF_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Proxy Data Element (Generated)
65	SALES_GROUP_ID	☐	CRMSEF_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Proxy Data Element (Generated)
66	BUYER_PARTY	☐	BTSQ_CUSTQTEUPDRQ_SBUYRPTY		STRU	0	0
67	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
68	INTERNAL_ID	☐	CRMSEF_PARTY_INTERNAL_ID		STRU	0	0
69	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
70	SCHEME_ID	☐			CHAR	60	0
71	SCHEME_AGENCY_ID	☐			CHAR	60	0
72	CONTENT	☐	CRMSEF_PARTY_INTERNAL_ID_CONTE		CHAR	32	0	Proprietary identifier for a party
73	GOODS_RECIPIENT_PARTY	☐	BTSQ_CUSTQTEUPDRQ_SGDSRCPNTPTY		STRU	0	0
74	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
75	INTERNAL_ID	☐	CRMSEF_PARTY_INTERNAL_ID		STRU	0	0
76	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
77	SCHEME_ID	☐			CHAR	60	0
78	SCHEME_AGENCY_ID	☐			CHAR	60	0
79	CONTENT	☐	CRMSEF_PARTY_INTERNAL_ID_CONTE		CHAR	32	0	Proprietary identifier for a party
80	PARTY	☐	BTSQ_CUST_QTE_CRMUPDT_RE_TAB16		TTYP	0	0
81	SALES_TERMS	☐	BTSQ_CUSTQTEUPDRQ_SSLSTRMS		STRU	0	0
82	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
83	REASON_CODE	☐	CRMSEF_CUSTOMER_TRANSACTION_D4		STRU	0	0
84	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
85	LIST_VERSION_ID	☐			CHAR	15	0
86	LIST_AGENCY_ID	☐			CHAR	60	0
87	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
88	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
89	CONTENT	☐	CRMSEF_CUSTOMER_TRANSACTION_D5		CHAR	4	0	Proxy Data Element (generated)
90	PRODUCT_USAGE_CODE	☐	CRMSEF_PRODUCT_USAGE_CODE		STRU	0	0
91	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
92	LIST_ID	☐			CHAR	60	0
93	LIST_VERSION_ID	☐			CHAR	15	0
94	LIST_AGENCY_ID	☐			CHAR	60	0
95	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
96	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
97	CONTENT	☐	CRMSEF_PRODUCT_USAGE_CODE_CONT		CHAR	3	0	Proxy Data Element (generated)
98	PROBABILITY_PERCENT	☐	CRMSEF_SMALLNONNEGATIVE_PERCEN		DEC	5	2	Proxy Data Element (generated)
99	TIME_POINT_TERMS	☐	BTSQ_CUST_QTE_CRMUPDT_RE_TAB12		TTYP	0	0
100	PERIOD_TERMS	☐	BTSQ_CUST_QTE_CRMUPDT_RE_TAB10		TTYP	0	0
101	DURATION_TERMS	☐	BTSQ_CUST_QTE_CRMUPDT_RE_TAB15		TTYP	0	0
102	PRICING_TERMS	☐	BTSQ_CUSTQTEUPDRQ_SPRCGTRMS		STRU	0	0
103	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
104	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
105	PRICE_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
106	PRICE_SPECIFICATION_CUSTOMER_G	☐	CRMSEF_PRICE_SPECIFICATION_CU1		STRU	0	0
107	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
108	LIST_ID	☐			CHAR	60	0
109	LIST_VERSION_ID	☐			CHAR	15	0
110	LIST_AGENCY_ID	☐			CHAR	60	0
111	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
112	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
113	CONTENT	☐	CRMSEF_PRICE_SPECIFICATION_CUS		CHAR	2	0	Proxy Data Element (generated)
114	CUSTOMER_PRICE_LIST_TYPE_CODE	☐	CRMSEF_CUSTOMER_PRICE_LIST_TYP		CHAR	2	0	Proxy Data Element (generated)
115	CUSTOMER_GROUP_CODE	☐	CRMSEF_CUSTOMER_GROUP_CODE		STRU	0	0
116	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
117	LIST_ID	☐			CHAR	60	0
118	LIST_VERSION_ID	☐			CHAR	15	0
119	LIST_AGENCY_ID	☐			CHAR	60	0
120	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
121	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
122	CONTENT	☐	CRMSEF_CUSTOMER_GROUP_CODE_CON		CHAR	2	0	Proxy Data Element (generated)
123	PRICE_AND_TAX_CALCULATION	☐	BTSQ_CUSTQTEUPDRQ_SPRANDTXCALC		STRU	0	0
124	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
125	PRICE_COMPONENT	☐	BTSQ_CUST_QTE_CRMUPDT_REQ_TAB3		TTYP	0	0
126	DELIVERY_TERMS	☐	BTSQ_CUSTQTEUPDRQ_SDELIVTRMS		STRU	0	0
127	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
128	INCOTERMS	☐	CRMSEF_INCOTERMS		STRU	0	0
129	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
130	CLASSIFICATION_CODE	☐	CRMSEF_INCOTERMS_CLASSIFICATIO		CHAR	3	0	Proxy Data Element (generated)
131	TRANSFER_LOCATION_NAME	☐	CRMSEF_INCOTERMS_TRANSFER_LOCA		CHAR	28	0	Proxy Data Element (generated)
132	PARTIAL_DELIVERY_CONTROL_CODE	☐	CRMSEF_PARTIAL_DELIVERY_CONTRO		CHAR	2	0	Proxy Data Element (generated)
133	QUANTITY_TOLERANCE	☐	CRMSEF_QUANTITY_TOLERANCE		STRU	0	0
134	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
135	OVER_PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
136	OVER_PERCENT_UNLIM_INDICATOR	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
137	UNDER_PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
138	REQUESTED_DELIVERY_DATE_TIME	☐	CRMSEF_LOCAL_DATE_TIME		STRU	0	0
139	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
140	TIME_ZONE_CODE	☐	CRMSEF_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (Generated)
141	DAYLIGHT_SAVING_TIME_INDICATOR	☐	XSDBOOLEAN	XSDBOOLEAN	CHAR	1	0	XSD Truth Value: True/False [ext.]
142	CONTENT	☐	CRMSEF_LOCAL_DATE_TIME_CONTENT	XSDDATETIME_LOCAL	CHAR	14	0	Proxy Data Element (generated)
143	CASH_DISCOUNT_TERMS	☐	BTSQ_CUSTQTEUPDRQ_SCASHDISCTRM		STRU	0	0
144	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
145	CODE	☐	CRMSEF_CASH_DISCOUNT_TERMS_CO1		STRU	0	0
146	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
147	LIST_AGENCY_ID	☐			CHAR	60	0
148	LIST_VERSION_ID	☐			CHAR	15	0
149	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
150	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
151	CONTENT	☐	CRMSEF_CASH_DISCOUNT_TERMS_COD		CHAR	4	0	Proxy Data Element (generated)
152	INVOICE_PLAN	☐	BTSQ_CUSTQTEUPDRQ_SINVCPLN		STRU	0	0
153	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
154	HORIZON_DATE_CALCULATION_FUNCT	☐	CRMSEF_DATE_CALCULATION_FUNCT4		STRU	0	0
155	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
156	LIST_VERSION_ID	☐			CHAR	15	0
157	LIST_AGENCY_ID	☐			CHAR	60	0
158	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
159	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
160	CONTENT	☐	CRMSEF_DATE_CALCULATION_FUNCT3		CHAR	12	0	Proxy Data Element (generated)
161	START_DATE_TIME	☐	CRMSEF_LOCAL_DATE_TIME		STRU	0	0
162	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
163	TIME_ZONE_CODE	☐	CRMSEF_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (Generated)
164	DAYLIGHT_SAVING_TIME_INDICATOR	☐	XSDBOOLEAN	XSDBOOLEAN	CHAR	1	0	XSD Truth Value: True/False [ext.]
165	CONTENT	☐	CRMSEF_LOCAL_DATE_TIME_CONTENT	XSDDATETIME_LOCAL	CHAR	14	0	Proxy Data Element (generated)
166	START_DATE_CALCULATION_FUNCTIO	☐	CRMSEF_DATE_CALCULATION_FUNCT4		STRU	0	0
167	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
168	LIST_VERSION_ID	☐			CHAR	15	0
169	LIST_AGENCY_ID	☐			CHAR	60	0
170	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
171	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
172	CONTENT	☐	CRMSEF_DATE_CALCULATION_FUNCT3		CHAR	12	0	Proxy Data Element (generated)
173	END_DATE_TIME	☐	CRMSEF_LOCAL_DATE_TIME		STRU	0	0
174	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
175	TIME_ZONE_CODE	☐	CRMSEF_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (Generated)
176	DAYLIGHT_SAVING_TIME_INDICATOR	☐	XSDBOOLEAN	XSDBOOLEAN	CHAR	1	0	XSD Truth Value: True/False [ext.]
177	CONTENT	☐	CRMSEF_LOCAL_DATE_TIME_CONTENT	XSDDATETIME_LOCAL	CHAR	14	0	Proxy Data Element (generated)
178	END_DATE_CALCULATION_FUNCTION	☐	CRMSEF_DATE_CALCULATION_FUNCT4		STRU	0	0
179	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
180	LIST_VERSION_ID	☐			CHAR	15	0
181	LIST_AGENCY_ID	☐			CHAR	60	0
182	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
183	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
184	CONTENT	☐	CRMSEF_DATE_CALCULATION_FUNCT3		CHAR	12	0	Proxy Data Element (generated)
185	INVOICE_PLAN_LINE	☐	BTSQ_CUST_QTE_CRMUPDT_REQ_TAB4		TTYP	0	0
186	TEXT_COLLECTION	☐	BTSQ_CUSTQTEUPDRQ_STXTCOLL		STRU	0	0
187	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
188	TEXT	☐	BTSQ_CUST_QTE_CRMUPDT_REQ_TAB5		TTYP	0	0
189	ATTACHMENT_FOLDER	☐	CRMSEF_ATTACHMENT_FOLDER		STRU	0	0
190	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
191	DOCUMENT	☐	CRMSEF_DOCUMENT_TAB		TTYP	0	0
192	ACTION_CODE	☐	CRMSEF_ACTION_CODE		CHAR	2	0	Proxy Data Element (generated)
193	BUSINESS_TRANSACTION_DOC_REF	☐	BTSQ_CUST_QTE_CRMUPDT_RE_TAB14		TTYP	0	0
194	ITEM	☐	BTSQ_CUST_QTE_CRMUPDT_RE_TAB13		TTYP	0	0

History

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