SAP ABAP Table LOYS_PPA_TXN_BI (Extract Structure: Partner Point account transactions)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY (Application Component) Loyalty
     ⤷ LOY_BI (Package) Loyalty BI objects

Basic Data

Table Category	INTTAB	Structure
Structure	LOYS_PPA_TXN_BI	Table Relationship Diagram
Short Description	Extract Structure: Partner Point account transactions

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	PPA_TXN_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
2	PPA_ID	☐	LOY_PT_ACCT_ID	LOY_PT_ACCT_OBJECT_ID	CHAR	18	0	Loyalty Management Point Account ID
3	PSH_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
4	PPA_TXN_TYPE	☐	LOY_PPA_TXN_TYPE	LOY_PPA_PTTXNTYPE	CHAR	4	0	Loyalty Management Partner Point Transaction Type
5	PPA_TXN_RSN	☐	LOY_PPA_TXN_RSN		CHAR	15	0	Loyalty Management Partner Point Transaction Reason
6	PT_TYPE	☐	LOY_PT_TYPE	LOY_PT_TYPE	CHAR	20	0	Point Type
7	POINTS	☐	LOY_PT_POINT		DEC	10	2	Number of Points
8	POSTING_DATE	☐	LOY_PT_TXN_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Storing Time Stamp
9	LOY_PROG_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
10	LOY_PROG_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
11	LOY_CAMP_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
12	LOY_CAMP_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
13	LOY_RRL_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
14	LOY_RRL_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
15	MSH_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
16	MSH_TYPE	☐	LOY_MSH_MEMS_TYPE		CHAR	20	0	Membership Types
17	MAIN_MEM_ID	☐	LOY_MA_MEMBER_ID	LOY_MA_MEMBER_ID	CHAR	10	0	MA member ID
18	BASIC_LVL	☐	LOY_MSH_TIERLEVEL_CODE	LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
19	LIFETIME_LVL	☐	LOY_MSH_TIERLEVEL_CODE	LOY_MSH_TIERGRP_CODE	CHAR	10	0	Tier ID
20	CHANGED_AT	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

History

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