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 |
Possible values
|
||||||
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 |