SAP ABAP Table COMT_PAYPLAN_D_DB_WRK (Payment Plan Date: Work Area of Database Buffer)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	COMT_PAYPLAN_D_DB_WRK	Table Relationship Diagram
Short Description	Payment Plan Date: Work Area of Database Buffer

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	Payment Plan Date
2	.INCLUDE	☐				0	0	Payment Plan Date/Item Key Fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	COMT_PAYPLAN_D_GUID	SYSUUID	RAW	16	0	GUID of Date/Item in Payment Plan
5	.INCLUDE	☐				0	0	Payment Plan: External Fields for Date/Item
6	PARENT_GUID	☐	COMT_PAYPLAN_D_GUID	SYSUUID	RAW	16	0	GUID of Date/Item in Payment Plan
7	DATE_TYPE	☐	COMT_PAYPLAN_DATE_TYPE	COM_DATE_TYPE_PP	CHAR	2	0	Date Category, Item Category Payment Plan	*
8	PAYM_TYPE	☐	COMT_PAYM_TYPE	COM_PAYM_TYPE	CHAR	2	0	Payment Form for Payment Plan Dates / Items
9	SORT_INT	☐	COMT_SORT_INT		CHAR	10	0	Sort Order for Internal Purposes (Authorized Line)
10	SORT_EXT	☐	COMT_SORT_EXT		CHAR	10	0	External Number
11	CURRENCY	☐	COMT_PAYPLAN_CURRENCY	WAERS	CUKY	5	0	Currency in Payment Plan	*
12	EXCH_RATE	☐	COMT_PAYPLAN_EXCH_RATE		DEC	9	5	Exchange Rate for Payment Plan
13	PLANNED_VAL	☐	COMT_PAY_PLANNED_VAL	WERTV8	CURR	15	2	Planned Value Incoming Payment
14	HEADER_GUID	☐	COMT_PAYPLAN_GUID	SYSUUID	RAW	16	0	Payment Plan GUID
15	.INCLUDE	☐				0	0	Payment Card Structure without Key Fields
16	.INCLUDE	☐				0	0	Payment Plan: External Fields for Date/Item
17	.INCLUDE	☐				0	0	Payment Cards: External Fields for Card
18	CARD_TYPE	☐	CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment card type	TB033
19	CARD_NO	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
20	CARD_SUFFIX	☐	COMT_CARD_SUFFIX	CHAR10	CHAR	10	0	Sequential Number of Payment Card
21	CARD_REF_NO	☐	COMT_CARD_REF_NO	COM_CARD_REF_NO	CHAR	25	0	Payment Cards: Reference Number of a Payment Card
22	CARD_BEG_DATE	☐	CC_DATAB	DATUM	DATS	8	0	Payment cards: Valid from
23	CARD_EXP_DATE	☐	CC_DATBI	DATUM	DATS	8	0	Payment Cards: Valid To
24	CARD_HOLDER	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
25	CARD_MERCH_ID	☐	COMT_CARD_MERCH_ID	COM_MERCH_ID_CC	CHAR	15	0	Identification of Merchant at Clearing House	*
26	CARD_DEFAULT	☐	COMT_CARD_DEFAULT	COM_BOOLEAN_PP	CHAR	1	0	Payment Cards: Indicator for a Standard Card
27	.INCLUDE	☐				0	0	Payment Cards: External Fields Reg. Card Verification Value
28	CARD_CVV	☐	COMT_CARD_CVV	COM_CARD_CVV	CHAR	6	0	Payment Cards: Card Verification Value
29	CARD_CVV_STATUS	☐	COMT_CARD_CVV_STATUS	COM_CARD_CVV_STATUS	CHAR	1	0	Payment Cards: State of Card Verification Value
30	CARD_CVV_CONTROL	☐	COMT_CARD_CVV_CONTROL	COM_CARD_CVV_CONTROL	CHAR	1	0	Payment Cards: Control Field for Card Verification Value
31	.INCLUDE	☐				0	0	Payment Cards: Encoding of Card Number
32	CARD_GUID	☐	COMT_CARD_GUID	SYSUUID	RAW	16	0	Payment Cards: GUID of Payment Card
33	.INCLUDE	☐				0	0	Payment Cards: External Fields for Authorization
34	AUTH_LIMIT	☐	COMT_AUTH_LIMIT	WERTV8	CURR	15	2	Payment Cards: Maximum Amount of Value to be Authorized
35	AUTH_LIMITED	☐	COMT_AUTH_LIMITED	XFELD	CHAR	1	0	Payment Cards: Limited Value
36	AUTH_AMOUNT	☐	COMT_AUTH_AMOUNT	WERTV8	CURR	15	2	Payment Cards: Authorized Amount
37	AUTH_USED	☐	COMT_AUTH_USED	XFELD	CHAR	1	0	Authorization Is Already Used
38	AUTH_USED_BY	☐	COMT_AUTH_USED_BY	CHAR10	CHAR	10	0	Authorization Line: Used By
39	AUTH_USED_OBJTYP	☐	COMT_AUTH_USED_OBJTYPE	OJ_NAME	CHAR	10	0	Authorization Line: Used By Object Type	*
40	AUTH_USED_LOGSYS	☐	COMT_AUTH_USED_LOGSYS	LOGSYS	CHAR	10	0	Authorization Line: Used By Logical System	*
41	AUTH_USED_AMOUNT	☐	COMT_AUTH_USED_AMOUNT	WERTV8	CURR	15	2	Authorization Line: Used Amount
42	AUTH_NO	☐	COMT_AUTH_NO	CHAR10	CHAR	10	0	Payment Cards: Authorization Number
43	AUTH_REF	☐	COMT_AUTH_REF	CHAR30	CHAR	30	0	Authorization Reference Number of Clearing House
44	AUTH_PRE	☐	COMT_AUTH_PRE	XFELD	CHAR	1	0	Payment Cards: Preauthorization
45	AUTH_TIMESTAMP	☐	COMT_AUTH_TIMESTAMP	BCOS_TSTMP	DEC	15	0	Date and Time of Authorization
46	AUTH_CALL_STATUS	☐	COMT_AUTH_CALL_STATUS	COM_AUTH_CALL_STATUS	CHAR	1	0	Payment Cards: Status when Calling Clearing House
47	AUTH_RESP	☐	COMT_AUTH_RESP	COM_AUTH_RESP	CHAR	1	0	Response to Authorization Result
48	AUTH_REQ_AMOUNT	☐	COMT_AUTH_REQ_AMOUNT	WERTV8	CURR	15	2	Payment Cards: Amount to be Authorized
49	AUTH_TIMESTAMPIO	☐	COMT_AUTH_TIMESTAMPIO	TZTF_IO_FIELD	CHAR	26	0	Date and Time of Authorization in Display Format
50	AUTH_TYPE	☐	COMT_AUTH_TYPE	COM_AUTH_TYPE	CHAR	1	0	Authorization Type for Payment Cards
51	AUTH_SEPARATE	☐	COMT_AUTH_SEPARATE	XFELD	CHAR	1	0	Indicates that this card will be authorized separately
52	.INCLUDE	☐				0	0	Payment Cards: Return Code from Clearing House
53	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
54	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
55	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
56	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
57	.INCLUDE	☐				0	0	Payment Card: Answer from Clearing House Regard. Check Field
58	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
59	AUTH_RESP_CODE	☐	COMT_AUTH_RESP_CODE	TEXT40	CHAR	40	0	Results Text of Authorization
60	.INCLUDE	☐				0	0	Payment Card Data: Internal Error
61	CARD_ORIG	☐	COMT_CARD_ORIG	COM_CARD_ORIG	CHAR	1	0	Payment Cards: Data Origin
62	CARD_CATEGORY	☐	CC_CCTYP	CCTYPE	CHAR	2	0	Payment cards: Card category	*
63	AUTH_EXP	☐	COMT_AUTH_EXP	XFELD	CHAR	1	0	Payment Cards: Authorization Expired
64	.INCLUDE	☐				0	0	Payment Service Provider Data
65	PAYM_SRV_PROV	☐	COM_WEC_PAYMENT_SRV_PROVIDER	COM_WEC_PAYMENT_SRV_PROVIDER	CHAR	4	0	Payment Service Provider	*
66	PAYM_TRANS_GUID	☐	COM_WEC_TRANSACTION_GUID	COM_WEC_TRANSACTION_GUID	RAW	16	0	Payment Transaction Reference GUID
67	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
68	PSP_TRANS_AMT	☐	COM_WEC_TRANSACTION_AMOUNT	WERTV8	CURR	15	2	Payment Transaction Amount
69	PSP_TRANS_CURR	☐	COM_WEC_TRANSACTION_CURRENCY	WAERS	CUKY	5	0	Payment Transaction Currency	*
70	PSP_STATUS_PF	☐	COM_WEC_TRANSACTION_PROFILE	COM_WEC_TRANSACTION_PROFILE	CHAR	4	0	Payment Status Profile	*
71	PSP_STATUS	☐	COM_WEC_TRANSACTION_STATUS	COM_WEC_TRANSACTION_STATUS	CHAR	4	0	Payment Transaction Status	*
72	.INCLUDE	☐				0	0	Internal Attributes for Payment Service Provider
73	HEADER_GUID_D	☐	COMT_PAYPLAN_GUID	SYSUUID	RAW	16	0	Payment Plan GUID
74	.INCLUDE	☐				0	0	Date Payment Plan: Dynamic Fields of Database Buffer
75	NOREC_FLAG	☐	COMT_NOREC_PP	XFELD	CHAR	1	0	Entry does not Exist in Database

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in