SAP ABAP Table BTSQ_CUSTQTEITBYITIDQR_IPATCLC (Proxy Structure (generated))

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_CUSTQTEITBYITIDQR_IPATCLC	Table Relationship Diagram
Short Description	Proxy Structure (generated)

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	PRICE_COMPONENT	☐	BTSQ_CUST_QTE_CRMITM_BY_IT_TAB		TTYP	0	0
3	PRODUCT_TAX_DETAILS	☐	BTSQ_CUST_QTE_CRMITM_BY_ITM_I2		STRU	0	0
4	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
5	TAXATION_CHARACTERISTICS_CODE	☐	CRMSEF_PRODUCT_TAXATION_CHARA1		STRU	0	0
6	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
7	LIST_ID	☐			CHAR	60	0
8	LIST_VERSION_ID	☐			CHAR	15	0
9	LIST_AGENCY_ID	☐			CHAR	60	0
10	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
11	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
12	CONTENT	☐	CRMSEF_PRODUCT_TAXATION_CHARA2		CHAR	4	0	Proxy Data Element (generated)
13	TRANSACTION_CURRENCY_PRODUCT_T	☐	CRMSEF_PRODUCT_TAX		STRU	0	0
14	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
15	COUNTRY_CODE	☐	CRMSEF_COUNTRY_CODE		CHAR	3	0	Proxy Data Element (Generated)
16	REGION_CODE	☐	CRMSEF_REGION_CODE		STRU	0	0
17	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
18	LIST_ID	☐			CHAR	60	0
19	LIST_VERSION_ID	☐			CHAR	15	0
20	LIST_AGENCY_ID	☐			CHAR	60	0
21	AGENCY_SCHEME_ID	☐			CHAR	60	0
22	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
23	CONTENT	☐	CRMSEF_REGION_CODE_CONTENT		CHAR	6	0	Proxy Data Element (Generated)
24	JURISDICTION_CODE	☐	CRMSEF_TAX_JURISDICTION_CODE		STRU	0	0
25	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
26	LIST_ID	☐			CHAR	60	0
27	LIST_VERSION_ID	☐			CHAR	15	0
28	LIST_AGENCY_ID	☐			CHAR	60	0
29	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
30	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
31	CONTENT	☐	CRMSEF_TAX_JURISDICTION_CODE_1		CHAR	15	0	Proxy Data Element (generated)
32	JURISDICTION_SUBDIVISION_CODE	☐	CRMSEF_TAX_JURISDICTION_SUBDI4		STRU	0	0
33	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
34	LIST_ID	☐			CHAR	60	0
35	LIST_VERSION_ID	☐			CHAR	15	0
36	LIST_AGENCY_ID	☐			CHAR	60	0
37	CONTENT	☐	CRMSEF_TAX_JURISDICTION_SUBDI5		CHAR	15	0	Proxy Data Element (generated)
38	JURISDICTION_SUBDIVISION_TYPE	☐	CRMSEF_TAX_JURISDICTION_SUBDI1		STRU	0	0
39	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
40	LIST_ID	☐			CHAR	60	0
41	LIST_VERSION_ID	☐			CHAR	15	0
42	LIST_AGENCY_ID	☐			CHAR	60	0
43	CONTENT	☐	CRMSEF_TAX_JURISDICTION_SUBDI2		CHAR	3	0	Proxy Data Element (generated)
44	EVENT_TYPE_CODE	☐	CRMSEF_PRODUCT_TAX_EVENT_TYPE2		STRU	0	0
45	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
46	LIST_ID	☐			CHAR	60	0
47	LIST_AGENCY_ID	☐			CHAR	60	0
48	CONTENT	☐	CRMSEF_PRODUCT_TAX_EVENT_TYPE1		CHAR	3	0	Proxy Data Element (generated)
49	TYPE_CODE	☐	CRMSEF_TAX_TYPE_CODE		STRU	0	0
50	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
51	LIST_ID	☐			CHAR	60	0
52	LIST_AGENCY_ID	☐			CHAR	60	0
53	CONTENT	☐	CRMSEF_TAX_TYPE_CODE_CONTENT		CHAR	3	0	Proxy Data Element (generated)
54	RATE_TYPE_CODE	☐	CRMSEF_TAX_RATE_TYPE_CODE		STRU	0	0
55	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
56	LIST_ID	☐			CHAR	60	0
57	LIST_AGENCY_ID	☐			CHAR	60	0
58	CONTENT	☐	CRMSEF_TAX_RATE_TYPE_CODE_CON1		CHAR	5	0	Proxy Data Element (generated)
59	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
60	BASE_AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
61	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
62	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
63	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
64	PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
65	BASE_QUANTITY	☐	CRMSEF_QUANTITY		STRU	0	0
66	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
67	UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
68	CONTENT	☐	CRMSEF_QUANTITY_CONTENT		DEC	31	14	QUANTITY is the non-monetary numerical declaration of a quan
69	BASE_QUANTITY_TYPE_CODE	☐	CRMSEF_QUANTITY_TYPE_CODE		STRU	0	0
70	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
71	LIST_ID	☐			CHAR	60	0
72	LIST_VERSION_ID	☐			CHAR	15	0
73	LIST_AGENCY_ID	☐			CHAR	60	0
74	LIST_AGEN_SCHM_ID	☐			CHAR	60	0
75	LIST_AGEN_SCHM_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
76	CONTENT	☐	CRMSEF_QUANTITY_TYPE_CODE_CONT		CHAR	10	0	Proxy Data Element (generated)
77	RATE	☐	CRMSEF_RATE		STRU	0	0
78	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
79	DECIMAL_VALUE	☐	CRMSEF_DECIMAL_VALUE		DEC	31	14	Proxy Data Element (generated)
80	MEASURE_UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
81	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
82	BASE_DECIMAL_VALUE	☐	CRMSEF_DECIMAL_VALUE		DEC	31	14	Proxy Data Element (generated)
83	BASE_MEASURE_UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
84	BASE_CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
85	AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
86	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
87	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
88	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
89	INTERNAL_AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
90	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
91	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
92	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
93	NON_DEDUCTIBLE_PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
94	NON_DEDUCTIBLE_AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
95	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
96	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
97	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
98	DEDUCTIBLE_AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
99	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
100	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
101	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
102	DEDUCTIBILITY_CODE	☐	CRMSEF_TAX_DEDUCTIBILITY_CODE1		STRU	0	0
103	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
104	LIST_ID	☐			CHAR	60	0
105	LIST_VERSION_ID	☐			CHAR	15	0
106	LIST_AGENCY_ID	☐			CHAR	60	0
107	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
108	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
109	CONTENT	☐	CRMSEF_TAX_DEDUCTIBILITY_CODE2		CHAR	4	0	Proxy Data Element (generated)
110	BUS_TRANS_DOC_ITEM_GROUPID	☐	CRMSEF_BUSTRANSDOCITMGRPID		CHAR	10	0	Proxy Data Element (generated)
111	EURP_CMNTY_VAT_TRIANGLE_IND	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
112	DUE_CATEGORY_CODE	☐	CRMSEF_DUE_CATEGORY_CODE		CHAR	1	0	Proxy Data Element (generated)
113	STATISTIC_RELEVANCE_INDICATOR	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
114	DEFERRED_INDICATOR	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
115	EXEMPTION	☐	CRMSEF_TAX_EXEMPTION		STRU	0	0
116	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
117	CERTIFICATE_ID	☐	CRMSEF_TAX_EXEMPTION_CERTIFIC1		STRU	0	0
118	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
119	SCHEME_AGENCY_ID	☐			CHAR	60	0
120	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
121	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
122	CONTENT	☐	CRMSEF_TAX_EXEMPTION_CERTIFICA		CHAR	30	0	Proxy Data Element (generated)
123	INTERNAL_CERTIFICATE_ID	☐	CRMSEF_TAX_EXEMPTION_CERTIFIC1		STRU	0	0
124	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
125	SCHEME_AGENCY_ID	☐			CHAR	60	0
126	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
127	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
128	CONTENT	☐	CRMSEF_TAX_EXEMPTION_CERTIFICA		CHAR	30	0	Proxy Data Element (generated)
129	VALIDITY_PERIOD	☐	CRMSEF_DATE_PERIOD		STRU	0	0
130	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
131	START_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
132	END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
133	DURATION	☐	CRMSEF_DURATION		STRG	0	0	Proxy Data Element (generated)
134	PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
135	AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
136	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
137	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
138	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
139	REASON_CODE	☐	CRMSEF_TAX_EXEMPTION_REASON_C2		STRU	0	0
140	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
141	LIST_ID	☐			CHAR	60	0
142	LIST_AGENCY_ID	☐			CHAR	3	0
143	CONTENT	☐	CRMSEF_TAX_EXEMPTION_REASON_C1		CHAR	3	0	Proxy Data Element (generated)
144	FOLLOW_UP_EXEMPTION	☐	CRMSEF_TAX_EXEMPTION		STRU	0	0
145	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
146	CERTIFICATE_ID	☐	CRMSEF_TAX_EXEMPTION_CERTIFIC1		STRU	0	0
147	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
148	SCHEME_AGENCY_ID	☐			CHAR	60	0
149	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
150	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
151	CONTENT	☐	CRMSEF_TAX_EXEMPTION_CERTIFICA		CHAR	30	0	Proxy Data Element (generated)
152	INTERNAL_CERTIFICATE_ID	☐	CRMSEF_TAX_EXEMPTION_CERTIFIC1		STRU	0	0
153	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
154	SCHEME_AGENCY_ID	☐			CHAR	60	0
155	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
156	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
157	CONTENT	☐	CRMSEF_TAX_EXEMPTION_CERTIFICA		CHAR	30	0	Proxy Data Element (generated)
158	VALIDITY_PERIOD	☐	CRMSEF_DATE_PERIOD		STRU	0	0
159	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
160	START_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
161	END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
162	DURATION	☐	CRMSEF_DURATION		STRG	0	0	Proxy Data Element (generated)
163	PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
164	AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
165	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
166	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
167	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
168	REASON_CODE	☐	CRMSEF_TAX_EXEMPTION_REASON_C2		STRU	0	0
169	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
170	LIST_ID	☐			CHAR	60	0
171	LIST_AGENCY_ID	☐			CHAR	3	0
172	CONTENT	☐	CRMSEF_TAX_EXEMPTION_REASON_C1		CHAR	3	0	Proxy Data Element (generated)
173	LEGALLY_REQUIRED_PHRASE	☐	CRMSEF_LEGALLY_REQUIRED_PHRASE		CHAR	255	0	Proxy Data Element (generated)
174	EXCHANGE_RATE	☐	CRMSEF_EXCHANGE_RATE		STRU	0	0
175	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
176	UNIT_CURRENCY	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
177	QUOTED_CURRENCY	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
178	RATE	☐	CRMSEF_EXCHANGE_RATE_RATE		DEC	28	14	Proxy Data Element (generated)
179	QUOTATION_DATE_TIME	☐	CRMSEF_GLOBAL_DATE_TIME	XSDDATETIME_LONG_Z	DEC	21	7	Proxy Data Element (generated)

History

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