SAP ABAP Table LOYMA_MSHACJCRTRQ_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_MSHACJCRTRQ_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	LOY_MSH_ACTIVITY_PROFCODE	☐	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_MSHACJCRTRQ_MEM_PARTY		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_MSHACJCRTRQ_CUST_CARD		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_MSHACJCRTRQ_LOYPRGPRTPTY		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_MSHACJCRTRQ_PROD		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	QUANTITY	☐	LOY_QUANTITY		STRU	0	0
46	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
47	UNIT_CODE	☐	LOY_MEASURE_UNIT_CODE		CHAR	3	0	Measure Unit Code
48	CONTENT	☐	LOY_QUANTITY_CONTENT		DEC	31	14	Non-monetary numerical declaration of a quantity
49	AMOUNT	☐	LOY_AMOUNT		STRU	0	0
50	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
51	CURRENCY_CODE	☐	LOY_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (generated)
52	CONTENT	☐	LOY_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (generated)
53	CATEGORY_ID	☐	LOY_PRODUCT_CATEGORY_ID		STRU	0	0
54	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
55	SCHEME_ID	☐			CHAR	60	0
56	SCHEME_VERSION_ID	☐			CHAR	15	0
57	SCHEME_AGENCY_ID	☐			CHAR	60	0
58	SCHEME_AGENCY_SCHEME_ID	☐			CHAR	60	0
59	SCHEME_AGENCY_SCHEME_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
60	CONTENT	☐	LOY_PRODUCT_CATEGORY_ID_CONTEN		CHAR	40	0	Proxy Data Element (generated)
61	SALES_DOCUMENT_REFERENCE	☐	LOYMA_MSHACJCRTRQ_SLSDOCREF		STRU	0	0
62	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
63	ID	☐	LOY_BUSINESS_TRANSACTION_DOCU1		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_AGENCY_ID	☐	LOY_AGENCY_IDENTIFICATION_CODE		CHAR	3	0	A code representation of agency responsible for a code list
68	CONTENT	☐	LOY_BUSINESS_TRANSACTION_DOCU2		CHAR	35	0	Proxy Data Element (generated)
69	TYPE_CODE	☐	LOY_BUS_TRAN_DOC_TYPE_CODE		CHAR	5	0	Proxy Data Element (generated)
70	ITEM_ID	☐	LOY_BUSTRAN_DOCITEMID		CHAR	10	0	Proxy Data Element (generated)
71	STORE_INTERNAL_ID	☐	LOY_STORE_INTERNAL_ID		STRU	0	0
72	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
73	SCHEME_ID	☐			CHAR	60	0
74	SCHEME_AGENCY_ID	☐			CHAR	60	0
75	CONTENT	☐	LOY_STORE_INTERNAL_ID_CONTENT		CHAR	20	0	Proxy Data Element (generated)
76	ACTUAL_VALUES	☐	LOYMA_MSHACJCRTRQ_ACTVALUES		STRU	0	0
77	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
78	AMOUNT	☐	LOY_AMOUNT		STRU	0	0
79	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
80	CURRENCY_CODE	☐	LOY_CURRENCY_CODE		CHAR	3	0	Proxy Data Element (generated)
81	CONTENT	☐	LOY_AMOUNT_CONTENT		DEC	28	6	Proxy Data Element (generated)
82	TIER	☐	LOYMA_MSHACJCRTRQ_TIER		STRU	0	0
83	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
84	LOYPRG_TIER_CAT_CODE	☐	LOY_TIER_LEVEL_CATEGORYCODE		STRU	0	0
85	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
86	LIST_ID	☐			CHAR	60	0
87	LIST_VERSION_ID	☐			CHAR	15	0
88	LIST_AGENCY_ID	☐			CHAR	60	0
89	CONTENT	☐	LOY_TIER_LEVEL_CATCODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
90	LOYPRG_TIER_LEVEL_CODE	☐	LOY_TIER_LEVEL_CODE		STRU	0	0
91	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
92	LIST_ID	☐			CHAR	60	0
93	LIST_VERSION_ID	☐			CHAR	15	0
94	LIST_AGENCY_ID	☐			CHAR	60	0
95	CONTENT	☐	LOY_TIER_LEVEL_CODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
96	POINT	☐	LOYMA_MSHACJCRTRQ_POINT		STRU	0	0
97	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
98	LOYPRG_POINTTYPE_CODE	☐	LOY_POINT_TYPECODE		STRU	0	0
99	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
100	LIST_ID	☐			CHAR	60	0
101	LIST_VERSION_ID	☐			CHAR	15	0
102	LIST_AGENCY_ID	☐			CHAR	60	0
103	CONTENT	☐	LOY_POINT_TYPECODE_CONTENT		CHAR	10	0	Proxy Data Element (generated)
104	LOYPRG_POINTENTLTYPE_CODE	☐	LOY_POINT_ENTITLEMENT_TYPECODE		STRU	0	0
105	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
106	LIST_ID	☐			CHAR	60	0
107	LIST_VERSION_ID	☐			CHAR	15	0
108	LIST_AGENCY_ID	☐			CHAR	60	0
109	CONTENT	☐	LOY_POINT_ENTIT_TYPECODE_CONT		CHAR	3	0	Proxy Data Element (generated)
110	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