SAP table CRACC (Payment Cards: Account Assignments in Card Master Record)
SAP table CRACC has 4 primary key fields being MANDT,CCINS,CCNUM,DATAB_ACC.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||
| CCINS | Payment cards: Card type | CHAR | 4 | 0 | TCRIN | CCINS_30F | |
| CCNUM | Payment cards: Card number | CHAR | 25 | 0 | CCNUM_30F | ||
| DATAB_ACC | Valid-From Date | DATS | 8 | 0 | DATAB | ||
| GJAHR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| CRLIFNR | Payment Cards: Vendor | CHAR | 10 | 0 | LFA1 | CRLIFNR | |
| CRMWSKZ | Tax on sales/purchases code | CHAR | 2 | 0 | T007A | MWSKZ | |
| MWSKZ_FREE | Tax on Sales/Purchases Code for Non-Tax-Relevant Transaction | CHAR | 2 | 0 | T007A | MWSKZ_FREE | |
| CRTXJCD | Tax Jurisdiction | CHAR | 15 | 0 | TTXJ | TXJCD | |
| CALCTAX | Payment Cards: Calculate Tax | CHAR | 1 | 0 | CRCALCTAX | ||
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| HWAER | Local Currency | CUKY | 5 | 0 | TCURC | HWAER | |
| FIKRS | Financial Management Area | CHAR | 4 | 0 | FM01 | FIKRS | |
| KOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |
| BLART | Document Type | CHAR | 2 | 0 | T003 | BLART | |
| SAKNR | G/L Account Number | CHAR | 10 | 0 | SKA1 | SAKNR | |
| KBLNR | Document Number for Earmarked Funds | CHAR | 10 | 0 | * | KBLNR_FI | |
| KBLPOS | Earmarked Funds: Document Item | NUMC | 3 | 0 | * | KBLPOS | |
| KOSTL | Cost Center | CHAR | 10 | 0 | * | KOSTL | |
| AUFNR | Order Number | CHAR | 12 | 0 | * | AUFNR | |
| PERNR | Personnel Number | NUMC | 8 | 0 | PERNR_D | ||
| LIFNR | Account Number of Supplier | CHAR | 10 | 0 | LFA1 | LIFNR | |
| FIPOS | Commitment Item | CHAR | 14 | 0 | * | FIPOS_XPO | |
| FISTL | Funds Center | CHAR | 16 | 0 | * | FISTL | |
| GEBER | Fund | CHAR | 10 | 0 | * | BP_GEBER | |
| FKBER | Functional Area | CHAR | 16 | 0 | TFKB | FM_FAREA | |
| GRANT_NBR | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | NUMC | 8 | 0 | * | PS_PSP_PNR | |
| NPLNR | Network Number for Account Assignment | CHAR | 12 | 0 | * | NPLNR | |
| FIPEX | Commitment Item | CHAR | 24 | 0 | * | FM_FIPEX | |
| BUDGET_PD | Budget Period | CHAR | 10 | 0 | * | FM_BUDGET_PERIOD | |
| DUMMY_INCL_EEW_COBL | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY |
CRACC foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 CRACC | BLART | T003 | Document Types | MANDT |
| 1 CRACC | BUKRS | T001 | Company Codes | BUKRS |
| 0 CRACC | CCINS | TCRIN | Payment Cards: Card Types | MANDT |
| 0 CRACC | CCINS | TCRIN | Payment Cards: Card Types | CCINS |
| 1 CRACC | CRLIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 1 CRACC | CRLIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 0 CRACC | CRMWSKZ | T007A | Tax Keys | KALSM |
| 0 CRACC | CRMWSKZ | T007A | Tax Keys | MWSKZ |
| 1 CRACC | CRTXJCD | TTXJ | Check Table for Tax Jurisdiction | MANDT |
| 1 CRACC | CRTXJCD | TTXJ | Check Table for Tax Jurisdiction | KALSM |
| 0 CRACC | FIKRS | FM01 | Financial Management Areas | FIKRS |
| 1 CRACC | FKBER | TFKB | Functional areas | FKBER |
| 0 CRACC | HWAER | TCURC | Currency Codes | MANDT |
| 0 CRACC | HWAER | TCURC | Currency Codes | WAERS |
| 1 CRACC | KOKRS | TKA01 | Controlling Areas | MANDT |
| 0 CRACC | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 0 CRACC | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 1 CRACC | MWSKZ_FREE | T007A | Tax Keys | KALSM |
| 1 CRACC | MWSKZ_FREE | T007A | Tax Keys | MWSKZ |
| 0 CRACC | SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 0 CRACC | SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 0 CRACC | SAKNR | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |