SAP Table CRACC

Payment Cards: Account Assignments in Card Master Record

CRACC (Payment Cards: Account Assignments in Card Master Record) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CRACC to other SAP tables.

CRACC table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
CCINS Payment cards: Card type CCINS_30F TCRIN CHAR 4 0
CCNUM Payment cards: Card number CCNUM_30F CHAR 25 0
DATAB_ACC Valid-From Date DATAB DATS 8 0
GJAHR Fiscal Year GJAHR NUMC 4 0
CRLIFNR Payment Cards: Vendor CRLIFNR LFA1 CHAR 10 0
CRMWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
MWSKZ_FREE Tax on Sales/Purchases Code for Non-Tax-Relevant Transaction MWSKZ_FREE T007A CHAR 2 0
CRTXJCD Tax Jurisdiction TXJCD TTXJ CHAR 15 0
CALCTAX Payment Cards: Calculate Tax CRCALCTAX CHAR 1 0
X Yes
NULL No
BUKRS Company Code BUKRS T001 CHAR 4 0
HWAER Local Currency HWAER TCURC CUKY 5 0
FIKRS Financial Management Area FIKRS FM01 CHAR 4 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
BLART Document Type BLART T003 CHAR 2 0
SAKNR G/L Account Number SAKNR SKA1 CHAR 10 0
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
KOSTL Cost Center KOSTL CHAR 10 0
AUFNR Order Number AUFNR CHAR 12 0
PERNR Personnel Number PERNR_D NUMC 8 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
FIPOS Commitment item FIPOS_XPO CHAR 14 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
FKBER Functional Area FM_FAREA TFKB CHAR 16 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
FIPEX Commitment Item FM_FIPEX CHAR 24 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0

CRACC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CRACC BLART SYST MANDT T003 Document Types MANDT
CRACC BLART CRACC BLART T003 Document Types BLART
CRACC BUKRS CRACC BUKRS T001 Company Codes BUKRS
CRACC BUKRS SYST MANDT T001 Company Codes MANDT
CRACC CCINS CRACC MANDT TCRIN Payment Cards: Card Types MANDT
CRACC CCINS CRACC CCINS TCRIN Payment Cards: Card Types CCINS
CRACC CRLIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
CRACC CRLIFNR CRACC CRLIFNR LFA1 Vendor Master (General Section) LIFNR
CRACC CRMWSKZ CRNUM MANDT T007A Tax Keys MANDT
CRACC CRMWSKZ T005 KALSM T007A Tax Keys KALSM
CRACC CRMWSKZ CRACC CRMWSKZ T007A Tax Keys MWSKZ
CRACC CRTXJCD T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
CRACC CRTXJCD CRACC CRTXJCD TTXJ Check Table for Tax Jurisdiction TXJCD
CRACC CRTXJCD CRNUM MANDT TTXJ Check Table for Tax Jurisdiction MANDT
CRACC FIKRS SYST MANDT FM01 Financial Management Areas MANDT
CRACC FIKRS CRACC FIKRS FM01 Financial Management Areas FIKRS
CRACC FKBER SYST MANDT TFKB Functional areas MANDT
CRACC FKBER CRACC FKBER TFKB Functional areas FKBER
CRACC HWAER SYST MANDT TCURC Currency Codes MANDT
CRACC HWAER CRACC HWAER TCURC Currency Codes WAERS
CRACC KOKRS SYST MANDT TKA01 Controlling Areas MANDT
CRACC KOKRS CRACC KOKRS TKA01 Controlling Areas KOKRS
CRACC LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
CRACC LIFNR CRACC LIFNR LFA1 Vendor Master (General Section) LIFNR
CRACC MWSKZ_FREE T005 KALSM T007A Tax Keys KALSM
CRACC MWSKZ_FREE CRACC MWSKZ_FREE T007A Tax Keys MWSKZ
CRACC MWSKZ_FREE CRNUM MANDT T007A Tax Keys MANDT
CRACC SAKNR SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
CRACC SAKNR T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
CRACC SAKNR CRACC SAKNR SKA1 G/L Account Master (Chart of Accounts) SAKNR
CRACC ZZREGION CRACC ZZREGION ZREG User Defined Regions ZZREGION
CRACC ZZREGION SYST MANDT ZREG User Defined Regions MANDT
CRACC ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
CRACC ZZSPREG CRACC ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
CRACC ZZSTATE CRACC ZZSTATE T005S Taxes: Region (Province) Key BLAND
CRACC ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
CRACC ZZSTATE * T005S Taxes: Region (Province) Key LAND1
CRACC ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
CRACC ZZUSERFLD1 CRACC ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1