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

History

Last changed by/on	SAP	20130529
SAP Release Created in