SAP ABAP Table CRM_IU_DSMAGRMPIFNO_MDT (Message Type: DemandSideManagementAgreementCRMMeasureProduct)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU (Application Component) Utilities Industry
     ⤷ CRM_IU_SOA_DSM (Package) Utilities: Demand Side Management - Service Implementations

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_IU_DSMAGRMPIFNO_MDT	Table Relationship Diagram
Short Description	Message Type: DemandSideManagementAgreementCRMMeasureProduct

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	DSMAGRMPIFNO_MSG	☐	CRM_IU_DSMAGRMPIFNO_DSMMSG_IDT		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	MESSAGE_HEADER	☐	CRM_IU_BUSINESS_DOCUMENT_MESS3		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	ID	☐	CRM_IU_BUSINESS_DOCUMENT_MESS4		STRU	0	0
7	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
8	SCHEME_ID	☐			CHAR	60	0
9	SCHEME_AGENCY_ID	☐			CHAR	60	0
10	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRM_IU_AGENCY_IDENTIFICATION_C		CHAR	3	0	AgencyIdentificationCode
11	CONTENT	☐	CRM_IU_BUSINESS_DOCUMENT_MESSA		CHAR	35	0	Unique identifier of a business document in a (technical) me
12	UUID	☐	CRM_IU_UUID		STRU	0	0
13	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
14	SCHEME_ID	☐			CHAR	60	0
15	SCHEME_AGENCY_ID	☐			CHAR	60	0
16	CONTENT	☐	CRM_IU_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
17	REFERENCE_ID	☐	CRM_IU_BUSINESS_DOCUMENT_MESS4		STRU	0	0
18	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
19	SCHEME_ID	☐			CHAR	60	0
20	SCHEME_AGENCY_ID	☐			CHAR	60	0
21	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	CRM_IU_AGENCY_IDENTIFICATION_C		CHAR	3	0	AgencyIdentificationCode
22	CONTENT	☐	CRM_IU_BUSINESS_DOCUMENT_MESSA		CHAR	35	0	Unique identifier of a business document in a (technical) me
23	REFERENCE_UUID	☐	CRM_IU_UUID		STRU	0	0
24	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
25	SCHEME_ID	☐			CHAR	60	0
26	SCHEME_AGENCY_ID	☐			CHAR	60	0
27	CONTENT	☐	CRM_IU_UUID_CONTENT		CHAR	36	0	Universally Unique Identifier
28	CREATION_DATE_TIME	☐	CRM_IU_GLOBAL_DATE_TIME	XSDDATETIME_LONG_Z	DEC	21	7	GLOBAL_DateTime
29	TEST_DATA_INDICATOR	☐	CRM_IU_INDICATOR		CHAR	5	0	Indicator
30	RECONCILIATION_INDICATOR	☐	CRM_IU_INDICATOR		CHAR	5	0	Indicator
31	SENDER_BUSINESS_SYSTEM_ID	☐	CRM_IU_BUSINESS_SYSTEM_ID		CHAR	60	0	System
32	RECIPIENT_BUSINESS_SYSTEM_ID	☐	CRM_IU_BUSINESS_SYSTEM_ID		CHAR	60	0	System
33	SENDER_PARTY	☐	CRM_IU_BUSINESS_DOCUMENT_MESS2		STRU	0	0
34	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
35	INTERNAL_ID	☐	CRM_IU_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	☐	CRM_IU_PARTY_INTERNAL_ID_CONTE		CHAR	32	0	PartyInternalID
40	STANDARD_ID	☐	CRM_IU_PARTY_STANDARD_ID_TAB		TTYP	0	0
41	CONTACT_PERSON	☐	CRM_IU_BUSINESS_DOCUMENT_MESS1		STRU	0	0
42	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
43	INTERNAL_ID	☐	CRM_IU_CONTACT_PERSON_INT_ID		STRU	0	0
44	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
45	SCHEME_ID	☐			CHAR	60	0
46	SCHEME_AGENCY_ID	☐			CHAR	60	0
47	CONTENT	☐	CRM_IU_CONTACT_PERSON_INTERNAL		CHAR	32	0	Proxy Data Element (generated)
48	ORGANISATION_FORMATTED_NAME	☐	CRM_IU_LANGUAGEINDEPENDENT_TAB		TTYP	0	0
49	PERSON_FORMATTED_NAME	☐	CRM_IU_LANGUAGEINDEPENDEN_TAB1		TTYP	0	0
50	PHONE_NUMBER	☐	CRM_IU_PHONE_NUMBER_TAB		TTYP	0	0
51	FAX_NUMBER	☐	CRM_IU_PHONE_NUMBER_TAB		TTYP	0	0
52	EMAIL_URI	☐	CRM_IU_EMAIL_URI_TAB		TTYP	0	0
53	RECIPIENT_PARTY	☐	CRM_IU_BUSINESS_DOCUMENT_M_TAB		TTYP	0	0
54	BUSINESS_SCOPE	☐	CRM_IU_BUSINESS_SCOPE_TAB		TTYP	0	0
55	DSM_AGREEMENT	☐	CRM_IU_DSMAGRMPIFNO_DSM_IDT		STRU	0	0
56	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
57	ID	☐	CRM_IU_DSMAGREEMENTID		STRU	0	0
58	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
59	SCHEME_ID	☐			CHAR	60	0
60	SCHEME_VERSION_ID	☐			CHAR	15	0
61	SCHEME_AGENCY_ID	☐			CHAR	60	0
62	CONTENT	☐	CRM_IU_DEMAND_SIDE_MANAGEMENT4		CHAR	10	0	Proxy Data Element (generated)
63	BUSINESS_AGREEMENT	☐	CRM_IU_SERV_INDUS_BUS_AGRMT_ID		STRU	0	0
64	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
65	SCHEME_ID	☐			CHAR	60	0
66	SCHEME_VERSION_ID	☐			CHAR	15	0
67	SCHEME_AGENCY_ID	☐			CHAR	60	0
68	CONTENT	☐	CRM_IU_SERVICE_INDUSTRIES_BUSI		CHAR	12	0	Proxy Data Element (generated)
69	DESCRIPTION	☐	CRM_IU_LANGUAGEINDEPENDENT_SHO		CHAR	40	0	LANGUAGEINDEPENDENT_SHORT_Description
70	VALIDITY_DATE_PERIOD	☐	CRM_IU_DATE_PERIOD		STRU	0	0
71	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
72	START_DATE	☐	CRM_IU_DATE	XSDDATE_D	DATS	8	0	Date
73	END_DATE	☐	CRM_IU_DATE	XSDDATE_D	DATS	8	0	Date
74	DURATION	☐	CRM_IU_DURATION		STRG	0	0	Duration
75	POSTING_DATE	☐	CRM_IU_DATE	XSDDATE_D	DATS	8	0	Date
76	PROJECT_COST_AMOUNT	☐	CRM_IU_AMOUNT		STRU	0	0
77	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
78	CURRENCY_CODE	☐	CRM_IU_CURRENCY_CODE		CHAR	3	0	Currency
79	CONTENT	☐	CRM_IU_AMOUNT_CONTENT		DEC	28	6	Amount
80	APPROVED_TOTAL_AMOUNT	☐	CRM_IU_AMOUNT		STRU	0	0
81	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
82	CURRENCY_CODE	☐	CRM_IU_CURRENCY_CODE		CHAR	3	0	Currency
83	CONTENT	☐	CRM_IU_AMOUNT_CONTENT		DEC	28	6	Amount
84	MEASURE_ITEM	☐	CRM_IU_DSMAGRMPIFNO_MSR_TAB		TTYP	0	0
85	BUYER_PARTY	☐	CRM_IU_DSMAGRMPIFNO_BUYPTY_IDT		STRU	0	0
86	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
87	INTERNAL_ID	☐	CRM_IU_PARTY_INTERNAL_ID		STRU	0	0
88	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
89	SCHEME_ID	☐			CHAR	60	0
90	SCHEME_AGENCY_ID	☐			CHAR	60	0
91	CONTENT	☐	CRM_IU_PARTY_INTERNAL_ID_CONTE		CHAR	32	0	PartyInternalID
92	FORMATTED_NAME	☐	CRM_IU_LONG_NAME		STRU	0	0
93	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
94	LANGUAGE_CODE	☐	CRM_IU_LANGUAGE_CODE		CHAR	9	0	Language
95	CONTENT	☐	CRM_IU_LONG_NAME_CONTENT		CHAR	80	0	Proxy Data Element (generated)
96	PARTY	☐	CRM_IU_DSMAGRMPIFNO_PTY_TAB		TTYP	0	0
97	SALES_SERVICE_BUSINESS_AREA	☐	CRM_IU_DSMAGRMPIFNO_BUAREA_IDT		STRU	0	0
98	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
99	SALES_ORGANISATION_ID	☐	CRM_IU_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Organisational Centre
100	DISTRIBUTION_CHANNEL_CODE	☐	CRM_IU_DISTRIBUTION_CHANNEL_C1		STRU	0	0
101	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
102	LIST_ID	☐			CHAR	60	0
103	LIST_VERSION_ID	☐			CHAR	15	0
104	LIST_AGENCY_ID	☐			CHAR	60	0
105	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
106	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRM_IU_AGENCY_IDENTIFICATION_C		CHAR	3	0	AgencyIdentificationCode
107	CONTENT	☐	CRM_IU_DISTRIBUTION_CHANNEL_CO		CHAR	2	0	Distribution Channel
108	DIVISION_CODE	☐	CRM_IU_DIVISION_CODE		STRU	0	0
109	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
110	LIST_ID	☐			CHAR	60	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	☐	CRM_IU_AGENCY_IDENTIFICATION_C		CHAR	3	0	AgencyIdentificationCode
115	CONTENT	☐	CRM_IU_DIVISION_CODE_CONTENT		CHAR	2	0	Proxy Data Element (generated)
116	SALES_OFFICE_ID	☐	CRM_IU_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Organisational Centre
117	SALES_GROUP_ID	☐	CRM_IU_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Organisational Centre
118	SERVICE_ORGANISATION_UNIT_ID	☐	CRM_IU_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Organisational Centre
119	SERVICE_ORGANISATION_ID	☐	CRM_IU_ORGANISATIONAL_CENTRE_I		CHAR	20	0	Organisational Centre
120	COMPANY_ID	☐	CRM_IU_COMPANY_ID		STRU	0	0
121	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
122	SCHEME_ID	☐			CHAR	60	0
123	SCHEME_AGENCY_ID	☐			CHAR	60	0
124	CONTENT	☐	CRM_IU_COMPANY_ID_CONTENT		CHAR	20	0	Proxy Data Element (generated)
125	BACKEND_SYSTEM_SENDER_BUSINESS	☐	CRM_IU_BUSINESS_SYSTEM_ID		CHAR	60	0	System
126	PREMISE_DATA	☐	CRM_IU_DSMAGRMPIFNO_PREMSD_IDT		STRU	0	0
127	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
128	ADDRESS	☐	CRM_IU_DSMAGRMPIFNO_DATADR_IDT		STRU	0	0
129	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
130	ADDRESS_ID	☐	CRM_IU_ADDRESS_ID		CHAR	40	0	Unique identifier for an address
131	PHYSICAL_ADDRESS	☐	CRM_IU_DSMAGRMPIFNO_PHYADR_IDT		STRU	0	0
132	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
133	COUNTRY_CODE	☐	CRM_IU_COUNTRY_CODE		CHAR	3	0	Country
134	COUNTRY_NAME	☐	CRM_IU_LONG_NAME		STRU	0	0
135	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
136	LANGUAGE_CODE	☐	CRM_IU_LANGUAGE_CODE		CHAR	9	0	Language
137	CONTENT	☐	CRM_IU_LONG_NAME_CONTENT		CHAR	80	0	Proxy Data Element (generated)
138	REGION_CODE	☐	CRM_IU_REGION_CODE		STRU	0	0
139	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
140	LIST_ID	☐			CHAR	60	0
141	LIST_VERSION_ID	☐			CHAR	15	0
142	LIST_AGENCY_ID	☐			CHAR	60	0
143	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
144	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRM_IU_AGENCY_IDENTIFICATION_C		CHAR	3	0	AgencyIdentificationCode
145	CONTENT	☐	CRM_IU_REGION_CODE_CONTENT		CHAR	6	0	RegionCode
146	REGION_NAME	☐	CRM_IU_LANGUAGEINDEPENDENT_MED		CHAR	40	0	LANGUAGEINDEPENDENT_MEDIUM_Name
147	CITY_NAME	☐	CRM_IU_LANGUAGEINDEPENDENT_MED		CHAR	40	0	LANGUAGEINDEPENDENT_MEDIUM_Name
148	ADDITIONAL_CITY_NAME	☐	CRM_IU_LANGUAGEINDEPENDENT_MED		CHAR	40	0	LANGUAGEINDEPENDENT_MEDIUM_Name
149	STREET_POSTAL_CODE	☐	CRM_IU_POSTAL_CODE		CHAR	10	0	Postal Code
150	STREET_NAME	☐	CRM_IU_STREET_NAME		CHAR	60	0	Street
151	REGIONAL_STRUCTURE_STREET_CODE	☐	CRM_IU_REGION_STRUCT_CITY_CODE		STRU	0	0
152	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
153	LIST_ID	☐			CHAR	60	0
154	LIST_VERSION_ID	☐			CHAR	15	0
155	LIST_AGENCY_ID	☐			CHAR	60	0
156	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
157	LIST_AGENCY_SCHEME_AGENCY_ID	☐	CRM_IU_AGENCY_IDENTIFICATION_C		CHAR	3	0	AgencyIdentificationCode
158	CONTENT	☐	CRM_IU_REGIONAL_STRUCTURE_CITY		CHAR	12	0	Proxy Data Element (generated)
159	REGIONAL_STRUCTURE_STREET_NAME	☐	CRM_IU_LANGUAGEINDEPENDENT_MED		CHAR	40	0	LANGUAGEINDEPENDENT_MEDIUM_Name
160	STREET_SUFFIX_NAME	☐	CRM_IU_LANGUAGEINDEPENDENT_MED		CHAR	40	0	LANGUAGEINDEPENDENT_MEDIUM_Name
161	ADDITIONAL_STREET_SUFFIX_NAME	☐	CRM_IU_LANGUAGEINDEPENDENT_MED		CHAR	40	0	LANGUAGEINDEPENDENT_MEDIUM_Name
162	HOUSE_ID	☐	CRM_IU_HOUSE_ID		CHAR	10	0	House Number
163	ADDITIONAL_HOUSE_ID	☐	CRM_IU_HOUSE_ID		CHAR	10	0	House Number
164	BUILDING_ID	☐	CRM_IU_BUILDING_ID		CHAR	10	0	Building
165	ROOM_ID	☐	CRM_IU_ROOM_ID		CHAR	10	0	Room Number
166	TIME_ZONE_CODE	☐	CRM_IU_TIME_ZONE_CODE		CHAR	10	0	Time Zone
167	ADDRESS_SUPPLEMENT	☐	CRM_IU_DSMAGRMPIFNO_ADRSUP_IDT		STRU	0	0
168	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
169	FLOOR_ID	☐	CRM_IU_FLOOR_ID		CHAR	10	0	Floor
170	ROOM_ID	☐	CRM_IU_ROOM_ID		CHAR	10	0	Room Number
171	ADDITIONAL_INFORMATION_TEXT	☐	CRM_IU_LEN40_ADDITIONAL_INFOR1		STRU	0	0
172	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
173	LANGUAGE_CODE	☐	CRM_IU_LANGUAGE_CODE		CHAR	9	0	Language
174	CONTENT	☐	CRM_IU_LEN40_ADDITIONAL_INFORM		CHAR	40	0	LEN40_AdditionalInformationText
175	DSM_PROGRAMME_REFERENCE	☐	CRM_IU_DSMAGRMPIFNO_PRGREF_IDT		STRU	0	0
176	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
177	ID	☐	CRM_IU_DSMPROGRAMMEID		STRU	0	0
178	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
179	SCHEME_ID	☐			CHAR	60	0
180	SCHEME_VERSION_ID	☐			CHAR	15	0
181	SCHEME_AGENCY_ID	☐			CHAR	60	0
182	CONTENT	☐	CRM_IU_DEMAND_SIDE_MANAGEMENT		CHAR	20	0	Proxy Data Element (generated)
183	DSM_APPLICATION_REFERENCE	☐	CRM_IU_DSMAGRMPIFNO_APLREF_IDT		STRU	0	0
184	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
185	ID	☐	CRM_IU_DSMAPPLICATIONID		STRU	0	0
186	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
187	SCHEME_ID	☐			CHAR	60	0
188	SCHEME_VERSION_ID	☐			CHAR	15	0
189	SCHEME_AGENCY_ID	☐			CHAR	60	0
190	CONTENT	☐	CRM_IU_DEMAND_SIDE_MANAGEMENT2		CHAR	10	0	Proxy Data Element (generated)
191	BUSTRANS_DOCUMENT_REFERENCE	☐	CRM_IU_DSMAGRMPIFNO_DOCREF_TAB		TTYP	0	0

History

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