SAP ABAP Table JFRKCC (IS-M/SD: Billing - Payment Card Data)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JFRKCC	Table Relationship Diagram
Short Description	IS-M/SD: Billing - 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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	VBELN	☑	ISPVBELN	ISPVBELN	CHAR	10	0	IS-M/SD: Billing Document	*
3	CCACT	☐	CCACT	SAKNR	CHAR	10	0	G/L Account Number for Payment Card Receivables	SKA1
4	.INCLUDE	☐				0	0	Payment cards: Database fields relevant to both SD and FI
5	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
6	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
7	CCFOL	☐	CCFOL	CHAR10	CHAR	10	0	Payment cards: Payment card suffix
8	DATAB	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
9	DATBI	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
10	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
11	CSOUR	☐	CSOUR	CSOUR	CHAR	1	0	Payment cards: Entry mode
12	AUTWR	☐	AUTWR	WERTV8	CURR	15	2	Payment cards: Authorized amount
13	CCWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
14	SETTL	☐	SETTL	XFELD	CHAR	1	0	Payment cards: Settlement carried out
15	AUNUM	☐	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
16	AUTRA	☐	AUTRA	CHAR15	CHAR	15	0	Payment cards: Authoriz. reference code of clearing house
17	AUDAT	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
18	AUTIM	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
19	MERCH	☐	MERCH	MERCH	CHAR	15	0	Payment cards: Merchant ID at the clearing house	TCCM
20	LOCID	☐	LOCID_CC	LOCID_CC	CHAR	10	0	Payment cards: Point of receipt for the transaction	TCCL
21	TRMID	☐	TRMID	CHAR10	CHAR	10	0	Payment cards: Terminal
22	CCBTC	☐	CCBTC	CCBTC	CHAR	10	0	Payment cards: Settlement run
23	CCTYP	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	TVCTY
24	CCARD_GUID	☐	CCARDEC_GUID	SYSUUID_C	CHAR	32	0	Reference to Encrypted Payment Card Data
25	.INCLUDE	☐				0	0	Payment Cards: Transaction Data - SD Database Fields
26	CCAUA	☐	CCAUA	CCAUA	CHAR	1	0	Payment cards: Authorization type
27	CCALL	☐	CCALL	CCALL	CHAR	1	0	Payment cards: Status when external system is called?
28	REACT	☐	REACT_SD	REACT_SD	CHAR	1	0	Payment cards: Response to authorization checks
29	AUTWV	☐	AUTWV	WERTV8	CURR	15	2	Payment cards: Amount to be authorized
30	CCOLD	☐	CCOLD	XFELD	CHAR	1	0	Payment cards: Authorization has expired
31	CCVAL	☐	CCVAL	XFELD	CHAR	1	0	Payment cards: Amount changed
32	CCPRE	☐	CCPRE	XFELD	CHAR	1	0	Payment cards: Preauthorization
33	UELTR_A	☐	UELTR_A	FPLTR	NUMC	6	0	Higher-level authorization for billing plan	FPLT
34	.INCLUDE	☐				0	0	Payment Cards: Result of Authorization/Settlement
35	RCAVR	☐	RCAVR_CC	CHAR4	CHAR	4	0	Payment Cards: Result of Address Check (Address Result)	TCCRC
36	RCAVA	☐	RCAVA_CC	CHAR4	CHAR	4	0	Payment Cards: Result of Address Check (Address Approval)	TCCRC
37	RCAVZ	☐	RCAVZ_CC	CHAR4	CHAR	4	0	Payment Cards: Result of Address Check (ZIP Code Result)	TCCRC
38	RCRSP	☐	RCRSP_CC	CHAR4	CHAR	4	0	Payment cards: Result of card check (response code)	TCCRC
39	RTEXT	☐	RTEXT_CC	TXT40	CHAR	40	0	Payment cards: Result text
40	.INCLUDE	☐				0	0	Card Verification Value
41	ISM_CVVAL	☐	ISM_CVVAL	ISM_CVVAL	CHAR	6	0	Card Verification Value
42	ISM_CVVCT	☐	ISM_CVVCT	ISM_CVVCT	CHAR	1	0	Control Field for Card Verification Value
43	ISM_CVVST	☐	ISM_CVVST	ISM_CVVST	CHAR	1	0	Usage Status of Card Verification Value
44	.INCLUDE	☐				0	0	Response for Card Verification Value
45	ISM_RCCVV	☐	ISM_RCCVV_CC	CHAR4	CHAR	4	0	Results Check for Card Verification Value	TCCRC
46	.INCLUDE	☐				0	0	Credit Card Encryption
47	CGUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
48	ENCTP	☐	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JFRKCC	CCACT	SKA1	SAKNR		1	CN
2	JFRKCC	CCINS	TVCIN	CCINS
3	JFRKCC	CCTYP	TVCTY	CCTYP	REF	1	CN
4	JFRKCC	CCWAE	TCURC	WAERS
5	JFRKCC	ISM_RCCVV	TCCRC	RCODE
6	JFRKCC	LOCID	TCCL	LOCID	REF	C	CN
7	JFRKCC	MERCH	TCCM	MERCH
8	JFRKCC	RCAVA	TCCRC	RCODE	REF	1	CN
9	JFRKCC	RCAVR	TCCRC	RCODE	REF	1	CN
10	JFRKCC	RCAVZ	TCCRC	RCODE	REF	1	CN
11	JFRKCC	RCRSP	TCCRC	RCODE	REF	1	CN
12	JFRKCC	UELTR_A	FPLT	FPLTR	REF	1	C

History

Last changed by/on	SAP	20130529
SAP Release Created in