SAP ABAP Table LOYS_BNFT_BI (Extract structure for benefits extractor)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	LOYS_BNFT_BI	Table Relationship Diagram
Short Description	Extract structure for benefits extractor

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	Generierte Tabelle zu einem View
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
4	LOYL_PRG	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
5	PRODUCT_GUID	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
6	OBJECT_ID	☐	LOY_BNFT_ID	LOY_BNFT_ID	CHAR	10	0	Loyalty Benefit ID
7	DESCRIPTION	☐	LOY_BNFT_DESCRIPTION	LOY_BNFT_DESCRIPTION	CHAR	60	0	Data Element for Benefit Description
8	START_DATE	☐	LOY_BNFT_DATE	LOY_BNFT_DATE	DATS	8	0	Benefit Date
9	END_DATE	☐	LOY_BNFT_DATE	LOY_BNFT_DATE	DATS	8	0	Benefit Date
10	TYPE	☐	LOY_BNFT_TYPE	LOY_BNFT_TYPE	CHAR	20	0	Loyalty Benefit Type
11	HANDLING	☐	LOY_BNFT_HANDLING	LOY_BNFT_HANDLING	CHAR	20	0	Loyalty Benefit Handling
12	USAGES	☐	LOY_BNFT_USAGE	LOY_BNFT_USAGE	INT2	5	0	Loyalty Benefit Usage
13	CHANGED_AT	☐	LOY_FRW_CHANGED_AT	LOY_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
14	CAMPAIGN_CODE	☐	LOY_FRW_GUID	SYSUUID	RAW	16	0	Object GUID
15	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
16	CHANGED_BY	☐	LOY_FRW_CHANGED_BY	UNAME	CHAR	12	0	Changed By
17	LOY_PROG_ID	☐	LOY_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	Generic External ID
18	LOY_CAMP_ID	☐	LOY_BNFT_CAMPAIGN_CODE_ID	LOY_BNFT_CAMPAIGN_CODE_ID	CHAR	24	0	Loyalty Benefit Campaign ID

History

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