SAP ABAP Table LOYS_PT_TXN_SRCH_ATTR (Point Transaction Search Structure)

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_SRCH_ATTR	Table Relationship Diagram
Short Description	Point Transaction Search Structure

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	POINT_ACCOUNT_ID	☐	LOY_PT_ACCT_SET_ID	LOY_PT_OBJECT_ID	CHAR	15	0	Loyalty Management Point Account Set ID
2	MEMBERSHIP_ID	☐	LOY_MEMS_ID	LOY_MEMS_ID	CHAR	10	0	Membership ID
3	MEMBER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	MEMBER_ACTIVITY_ID	☐	LOY_MA_ACT_ID	LOY_MA_ACTID	CHAR	10	0	Member Activity ID
5	CARD_ID	☐	LOY_CRD_CARD_ID	LOY_CRD_CARD_ID	CHAR	16	0	Card ID
6	PARTNER_ID	☐	LOY_MA_PARTNER_ID	LOY_MA_PARTNER_ID	CHAR	10	0	Member Activity Partner ID
7	PARTNERSHIP_ID	☐	LOY_PSH_ID	LOY_PSH_ID	CHAR	10	0	Partnership ID
8	POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points
9	TXN_TYPE	☐	LOY_PT_TXN_TYPE	LOY_PTTXNTYPE	CHAR	4	0	Loyalty Point Transaction Type
10	TXN_REASON	☐	LOY_FRW_PROCESS_TYPE	LOY_FRW_PROCESS_TYPE	CHAR	15	0	Process Type
11	PT_TYPE	☐	LOY_PT_TYPE	LOY_PT_TYPE	CHAR	20	0	Point Type
12	QUAL_TYPE	☐	LOY_PT_QUAL_TYPE	LOY_PTQUALTYPE	CHAR	20	0	Point Qualification Type
13	POSTING_DATE	☐	LOY_PT_TXN_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Storing Time Stamp
14	EXPIRY_DATE	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
15	CREATED_ON	☐	LOY_FRW_CREATED_ON	SYDATS	DATS	8	0	Created On - OBSOLETE !!!
16	CREATED_BY	☐	LOY_FRW_CREATED_BY	UNAME	CHAR	12	0	Created By
17	CHANGED_ON	☐	LOY_FRW_CHANGED_ON	SYDATS	DATS	8	0	Changed On - OBSOLETE !!!
18	CHANGED_BY	☐	LOY_FRW_CHANGED_BY	UNAME	CHAR	12	0	Changed By
19	EXTERNAL_CARD_NU	☐	LOY_CRD_CARD_EXT_ID	LOY_CRD_CARD_EXT_ID	CHAR	25	0	External Card ID
20	LAST_NAME	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
21	.INCLUDE	☐				0	0	Extensibility Include Structure for point transactions
22	PT_TXN_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
23	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20130604
SAP Release Created in