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 | |||
|---|---|---|---|---|---|---|---|---|
| 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 | CCLOCK | TVCLK | Block reason (payment card) | CCLOCK |
| VCNUM | CCLOCK | VCNUM | MANDT | TVCLK | Block reason (payment card) | MANDT |
| VCNUM | CCTYP | VCNUM | MANDT | TVCTY | Payment card category | MANDT |
| VCNUM | CCTYP | VCNUM | CCTYP | TVCTY | Payment card category | CCTYP |
| VCNUM | MANDT | VCNUM | MANDT | T000 | Clients | MANDT |
