SAP ABAP Table COMD_PAYPLAN_DC (Payment Plan Date/Item: Payment Card Data)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	COMD_PAYPLAN_DC	Table Relationship Diagram
Short Description	Payment Plan Date/Item: Payment Card Data

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	Payment Plan Date/Item Key Fields
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☑	COMT_PAYPLAN_D_GUID	SYSUUID	RAW	16	0	GUID of Date/Item in Payment Plan
4	.INCLUDE	☐				0	0	Payment Plan: External Fields for Date/Item
5	.INCLUDE	☐				0	0	Payment Cards: External Fields for Card
6	CARD_TYPE	☐	CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment card type	TB033
7	CARD_NO	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
8	CARD_SUFFIX	☐	COMT_CARD_SUFFIX	CHAR10	CHAR	10	0	Sequential Number of Payment Card
9	CARD_REF_NO	☐	COMT_CARD_REF_NO	COM_CARD_REF_NO	CHAR	25	0	Payment Cards: Reference Number of a Payment Card
10	CARD_BEG_DATE	☐	CC_DATAB	DATUM	DATS	8	0	Payment cards: Valid from
11	CARD_EXP_DATE	☐	CC_DATBI	DATUM	DATS	8	0	Payment Cards: Valid To
12	CARD_HOLDER	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
13	CARD_MERCH_ID	☐	COMT_CARD_MERCH_ID	COM_MERCH_ID_CC	CHAR	15	0	Identification of Merchant at Clearing House	*
14	CARD_DEFAULT	☐	COMT_CARD_DEFAULT	COM_BOOLEAN_PP	CHAR	1	0	Payment Cards: Indicator for a Standard Card
15	.INCLUDE	☐				0	0	Payment Cards: External Fields Reg. Card Verification Value
16	CARD_CVV	☐	COMT_CARD_CVV	COM_CARD_CVV	CHAR	6	0	Payment Cards: Card Verification Value
17	CARD_CVV_STATUS	☐	COMT_CARD_CVV_STATUS	COM_CARD_CVV_STATUS	CHAR	1	0	Payment Cards: State of Card Verification Value
18	CARD_CVV_CONTROL	☐	COMT_CARD_CVV_CONTROL	COM_CARD_CVV_CONTROL	CHAR	1	0	Payment Cards: Control Field for Card Verification Value
19	.INCLUDE	☐				0	0	Payment Cards: Encoding of Card Number
20	CARD_GUID	☐	COMT_CARD_GUID	SYSUUID	RAW	16	0	Payment Cards: GUID of Payment Card
21	.INCLUDE	☐				0	0	Payment Cards: External Fields for Authorization
22	AUTH_LIMIT	☐	COMT_AUTH_LIMIT	WERTV8	CURR	15	2	Payment Cards: Maximum Amount of Value to be Authorized
23	AUTH_LIMITED	☐	COMT_AUTH_LIMITED	XFELD	CHAR	1	0	Payment Cards: Limited Value
24	AUTH_AMOUNT	☐	COMT_AUTH_AMOUNT	WERTV8	CURR	15	2	Payment Cards: Authorized Amount
25	AUTH_USED	☐	COMT_AUTH_USED	XFELD	CHAR	1	0	Authorization Is Already Used
26	AUTH_USED_BY	☐	COMT_AUTH_USED_BY	CHAR10	CHAR	10	0	Authorization Line: Used By
27	AUTH_USED_OBJTYP	☐	COMT_AUTH_USED_OBJTYPE	OJ_NAME	CHAR	10	0	Authorization Line: Used By Object Type	*
28	AUTH_USED_LOGSYS	☐	COMT_AUTH_USED_LOGSYS	LOGSYS	CHAR	10	0	Authorization Line: Used By Logical System	*
29	AUTH_USED_AMOUNT	☐	COMT_AUTH_USED_AMOUNT	WERTV8	CURR	15	2	Authorization Line: Used Amount
30	AUTH_NO	☐	COMT_AUTH_NO	CHAR10	CHAR	10	0	Payment Cards: Authorization Number
31	AUTH_REF	☐	COMT_AUTH_REF	CHAR30	CHAR	30	0	Authorization Reference Number of Clearing House
32	AUTH_PRE	☐	COMT_AUTH_PRE	XFELD	CHAR	1	0	Payment Cards: Preauthorization
33	AUTH_TIMESTAMP	☐	COMT_AUTH_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Date and Time of Authorization
34	AUTH_CALL_STATUS	☐	COMT_AUTH_CALL_STATUS	COM_AUTH_CALL_STATUS	CHAR	1	0	Payment Cards: Status when Calling Clearing House
35	AUTH_RESP	☐	COMT_AUTH_RESP	COM_AUTH_RESP	CHAR	1	0	Response to Authorization Result
36	AUTH_REQ_AMOUNT	☐	COMT_AUTH_REQ_AMOUNT	WERTV8	CURR	15	2	Payment Cards: Amount to be Authorized
37	AUTH_TIMESTAMPIO	☐	COMT_AUTH_TIMESTAMPIO	TZTF_IO_FIELD	CHAR	26	0	Date and Time of Authorization in Display Format
38	AUTH_TYPE	☐	COMT_AUTH_TYPE	COM_AUTH_TYPE	CHAR	1	0	Authorization Type for Payment Cards
39	AUTH_SEPARATE	☐	COMT_AUTH_SEPARATE	XFELD	CHAR	1	0	Indicates that this card will be authorized separately
40	.INCLUDE	☐				0	0	Payment Cards: Return Code from Clearing House
41	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
42	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
43	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
44	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
45	.INCLUDE	☐				0	0	Payment Card: Answer from Clearing House Regard. Check Field
46	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
47	AUTH_RESP_CODE	☐	COMT_AUTH_RESP_CODE	TEXT40	CHAR	40	0	Results Text of Authorization
48	.INCLUDE	☐				0	0	Payment Card Data: Internal Error
49	CARD_ORIG	☐	COMT_CARD_ORIG	COM_CARD_ORIG	CHAR	1	0	Payment Cards: Data Origin
50	CARD_CATEGORY	☐	CC_CCTYP	CCTYPE	CHAR	2	0	Payment cards: Card category	*
51	AUTH_EXP	☐	COMT_AUTH_EXP	XFELD	CHAR	1	0	Payment Cards: Authorization Expired

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in