SAP CRNUM Payment cards: Card master record Table data and field list

CRNUM is a standard SAP Table which is used to store Payment cards: Card master record data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CRNUM table consists of various fields, each holding specific information or linking keys about Payment cards: Card master record data available in SAP. These include CCINS (Payment cards: Card type), CCNUM (Payment cards: Card number), CCNAME (Payment cards: Name of cardholder), DATAB (Payment cards: Valid from)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CRNUM table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP CRNUM table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CRNUM table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
CCINS	Payment cards: Card type	CCINS_30F	CHAR	4	TCRIN		CCINS_30F	CIN
CCNUM	Payment cards: Card number	CCNUM_30F	CHAR	25			CCNUM_30F	CNO
CCNAME	Payment cards: Name of cardholder	CCNAME_30F	CHAR	40			CHAR40
DATAB	Payment cards: Valid from	DATAB_CR	DATS	8			DATUM
DATBI	Payment cards: Valid through	DATBI_CR	DATS	8			DATUM
CCTYP	Payment cards: Card category	CCTYP_30F	CHAR	2			CHAR2
.INCLU--AP				0
CRDISABLED	Payment Cards: Invalid	CRDISABLED	CHAR	1			XFELD
CRDISDAT	Payment Cards: Invalid From	CRDISDAT	DATS	8			DATUM
CRLOEVM	Payment Cards: Central Deletion Indicator for Master Record	CRLOEVM	CHAR	1			XFELD
CRCLASS	Payment Cards: Main Card	CRCLASS	CHAR	1			CRCLASS
CRDSCODE	Payment Cards: Selection Code	CRDSCODE	CHAR	20	Assigned to domain		CRDSCODE	CSC
CRCREATDT	Payment Cards: Creation Date of Master Record	CRCREATDT	DATS	8			DATUM
CRCREATUS	Payment Cards: Created By	CRCREATUS	CHAR	12			USNAM
CRLIMIT	Payment Cards: Credit Limit	CRLIMIT	CURR	15(2)			WERT8
CRFIPARKBT	Payment Cards: Amount Limit for Parked Documents	CRFIPARK	CURR	15(2)			WERT8
CRWORKFLOW	Payment Cards: Determine Document Entry and Workflow Type	CRWORKFLOW	CHAR	1			CRWORKFLOW
CRFIWFBT	Payment Cards: Amount from which Workflow Started	CRFIWFBT	CURR	15(2)			WERT8
OTYPE	Payment Cards: Cardholder Type	CROTYPE	CHAR	2			FMOTYPE
OBJID	Payment Cards: Cardholder ID	CROBJID	CHAR	12			CHAR12
WFOTYPE	Payment Cards: Processor Type	WFCROTYPE	CHAR	2			FMOTYPE
WFOBJID	Payment Cards: Processor ID	WFCROBJID	CHAR	12			CHAR12
BEGRU	Authorization Group	BRGRU	CHAR	4	Assigned to domain		BRGRU
CRLIFNRKZ	Payment Cards: Vendor Control for FI Document	CRLIFNRKZ	CHAR	1			CRLIFNRKZ
CRVOUCHER	Payments Cards: Posting with Reduction of Card Document	CRVOUCHER	CHAR	1			CRVOUCHER
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
CRLIFNR	Payment Cards: Vendor	CRLIFNR	CHAR	10	LFA1	ALPHA	LIFNR	LIF
CRMWSKZ	Tax on sales/purchases code	MWSKZ	CHAR	2	T007A		MWSKZ
MWSKZ_FREE	Tax on Sales/Purchases Code for Non-Tax-Relevant Transaction	MWSKZ_FREE	CHAR	2	T007A		MWSKZ
CRTXJCD	Tax Jurisdiction	TXJCD	CHAR	15	TTXJ		TXJCD	TXJ
CALCTAX	Payment Cards: Calculate Tax	CRCALCTAX	CHAR	1			XFELD	XTX
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
HWAER	Local Currency	HWAER	CUKY	5	TCURC		WAERS
FIKRS	Financial Management Area	FIKRS	CHAR	4	FM01		FIKRS	FIK
KOKRS	Controlling Area	KOKRS	CHAR	4	TKA01		CACCD	CAC
BLART	Document Type	BLART	CHAR	2	T003		BLART	BAR
SAKNR	G/L Account Number	SAKNR	CHAR	10	SKA1	ALPHA	SAKNR	SAK	C_SAKNR
KBLNR	Document Number for Earmarked Funds	KBLNR_FI	CHAR	10	Assigned to domain	ALPHA	KBLNR	KBL
KBLPOS	Earmarked Funds: Document Item	KBLPOS	NUMC	3	Assigned to domain		KBLPOS	KBP
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
AUFNR	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
PERNR	Personnel Number	PERNR_D	NUMC	8			PERNR	PER
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10	LFA1	ALPHA	LIFNR	LIF	KRED_C
FIPOS	Commitment item	FIPOS_XPO	CHAR	14	Assigned to domain	FMCIS	FIPOS	FIP
FISTL	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
GEBER	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
FKBER	Functional Area	FM_FAREA	CHAR	16	TFKB		FKBER	FBE
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	Assigned to domain	KONPR	PS_POSNR
NPLNR	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
FIPEX	Commitment Item	FM_FIPEX	CHAR	24	Assigned to domain		FM_FIPEX	FPS
BUDGET_PD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER

Key field

Non-key field

< CRM_WST_EXCEL_STRUC - Structure for excel export CRNUM_KONT - Credit Card Master Record: Default Account Assignments >

How do I retrieve data from SAP table CRNUM using ABAP code

The following ABAP code Example will allow you to do a basic selection on CRNUM to SELECT all data from the table
DATA: WA_CRNUM TYPE CRNUM.

SELECT SINGLE *
FROM CRNUM
INTO CORRESPONDING FIELDS OF WA_CRNUM
WHERE...

How to access SAP table CRNUM

Within an ECC or HANA version of SAP you can also view further information about CRNUM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).