SAP ABAP Table CRMT_PAYPLAN_D_COM (Payment Plan Set Communication Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-PC (Application Component) Payment Cards
     ⤷ CRM_PAYPLAN (Package) Payment Plan in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PAYPLAN_D_COM	Table Relationship Diagram
Short Description	Payment Plan Set Communication 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	REF_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
2	REF_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	REF_KIND	☐	CRMT_OBJECT_KIND	CRM_OBJECTKIND	CHAR	1	0	Object Type
4	HANDLE	☐	COMT_PAYPLAN_D_HANDLE		NUMC	10	0	Payment Plan Date Handle
5	GUID	☐	COMT_PAYPLAN_D_GUID	SYSUUID	RAW	16	0	GUID of Date/Item in Payment Plan
6	PARENT_HANDLE	☐	COMT_PAYPLAN_D_HANDLE		NUMC	10	0	Payment Plan Date Handle
7	.INCLUDE	☐				0	0	Payment Plan: External Fields for Date/Item
8	PARENT_GUID	☐	COMT_PAYPLAN_D_GUID	SYSUUID	RAW	16	0	GUID of Date/Item in Payment Plan
9	DATE_TYPE	☐	COMT_PAYPLAN_DATE_TYPE	COM_DATE_TYPE_PP	CHAR	2	0	Date Category, Item Category Payment Plan	*
10	PAYM_TYPE	☐	COMT_PAYM_TYPE	COM_PAYM_TYPE	CHAR	2	0	Payment Form for Payment Plan Dates / Items
11	SORT_INT	☐	COMT_SORT_INT		CHAR	10	0	Sort Order for Internal Purposes (Authorized Line)
12	SORT_EXT	☐	COMT_SORT_EXT		CHAR	10	0	External Number
13	CURRENCY	☐	COMT_PAYPLAN_CURRENCY	WAERS	CUKY	5	0	Currency in Payment Plan	*
14	EXCH_RATE	☐	COMT_PAYPLAN_EXCH_RATE		DEC	9	5	Exchange Rate for Payment Plan
15	PLANNED_VAL	☐	COMT_PAY_PLANNED_VAL	WERTV8	CURR	15	2	Planned Value Incoming Payment
16	HEADER_GUID	☐	COMT_PAYPLAN_GUID	SYSUUID	RAW	16	0	Payment Plan GUID
17	.INCLUDE	☐				0	0	Payment Plan: External Fields for Date/Item
18	.INCLUDE	☐				0	0	Payment Cards: External Fields for Card
19	CARD_TYPE	☐	CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment card type	TB033
20	CARD_NO	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
21	CARD_SUFFIX	☐	COMT_CARD_SUFFIX	CHAR10	CHAR	10	0	Sequential Number of Payment Card
22	CARD_REF_NO	☐	COMT_CARD_REF_NO	COM_CARD_REF_NO	CHAR	25	0	Payment Cards: Reference Number of a Payment Card
23	CARD_BEG_DATE	☐	CC_DATAB	DATUM	DATS	8	0	Payment cards: Valid from
24	CARD_EXP_DATE	☐	CC_DATBI	DATUM	DATS	8	0	Payment Cards: Valid To
25	CARD_HOLDER	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
26	CARD_MERCH_ID	☐	COMT_CARD_MERCH_ID	COM_MERCH_ID_CC	CHAR	15	0	Identification of Merchant at Clearing House	*
27	CARD_DEFAULT	☐	COMT_CARD_DEFAULT	COM_BOOLEAN_PP	CHAR	1	0	Payment Cards: Indicator for a Standard Card
28	.INCLUDE	☐				0	0	Payment Cards: External Fields Reg. Card Verification Value
29	CARD_CVV	☐	COMT_CARD_CVV	COM_CARD_CVV	CHAR	6	0	Payment Cards: Card Verification Value
30	CARD_CVV_STATUS	☐	COMT_CARD_CVV_STATUS	COM_CARD_CVV_STATUS	CHAR	1	0	Payment Cards: State of Card Verification Value
31	CARD_CVV_CONTROL	☐	COMT_CARD_CVV_CONTROL	COM_CARD_CVV_CONTROL	CHAR	1	0	Payment Cards: Control Field for Card Verification Value
32	.INCLUDE	☐				0	0	Payment Cards: Encoding of Card Number
33	CARD_GUID	☐	COMT_CARD_GUID	SYSUUID	RAW	16	0	Payment Cards: GUID of Payment Card
34	.INCLUDE	☐				0	0	Payment Cards: External Fields for Authorization
35	AUTH_LIMIT	☐	COMT_AUTH_LIMIT	WERTV8	CURR	15	2	Payment Cards: Maximum Amount of Value to be Authorized
36	AUTH_LIMITED	☐	COMT_AUTH_LIMITED	XFELD	CHAR	1	0	Payment Cards: Limited Value
37	AUTH_AMOUNT	☐	COMT_AUTH_AMOUNT	WERTV8	CURR	15	2	Payment Cards: Authorized Amount
38	AUTH_USED	☐	COMT_AUTH_USED	XFELD	CHAR	1	0	Authorization Is Already Used
39	AUTH_USED_BY	☐	COMT_AUTH_USED_BY	CHAR10	CHAR	10	0	Authorization Line: Used By
40	AUTH_USED_OBJTYP	☐	COMT_AUTH_USED_OBJTYPE	OJ_NAME	CHAR	10	0	Authorization Line: Used By Object Type	*
41	AUTH_USED_LOGSYS	☐	COMT_AUTH_USED_LOGSYS	LOGSYS	CHAR	10	0	Authorization Line: Used By Logical System	*
42	AUTH_USED_AMOUNT	☐	COMT_AUTH_USED_AMOUNT	WERTV8	CURR	15	2	Authorization Line: Used Amount
43	AUTH_NO	☐	COMT_AUTH_NO	CHAR10	CHAR	10	0	Payment Cards: Authorization Number
44	AUTH_REF	☐	COMT_AUTH_REF	CHAR30	CHAR	30	0	Authorization Reference Number of Clearing House
45	AUTH_PRE	☐	COMT_AUTH_PRE	XFELD	CHAR	1	0	Payment Cards: Preauthorization
46	AUTH_TIMESTAMP	☐	COMT_AUTH_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Date and Time of Authorization
47	AUTH_CALL_STATUS	☐	COMT_AUTH_CALL_STATUS	COM_AUTH_CALL_STATUS	CHAR	1	0	Payment Cards: Status when Calling Clearing House
48	AUTH_RESP	☐	COMT_AUTH_RESP	COM_AUTH_RESP	CHAR	1	0	Response to Authorization Result
49	AUTH_REQ_AMOUNT	☐	COMT_AUTH_REQ_AMOUNT	WERTV8	CURR	15	2	Payment Cards: Amount to be Authorized
50	AUTH_TIMESTAMPIO	☐	COMT_AUTH_TIMESTAMPIO	TZTF_IO_FIELD	CHAR	26	0	Date and Time of Authorization in Display Format
51	AUTH_TYPE	☐	COMT_AUTH_TYPE	COM_AUTH_TYPE	CHAR	1	0	Authorization Type for Payment Cards
52	AUTH_SEPARATE	☐	COMT_AUTH_SEPARATE	XFELD	CHAR	1	0	Indicates that this card will be authorized separately
53	.INCLUDE	☐				0	0	Payment Cards: Return Code from Clearing House
54	AUTH_RESP_RC_AR	☐	COMT_AUTH_RESP_RC_AR	COM_AUTH_CHECK_RESULT	CHAR	4	0	Payment Cards: Result of Address Check (Address Result)	COMC_PC_RESP
55	AUTH_RESP_RC_AP	☐	COMT_AUTH_RESP_RC_AP	COM_AUTH_CHECK_RESULT	CHAR	4	0	Payment Cards: Result of Address Check (Address Approval)	COMC_PC_RESP
56	AUTH_RESP_RC_ZR	☐	COMT_AUTH_RESP_RC_ZR	COM_AUTH_CHECK_RESULT	CHAR	4	0	Payment Cards: Result of Address Check (ZIP Code Result)	COMC_PC_RESP
57	AUTH_RESP_RC_CC	☐	COMT_AUTH_RESP_RC_CC	COM_AUTH_CHECK_RESULT	CHAR	4	0	Payment Cards: Result of Card Check (Response Code)	COMC_PC_RESP
58	.INCLUDE	☐				0	0	Payment Card: Answer from Clearing House Regard. Check Field
59	AUTH_RESP_RC_CVV	☐	COMT_AUTH_RESP_RC_CVV	COM_AUTH_CHECK_RESULT	CHAR	4	0	Payment Cards: Result Check of the Card Verification Code
60	AUTH_RESP_CODE	☐	COMT_AUTH_RESP_CODE	TEXT40	CHAR	40	0	Results Text of Authorization
61	.INCLUDE	☐				0	0	Payment Service Provider Data
62	PAYM_SRV_PROV	☐	COM_WEC_PAYMENT_SRV_PROVIDER	COM_WEC_PAYMENT_SRV_PROVIDER	CHAR	4	0	Payment Service Provider	*
63	PAYM_TRANS_GUID	☐	COM_WEC_TRANSACTION_GUID	COM_WEC_TRANSACTION_GUID	RAW	16	0	Payment Transaction Reference GUID
64	PSP_TRANS_ID	☐	COM_WEC_PSP_TRANSACTION_ID	COM_WEC_PSP_TRANSACTION_ID	CHAR	35	0	ID of the Payment Transaction in the PSP System
65	PSP_TRANS_AMT	☐	COM_WEC_TRANSACTION_AMOUNT	WERTV8	CURR	15	2	Payment Transaction Amount
66	PSP_TRANS_CURR	☐	COM_WEC_TRANSACTION_CURRENCY	WAERS	CUKY	5	0	Payment Transaction Currency	*
67	PSP_STATUS_PF	☐	COM_WEC_TRANSACTION_PROFILE	COM_WEC_TRANSACTION_PROFILE	CHAR	4	0	Payment Status Profile	*
68	PSP_STATUS	☐	COM_WEC_TRANSACTION_STATUS	COM_WEC_TRANSACTION_STATUS	CHAR	4	0	Payment Transaction Status	*
69	.INCLUDE	☐				0	0	Payment Plan Date: Dynamic Communication Fields
70	PAYPLAN_D_C_GUID	☐	COMT_PAYPLAN_D_GUID	SYSUUID	RAW	16	0	GUID of Date/Item in Payment Plan
71	.INCLUDE	☐				0	0	Payment Plan Date: User Interface Communication Fields
72	.INCLUDE	☐				0	0	Payment Cards: Control Fields for Displaying Terms
73	CARD_NO_MASK_FLAG	☐	COMT_CARD_NO_MASK_FLAG	XFELD	CHAR	1	0	Payment Cards: Format Flag of Card Number
74	.INCLUDE	☐				0	0	Internal Dynamic Fields
75	MODE	☐	COMT_MODE_PP	COM_MODE_PP	CHAR	1	0	Processing Mode of Transaction

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_PAYPLAN_D_COM	AUTH_RESP_RC_AP	COMC_PC_RESP	AUTH_CHECK_RES	REF	1	CN
2	CRMT_PAYPLAN_D_COM	AUTH_RESP_RC_AR	COMC_PC_RESP	AUTH_CHECK_RES	REF	1	CN
3	CRMT_PAYPLAN_D_COM	AUTH_RESP_RC_CC	COMC_PC_RESP	AUTH_CHECK_RES	REF	1	CN
4	CRMT_PAYPLAN_D_COM	AUTH_RESP_RC_ZR	COMC_PC_RESP	AUTH_CHECK_RES	REF	1	CN
5	CRMT_PAYPLAN_D_COM	CARD_TYPE	TB033	CCINS	REF	C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in