SAP ABAP Table CRMS_LOY_OUTBND_EVT_CARD_CRE (Structure :Create/Expire/Lost Card)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY-OUT (Application Component) Loyalty Outbound Correspondence
     ⤷ CRM_LOY_OUTBOUND (Package) Loyalty Outbound Correspondence

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_LOY_OUTBND_EVT_CARD_CRE	Table Relationship Diagram
Short Description	Structure :Create/Expire/Lost Card

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	MEMB_ID	☐	CRM_LOY_OUTBND_MEM_ID	BU_PARTNER	CHAR	10	0	Loyalty Outbound: Member ID	*
2	MC_NAME1	☐	CRM_LOY_OUTBND_MEM_LASTNAME	BU_NAME	CHAR	40	0	Loyalty Outbound: Member Last Name
3	MC_NAME2	☐	CRM_LOY_OUTBND_MEM_FIRSTNAME	BU_NAME	CHAR	40	0	Loyalty Outbound: Member First Name
4	MEMSHIP_ID	☐	CRM_LOY_OUTBND_MSH_ID	CRM_LOY_MEMS_ID	CHAR	10	0	Loyalty Outbound: Membership ID
5	LOY_PROGRAM	☐	CRM_LOY_OUTBND_PGM_ID	CGPL_EXTID	CHAR	24	0	Loyalty Outbound: Program ID
6	MEMSHIP_TYPE_DESC	☐	CRM_LOY_MSH_MEMS_TYPE	CRM_LOY_MSH_MEMS_TYPE	CHAR	20	0	Membership Type
7	START_DATE	☐	CRM_LOY_OUTBND_MSH_START_DATE	DATS	DATS	8	0	Loyalty Outbound: Membership Start Date
8	END_DATE	☐	CRM_LOY_OUTBND_MSH_END_DATE	DATS	DATS	8	0	Loyalty Outbound: Membership End Date
9	PURPOSE_OF_USE	☐	CRM_LOY_MSH_PURPOSE_OF_USE	CRM_LOY_MSH_PURPOSE_OF_USE	CHAR	50	0	Purpose Of Usage
10	CREATED_VIA	☐	CRM_LOY_MSH_CREATED_VIA	CRM_LOY_MSH_CREATED_VIA	CHAR	20	0	Origin
11	CARD_ID	☐	CRM_LOY_OUTBND_CARD_ID	CRM_CRD_CARD_ID	CHAR	16	0	Loyalty Outbound: Card ID
12	CARD_TYPE	☐	CRM_LOY_OUTBND_CARD_TYPE	CRM_LOY_CRD_CARD_CTYPE_DESC	CHAR	30	0	Loyalty Outbound: Card Type
13	STATUS_DESC	☐	CRM_LOY_OUTBND_CARD_STATUS	CHAR5	CHAR	5	0	Loyalty Outbound: Card Status
14	CARD_VALID_FROM	☐	CRM_LOY_OUTBND_CARD_VALIDFROM	DATUM	DATS	8	0	Loyalty Outbound: Card Valid From
15	CARD_VALID_TO	☐	CRM_LOY_OUTBND_CARD_VALIDTO	DATUM	DATS	8	0	Loyalty Outbound: Card Valid To
16	CARD_DISP_NAME	☐	CRM_LOY_OUTBND_CARD_NAME	CRM_LOY_CRD_CARD_DNAME	CHAR	25	0	Loyalty Outbound: Card Display Name
17	EXTERNAL_CARD_NU	☐	LOY_CRD_CARD_EXT_ID	LOY_CRD_CARD_EXT_ID	CHAR	25	0	External Card ID
18	CARD_TITLE_1	☐	CRM_LOY_OUTBND_CARD_TITLE1	CRM_LOY_CRD_CARD_DNAME	CHAR	25	0	Loyalty Outbound: Card Title 1
19	CARD_TITLE_2	☐	CRM_LOY_OUTBND_CARD_TITLE2	CRM_LOY_CRD_CARD_DNAME	CHAR	25	0	Loyalty Outbound: Card Title 2
20	LAYOUT	☐	CRM_LOY_CRD_CARD_LAYOUT	CRM_LOY_CRD_CARD_LAYOUT	CHAR	5	0	Card Layout
21	CARD_MEMB_ID	☐	CRM_LOY_OUTBND_MEM_ID	BU_PARTNER	CHAR	10	0	Loyalty Outbound: Member ID	*
22	CARD_REN_DATE	☐	CRM_LOY_OUTBND_CARD_LAYOUT	CHAR30	CHAR	30	0	Loyalty Outbound: Card Layout
23	CARD_RANK	☐	CRM_LOY_OUTBND_CARD_RANK	LOY_CRD_CARD_RANK	CHAR	2	0	Loyalty Outbound: Card Rank
24	BANK_COUNTRY	☐	CRM_LOY_OUTBND_CARD_BNKCOUNTRY	TEXT3	CHAR	3	0	Loyalty Outbound: Card Bank Country
25	BANK_KEY	☐	CRM_LOY_OUTBND_CARD_BNKKEY	BANKK	CHAR	15	0	Loyalty Outbound: Card Bank Key
26	BANK_ACCT_NO	☐	CRM_LOY_OUTBND_CARD_BNKACCNO	BANKN35	CHAR	35	0	Loyalty Outbound: Card Bank Account Number
27	IBAN	☐	CRM_LOY_OUTBND_CARD_BNKIBAN	IBAN	CHAR	34	0	Loy. Outbound: Card IBAN (International Bank Account Number)
28	BANK_ACCT_HOLDER	☐	CRM_LOY_OUTBND_CARD_BNKACCHOLD	KOINH	CHAR	60	0	Loyalty Outbound: Card Bank Account Holder Name
29	ORDER_REF_NO	☐	CRM_LOY_CRD_ORDER_REF	CRM_LOY_CRD_ORDER_REF	CHAR	20	0	Loyalty Card Order Reference Number
30	ORDERED_AT	☐	CRM_LOY_OUTBND_CARD_ORDEREDAT	BCOS_TSTMP	DEC	15	0	Loyalty Outbound: Card Ordered At
31	PRINTED_AT	☐	CRM_LOY_OUTBND_CARD_PRINTEDAT	BCOS_TSTMP	DEC	15	0	Loyalty Outbound: Card Printed At
32	SHIPPED_AT	☐	CRM_LOY_OUTBND_CARD_SHIPPEDAT	BCOS_TSTMP	DEC	15	0	Loyalty Outbound: Card Shipped At

History

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