SAP ABAP Table LOYMA_MSHACJBLKCRTCO_ACTIVITY (IDT - Loyalty Membership Activity Journal Confirmation Activ)

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_MSHACJBLKCRTCO_ACTIVITY	Table Relationship Diagram
Short Description	IDT - Loyalty Membership Activity Journal Confirmation Activ

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	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	ACTIVITY_CATEGORY_CODE	☐	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	ACTIVITY_TYPE_CODE	☐	LOY_MSH_ACTY_PROFILECODE		STRU	0	0
15	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
16	LIST_ID	☐			CHAR	60	0
17	LIST_VERSION_ID	☐			CHAR	15	0
18	LIST_AGENCY_ID	☐			CHAR	60	0
19	CONTENT	☐	LOY_MSH_ACTY_PROFILECODE_CONT		CHAR	3	0	Proxy Data Element (generated)
20	DATE_TIME	☐	LOY_GLOBAL_DATE_TIME	XSDDATETIME_LONG_Z	DEC	21	7	Global Date Time
21	ORIGINAL_ENTRY_TIME_ZONE_CODE	☐	LOY_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (generated)
22	ACTIVITY_USER_STATUS	☐	LOY_USER_STATUS		STRU	0	0
23	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
24	CODE	☐	LOY_USER_STATUS_CODE		STRU	0	0
25	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
26	LIST_ID	☐			CHAR	60	0
27	LIST_VERSION_ID	☐			CHAR	15	0
28	LIST_AGENCY_ID	☐			CHAR	60	0
29	LIST_AGENCY_SCHEME_ID	☐			CHAR	60	0
30	LIST_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
31	CONTENT	☐	LOY_USER_STATUS_CODE_CONTENT		CHAR	5	0	Proxy Data Element (generated)
32	NAME	☐	LOY_LEN30_NAME		STRU	0	0
33	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
34	LANGUAGE_CODE	☐	LOY_LANGUAGE_CODE		CHAR	9	0	Proxy Data Element (generated)
35	CONTENT	☐	LOY_LEN30_NAME_CONTENT		CHAR	30	0	Proxy Data Element (generated)
36	ORDINAL_NUMBER_VALUE	☐	LOY_ORDINAL_NUMBER_VALUE		INT4	10	0	Proxy Data Element (generated)
37	ACTIVE_INDICATOR	☐	LOY_INDICATOR	XSDBOOLEAN	CHAR	1	0	Representation of two mutually exclusive Boolean value
38	MEMBER_PARTY	☐	LOYMA_MSHACJBLKCRTCO_MBRPTY		STRU	0	0
39	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
40	ID	☐	LOY_PARTY_ID		STRU	0	0
41	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
42	SCHEME_ID	☐			CHAR	60	0
43	SCHEME_AGENCY_ID	☐			CHAR	60	0
44	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
45	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
46	CONTENT	☐	LOY_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
47	CUSTOMER_CARD	☐	LOYMA_MSHACJBLKCRTCO_CUSTCARD		STRU	0	0
48	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
49	LOYALTY_PROGRAMME_MEMBERSHIP_C	☐	LOY_MSH_CARD_TYPECODE		STRU	0	0
50	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
51	LIST_ID	☐			CHAR	60	0
52	LIST_VERSION_ID	☐			CHAR	15	0
53	LIST_AGENCY_ID	☐			CHAR	60	0
54	CONTENT	☐	LOY_MSH_CARD_TYPECODE_CONTENT		CHAR	5	0	Proxy Data Element (generated)
55	ID	☐	LOY_SMART_CARD_ID		STRU	0	0
56	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
57	SCHEME_ID	☐			CHAR	60	0
58	SCHEME_VERSION_ID	☐			CHAR	15	0
59	SCHEME_AGENCY_ID	☐			CHAR	60	0
60	CONTENT	☐	LOY_SMART_CARD_ID_CONTENT		CHAR	25	0	Proxy Data Element (generated)
61	PARTNER_PARTY	☐	LOYMA_MSHACJBLKCRTCO_LPPRTPTY		STRU	0	0
62	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
63	ID	☐	LOY_PARTY_ID		STRU	0	0
64	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
65	SCHEME_ID	☐			CHAR	60	0
66	SCHEME_AGENCY_ID	☐			CHAR	60	0
67	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
68	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
69	CONTENT	☐	LOY_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
70	PRODUCT	☐	LOYMA_MSHACJBLKCRTCO_PROD		STRU	0	0
71	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
72	ID	☐	LOY_PRODUCT_ID		STRU	0	0
73	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
74	SCHEME_ID	☐			CHAR	60	0
75	SCHEME_AGENCY_ID	☐			CHAR	60	0
76	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
77	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
78	CONTENT	☐	LOY_PRODUCT_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
79	QUANTITY	☐	LOY_QUANTITY		STRU	0	0
80	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
81	UNIT_CODE	☐	LOY_MEASURE_UNIT_CODE		CHAR	3	0	Measure Unit Code
82	CONTENT	☐	LOY_QUANTITY_CONTENT		DEC	31	14	Non-monetary numerical declaration of a quantity
83	AMOUNT	☐	LOY_AMOUNT		STRU	0	0
84	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
85	CURRENCY_CODE	☐	LOY_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (generated)
86	CONTENT	☐	LOY_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (generated)
87	CATEGORY_ID	☐	LOY_PRODUCT_CATEGORY_ID		STRU	0	0
88	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
89	SCHEME_ID	☐			CHAR	60	0
90	SCHEME_VERSION_ID	☐			CHAR	15	0
91	SCHEME_AGENCY_ID	☐			CHAR	60	0
92	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
93	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
94	CONTENT	☐	LOY_PRODUCT_CATEGORY_ID_CONTEN		CHAR	40	0	Proxy Data Element (generated)
95	SALES_ORDER_REFERENCE	☐	LOYMA_MSHACJBLKCRTCO_SLSDOCREF		STRU	0	0
96	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
97	ID	☐	LOY_BUSINESS_TRANSACTION_DOCU1		STRU	0	0
98	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
99	SCHEME_ID	☐			CHAR	60	0
100	SCHEME_AGENCY_ID	☐			CHAR	60	0
101	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
102	CONTENT	☐	LOY_BUSINESS_TRANSACTION_DOCU2		CHAR	35	0	Proxy Data Element (generated)
103	CODE	☐	LOY_BUS_TRAN_DOC_TYPE_CODE		CHAR	5	0	Proxy Data Element (generated)
104	ITEM_ID	☐	LOY_BUSTRAN_DOCITEMID		CHAR	10	0	Proxy Data Element (generated)
105	STORE_INTERNAL_ID	☐	LOY_STORE_INTERNAL_ID		STRU	0	0
106	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
107	SCHEME_ID	☐			CHAR	60	0
108	SCHEME_AGENCY_ID	☐			CHAR	60	0
109	CONTENT	☐	LOY_STORE_INTERNAL_ID_CONTENT		CHAR	20	0	Proxy Data Element (generated)
110	ACTUAL_VALUE	☐	LOYMA_MSHACJBLKCRTCO_ACTLVALS		STRU	0	0
111	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
112	AMOUNT	☐	LOY_AMOUNT		STRU	0	0
113	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
114	CURRENCY_CODE	☐	LOY_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (generated)
115	CONTENT	☐	LOY_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (generated)
116	TIER	☐	LOYMA_MSHACJBLKCRTCO_TIER		STRU	0	0
117	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
118	GROUP_CODE	☐	LOY_TIER_LEVEL_CATEGORYCODE		STRU	0	0
119	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
120	LIST_ID	☐			CHAR	60	0
121	LIST_VERSION_ID	☐			CHAR	15	0
122	LIST_AGENCY_ID	☐			CHAR	60	0
123	CONTENT	☐	LOY_TIER_LEVEL_CATCODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
124	LEVEL_CODE	☐	LOY_TIER_LEVEL_CODE		STRU	0	0
125	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
126	LIST_ID	☐			CHAR	60	0
127	LIST_VERSION_ID	☐			CHAR	15	0
128	LIST_AGENCY_ID	☐			CHAR	60	0
129	CONTENT	☐	LOY_TIER_LEVEL_CODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
130	POINT	☐	LOYMA_MSHACJBLKCRTCO_POINT		STRU	0	0
131	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
132	TYPE_CODE	☐	LOY_POINT_TYPECODE		STRU	0	0
133	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
134	LIST_ID	☐			CHAR	60	0
135	LIST_VERSION_ID	☐			CHAR	15	0
136	LIST_AGENCY_ID	☐			CHAR	60	0
137	CONTENT	☐	LOY_POINT_TYPECODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
138	QUALIFICATION_TYPE_CODE	☐	LOY_POINT_ENTITLEMENT_TYPECODE		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	CONTENT	☐	LOY_POINT_ENTIT_TYPECODE_CONT		CHAR	3	0	Proxy Data Element (generated)
144	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