SAP ABAP Table LOYMA_MSHACJBLKCRTRQ_ACTIVITY (IDT - Loyalty Membership Activity Journal Request 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_MSHACJBLKCRTRQ_ACTIVITY	Table Relationship Diagram
Short Description	IDT - Loyalty Membership Activity Journal Request 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	ACTIVITY_TYPE_CODE	☐	LOY_MSH_ACTY_PROFILECODE		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	LIST_ID	☐			CHAR	60	0
5	LIST_VERSION_ID	☐			CHAR	15	0
6	LIST_AGENCY_ID	☐			CHAR	60	0
7	CONTENT	☐	LOY_MSH_ACTY_PROFILECODE_CONT		CHAR	3	0	Proxy Data Element (generated)
8	DATE_TIME	☐	LOY_GLOBAL_DATE_TIME	XSDDATETIME_LONG_Z	DEC	21	7	Global Date Time
9	ORIGINAL_ENTRY_TIME_ZONE_CODE	☐	LOY_TIME_ZONE_CODE		CHAR	10	0	Proxy Data Element (generated)
10	MEMBER_PARTY	☐	LOYMA_MSHACJBLKCRTRQ_MEMPARTY		STRU	0	0
11	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
12	ID	☐	LOY_PARTY_ID		STRU	0	0
13	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
14	SCHEME_ID	☐			CHAR	60	0
15	SCHEME_AGENCY_ID	☐			CHAR	60	0
16	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
17	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
18	CONTENT	☐	LOY_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
19	CUSTOMER_CARD	☐	LOYMA_MSHACJBLKCRTRQ_CUSTCARD		STRU	0	0
20	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
21	ID	☐	LOY_SMART_CARD_ID		STRU	0	0
22	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
23	SCHEME_ID	☐			CHAR	60	0
24	SCHEME_VERSION_ID	☐			CHAR	15	0
25	SCHEME_AGENCY_ID	☐			CHAR	60	0
26	CONTENT	☐	LOY_SMART_CARD_ID_CONTENT		CHAR	25	0	Proxy Data Element (generated)
27	PARTNER_PARTY	☐	LOYMA_MSHACJBLKCRTRQ_LPPRTPTY		STRU	0	0
28	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
29	ID	☐	LOY_PARTY_ID		STRU	0	0
30	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
31	SCHEME_ID	☐			CHAR	60	0
32	SCHEME_AGENCY_ID	☐			CHAR	60	0
33	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
34	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
35	CONTENT	☐	LOY_PARTY_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
36	PRODUCT	☐	LOYMA_MSHACJBLKCRTRQ_PRODUCT		STRU	0	0
37	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
38	ID	☐	LOY_PRODUCT_ID		STRU	0	0
39	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
40	SCHEME_ID	☐			CHAR	60	0
41	SCHEME_AGENCY_ID	☐			CHAR	60	0
42	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
43	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
44	CONTENT	☐	LOY_PRODUCT_ID_CONTENT		CHAR	60	0	Proxy Data Element (generated)
45	STANDARD_ID	☐	LOY_PRODUCT_STANDARD_ID		STRU	0	0
46	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
47	SCHEME_ID	☐			CHAR	60	0
48	SCHEME_AGENCY_ID	☐			CHAR	60	0
49	CONTENT	☐	LOY_PRODUCT_STANDARD_ID_CONTEN		CHAR	14	0	Proxy Data Element (generated)
50	QUANTITY	☐	LOY_QUANTITY		STRU	0	0
51	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
52	UNIT_CODE	☐	LOY_MEASURE_UNIT_CODE		CHAR	3	0	Measure Unit Code
53	CONTENT	☐	LOY_QUANTITY_CONTENT		DEC	31	14	Non-monetary numerical declaration of a quantity
54	AMOUNT	☐	LOY_AMOUNT		STRU	0	0
55	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
56	CURRENCY_CODE	☐	LOY_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (generated)
57	CONTENT	☐	LOY_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (generated)
58	CATEGORY_ID	☐	LOY_PRODUCT_CATEGORY_ID		STRU	0	0
59	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
60	SCHEME_ID	☐			CHAR	60	0
61	SCHEME_VERSION_ID	☐			CHAR	15	0
62	SCHEME_AGENCY_ID	☐			CHAR	60	0
63	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
64	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
65	CONTENT	☐	LOY_PRODUCT_CATEGORY_ID_CONTEN		CHAR	40	0	Proxy Data Element (generated)
66	SALES_ORDER_REFERENCE	☐	LOYMA_MSHACJBLKCRTRQ_SLSDOCREF		STRU	0	0
67	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
68	ID	☐	LOY_BUSINESS_TRANSACTION_DOCU1		STRU	0	0
69	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
70	SCHEME_ID	☐			CHAR	60	0
71	SCHEME_AGENCY_ID	☐			CHAR	60	0
72	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
73	CONTENT	☐	LOY_BUSINESS_TRANSACTION_DOCU2		CHAR	35	0	Proxy Data Element (generated)
74	CODE	☐	LOY_BUS_TRAN_DOC_TYPE_CODE		CHAR	5	0	Proxy Data Element (generated)
75	ITEM_ID	☐	LOY_BUSTRAN_DOCITEMID		CHAR	10	0	Proxy Data Element (generated)
76	STORE_INTERNAL_ID	☐	LOY_STORE_INTERNAL_ID		STRU	0	0
77	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
78	SCHEME_ID	☐			CHAR	60	0
79	SCHEME_AGENCY_ID	☐			CHAR	60	0
80	CONTENT	☐	LOY_STORE_INTERNAL_ID_CONTENT		CHAR	20	0	Proxy Data Element (generated)
81	ACTUAL_VALUE	☐	LOYMA_MSHACJBLKCRTRQ_ACTLVALS		STRU	0	0
82	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
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	TIER	☐	LOYMA_MSHACJBLKCRTRQ_TIER		STRU	0	0
88	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
89	GROUP_CODE	☐	LOY_TIER_LEVEL_CATEGORYCODE		STRU	0	0
90	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
91	LIST_ID	☐			CHAR	60	0
92	LIST_VERSION_ID	☐			CHAR	15	0
93	LIST_AGENCY_ID	☐			CHAR	60	0
94	CONTENT	☐	LOY_TIER_LEVEL_CATCODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
95	LEVEL_CODE	☐	LOY_TIER_LEVEL_CODE		STRU	0	0
96	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
97	LIST_ID	☐			CHAR	60	0
98	LIST_VERSION_ID	☐			CHAR	15	0
99	LIST_AGENCY_ID	☐			CHAR	60	0
100	CONTENT	☐	LOY_TIER_LEVEL_CODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
101	POINT	☐	LOYMA_MSHACJBLKCRTRQ_POINT		STRU	0	0
102	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
103	LOYPRG_POINTTYPE_CODE	☐	LOY_POINT_TYPECODE		STRU	0	0
104	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
105	LIST_ID	☐			CHAR	60	0
106	LIST_VERSION_ID	☐			CHAR	15	0
107	LIST_AGENCY_ID	☐			CHAR	60	0
108	CONTENT	☐	LOY_POINT_TYPECODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
109	LOYPRG_POINTENTLTYPE_CODE	☐	LOY_POINT_ENTITLEMENT_TYPECODE		STRU	0	0
110	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
111	LIST_ID	☐			CHAR	60	0
112	LIST_VERSION_ID	☐			CHAR	15	0
113	LIST_AGENCY_ID	☐			CHAR	60	0
114	CONTENT	☐	LOY_POINT_ENTIT_TYPECODE_CONT		CHAR	3	0	Proxy Data Element (generated)
115	QUANTITY_DECIMAL_VALUE	☐	LOY_DECIMAL_VALUE		DEC	31	14	Proxy Data Element (generated)

History

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