SAP ABAP Table LOYS_PT_TXN_WC (Transction Structure including attributes for Web Channel)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY-PA (Application Component) Point Account
     ⤷ LOY_POINT_ACCOUNT (Package) Loyalty management Point Account

Basic Data

Table Category	INTTAB	Structure
Structure	LOYS_PT_TXN_WC	Table Relationship Diagram
Short Description	Transction Structure including attributes for Web Channel

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	.INCLUDE	☐				0	0	Structure for point Account transaction
2	.INCLUDE	☐				0	0	Loyalty Management Point Account Transaction.
3	.INCLUDE	☐				0	0	LOY FRW : Primary key Include
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
6	.INCLUDE	☐				0	0	LOY FRW : Non-Key Framework Include
7	REF_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
8	APPLICATION	☐	LOY_FRW_APPLICATION	LOY_FRW_APPLICATION	CHAR	4	0	Application
9	PROCESS_TYPE	☐	LOY_FRW_PROCESS_TYPE	LOY_FRW_PROCESS_TYPE	CHAR	15	0	Process Type
10	MEMBERSHIP_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID	LOYD_MSH_MEMS
11	ACTIVITY_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID	LOYD_MA_GENATTR
12	MEMBER_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID	LOYD_MEM_MEMBER
13	TXN_TYPE	☐	LOY_PT_TXN_TYPE	LOY_PTTXNTYPE	CHAR	4	0	Loyalty Point Transaction Type
14	TXN_REASON	☐	LOY_FRW_PROCESS_TYPE	LOY_FRW_PROCESS_TYPE	CHAR	15	0	Process Type
15	PT_TYPE	☐	LOY_PT_TYPE	LOY_PT_TYPE	CHAR	20	0	Point Type
16	QUAL_TYPE	☐	LOY_PT_QUAL_TYPE	LOY_PTQUALTYPE	CHAR	20	0	Point Qualification Type
17	POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points
18	POSTING_DATE	☐	LOY_PT_TXN_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Storing Time Stamp
19	EXPIRY_DATE	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
20	CARD_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
21	PARTNER_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
22	REFERENCE	☐	LOY_PT_TXN_REF		CHAR	100	0	Loyalty Point Transaction Reference
23	CAMPAIGN_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
24	REWARD_RULE_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
25	ACTUAL_POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points
26	.INCLUDE	☐				0	0	Extensibility Include Structure for point transactions
27	PT_TXN_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
28	.INCLUDE	☐				0	0
29	PSH_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
30	PARTNER_TIER	☐	LOY_PSH_PARTNER_TIER	CRM_LOY_PSH_PARTNER_TIER	CHAR	20	0	Partner Tier
31	ACCOUNT_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
32	.INCLUDE	☐				0	0	LOY FRW : Administrative Include
33	CREATED_ON	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
34	CREATED_BY	☐	LOY_FRW_CREATED_BY	UNAME	CHAR	12	0	Created By
35	CREATED_AT	☐	LOY_FRW_CREATED_AT	LOY_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
36	CHANGED_ON	☐	LOY_FRW_CHANGED_ON	SYDATS	DATS	8	0	Changed On - OBSOLETE !!!
37	CHANGED_BY	☐	LOY_FRW_CHANGED_BY	UNAME	CHAR	12	0	Changed By
38	CHANGED_AT	☐	LOY_FRW_CHANGED_AT	LOY_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
39	QUAL_POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points
40	.INCLUDE	☐				0	0	LOY FRW : Actions Include
41	PROCESS_MODE	☐	LOY_FRW_MODE	LOY_FRW_MODE	CHAR	1	0	Mode
42	.INCLUDE	☐				0	0	Structure to fill ID for Point Account transactions
43	MEMBERSHIP_ID	☐	LOY_MEMS_ID	LOY_MEMS_ID	CHAR	10	0	Membership ID
44	ACTIVITY_ID	☐	LOY_MA_ACT_ID	LOY_MA_ACTID	CHAR	10	0	Member Activity ID
45	CARD_ID	☐	LOY_CRD_CARD_ID	LOY_CRD_CARD_ID	CHAR	16	0	Card ID
46	MEMBER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
47	TXN_TYPE_DESC	☐	LOY_MA_DESCRIPTION	TEXT40	CHAR	40	0	Member Activity Description
48	TXN_REASON_DESC	☐	LOY_MA_DESCRIPTION	TEXT40	CHAR	40	0	Member Activity Description
49	QUAL_TYPE_DESC	☐	LOY_MA_DESCRIPTION	TEXT40	CHAR	40	0	Member Activity Description
50	REWARD_RULE_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
51	POSTING_DATE_ALT	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
52	PSH_ID	☐	LOY_PSH_ID	LOY_PSH_ID	CHAR	10	0	Partnership ID
53	ACCOUNT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
54	ACTIVITY_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
55	EMP_RESP_DESC	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
56	REWARD_RULE_DESC	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
57	EMP_RESP_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LOYS_PT_TXN_WC	ACTIVITY_GUID	LOYD_MA_GENATTR	CLIENT		1	CN
2	LOYS_PT_TXN_WC	MEMBERSHIP_GUID	LOYD_MSH_MEMS	CLIENT		1	CN
3	LOYS_PT_TXN_WC	MEMBER_GUID	LOYD_MEM_MEMBER	CLIENT		1	CN

History

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