SAP ABAP Table CRMPMM_SIMQRY_PRICEAGR (Price Agreement CRM Simulate Price Information Query Synchro)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-SLO-QUT-PMM (Application Component) Quotations Price and Margin Management Integration
     ⤷ CRM_QUOTATION_PMM_PROXY (Package) Integration of SAP Price and Margin Management with SAP CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMPMM_SIMQRY_PRICEAGR	Table Relationship Diagram
Short Description	Price Agreement CRM Simulate Price Information Query Synchro

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_AGREEMENT	☐	CRMPMM_SIMQRY_PRICEAGR_PRICE		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	SYSTEM_ADMINISTRATIVE_DATA	☐	CRMSEF_SYSTEM_ADMINISTRATIVE_D		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	CREATION_DATE_TIME	☐	CRMSEF_GLOBAL_DATE_TIME	XSDDATETIME_LONG_Z	DEC	21	7	Proxy Data Element (generated)
7	CREATION_IDENTITY_UUID	☐	CRMSEF_UUID		STRU	0	0
8	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
9	SCHEME_ID	☐			CHAR	60	0
10	SCHEME_AGENCY_ID	☐			CHAR	60	0
11	CONTENT	☐	CRMSEF_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
12	CREATION_USER_ACCOUNT_ID	☐	CRMSEF_USER_ACCOUNT_ID		STRU	0	0
13	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
14	SCHEME_AGENCY_ID	☐			CHAR	60	0
15	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
16	CONTENT	☐	CRMSEF_USER_ACCOUNT_ID_CONTENT		CHAR	255	0	Proxy Data Element (generated)
17	LAST_CHANGE_DATE_TIME	☐	CRMSEF_GLOBAL_DATE_TIME	XSDDATETIME_LONG_Z	DEC	21	7	Proxy Data Element (generated)
18	LAST_CHANGE_IDENTITY_UUID	☐	CRMSEF_UUID		STRU	0	0
19	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
20	SCHEME_ID	☐			CHAR	60	0
21	SCHEME_AGENCY_ID	☐			CHAR	60	0
22	CONTENT	☐	CRMSEF_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
23	LAST_CHANGE_USER_ACCOUNT_ID	☐	CRMSEF_USER_ACCOUNT_ID		STRU	0	0
24	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
25	SCHEME_AGENCY_ID	☐			CHAR	60	0
26	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
27	CONTENT	☐	CRMSEF_USER_ACCOUNT_ID_CONTENT		CHAR	255	0	Proxy Data Element (generated)
28	CUSTOMER_QUOTE_UUID	☐	CRMSEF_UUID		STRU	0	0
29	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
30	SCHEME_ID	☐			CHAR	60	0
31	SCHEME_AGENCY_ID	☐			CHAR	60	0
32	CONTENT	☐	CRMSEF_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
33	CUSTOMER_QUOTE_ID	☐	CRMSEF_CUSTOMER_QUOTE_ID		STRU	0	0
34	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
35	SCHEME_AGENCY_ID	☐			CHAR	60	0
36	CONTENT	☐	CRMSEF_CUSTOMER_QUOTE_ID_CONTE		CHAR	10	0	Proxy Data Element (generated)
37	BUYER_PARTY_INTERNAL_ID	☐	CRMSEF_PARTY_INTERNAL_ID		STRU	0	0
38	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
39	SCHEME_ID	☐			CHAR	60	0
40	SCHEME_AGENCY_ID	☐			CHAR	60	0
41	CONTENT	☐	CRMSEF_PARTY_INTERNAL_ID_CONTE		CHAR	32	0	Proprietary identifier for a party
42	SALES_RESPONSIBLE	☐	CRMPMM_SIMQRY_RESP		STRU	0	0
43	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
44	PARTY_INTERNAL_ID	☐	CRMSEF_PARTY_INTERNAL_ID		STRU	0	0
45	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
46	SCHEME_ID	☐			CHAR	60	0
47	SCHEME_AGENCY_ID	☐			CHAR	60	0
48	CONTENT	☐	CRMSEF_PARTY_INTERNAL_ID_CONTE		CHAR	32	0	Proprietary identifier for a party
49	RESPONSIBLE_USER_ACCOUNT_ID	☐	CRMSEF_USER_ACCOUNT_ID		STRU	0	0
50	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
51	SCHEME_AGENCY_ID	☐			CHAR	60	0
52	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
53	CONTENT	☐	CRMSEF_USER_ACCOUNT_ID_CONTENT		CHAR	255	0	Proxy Data Element (generated)
54	SHIP_TO_PARTY_INTERNAL_ID	☐	CRMSEF_PARTY_INTERNAL_ID		STRU	0	0
55	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
56	SCHEME_ID	☐			CHAR	60	0
57	SCHEME_AGENCY_ID	☐			CHAR	60	0
58	CONTENT	☐	CRMSEF_PARTY_INTERNAL_ID_CONTE		CHAR	32	0	Proprietary identifier for a party
59	CRMPMM_SALES_SERVICE_AREA	☐	CRMPMM_SIMQRY_SRVBUSAREA		STRU	0	0
60	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
61	SALES_ORGANISATION_ID	☐	CRMSEF_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Proxy Data Element (Generated)
62	DISTRIBUTION_CHANNEL_CODE	☐	CRMSEF_DISTRIBUTION_CHANNEL_C1		STRU	0	0
63	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
64	LIST_ID	☐			CHAR	60	0
65	LIST_VERSION_ID	☐			CHAR	15	0
66	LIST_AGENCY_ID	☐			CHAR	60	0
67	AGENCY_SCHEME_ID	☐			CHAR	60	0
68	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
69	CONTENT	☐	CRMSEF_DISTRIBUTION_CHANNEL_CO		CHAR	2	0	Proxy Data Element (Generated)
70	DIVISION_CODE	☐	CRMSEF_DIVISION_CODE		STRU	0	0
71	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
72	LIST_ID	☐			CHAR	60	0
73	LIST_VERSION_ID	☐			CHAR	15	0
74	LIST_AGENCY_ID	☐			CHAR	60	0
75	AGENCY_SCHEME_ID	☐			CHAR	60	0
76	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
77	CONTENT	☐	CRMSEF_DIVISION_CODE_CONTENT		CHAR	2	0	Proxy Data Element (Generated)
78	SALES_GROUP_ID	☐	CRMSEF_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Proxy Data Element (Generated)
79	VALIDITY_START_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
80	VALIDITY_END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
81	PRICING_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
82	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
83	NET_AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
84	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
85	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
86	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
87	CRMPMM_APPROVAL_MAP_REQ	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
88	DELIVERY_TERMS	☐	CRMPMM_SIMQRY_DELIVERY_TERM		STRU	0	0
89	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
90	INCOTERMS	☐	CRMSEF_INCOTERMS		STRU	0	0
91	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
92	CLASSIFICATION_CODE	☐	CRMSEF_INCOTERMS_CLASSIFICATIO		CHAR	3	0	Proxy Data Element (generated)
93	TRANSFER_LOCATION_NAME	☐	CRMSEF_INCOTERMS_TRANSFER_LOCA		CHAR	28	0	Proxy Data Element (generated)
94	QUANTITY_TOLERANCE	☐	CRMSEF_QUANTITY_TOLERANCE		STRU	0	0
95	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
96	OVER_PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
97	OVER_PERCENT_UNLIM_INDICATOR	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
98	UNDER_PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
99	DELIVERY_PLANT_ID	☐	CRMSEF_PLANT_ID		STRU	0	0
100	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
101	SCHEME_AGENCY_ID	☐			CHAR	60	0
102	CONTENT	☐	CRMSEF_PLANT_ID_CONTENT		CHAR	4	0	Proxy Data Element (generated)
103	REQUESTED_DELIVERY_DATE_TIME	☐	CRMSEF_LOCALNORMALISED_DATE_T1		STRU	0	0
104	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
105	TIME_ZONE_CODE	☐	CRMSEF_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (Generated)
106	CONTENT	☐	CRMSEF_LOCALNORMALISED_DATE_TI	XSDDATETIME_LONG_Z	DEC	21	7	Proxy Data Element (generated)
107	CRMPMM_REQ_DELIV_DATE_CALCUL	☐	CRMSEF_DATE_CALCULATION_FUNCTI		STRU	0	0
108	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
109	DATE_CALC_FUNC_GRP_CODE	☐	CRMSEF_DATE_CALCULATION_FUNCT2		STRU	0	0
110	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
111	LIST_VERSION_ID	☐			CHAR	15	0
112	LIST_AGENCY_ID	☐			CHAR	60	0
113	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
114	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
115	CONTENT	☐	CRMSEF_DATE_CALCULATION_FUNCT1		CHAR	4	0	Proxy Data Element (generated)
116	DATE_CALC_FUNC_CODE	☐	CRMSEF_DATE_CALCULATION_FUNCT4		STRU	0	0
117	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	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_DATE_CALCULATION_FUNCT3		CHAR	12	0	Proxy Data Element (generated)
123	DATE_CALC_FUNC_VERSION_ID	☐	CRMSEF_VERSION_ID		CHAR	32	0	Proxy Data Element (generated)
124	CASH_DISCOUNT_TERMS	☐	CRMSEF_CASH_DISCOUNT_TERMS		STRU	0	0
125	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
126	CODE	☐	CRMSEF_CASH_DISCOUNT_TERMS_CO1		STRU	0	0
127	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
128	LIST_AGENCY_ID	☐			CHAR	60	0
129	LIST_VERSION_ID	☐			CHAR	15	0
130	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
131	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
132	CONTENT	☐	CRMSEF_CASH_DISCOUNT_TERMS_COD		CHAR	4	0	Proxy Data Element (generated)
133	PAYMENT_BASELINE_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
134	MAXIMUM_CASH_DISCOUNT	☐	CRMSEF_CASH_DISCOUNT		STRU	0	0
135	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
136	DAYS_VALUE	☐	CRMSEF_CASH_DISCOUNT_DAYS_VALU		INT4	10	0	Proxy Data Element (generated)
137	DAY_OF_MONTH_VALUE	☐	CRMSEF_CASH_DISCOUNT_DAY_OF_MO		INT4	10	0	Proxy Data Element (generated)
138	MONTH_OFFSET_VALUE	☐	CRMSEF_CASH_DISCOUNT_MONTH_OFF		INT4	10	0	Proxy Data Element (generated)
139	END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
140	PERCENT	☐	CRMSEF_CASH_DISCOUNT_PERCENT		DEC	5	3	Proxy Data Element (generated)
141	NORMAL_CASH_DISCOUNT	☐	CRMSEF_CASH_DISCOUNT		STRU	0	0
142	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
143	DAYS_VALUE	☐	CRMSEF_CASH_DISCOUNT_DAYS_VALU		INT4	10	0	Proxy Data Element (generated)
144	DAY_OF_MONTH_VALUE	☐	CRMSEF_CASH_DISCOUNT_DAY_OF_MO		INT4	10	0	Proxy Data Element (generated)
145	MONTH_OFFSET_VALUE	☐	CRMSEF_CASH_DISCOUNT_MONTH_OFF		INT4	10	0	Proxy Data Element (generated)
146	END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
147	PERCENT	☐	CRMSEF_CASH_DISCOUNT_PERCENT		DEC	5	3	Proxy Data Element (generated)
148	FULL_PAYMENT_DUE_DAYS_VALUE	☐	CRMSEF_FL_PAY_CSH_DIS_DAY_VAL		INT4	10	0	Proxy Data Element (generated)
149	FULL_PAYMENT_DAY_OF_MONTH_VALU	☐	CRMSEF_FL_PAY_CSH_DISC_MON_VAL		INT4	10	0	Proxy Data Element (generated)
150	FULL_PAYMENT_MONTH_OFFSET_VALU	☐	CRMSEF_FL_PAY_CSH_DIS_MON_OFF		INT4	10	0	Proxy Data Element (generated)
151	FULL_PAYMENT_END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
152	DESCRIPTION	☐	CRMSEF_MEDIUM_DESCRIPTION		STRU	0	0
153	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
154	LANGUAGE_CODE	☐	CRMSEF_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (Generated)
155	CONTENT	☐	CRMSEF_MEDIUM_DESCRIPTION_CONT		CHAR	80	0	Proxy Data Element (generated)
156	ITEM	☐	CRMPMM_SIMQRY_PRICEAGR_I_TAB		TTYP	0	0

History

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