SAP ABAP Table SPS_SALES_PRICE_SPECIFICATION6 (Sales price specification create check query.)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-CON (Application Component) Condition Technique
     ⤷ CRM_SPS_CND_XI_PROXY (Package) Generated Proxies for Sales Price Specification

Basic Data

Table Category	INTTAB	Structure
Structure	SPS_SALES_PRICE_SPECIFICATION6	Table Relationship Diagram
Short Description	Sales price specification create check query.

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	MESSAGE_HEADER	☐	CRMSEF_BUSINESS_DOCUMENT_MESS4		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	ID	☐	CRMSEF_BUSINESS_DOCUMENT_MESS1		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	SCHEME_ID	☐			CHAR	60	0
7	SCHEME_AGENCY_ID	☐			CHAR	60	0
8	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
9	CONTENT	☐	CRMSEF_BUSINESS_DOCUMENT_MESSA		CHAR	35	0	Unique identifier of a business document in a (technical) me
10	UUID	☐	CRMSEF_UUID		STRU	0	0
11	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
12	SCHEME_ID	☐			CHAR	60	0
13	SCHEME_AGENCY_ID	☐			CHAR	60	0
14	CONTENT	☐	CRMSEF_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
15	REFERENCE_ID	☐	CRMSEF_BUSINESS_DOCUMENT_MESS1		STRU	0	0
16	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
17	SCHEME_ID	☐			CHAR	60	0
18	SCHEME_AGENCY_ID	☐			CHAR	60	0
19	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
20	CONTENT	☐	CRMSEF_BUSINESS_DOCUMENT_MESSA		CHAR	35	0	Unique identifier of a business document in a (technical) me
21	REFERENCE_UUID	☐	CRMSEF_UUID		STRU	0	0
22	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
23	SCHEME_ID	☐			CHAR	60	0
24	SCHEME_AGENCY_ID	☐			CHAR	60	0
25	CONTENT	☐	CRMSEF_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
26	CREATION_DATE_TIME	☐	CRMSEF_GLOBAL_DATE_TIME	XSDDATETIME_LONG_Z	DEC	21	7	Proxy Data Element (generated)
27	TEST_DATA_INDICATOR	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
28	RECONCILIATION_INDICATOR	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
29	SENDER_BUSINESS_SYSTEM_ID	☐	CRMSEF_BUSINESS_SYSTEM_ID		CHAR	60	0	Proxy Data Element (generated)
30	RECIPIENT_BUSINESS_SYSTEM_ID	☐	CRMSEF_BUSINESS_SYSTEM_ID		CHAR	60	0	Proxy Data Element (generated)
31	SENDER_PARTY	☐	CRMSEF_BUSINESS_DOCUMENT_MESS3		STRU	0	0
32	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
33	INTERNAL_ID	☐	CRMSEF_PARTY_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_PARTY_INTERNAL_ID_CONTE		CHAR	32	0	Proprietary identifier for a party
38	STANDARD_ID	☐	CRMSEF_PARTY_STANDARD_ID_TAB		TTYP	0	0
39	CONTACT_PERSON	☐	CRMSEF_BUSINESS_DOCUMENT_MESS2		STRU	0	0
40	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
41	INTERNAL_ID	☐	CRMSEF_CONTACT_PERSON_INTERNA1		STRU	0	0
42	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
43	SCHEME_ID	☐			CHAR	60	0
44	SCHEME_AGENCY_ID	☐			CHAR	60	0
45	CONTENT	☐	CRMSEF_CONTACT_PERSON_INTERNAL		CHAR	32	0	Proxy Data Element (generated)
46	ORGANISATION_FORMATTED_NAME	☐	CRMSEF_LANGUAGEINDEPENDENT_TAB		TTYP	0	0
47	PERSON_FORMATTED_NAME	☐	CRMSEF_LANGUAGEINDEPENDEN_TAB1		TTYP	0	0
48	PHONE_NUMBER	☐	CRMSEF_PHONE_NUMBER_TAB		TTYP	0	0
49	FAX_NUMBER	☐	CRMSEF_PHONE_NUMBER_TAB		TTYP	0	0
50	EMAIL_URI	☐	CRMSEF_EMAIL_URI_TAB		TTYP	0	0
51	RECIPIENT_PARTY	☐	CRMSEF_BUSINESS_DOCUMENT_M_TAB		TTYP	0	0
52	BUSINESS_SCOPE	☐	CRMSEF_BUSINESS_SCOPE_TAB		TTYP	0	0
53	A2AINDICATOR	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
54	PRICE_SPECIFICATION_ELEMENT	☐	CRMSEF_PRICE_SPECIFICATION_E16		STRU	0	0
55	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
56	ACCEPTANCE_STATUS_CODE	☐	CRMSEF_ACCEPTANCE_STATUS_CODE		CHAR	2	0	Proxy Data Element (generated)
57	TYPE_CODE	☐	CRMSEF_PRICE_SPECIFICATION_EL1		STRU	0	0
58	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
59	LIST_ID	☐			CHAR	60	0
60	LIST_VERSION_ID	☐			CHAR	15	0
61	LIST_AGENCY_ID	☐			CHAR	60	0
62	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
63	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
64	CONTENT	☐	CRMSEF_PRICE_SPECIFICATION_ELE		CHAR	4	0	Proxy Data Element (generated)
65	CATEGORY_CODE	☐	CRMSEF_PRICE_SPECIFICATION_EL5		STRU	0	0
66	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
67	LIST_VERSION_ID	☐			CHAR	15	0
68	CONTENT	☐	CRMSEF_PRICE_SPECIFICATION_EL4		CHAR	1	0	Proxy Data Element (generated)
69	PURPOSE_CODE	☐	CRMSEF_PRICE_SPECIFICATION_EL3		STRU	0	0
70	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
71	LIST_VERSION_ID	☐			CHAR	15	0
72	CONTENT	☐	CRMSEF_PRICE_SPECIFICATION_EL2		CHAR	4	0	Proxy Data Element (generated)
73	VALIDITY_PERIOD	☐	CRMSEF_TIME_POINT_PERIOD		STRU	0	0
74	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
75	INTERVAL_BOUNDARY_TYPE_CODE	☐	CRMSEF_INTERVAL_BOUNDARY_TYPE		CHAR	1	0	Proxy Data Element (generated)
76	START_TIME_POINT	☐	CRMSEF_TIME_POINT		STRU	0	0
77	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
78	TYPE_CODE	☐	CRMSEF_TIME_POINT_TYPE_CODE		CHAR	2	0	Proxy Data Element (generated)
79	DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
80	TIME	☐	CRMSEF_TIME		TIMS	6	0	Proxy Data Element (Generated)
81	DATE_TIME	☐	CRMSEF_DATE_TIME		STRU	0	0
82	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
83	TIME_ZONE_CODE	☐	CRMSEF_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (Generated)
84	DAYLIGHT_SAVING_TIME_INDICATOR	☐			CHAR	5	0
85	CONTENT	☐			STRG	0	0
86	END_TIME_POINT	☐	CRMSEF_TIME_POINT		STRU	0	0
87	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
88	TYPE_CODE	☐	CRMSEF_TIME_POINT_TYPE_CODE		CHAR	2	0	Proxy Data Element (generated)
89	DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
90	TIME	☐	CRMSEF_TIME		TIMS	6	0	Proxy Data Element (Generated)
91	DATE_TIME	☐	CRMSEF_DATE_TIME		STRU	0	0
92	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
93	TIME_ZONE_CODE	☐	CRMSEF_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (Generated)
94	DAYLIGHT_SAVING_TIME_INDICATOR	☐			CHAR	5	0
95	CONTENT	☐			STRG	0	0
96	DURATION	☐	CRMSEF_DURATION		STRG	0	0	Proxy Data Element (generated)
97	PROPERTY_DEFINITION_CLASS_CODE	☐	CRMSEF_PRICE_SPECIFICATION_E15		STRU	0	0
98	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
99	LIST_VERSION_ID	☐			CHAR	15	0
100	CONTENT	☐	CRMSEF_PRICE_SPECIFICATION_E14		CHAR	2	0	Proxy Data Element (generated)
101	PROPERTY_VALUATION	☐	CRMSEF_PRICE_SPECIFICATIO_TAB1		TTYP	0	0
102	RATE	☐	CRMSEF_RATE		STRU	0	0
103	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
104	DECIMAL_VALUE	☐	CRMSEF_DECIMAL_VALUE		DEC	31	14	Proxy Data Element (generated)
105	MEASURE_UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
106	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
107	BASE_DECIMAL_VALUE	☐	CRMSEF_DECIMAL_VALUE		DEC	31	14	Proxy Data Element (generated)
108	BASE_MEASURE_UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
109	BASE_CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
110	RATE_QUANTITY_TYPE_CODE	☐	CRMSEF_QUANTITY_TYPE_CODE		STRU	0	0
111	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
112	LIST_ID	☐			CHAR	60	0
113	LIST_VERSION_ID	☐			CHAR	15	0
114	LIST_AGENCY_ID	☐			CHAR	60	0
115	LIST_AGEN_SCHM_ID	☐			CHAR	60	0
116	LIST_AGEN_SCHM_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
117	CONTENT	☐	CRMSEF_QUANTITY_TYPE_CODE_CONT		CHAR	10	0	Proxy Data Element (generated)
118	RATE_BASE_QUANTITY_TYPE_CODE	☐	CRMSEF_QUANTITY_TYPE_CODE		STRU	0	0
119	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
120	LIST_ID	☐			CHAR	60	0
121	LIST_VERSION_ID	☐			CHAR	15	0
122	LIST_AGENCY_ID	☐			CHAR	60	0
123	LIST_AGEN_SCHM_ID	☐			CHAR	60	0
124	LIST_AGEN_SCHM_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
125	CONTENT	☐	CRMSEF_QUANTITY_TYPE_CODE_CONT		CHAR	10	0	Proxy Data Element (generated)
126	PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
127	FIXED_AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
128	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
129	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
130	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
131	SCALE_LINE	☐	CRMSEF_PRICE_SPECIFICATION_TAB		TTYP	0	0
132	DESCRIPTION	☐	CRMSEF_SHORT_DESCRIPTION_TAB		TTYP	0	0
133	ACTION_CODE	☐	CRMSEF_ACTION_CODE		CHAR	2	0	Proxy Data Element (generated)

History

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