SAP ABAP Table DFKKOPKC (Card Data Appendix for FICA Document)

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKKB (Package) Contract A/R & A/P: Central Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DFKKOPKC	Table Relationship Diagram
Short Description	Card Data Appendix for FICA Document

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	OPBEL	☑	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
3	OPUPK	☑	OPUPK_KK	OPUPK_KK	NUMC	4	0	Item number in contract account document
4	.INCLUDE	☐				0	0	Payment Cards: Card Data
5	CCINS	☐	CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment card type	TB033
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	☐	CC_DATAB	DATUM	DATS	8	0	Payment cards: Valid from
9	DATBI	☐	CC_DATBI	DATUM	DATS	8	0	Payment Cards: Valid To
10	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
11	.INCLUDE	☐				0	0	Payment Cards: Data for Authorization
12	AUNUM	☐	AUNUM_KK	CHAR25	CHAR	25	0	Payment cards: Authorization number
13	AUTRA	☐	AUTRA_KK	CHAR25	CHAR	25	0	Payment Cards: Authorization Reference Number
14	AUDAT	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
15	AUTIM	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
16	AUART	☐	AUART_KK	AUART_KK	CHAR	1	0	Payment cards: Authorization type
17	AUTWR	☐	AUTWR	WERTV8	CURR	15	2	Payment cards: Authorized amount
18	CCWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
19	MERCH	☐	MERCH	MERCH	CHAR	15	0	Payment cards: Merchant ID at the clearing house	TCCM
20	.INCLUDE	☐				0	0	Payment Cards: Doc Data
21	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
22	BETRW	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
23	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
24	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
25	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
26	.INCLUDE	☐				0	0	Payment Cards: Data for Billing/Reporting
27	XSETT	☐	XSETT_KK	XSETT_KK	CHAR	1	0	Billing Status
28	LAUFI	☐	LAUFI_KK2	CHAR16	CHAR	16	0	Payment cards: Run ID of billing run	DFKKPC_LOGH
29	STDOC	☐	STDOC_KK	OPBEL_KK	CHAR	12	0	Document Number of Billing Document	*
30	.INCLUDE	☐				0	0	Payment Cards: Data from Payment Program
31	LAUFD_PYP	☐	LAUFD_KK	DATUM	DATS	8	0	Date ID	DPAYC
32	LAUFI_PYP	☐	LAUFI_PAY	LAUFI_PAY	CHAR	5	0	Identification for the payment run	DPAYC
33	ORIGN_PYP	☐	ORIGN_PAY	LAUFK_F110	CHAR	1	0	Source of the payment data	DPAYC
34	.INCLUDE	☐				0	0	Payment Cards: Payment Data for Card Organization
35	ANZRATE	☐	ANZRATE_CRD	ANZRATE_KK	NUMC	3	0	No. of Installments
36	.INCLUDE	☐				0	0	Card Verification Code (Card Check Number)
37	CVVAL	☐	CVVAL_KK	CVVAL_KK	CHAR	6	0	Card Verification Code (Check Number on Card, CVC Number)
38	CVVCT	☐	CVVCT_KK	CVVCT_KK	CHAR	1	0	Control Field for Card Verification Value
39	CVVST	☐	CVVST_KK	CVVST_KK	CHAR	1	0	Usage Status of Card Verification Code
40	.INCLUDE	☐				0	0	Payment Cards: Data for Encryption
41	CGUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
42	ENCTP	☐	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption
43	.INCLUDE	☐				0	0
44	.INCLUDE	☐				0	0
45	.INCLUDE	☐				0	0
46	.INCLUDE	☐				0	0
47	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DFKKOPKC	BUKRS	T001	BUKRS
2	DFKKOPKC	CCINS	TB033	CCINS
3	DFKKOPKC	LAUFD_PYP	DPAYC	LAUFD
4	DFKKOPKC	LAUFI	DFKKPC_LOGH	LAUFI
5	DFKKOPKC	LAUFI_PYP	DPAYC	LAUFI
6	DFKKOPKC	MERCH	TCCM	MERCH
7	DFKKOPKC	ORIGN_PYP	DPAYC	ORIGN
8	DFKKOPKC	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in