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
⤷ 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 |