SAP ABAP Table CRMD_GIFT_CERT (Gift Certificate Accounts)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-GC (Application Component) Gift Certificate Management
     ⤷ CRM_GIFT_CERTIFICATE (Package) Gift Certificate Processing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_GIFT_CERT	Table Relationship Diagram
Short Description	Gift Certificate Accounts

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	Gift Certificate: Key Fields
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☑	CRMT_GC_OBJECT_GUID	SYSUUID	RAW	16	0	Gift Card Object GUID
4	.INCLUDE	☐				0	0	Gift Certifcates: General Header Data
5	OBJECT_ID	☐	CRMT_GC_OBJECT_ID	CRM_GC_OBJECT_ID	CHAR	25	0	Gift Card Object ID
6	CODE	☐	HASH512_HEX		CHAR	128	0	Hash or HMAC Value up to 512 Bits (128 Hex Digits)
7	TYPE	☐	CRMT_GC_TYPE	CRM_GC_SEND_TYPE	CHAR	1	0	Gift Card: Type
8	VALID_FROM	☐	CRMT_GC_VALID_FROM	DATS	DATS	8	0	Gift Card: Valid From
9	VALID_TO	☐	CRMT_GC_VALID_TO	DATS	DATS	8	0	Gift Card: Valid To
10	CURRENCY	☐	CRMT_GC_CURRENCY	WAERS	CUKY	5	0	Gift Card: Currency	*
11	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
12	OWNER	☐	CRMT_GC_OWNER		CHAR	20	0	Gift Card: Owner
13	AVAIL_BALANCE	☐	CRMT_GC_AVAILABLE_BALANCE		CURR	19	2	Gift Certificate: Available Balance
14	REDEEMABLE	☐	CRMT_GC_REDEEMABLE	CRM_GC_REDEEMABLE	CHAR	1	0	Gift Card: Is Gift Card Redeemable
15	.INCLUDE	☐				0	0	Gift Certificate: Checkbook Fields excluding Avail Balance
16	INITIAL_LOAD	☐	CRMT_GC_AMOUNT		CURR	19	2	Gift Card: Amount
17	SETTLED	☐	CRMT_GC_AMOUNT		CURR	19	2	Gift Card: Amount
18	EXPIRED	☐	CRMT_GC_AMOUNT		CURR	19	2	Gift Card: Amount
19	.INCLUDE	☐				0	0	Gift Card: Organization Data
20	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
21	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
22	CREATED_AT	☐	CRMT_GC_CREATED_AT	CRM_GC_TIMESTAMP	DEC	15	0	Gift Card: Created At
23	CREATED_BY	☐	CRMT_GC_CREATED_BY	UNAME	CHAR	12	0	Gift Card: Created By
24	CHANGED_AT	☐	CRMT_GC_CHANGED_AT	CRM_GC_TIMESTAMP	DEC	15	0	Gift Card: Changed At
25	CHANGED_BY	☐	CRMT_GC_CHANGED_BY	UNAME	CHAR	12	0	Gift Card: Changed By
26	.INCLUDE	☐				0	0	Gift Certificate: Extensibility Structure for GC Header
27	GC_HEADER	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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