SAP Table VCNUM
Credit card master
VCNUM (Credit card master) 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 VCNUM to other SAP tables.
VCNUM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
CCINS
Payment cards: Card type
|
CCINS | TVCIN |
CHAR
|
4 | 0 | |
|
CCNUM
Payment cards: Card number
|
CCNUM |
CHAR
|
25 | 0 | ||
|
CCNAME
Payment cards: Name of cardholder
|
CCNAME |
CHAR
|
40 | 0 | ||
|
DATAB
Payment cards: Valid from
|
DATAB_CC |
DATS
|
8 | 0 | ||
|
DATBI
Payment Cards: Valid To
|
DATBI_CC |
DATS
|
8 | 0 | ||
|
CCTYP
Payment cards: Card category
|
CCTYP | TVCTY |
CHAR
|
2 | 0 | |
|
CCLOCK
Payment cards: Reason for payment card block
|
CCLOCK | TVCLK |
CHAR
|
2 | 0 | |
|
ISSBANK
Payment cards: Issuing bank
|
CC_ISSBANK |
CHAR
|
40 | 0 | ||
|
AUSGDAT
Payment Cards: Date of Issue
|
CC_AUSGDAT |
DATS
|
8 | 0 | ||
|
CCNUM_MASK
Payment cards: Card number
|
CCNUM |
CHAR
|
25 | 0 | ||
|
CCARD_GUID
Reference to Encrypted Payment Card Data
|
CCARDEC_GUID |
CHAR
|
32 | 0 | ||
|
CCARD_ID
Payment Card ID
|
BU_CCID |
CHAR
|
6 | 0 | ||
|
CCACCNAME
Description of Credit Card Details
|
BU_CREDITCNAME |
CHAR
|
40 | 0 |
VCNUM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| VCNUM | CCINS | VCNUM | MANDT |
TVCIN
Payment cards: Type
|
MANDT |
| VCNUM | CCINS | VCNUM | CCINS |
TVCIN
Payment cards: Type
|
CCINS |
| VCNUM | CCLOCK | VCNUM | MANDT |
TVCLK
Block reason (payment card)
|
MANDT |
| VCNUM | CCLOCK | VCNUM | CCLOCK |
TVCLK
Block reason (payment card)
|
CCLOCK |
| VCNUM | CCTYP | VCNUM | CCTYP |
TVCTY
Payment card category
|
CCTYP |
| VCNUM | CCTYP | VCNUM | MANDT |
TVCTY
Payment card category
|
MANDT |
| VCNUM | MANDT | VCNUM | MANDT |
T000
Clients
|
MANDT |