SAP ABAP Table PRD_MATL_CRM_S_SLS_SPEC (SalesSpecification)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PRO (Application Component) Products
     ⤷ CRM_PRODUCT_XI_PROXY (Package) eSOA Package for generated Proxies

Basic Data

Table Category	INTTAB	Structure
Structure	PRD_MATL_CRM_S_SLS_SPEC	Table Relationship Diagram
Short Description	SalesSpecification

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	SALES_ORGANISATION_ID	☐	CRMSEF_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Proxy Data Element (Generated)
3	DISTRIBUTION_CHANNEL_CODE	☐	CRMSEF_DISTRIBUTION_CHANNEL_C1		STRU	0	0
4	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
5	LIST_ID	☐			CHAR	60	0
6	LIST_VERSION_ID	☐			CHAR	15	0
7	LIST_AGENCY_ID	☐			CHAR	60	0
8	AGENCY_SCHEME_ID	☐			CHAR	60	0
9	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
10	CONTENT	☐	CRMSEF_DISTRIBUTION_CHANNEL_CO		CHAR	2	0	Proxy Data Element (Generated)
11	SALES_ORGANISATION_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
12	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
13	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
14	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
15	DISTRIBUTION_CHANNEL_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
16	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
17	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
18	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
19	SALES_MEASURE_UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
20	SALES_MEASURE_UNIT_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
21	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
22	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
23	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
24	LONG_SALES_MEASURE_UNIT_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
25	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
26	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
27	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
28	CASH_DISCOUNT_DEDUCTIBLE_INDIC	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
29	MINIMUM_ORDER_QUANTITY	☐	CRMSEF_QUANTITY		STRU	0	0
30	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
31	UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
32	CONTENT	☐	CRMSEF_QUANTITY_CONTENT		DEC	31	14	QUANTITY is the non-monetary numerical declaration of a quan
33	PRICING_REFERENCE_PRODUCT_INTE	☐	CRMSEF_PRODUCT_INTERNAL_ID		STRU	0	0
34	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
35	SCHEME_ID	☐			CHAR	60	0
36	SCHEME_AGENCY_ID	☐			CHAR	60	0
37	CONTENT	☐	CRMSEF_PRODUCT_INTERNAL_ID_CON		CHAR	60	0	Proxy Data Element (generated)
38	PRICING_REFERENCE_PRODUCT_TYPE	☐	CRMSEF_PRODUCT_TYPE_CODE		CHAR	2	0	Proxy Data Element (generated)
39	PRICING_REFERENCE_SOURCE_BUSIN	☐	CRMSEF_BUSINESS_SYSTEM_ID		CHAR	60	0	Proxy Data Element (generated)
40	PRICING_REFERENCE_PRODUCT_DESC	☐	CRMSEF_SHORT_DESCRIPTION		STRU	0	0
41	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
42	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
43	CONTENT	☐	CRMSEF_SHORT_DESCRIPTION_CONTE		CHAR	40	0	Proxy Data Element (generated)
44	CUSTOMER_TRANSACTION_DOCUMENT1	☐	CRMSEF_CUSTOMER_TRANSACTION_10		CHAR	4	0	Proxy Data Element (generated)
45	CUSTOMER_TRANSACTION_DOCUMENT	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
46	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
47	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
48	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
49	DELIVERY_QUANTITY	☐	CRMSEF_QUANTITY		STRU	0	0
50	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
51	UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
52	CONTENT	☐	CRMSEF_QUANTITY_CONTENT		DEC	31	14	QUANTITY is the non-monetary numerical declaration of a quan
53	DELIVERY_MEASURE_UNIT_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
54	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
55	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
56	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
57	LONG_DELIVERY_MEASURE_UNIT_NAM	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
58	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
59	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
60	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
61	VARIABLE_SALES_UNIT_NOT_ALLOWE	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
62	CUSTOMER_TRANSACTION_DOCUMENT3	☐	CRMSEF_CUSTOMER_TRANSACTION_10		CHAR	4	0	Proxy Data Element (generated)
63	CUSTOMER_TRANSACTION_DOCUMENT2	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
64	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
65	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
66	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
67	PRICE_SPECIFICATION_PRODUCT_G1	☐	PRD_PRICE_SPECIFICATION_PRODU1		STRU	0	0
68	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
69	LIST_ID	☐			CHAR	60	0
70	LIST_VERSION_ID	☐			CHAR	15	0
71	LIST_AGENCY_ID	☐			CHAR	60	0
72	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
73	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
74	CONTENT	☐	PRD_PRICE_SPECIFICATION_PRODUC		CHAR	2	0	Proxy Data Element (generated)
75	PRICE_SPECIFICATION_PRODUCT_GR	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
76	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
77	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
78	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
79	FIRST_PRODUCT_GROUP_CODE	☐	CRMSEF_SALES_SPEC_PROD_GRP_STR		STRU	0	0
80	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
81	LIST_ID	☐			CHAR	60	0
82	LIST_VERSION_ID	☐			CHAR	15	0
83	LIST_AGENCY_ID	☐			CHAR	60	0
84	CONTENT	☐	CRMSEF_SALES_SPEC_PROD_GRP		CHAR	3	0	Proxy Data Element (generated)
85	FIRST_PRODUCT_GROUP_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
86	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
87	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
88	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
89	SECOND_PRODUCT_GROUP_CODE	☐	CRMSEF_SALES_SPEC_PROD_GRP_STR		STRU	0	0
90	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
91	LIST_ID	☐			CHAR	60	0
92	LIST_VERSION_ID	☐			CHAR	15	0
93	LIST_AGENCY_ID	☐			CHAR	60	0
94	CONTENT	☐	CRMSEF_SALES_SPEC_PROD_GRP		CHAR	3	0	Proxy Data Element (generated)
95	SECOND_PRODUCT_GROUP_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
96	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
97	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
98	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
99	THIRD_PRODUCT_GROUP_CODE	☐	CRMSEF_SALES_SPEC_PROD_GRP_STR		STRU	0	0
100	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
101	LIST_ID	☐			CHAR	60	0
102	LIST_VERSION_ID	☐			CHAR	15	0
103	LIST_AGENCY_ID	☐			CHAR	60	0
104	CONTENT	☐	CRMSEF_SALES_SPEC_PROD_GRP		CHAR	3	0	Proxy Data Element (generated)
105	THIRD_PRODUCT_GROUP_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
106	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
107	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
108	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
109	FOURTH_PRODUCT_GROUP_CODE	☐	CRMSEF_SALES_SPEC_PROD_GRP_STR		STRU	0	0
110	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
111	LIST_ID	☐			CHAR	60	0
112	LIST_VERSION_ID	☐			CHAR	15	0
113	LIST_AGENCY_ID	☐			CHAR	60	0
114	CONTENT	☐	CRMSEF_SALES_SPEC_PROD_GRP		CHAR	3	0	Proxy Data Element (generated)
115	FOURTH_PRODUCT_GROUP_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
116	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
117	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
118	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
119	FIFTH_PRODUCT_GROUP_CODE	☐	CRMSEF_SALES_SPEC_PROD_GRP_STR		STRU	0	0
120	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
121	LIST_ID	☐			CHAR	60	0
122	LIST_VERSION_ID	☐			CHAR	15	0
123	LIST_AGENCY_ID	☐			CHAR	60	0
124	CONTENT	☐	CRMSEF_SALES_SPEC_PROD_GRP		CHAR	3	0	Proxy Data Element (generated)
125	FIFTH_PRODUCT_GROUP_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
126	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
127	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
128	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
129	REBATE_PRODUCT_GROUP_CODE	☐	PRD_REBATE_PRODUCT_GROUP_CODE1		STRU	0	0
130	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
131	LIST_ID	☐			CHAR	60	0
132	LIST_VERSION_ID	☐			CHAR	15	0
133	LIST_AGENCY_ID	☐			CHAR	60	0
134	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
135	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
136	CONTENT	☐	PRD_REBATE_PRODUCT_GROUP_CODE		CHAR	2	0	Proxy Data Element (generated)
137	REBATE_PRODUCT_GROUP_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
138	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
139	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
140	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
141	COMMISSION_PRODUCT_GROUP_CODE	☐	PRD_COMMISSION_PRODUCT_GROUP_1		STRU	0	0
142	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
143	LIST_ID	☐			CHAR	60	0
144	LIST_VERSION_ID	☐			CHAR	15	0
145	LIST_AGENCY_ID	☐			CHAR	60	0
146	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
147	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
148	CONTENT	☐	PRD_COMMISSION_PRODUCT_GROUP_C		CHAR	2	0	Coded representation of a group of products for which a spec
149	COMMISSION_PRODUCT_GROUP_NAME	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
150	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
151	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
152	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
153	ACCOUNT_DETERMINATION_PRODUCT1	☐	CRMSEF_L_ACCOUNT_DETERMINATIO1		STRU	0	0
154	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
155	LIST_ID	☐			STRG	0	0
156	LIST_VERSION_ID	☐			STRG	0	0
157	LIST_AGENCY_ID	☐			STRG	0	0
158	LIST_AGENCY_SCHEME_ID	☐			STRG	0	0
159	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_L_AGENCY_IDENTIFICATION		CHAR	3	0	An AgencyIdentificationCode is a code representation of the
160	CONTENT	☐	CRMSEF_L_ACCOUNT_DETERMINATION		CHAR	2	0	Account Assignment Group for Product
161	ACCOUNT_DETERMINATION_PRODUCT	☐	CRMSEF_MEDIUM_NAME		STRU	0	0
162	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
163	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
164	CONTENT	☐	CRMSEF_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (Generated)
165	DISTRIBUTION_CHAIN_DEPENDENT_1	☐	CRMSEF_PRODUCT_CATEGORY_INTER1		STRU	0	0
166	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
167	SCHEME_ID	☐			CHAR	60	0
168	SCHEME_AGENCY_ID	☐			CHAR	60	0
169	CONTENT	☐	CRMSEF_PRODUCT_CATEGORY_INTERN		CHAR	40	0	Proxy Data Element (generated)
170	DISTRIBUTION_CHAIN_DEPENDENT_2	☐	CRMSEF_MEDIUM_DESCRIPTION		STRU	0	0
171	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
172	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
173	CONTENT	☐	CRMSEF_MEDIUM_DESCRIPTION_CONT		CHAR	80	0	Proxy Data Element (generated)
174	SALES_SPECIFICATION_TEXT_COLLE	☐	PRD_MATL_CRM_S_SLS_SPEC_TX_TAB		TTYP	0	0

History

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