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