SAP ABAP Table CRMPMM_SIMQUERY_PRICEAGR (Request to simulate price information of a price agreement)

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_SIMQUERY_PRICEAGR	Table Relationship Diagram
Short Description	Request to simulate price information of a price agreement

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

History

Last changed by/on	SAP	20130604
SAP Release Created in