SAP ABAP Table BIL_S_PRT_PAYMENT_CARDS (Structure for Payment Cards)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-BF-OC (Application Component) Output Determination
     ⤷ VD_PDF (Package) Sales: PDF Print

Basic Data

Table Category	INTTAB	Structure
Structure	BIL_S_PRT_PAYMENT_CARDS	Table Relationship Diagram
Short Description	Structure for Payment Cards

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	Reference Structure for XFPLT/YFPLT
2	.INCLUDE	☐				0	0	Billing Plan: Dates
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
5	FPLTR	☐	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards	*
6	FPTTP	☐	FPTTP	FPTTP	CHAR	2	0	Date Category	TFPLT
7	TETXT	☐	TETXT_FP	TETXT	CHAR	4	0	Date description	TVTB
8	FKDAT	☐	BFDAT	DATUM	DATS	8	0	Settlement Date for Deadline
9	FPFIX	☐	FPFIX	FPFIX	CHAR	1	0	ID for adopting billing/invoice date
10	FAREG	☐	FAREG	FAREG	CHAR	1	0	Rule in billing plan/invoice plan
11	FPROZ	☐	FPROZ	PRZ32	DEC	5	2	Percentage of value to be billed
12	WAERS	☐	WAERS_CP	WAERS	CUKY	5	0	Currency Key of Credit Control Area	TCURC
13	KURFP	☐	KURFP	KURRF	DEC	9	5	Exchange rate for date in billing plan
14	FAKWR	☐	FAKWR	WERTV8	CURR	15	2	Value to be billed/calc. on date in billing/invoice plan
15	FAKSP	☐	FAKSP_FP	FAKSP	CHAR	2	0	Billing block for billing plan/invoice plan dates	TVFS
16	FKARV	☐	FKARA	FKART	CHAR	4	0	Proposed billing type for an order-related billing document	TVFK
17	FKSAF	☐	FKSAF	STATV	CHAR	1	0	Billing status for the billing plan/invoice plan date
18	PERIO	☐	PERIO_FP	VDREG_VEDA	CHAR	2	0	Rule for determining the next billing/invoice date	TVRG
19	FPLAE	☐	FPLAE	NUM3	NUMC	3	0	Length of a standard period in the billing plan
20	MLSTN	☐	MLST_ZAEHL	NUM12	NUMC	12	0	Number of milestone
21	MLBEZ	☐	MILESTONE	MILESTONE	CHAR	5	0	Usage	T433
22	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
23	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
24	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
25	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
26	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
27	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
28	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
29	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
30	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
31	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
32	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
33	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
34	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
35	NFDAT	☐	NFDAT	DATUM	DATS	8	0	Settlement date for deadline
36	TEMAN	☐	TEMAN_1	TEMAN	CHAR	1	0	Process as for manually entered date
37	FAKCA	☐	FAKCA	WFCID	CHAR	2	0	Calendar for defining days relevant for billing/invoicing	TFACD
38	AFDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
39	NETWR	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
40	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
41	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
42	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
43	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
44	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
45	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
46	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
47	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
48	CMPRE	☐	CMPRE	WERTV6	CURR	11	2	Item credit price
49	SKFBP	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
50	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
51	PRSOK	☐	PRSOK	XFELD	CHAR	1	0	Pricing is OK
52	TYPZM	☐	TYPZM	TYPZM	CHAR	1	0	Means of payment for classifying payment card plan lines
53	CMPRE_FLT	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
54	UELNR	☐	UELNR	FPLNR	CHAR	10	0	Higher-level payment card plan number for billing	FPLA
55	UELTR	☐	UELTR	FPLTR	NUMC	6	0	Higher-level item in billing plan	FPLT
56	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
57	CCACT	☐	CCACT	SAKNR	CHAR	10	0	G/L Account Number for Payment Card Receivables	SKA1
58	KORTE	☐	KORTE	KORTE	CHAR	1	0	Indicator for correction date in billing plan
59	OFKDAT	☐	OFKDAT	DATUM	DATS	8	0	Baseline date for determining AFDAT
60	.INCLU--AP	☐				0	0	Period of Performance
61	PEROP_BEG	☐	FM_PEROP_SD_LOW	DATUM	DATS	8	0	Period of Performance Start Date
62	PEROP_END	☐	FM_PEROP_SD_HIGH	DATUM	DATS	8	0	Period of Performance End Date
63	.INCLUDE	☐				0	0	Dynamic Part of Billing Plan Dates
64	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
65	SELKZ	☐	SELKZ_LIST	SELKZ	CHAR	1	0	Selection indicator for list screens
66	KZMEI	☐	KZMEI	XFELD	CHAR	1	0	ID: Milestone assigned to date
67	TEBEZ	☐	TEBEZ_FP	TEXT40	CHAR	40	0	Date description
68	NETWRG	☐	NETWRG	WERTV8	CURR	15	2	Total net value of the header billing plan in doc. curr.
69	FKSAFK	☐	FKSAFK	STATV	CHAR	1	0	Header status for date of billing plan/invoice plan
70	.INCLUDE	☐				0	0	Payment cards: Database fields relevant to both SD and FI
71	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
72	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
73	CCFOL	☐	CCFOL	CHAR10	CHAR	10	0	Payment cards: Payment card suffix
74	DATAB	☐	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
75	DATBI	☐	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
76	CCNAME	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
77	CSOUR	☐	CSOUR	CSOUR	CHAR	1	0	Payment cards: Entry mode
78	AUTWR	☐	AUTWR	WERTV8	CURR	15	2	Payment cards: Authorized amount
79	CCWAE	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
80	SETTL	☐	SETTL	XFELD	CHAR	1	0	Payment cards: Settlement carried out
81	AUNUM	☐	AUNUM	CHAR10	CHAR	10	0	Payment cards: Authorization number
82	AUTRA	☐	AUTRA	CHAR15	CHAR	15	0	Payment cards: Authoriz. reference code of clearing house
83	AUDAT	☐	AUDAT_CC	DATUM	DATS	8	0	Payment cards: Authorization date
84	AUTIM	☐	AUTIM	UZEIT	TIMS	6	0	Payment cards: Authorization time
85	MERCH	☐	MERCH	MERCH	CHAR	15	0	Payment cards: Merchant ID at the clearing house	TCCM
86	LOCID	☐	LOCID_CC	LOCID_CC	CHAR	10	0	Payment cards: Point of receipt for the transaction	TCCL
87	TRMID	☐	TRMID	CHAR10	CHAR	10	0	Payment cards: Terminal
88	CCBTC	☐	CCBTC	CCBTC	CHAR	10	0	Payment cards: Settlement run
89	CCTYP	☐	CCTYP	CCTYP	CHAR	2	0	Payment cards: Card category	TVCTY
90	CCARD_GUID	☐	CCARDEC_GUID	SYSUUID_C	CHAR	32	0	Reference to Encrypted Payment Card Data
91	.INCLUDE	☐				0	0	Payment Cards: Transaction Data - SD Database Fields
92	CCAUA	☐	CCAUA	CCAUA	CHAR	1	0	Payment cards: Authorization type
93	CCALL	☐	CCALL	CCALL	CHAR	1	0	Payment cards: Status when external system is called?
94	REACT	☐	REACT_SD	REACT_SD	CHAR	1	0	Payment cards: Response to authorization checks
95	AUTWV	☐	AUTWV	WERTV8	CURR	15	2	Payment cards: Amount to be authorized
96	CCOLD	☐	CCOLD	XFELD	CHAR	1	0	Payment cards: Authorization has expired
97	CCVAL	☐	CCVAL	XFELD	CHAR	1	0	Payment cards: Amount changed
98	CCPRE	☐	CCPRE	XFELD	CHAR	1	0	Payment cards: Preauthorization
99	UELTR_A	☐	UELTR_A	FPLTR	NUMC	6	0	Higher-level authorization for billing plan	FPLT
100	.INCLUDE	☐				0	0	Payment Cards: Result of Authorization/Settlement
101	RCAVR	☐	RCAVR_CC	CHAR4	CHAR	4	0	Payment Cards: Result of Address Check (Address Result)	TCCRC
102	RCAVA	☐	RCAVA_CC	CHAR4	CHAR	4	0	Payment Cards: Result of Address Check (Address Approval)	TCCRC
103	RCAVZ	☐	RCAVZ_CC	CHAR4	CHAR	4	0	Payment Cards: Result of Address Check (ZIP Code Result)	TCCRC
104	RCRSP	☐	RCRSP_CC	CHAR4	CHAR	4	0	Payment cards: Result of card check (response code)	TCCRC
105	RTEXT	☐	RTEXT_CC	TXT40	CHAR	40	0	Payment cards: Result text
106	.INCLUDE	☐				0	0	Payment Cards: Fields for SET Processing
107	VCARD	☐	VCARD	XFELD	CHAR	1	0	Virtual card
108	RFCAUT	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
109	FNAUT_SETINIT	☐	FNAUT_SETINIT	FUNCNAME	CHAR	30	0	Payment Cards: Function for Initialization SET Authorization	*
110	FNAUT_SETINFO	☐	FNAUT_SETINFO	FUNCNAME	CHAR	30	0	Payment Cards: Function for Result of Authorization (SET)	*
111	.INCLUDE	☐				0	0	Card Verification Value
112	CVVAL	☐	CVVAL	CVVAL	CHAR	6	0	Card Verification Value
113	CVVCT	☐	CVVCT	CVVCT	CHAR	1	0	Control Field for Card Verification Value
114	CVVST	☐	CVVST	CVVST	CHAR	1	0	Usage Status for Card Verification Value
115	.INCLUDE	☐				0	0	Response for Card Verification Value
116	RCCVV	☐	RCCVV_CC	CHAR4	CHAR	4	0	Results Check for Card Verification Value	TCCRC
117	DESCRIPTION	☐	VTEXT	TEXT20	CHAR	20	0	Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BIL_S_PRT_PAYMENT_CARDS	CCACT	SKA1	SAKNR		1	CN
2	BIL_S_PRT_PAYMENT_CARDS	CCINS	TVCIN	CCINS
3	BIL_S_PRT_PAYMENT_CARDS	CCTYP	TVCTY	CCTYP	REF	1	CN
4	BIL_S_PRT_PAYMENT_CARDS	CCWAE	TCURC	WAERS
5	BIL_S_PRT_PAYMENT_CARDS	FAKCA	TFACD	IDENT
6	BIL_S_PRT_PAYMENT_CARDS	FAKSP	TVFS	FAKSP	REF	C	CN
7	BIL_S_PRT_PAYMENT_CARDS	FKARV	TVFK	FKART	REF	C	CN
8	BIL_S_PRT_PAYMENT_CARDS	FPTTP	TFPLT	FPTTP	REF	1	CN
9	BIL_S_PRT_PAYMENT_CARDS	KUNRG	KNA1	KUNNR	REF	C	CN
10	BIL_S_PRT_PAYMENT_CARDS	LOCID	TCCL	LOCID	REF	C	CN
11	BIL_S_PRT_PAYMENT_CARDS	MANDT	T000	MANDT	KEY	1	CN
12	BIL_S_PRT_PAYMENT_CARDS	MERCH	TCCM	MERCH
13	BIL_S_PRT_PAYMENT_CARDS	MLBEZ	T433	MLSTN	REF	C	CN
14	BIL_S_PRT_PAYMENT_CARDS	PERIO	TVRG	REGEL	REF	C	CN
15	BIL_S_PRT_PAYMENT_CARDS	RCAVA	TCCRC	RCODE	REF	1	CN
16	BIL_S_PRT_PAYMENT_CARDS	RCAVR	TCCRC	RCODE	REF	1	CN
17	BIL_S_PRT_PAYMENT_CARDS	RCAVZ	TCCRC	RCODE	REF	1	CN
18	BIL_S_PRT_PAYMENT_CARDS	RCCVV	TCCRC	RCODE
19	BIL_S_PRT_PAYMENT_CARDS	RCRSP	TCCRC	RCODE	REF	1	CN
20	BIL_S_PRT_PAYMENT_CARDS	TETXT	TVTB	TETBE	REF	1	CN
21	BIL_S_PRT_PAYMENT_CARDS	UELNR	FPLA	FPLNR	REF	1	CN
22	BIL_S_PRT_PAYMENT_CARDS	UELTR	FPLT	FPLTR	REF	1	CN
23	BIL_S_PRT_PAYMENT_CARDS	UELTR_A	FPLT	FPLTR	REF	1	C
24	BIL_S_PRT_PAYMENT_CARDS	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in