SAP ABAP Table BEAS_PAYPLAN (Billing of Payment Plan Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BE (Application Component) Billing
     ⤷ BEA_PYP (Package) Billing Payment Plan

Basic Data

Table Category	INTTAB	Structure
Structure	BEAS_PAYPLAN	Table Relationship Diagram
Short Description	Billing of Payment Plan Data

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

Foreign Keys

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

History

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