SAP ABAP Table FPLTC (Payment cards: Transaction data - SD)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-BIL-IV-PC (Application Component) Payment Cards
     ⤷ VFC (Package) Application development R/3 billing docs.: Payment cards

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FPLTC	Table Relationship Diagram
Short Description	Payment cards: Transaction data - SD

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	FPLNR	☑	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	FPLA
3	FPLTR	☑	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards	FPLT
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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in