SAP ABAP Table LOYMA_MSHACJBECO_ACTIVITY (IDT - Activity)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY-INT-POS (Application Component) Loyalty POS Integration
     ⤷ LOY_MA_XI_PROXY (Package) Loyalty Member Activity XI Proxy Generation

Basic Data

Table Category	INTTAB	Structure
Structure	LOYMA_MSHACJBECO_ACTIVITY	Table Relationship Diagram
Short Description	IDT - Activity

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	LOYALTY_MEMBERSHIP_ACTIVITY_ID	☐	LOY_MSH_ACTY_ID		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	SCHEME_ID	☐			CHAR	60	0
5	SCHEME_VERSION_ID	☐			CHAR	15	0
6	SCHEME_AGENCY_ID	☐			CHAR	60	0
7	CONTENT	☐	LOY_MSH_ACTY_ID_CONTENT		CHAR	10	0	Proxy Data Element (generated)
8	LOYALTY_MSH_ACTCATCODE	☐	LOY_MSHACTY_CATEGORYCODE		STRU	0	0
9	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
10	LIST_ID	☐			CHAR	60	0
11	LIST_VERSION_ID	☐			CHAR	15	0
12	LIST_AGENCY_ID	☐			CHAR	60	0
13	CONTENT	☐	LOY_MSHACTY_CATEGORYCODE_CONT		CHAR	3	0	Proxy Data Element (generated)
14	LOYALTY_MSH_ACTCATNAME	☐	LOY_MEDIUM_NAME		STRU	0	0
15	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
16	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
17	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
18	LOYALTY_MSH_ACTTYPECODE	☐	LOY_MSH_ACTY_PROFILECODE		STRU	0	0
19	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
20	LIST_ID	☐			CHAR	60	0
21	LIST_VERSION_ID	☐			CHAR	15	0
22	LIST_AGENCY_ID	☐			CHAR	60	0
23	CONTENT	☐	LOY_MSH_ACTY_PROFILECODE_CONT		CHAR	3	0	Proxy Data Element (generated)
24	LOYALTY_MSH_ACTTYPENAME	☐	LOY_MEDIUM_NAME		STRU	0	0
25	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
26	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
27	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
28	DATE_TIME	☐	LOY_GLOBAL_DATE_TIME	XSDDATETIME_LONG_Z	DEC	21	7	Global Date Time
29	ORIGINAL_ENTRY_TIME_ZONE_CODE	☐	LOY_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (generated)
30	LOYALTY_MSH_ACTUSTAT	☐	LOY_USER_STATUS		STRU	0	0
31	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
32	CODE	☐	LOY_USER_STATUS_CODE		STRU	0	0
33	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
34	LIST_ID	☐			CHAR	60	0
35	LIST_VERSION_ID	☐			CHAR	15	0
36	LIST_AGENCY_ID	☐			CHAR	60	0
37	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
38	LIST_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
39	CONTENT	☐	LOY_USER_STATUS_CODE_CONTENT		CHAR	5	0	Proxy Data Element (generated)
40	NAME	☐	LOY_LEN30_NAME		STRU	0	0
41	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
42	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
43	CONTENT	☐	LOY_LEN30_NAME_CONTENT		CHAR	30	0	Proxy Data Element (generated)
44	ORDINAL_NUMBER_VALUE	☐	LOY_ORDINAL_NUMBER_VALUE		INT4	10	0	Proxy Data Element (generated)
45	ACTIVE_INDICATOR	☐	LOY_INDICATOR	XSDBOOLEAN	CHAR	1	0	Representation of two mutually exclusive Boolean value
46	MEMBER_PARTY	☐	LOYMA_MSHACJBECO_MEMPTY		STRU	0	0
47	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
48	ID	☐	LOY_PARTY_ID		STRU	0	0
49	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
50	SCHEME_ID	☐			CHAR	60	0
51	SCHEME_AGENCY_ID	☐			CHAR	60	0
52	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
53	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
54	CONTENT	☐	LOY_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
55	NAME	☐	LOY_LONG_NAME		STRU	0	0
56	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
57	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
58	CONTENT	☐	LOY_LONG_NAME_CONTENT		CHAR	80	0	Proxy Data Element (generated)
59	CUSTOMER_CARD	☐	LOYMA_MSHACJBECO_CUSTCARD		STRU	0	0
60	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
61	ID	☐	LOY_SMART_CARD_ID		STRU	0	0
62	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
63	SCHEME_ID	☐			CHAR	60	0
64	SCHEME_VERSION_ID	☐			CHAR	15	0
65	SCHEME_AGENCY_ID	☐			CHAR	60	0
66	CONTENT	☐	LOY_SMART_CARD_ID_CONTENT		CHAR	25	0	Proxy Data Element (generated)
67	LOYALTY_MEMBERSHIP_CARD_TYPE_C	☐	LOY_MSH_CARD_TYPECODE		STRU	0	0
68	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
69	LIST_ID	☐			CHAR	60	0
70	LIST_VERSION_ID	☐			CHAR	15	0
71	LIST_AGENCY_ID	☐			CHAR	60	0
72	CONTENT	☐	LOY_MSH_CARD_TYPECODE_CONTENT		CHAR	5	0	Proxy Data Element (generated)
73	LOYALTY_MEMBERSHIP_CARD_TYPE_N	☐	LOY_MEDIUM_NAME		STRU	0	0
74	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
75	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
76	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
77	PARTNER_PARTY	☐	LOYMA_MSHACJBECO_LOYPRGPRTPTY		STRU	0	0
78	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
79	ID	☐	LOY_PARTY_ID		STRU	0	0
80	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
81	SCHEME_ID	☐			CHAR	60	0
82	SCHEME_AGENCY_ID	☐			CHAR	60	0
83	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
84	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
85	CONTENT	☐	LOY_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
86	FORMATTED_NAME	☐	LOY_LONG_NAME		STRU	0	0
87	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
88	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
89	CONTENT	☐	LOY_LONG_NAME_CONTENT		CHAR	80	0	Proxy Data Element (generated)
90	PRODUCT	☐	LOYMA_MSHACJBECO_PRODUCT		STRU	0	0
91	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
92	ID	☐	LOY_PRODUCT_ID		STRU	0	0
93	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
94	SCHEME_ID	☐			CHAR	60	0
95	SCHEME_AGENCY_ID	☐			CHAR	60	0
96	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
97	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
98	CONTENT	☐	LOY_PRODUCT_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
99	DESCRIPTION	☐	LOY_SHORT_DESCRIPTION		STRU	0	0
100	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
101	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
102	CONTENT	☐	LOY_SHORT_DESCRIPTION_CONTENT		CHAR	40	0	Proxy Data Element (generated)
103	QUANTITY	☐	LOY_QUANTITY		STRU	0	0
104	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
105	UNIT_CODE	☐	LOY_MEASURE_UNIT_CODE		CHAR	3	0	Measure Unit Code
106	CONTENT	☐	LOY_QUANTITY_CONTENT		DEC	31	14	Non-monetary numerical declaration of a quantity
107	AMOUNT	☐	LOY_AMOUNT		STRU	0	0
108	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
109	CURRENCY_CODE	☐	LOY_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (generated)
110	CONTENT	☐	LOY_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (generated)
111	CATEGORY_ID	☐	LOY_PRODUCT_CATEGORY_ID		STRU	0	0
112	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
113	SCHEME_ID	☐			CHAR	60	0
114	SCHEME_VERSION_ID	☐			CHAR	15	0
115	SCHEME_AGENCY_ID	☐			CHAR	60	0
116	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
117	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
118	CONTENT	☐	LOY_PRODUCT_CATEGORY_ID_CONTEN		CHAR	40	0	Proxy Data Element (generated)
119	CATEGORY_DESCRIPTION	☐	LOY_MEDIUM_DESCRIPTION		STRU	0	0
120	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
121	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
122	CONTENT	☐	LOY_MEDIUM_DESCRIPTION_CONTENT		CHAR	80	0	Proxy Data Element (generated)
123	SALES_ORDER_REFERENCE	☐	LOYMA_MSHACJBECO_SALESDOCREF		STRU	0	0
124	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
125	ID	☐	LOY_BUSINESS_TRANSACTION_DOCU1		STRU	0	0
126	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
127	SCHEME_ID	☐			CHAR	60	0
128	SCHEME_AGENCY_ID	☐			CHAR	60	0
129	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
130	CONTENT	☐	LOY_BUSINESS_TRANSACTION_DOCU2		CHAR	35	0	Proxy Data Element (generated)
131	TYPE_CODE	☐	LOY_BUS_TRAN_DOC_TYPE_CODE		CHAR	5	0	Proxy Data Element (generated)
132	ITEM_ID	☐	LOY_BUSTRAN_DOCITEMID		CHAR	10	0	Proxy Data Element (generated)
133	STORE_INTERNAL_ID	☐	LOY_STORE_INTERNAL_ID		STRU	0	0
134	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
135	SCHEME_ID	☐			CHAR	60	0
136	SCHEME_AGENCY_ID	☐			CHAR	60	0
137	CONTENT	☐	LOY_STORE_INTERNAL_ID_CONTENT		CHAR	20	0	Proxy Data Element (generated)
138	ACTUAL_VALUES	☐	LOYMA_MSHACJBECO_ACTVALS		STRU	0	0
139	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
140	AMOUNT	☐	LOY_AMOUNT		STRU	0	0
141	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
142	CURRENCY_CODE	☐	LOY_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (generated)
143	CONTENT	☐	LOY_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (generated)
144	TIER	☐	LOYMA_MSHACJBECO_TIER		STRU	0	0
145	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
146	GROUP_CODE	☐	LOY_TIER_LEVEL_CATEGORYCODE		STRU	0	0
147	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
148	LIST_ID	☐			CHAR	60	0
149	LIST_VERSION_ID	☐			CHAR	15	0
150	LIST_AGENCY_ID	☐			CHAR	60	0
151	CONTENT	☐	LOY_TIER_LEVEL_CATCODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
152	GROUP_NAME	☐	LOY_MEDIUM_NAME		STRU	0	0
153	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
154	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
155	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
156	LEVEL_CODE	☐	LOY_TIER_LEVEL_CODE		STRU	0	0
157	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
158	LIST_ID	☐			CHAR	60	0
159	LIST_VERSION_ID	☐			CHAR	15	0
160	LIST_AGENCY_ID	☐			CHAR	60	0
161	CONTENT	☐	LOY_TIER_LEVEL_CODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
162	LEVEL_NAME	☐	LOY_MEDIUM_NAME		STRU	0	0
163	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
164	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
165	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
166	POINT	☐	LOYMA_MSHACJBECO_POINT		STRU	0	0
167	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
168	TYPE_CODE	☐	LOY_POINT_TYPECODE		STRU	0	0
169	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
170	LIST_ID	☐			CHAR	60	0
171	LIST_VERSION_ID	☐			CHAR	15	0
172	LIST_AGENCY_ID	☐			CHAR	60	0
173	CONTENT	☐	LOY_POINT_TYPECODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
174	TYPE_NAME	☐	LOY_MEDIUM_NAME		STRU	0	0
175	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
176	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
177	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
178	QUALIFICATION_TYPE_CODE	☐	LOY_POINT_ENTITLEMENT_TYPECODE		STRU	0	0
179	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
180	LIST_ID	☐			CHAR	60	0
181	LIST_VERSION_ID	☐			CHAR	15	0
182	LIST_AGENCY_ID	☐			CHAR	60	0
183	CONTENT	☐	LOY_POINT_ENTIT_TYPECODE_CONT		CHAR	3	0	Proxy Data Element (generated)
184	QUALIFICATION_TYPE_NAME	☐	LOY_MEDIUM_NAME		STRU	0	0
185	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
186	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
187	CONTENT	☐	LOY_MEDIUM_NAME_CONTENT		CHAR	40	0	Proxy Data Element (generated)
188	QUANTITY_DECIMAL_VALUE	☐	LOY_DECIMAL_VALUE		DEC	31	14	Proxy Data Element (generated)

History

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