SAP ABAP Table CRNUM (Payment cards: Card master record)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-AP-AP-PT (Application Component) Payment Transactions
     ⤷ FCRD (Package) Payment Card

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRNUM	Table Relationship Diagram
Short Description	Payment cards: Card master record

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	CCINS	☑	CCINS_30F	CCINS_30F	CHAR	4	0	Payment cards: Card type	TCRIN
3	CCNUM	☑	CCNUM_30F	CCNUM_30F	CHAR	25	0	Payment cards: Card number
4	CCNAME	☐	CCNAME_30F	CHAR40	CHAR	40	0	Payment cards: Name of cardholder
5	DATAB	☐	DATAB_CR	DATUM	DATS	8	0	Payment cards: Valid from
6	DATBI	☐	DATBI_CR	DATUM	DATS	8	0	Payment cards: Valid through
7	CCTYP	☐	CCTYP_30F	CHAR2	CHAR	2	0	Payment cards: Card category
8	.INCLU--AP	☐				0	0	Append for CRNUM
9	CRDISABLED	☐	CRDISABLED	XFELD	CHAR	1	0	Payment Cards: Invalid
10	CRDISDAT	☐	CRDISDAT	DATUM	DATS	8	0	Payment Cards: Invalid From
11	CRLOEVM	☐	CRLOEVM	XFELD	CHAR	1	0	Payment Cards: Central Deletion Indicator for Master Record
12	CRCLASS	☐	CRCLASS	CRCLASS	CHAR	1	0	Payment Cards: Main Card
13	CRDSCODE	☐	CRDSCODE	CRDSCODE	CHAR	20	0	Payment Cards: Selection Code	*
14	CRCREATDT	☐	CRCREATDT	DATUM	DATS	8	0	Payment Cards: Creation Date of Master Record
15	CRCREATUS	☐	CRCREATUS	USNAM	CHAR	12	0	Payment Cards: Created By
16	CRLIMIT	☐	CRLIMIT	WERT8	CURR	15	2	Payment Cards: Credit Limit
17	CRFIPARKBT	☐	CRFIPARK	WERT8	CURR	15	2	Payment Cards: Amount Limit for Parked Documents
18	CRWORKFLOW	☐	CRWORKFLOW	CRWORKFLOW	CHAR	1	0	Payment Cards: Determine Document Entry and Workflow Type
19	CRFIWFBT	☐	CRFIWFBT	WERT8	CURR	15	2	Payment Cards: Amount from which Workflow Started
20	OTYPE	☐	CROTYPE	FMOTYPE	CHAR	2	0	Payment Cards: Cardholder Type
21	OBJID	☐	CROBJID	CHAR12	CHAR	12	0	Payment Cards: Cardholder ID
22	WFOTYPE	☐	WFCROTYPE	FMOTYPE	CHAR	2	0	Payment Cards: Processor Type
23	WFOBJID	☐	WFCROBJID	CHAR12	CHAR	12	0	Payment Cards: Processor ID
24	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
25	CRLIFNRKZ	☐	CRLIFNRKZ	CRLIFNRKZ	CHAR	1	0	Payment Cards: Vendor Control for FI Document
26	CRVOUCHER	☐	CRVOUCHER	CRVOUCHER	CHAR	1	0	Payments Cards: Posting with Reduction of Card Document
27	.INCLUDE	☐				0	0	Credit Card Master Record: Default Account Assignments
28	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
29	CRLIFNR	☐	CRLIFNR	LIFNR	CHAR	10	0	Payment Cards: Vendor	LFA1
30	CRMWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
31	MWSKZ_FREE	☐	MWSKZ_FREE	MWSKZ	CHAR	2	0	Tax on Sales/Purchases Code for Non-Tax-Relevant Transaction	T007A
32	CRTXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
33	CALCTAX	☐	CRCALCTAX	XFELD	CHAR	1	0	Payment Cards: Calculate Tax
34	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
35	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
36	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
37	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
38	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
39	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
40	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
41	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
42	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
43	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
44	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
45	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
46	FIPOS	☐	FIPOS_XPO	FIPOS	CHAR	14	0	Commitment item	*
47	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
48	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
49	FKBER	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	TFKB
50	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
51	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
52	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
53	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
54	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
55	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRNUM	BLART	T003	BLART
2	CRNUM	BUKRS	T001	BUKRS
3	CRNUM	CCINS	TCRIN	CCINS
4	CRNUM	CRLIFNR	LFA1	LIFNR
5	CRNUM	CRMWSKZ	T007A	MWSKZ
6	CRNUM	CRTXJCD	TTXJ	TXJCD
7	CRNUM	FIKRS	FM01	FIKRS
8	CRNUM	FKBER	TFKB	FKBER
9	CRNUM	HWAER	TCURC	WAERS
10	CRNUM	KOKRS	TKA01	KOKRS
11	CRNUM	LIFNR	LFA1	LIFNR
12	CRNUM	MWSKZ_FREE	T007A	MWSKZ
13	CRNUM	SAKNR	SKA1	SAKNR

History

Last changed by/on	SAP	20130529
SAP Release Created in