SAP ABAP Table CRMPMM_SIMQRY_PRICEAGR_I (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_I	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	CUSTOMER_QUOTE_ITEM_ID	☐	CRMPMM_CUSTOMER_QUOTE_ITEM_ID		CHAR	6	0	Proxy Data Element (generated)
3	CUSTOMER_QUOTE_ITEM_UUID	☐	CRMSEF_UUID		STRU	0	0
4	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
5	SCHEME_ID	☐			CHAR	60	0
6	SCHEME_AGENCY_ID	☐			CHAR	60	0
7	CONTENT	☐	CRMSEF_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
8	PARENT_CUSTOMER_QUOTE_ITEM_ID	☐	CRMPMM_CUSTOMER_QUOTE_ITEM_ID		CHAR	6	0	Proxy Data Element (generated)
9	SALES_RESPONSIBLE	☐	CRMPMM_SIMQRY_RESP_I		STRU	0	0
10	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
11	PARTY_INTERNAL_ID	☐	CRMSEF_PARTY_INTERNAL_ID		STRU	0	0
12	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
13	SCHEME_ID	☐			CHAR	60	0
14	SCHEME_AGENCY_ID	☐			CHAR	60	0
15	CONTENT	☐	CRMSEF_PARTY_INTERNAL_ID_CONTE		CHAR	32	0	Proprietary identifier for a party
16	RESPONSIBLE_USER_ACCOUNT_ID	☐	CRMSEF_USER_ACCOUNT_ID		STRU	0	0
17	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
18	SCHEME_AGENCY_ID	☐			CHAR	60	0
19	AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
20	CONTENT	☐	CRMSEF_USER_ACCOUNT_ID_CONTENT		CHAR	255	0	Proxy Data Element (generated)
21	SHIP_TO_PARTY_INTERNAL_ID	☐	CRMSEF_PARTY_INTERNAL_ID		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_PARTY_INTERNAL_ID_CONTE		CHAR	32	0	Proprietary identifier for a party
26	PRODUCT	☐	CRMPMM_SIMQRY_PRODUCT_I		STRU	0	0
27	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
28	INTERNAL_ID	☐	CRMSEF_PRODUCT_INTERNAL_ID		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_PRODUCT_INTERNAL_ID_CON		CHAR	60	0	Proxy Data Element (generated)
33	QUANTITY	☐	CRMSEF_QUANTITY		STRU	0	0
34	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
35	UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
36	CONTENT	☐	CRMSEF_QUANTITY_CONTENT		DEC	31	14	QUANTITY is the non-monetary numerical declaration of a quan
37	SALES_MEASURE_UNIT_CODE	☐	CRMSEF_MEASURE_UNIT_CODE		CHAR	3	0	Proxy Data Element (Generated)
38	CONFIGURATION	☐	CRMPMM_SIMQRY_PROD_CONF_I_TAB		TTYP	0	0
39	VALIDITY_START_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
40	VALIDITY_END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
41	NET_AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
42	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
43	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
44	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
45	REQUESTED_DEAL_PRICE_AMOUNT	☐	CRMSEF_AMOUNT		STRU	0	0
46	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
47	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
48	CONTENT	☐	CRMSEF_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (Generated)
49	REQUESTED_DEAL_DISCOUNT	☐	CRMPMM_SIMQRY_REQ_DEAL_I_TAB		TTYP	0	0
50	CURRENCY_CODE	☐	CRMSEF_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (Generated)
51	DELIVERY_TERMS	☐	CRMPMM_SIMQRY_DELIVERY_TERM_I		STRU	0	0
52	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
53	INCOTERMS	☐	CRMSEF_INCOTERMS		STRU	0	0
54	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
55	CLASSIFICATION_CODE	☐	CRMSEF_INCOTERMS_CLASSIFICATIO		CHAR	3	0	Proxy Data Element (generated)
56	TRANSFER_LOCATION_NAME	☐	CRMSEF_INCOTERMS_TRANSFER_LOCA		CHAR	28	0	Proxy Data Element (generated)
57	QUANTITY_TOLERANCE	☐	CRMSEF_QUANTITY_TOLERANCE		STRU	0	0
58	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
59	OVER_PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
60	OVER_PERCENT_UNLIM_INDICATOR	☐	CRMSEF_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has ex
61	UNDER_PERCENT	☐	CRMSEF_PERCENT		DEC	16	6	Proxy Data Element (generated)
62	DELIVERY_PLANT_ID	☐	CRMSEF_PLANT_ID		STRU	0	0
63	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
64	SCHEME_AGENCY_ID	☐			CHAR	60	0
65	CONTENT	☐	CRMSEF_PLANT_ID_CONTENT		CHAR	4	0	Proxy Data Element (generated)
66	REQUESTED_DELIVERY_DATE_TIME	☐	CRMSEF_LOCALNORMALISED_DATE_T1		STRU	0	0
67	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
68	TIME_ZONE_CODE	☐	CRMSEF_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (Generated)
69	CONTENT	☐	CRMSEF_LOCALNORMALISED_DATE_TI	XSDDATETIME_LONG_Z	DEC	21	7	Proxy Data Element (generated)
70	CRMPMM_REQ_DELIV_DATE_CALCUL_I	☐	CRMSEF_DATE_CALCULATION_FUNCTI		STRU	0	0
71	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
72	DATE_CALC_FUNC_GRP_CODE	☐	CRMSEF_DATE_CALCULATION_FUNCT2		STRU	0	0
73	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
74	LIST_VERSION_ID	☐			CHAR	15	0
75	LIST_AGENCY_ID	☐			CHAR	60	0
76	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
77	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
78	CONTENT	☐	CRMSEF_DATE_CALCULATION_FUNCT1		CHAR	4	0	Proxy Data Element (generated)
79	DATE_CALC_FUNC_CODE	☐	CRMSEF_DATE_CALCULATION_FUNCT4		STRU	0	0
80	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
81	LIST_VERSION_ID	☐			CHAR	15	0
82	LIST_AGENCY_ID	☐			CHAR	60	0
83	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
84	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
85	CONTENT	☐	CRMSEF_DATE_CALCULATION_FUNCT3		CHAR	12	0	Proxy Data Element (generated)
86	DATE_CALC_FUNC_VERSION_ID	☐	CRMSEF_VERSION_ID		CHAR	32	0	Proxy Data Element (generated)
87	CASH_DISCOUNT_TERMS	☐	CRMSEF_CASH_DISCOUNT_TERMS		STRU	0	0
88	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
89	CODE	☐	CRMSEF_CASH_DISCOUNT_TERMS_CO1		STRU	0	0
90	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
91	LIST_AGENCY_ID	☐			CHAR	60	0
92	LIST_VERSION_ID	☐			CHAR	15	0
93	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
94	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRMSEF_AGENCY_IDENTIFICATION_C		CHAR	3	0	An AgencyIdentificationCode is a code representation of th
95	CONTENT	☐	CRMSEF_CASH_DISCOUNT_TERMS_COD		CHAR	4	0	Proxy Data Element (generated)
96	PAYMENT_BASELINE_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
97	MAXIMUM_CASH_DISCOUNT	☐	CRMSEF_CASH_DISCOUNT		STRU	0	0
98	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
99	DAYS_VALUE	☐	CRMSEF_CASH_DISCOUNT_DAYS_VALU		INT4	10	0	Proxy Data Element (generated)
100	DAY_OF_MONTH_VALUE	☐	CRMSEF_CASH_DISCOUNT_DAY_OF_MO		INT4	10	0	Proxy Data Element (generated)
101	MONTH_OFFSET_VALUE	☐	CRMSEF_CASH_DISCOUNT_MONTH_OFF		INT4	10	0	Proxy Data Element (generated)
102	END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
103	PERCENT	☐	CRMSEF_CASH_DISCOUNT_PERCENT		DEC	5	3	Proxy Data Element (generated)
104	NORMAL_CASH_DISCOUNT	☐	CRMSEF_CASH_DISCOUNT		STRU	0	0
105	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
106	DAYS_VALUE	☐	CRMSEF_CASH_DISCOUNT_DAYS_VALU		INT4	10	0	Proxy Data Element (generated)
107	DAY_OF_MONTH_VALUE	☐	CRMSEF_CASH_DISCOUNT_DAY_OF_MO		INT4	10	0	Proxy Data Element (generated)
108	MONTH_OFFSET_VALUE	☐	CRMSEF_CASH_DISCOUNT_MONTH_OFF		INT4	10	0	Proxy Data Element (generated)
109	END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
110	PERCENT	☐	CRMSEF_CASH_DISCOUNT_PERCENT		DEC	5	3	Proxy Data Element (generated)
111	FULL_PAYMENT_DUE_DAYS_VALUE	☐	CRMSEF_FL_PAY_CSH_DIS_DAY_VAL		INT4	10	0	Proxy Data Element (generated)
112	FULL_PAYMENT_DAY_OF_MONTH_VALU	☐	CRMSEF_FL_PAY_CSH_DISC_MON_VAL		INT4	10	0	Proxy Data Element (generated)
113	FULL_PAYMENT_MONTH_OFFSET_VALU	☐	CRMSEF_FL_PAY_CSH_DIS_MON_OFF		INT4	10	0	Proxy Data Element (generated)
114	FULL_PAYMENT_END_DATE	☐	CRMSEF_DATE		DATS	8	0	Proxy Data Element (Generated)
115	DESCRIPTION	☐	CRMSEF_MEDIUM_DESCRIPTION		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_DESCRIPTION_CONT		CHAR	80	0	Proxy Data Element (generated)

History

Last changed by/on	SAP	20130604
SAP Release Created in