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

History

Last changed by/on	SAP	20130604
SAP Release Created in