SAP ABAP Table CRMST_PAYPLANDET_BTIL (Payment Plan Date/ Item - Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_BTIL_OBJ (Package) Objects of the Transaction Interaction Layer

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_PAYPLANDET_BTIL	Table Relationship Diagram
Short Description	Payment Plan Date/ Item - Fields

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

History

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