SAP ABAP Table LOYD_PT_TXN (Loyalty Management Point Account Transaction.)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	LOYD_PT_TXN	Table Relationship Diagram
Short Description	Loyalty Management Point Account Transaction.

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	LOY FRW : Primary key Include
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☑	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
4	.INCLUDE	☐				0	0	LOY FRW : Non-Key Framework Include
5	REF_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
6	APPLICATION	☐	LOY_FRW_APPLICATION	LOY_FRW_APPLICATION	CHAR	4	0	Application
7	PROCESS_TYPE	☐	LOY_FRW_PROCESS_TYPE	LOY_FRW_PROCESS_TYPE	CHAR	15	0	Process Type
8	MEMBERSHIP_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID	LOYD_MSH_MEMS
9	ACTIVITY_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID	LOYD_MA_GENATTR
10	MEMBER_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID	LOYD_MEM_MEMBER
11	TXN_TYPE	☐	LOY_PT_TXN_TYPE	LOY_PTTXNTYPE	CHAR	4	0	Loyalty Point Transaction Type
12	TXN_REASON	☐	LOY_FRW_PROCESS_TYPE	LOY_FRW_PROCESS_TYPE	CHAR	15	0	Process Type
13	PT_TYPE	☐	LOY_PT_TYPE	LOY_PT_TYPE	CHAR	20	0	Point Type
14	QUAL_TYPE	☐	LOY_PT_QUAL_TYPE	LOY_PTQUALTYPE	CHAR	20	0	Point Qualification Type
15	POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points
16	POSTING_DATE	☐	LOY_PT_TXN_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Storing Time Stamp
17	EXPIRY_DATE	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
18	CARD_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
19	PARTNER_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
20	REFERENCE	☐	LOY_PT_TXN_REF		CHAR	100	0	Loyalty Point Transaction Reference
21	CAMPAIGN_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
22	REWARD_RULE_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
23	ACTUAL_POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points
24	.INCLUDE	☐				0	0	Extensibility Include Structure for point transactions
25	PT_TXN_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
26	.INCLUDE	☐				0	0
27	PSH_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
28	PARTNER_TIER	☐	LOY_PSH_PARTNER_TIER	CRM_LOY_PSH_PARTNER_TIER	CHAR	20	0	Partner Tier
29	ACCOUNT_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
30	.INCLUDE	☐				0	0	LOY FRW : Administrative Include
31	CREATED_ON	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
32	CREATED_BY	☐	LOY_FRW_CREATED_BY	UNAME	CHAR	12	0	Created By
33	CREATED_AT	☐	LOY_FRW_CREATED_AT	LOY_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
34	CHANGED_ON	☐	LOY_FRW_CHANGED_ON	SYDATS	DATS	8	0	Changed On - OBSOLETE !!!
35	CHANGED_BY	☐	LOY_FRW_CHANGED_BY	UNAME	CHAR	12	0	Changed By
36	CHANGED_AT	☐	LOY_FRW_CHANGED_AT	LOY_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
37	QUAL_POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points

Foreign Keys

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

History

Last changed by/on	SAP	20100421
SAP Release Created in	700