SAP Table CCDATA
Payment cards: Database fields relevant to both SD and FI
CCDATA (Payment cards: Database fields relevant to both SD and FI) 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 CCDATA to other SAP tables.
CCDATA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CCINS | Payment cards: Card type | CCINS | TVCIN | CHAR | 4 | 0 | ||||||
| CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | 0 | |||||||
| CCFOL | Payment cards: Payment card suffix | CCFOL | CHAR | 10 | 0 | |||||||
| DATAB | Payment cards: Valid from | DATAB_CC | DATS | 8 | 0 | |||||||
| DATBI | Payment Cards: Valid To | DATBI_CC | DATS | 8 | 0 | |||||||
| CCNAME | Payment cards: Name of cardholder | CCNAME | CHAR | 40 | 0 | |||||||
| CSOUR | Payment cards: Entry mode | CSOUR | CHAR | 1 | 0 |
Possible values
|
||||||
| AUTWR | Payment cards: Authorized amount | AUTWR | CURR | 15 | 2 | |||||||
| CCWAE | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| SETTL | Payment cards: Settlement carried out | SETTL | CHAR | 1 | 0 |
Possible values
|
||||||
| AUNUM | Payment cards: Authorization number | AUNUM | CHAR | 10 | 0 | |||||||
| AUTRA | Payment cards: Authoriz. reference code of clearing house | AUTRA | CHAR | 15 | 0 | |||||||
| AUDAT | Payment cards: Authorization date | AUDAT_CC | DATS | 8 | 0 | |||||||
| AUTIM | Payment cards: Authorization time | AUTIM | TIMS | 6 | 0 | |||||||
| MERCH | Payment cards: Merchant ID at the clearing house | MERCH | TCCM | CHAR | 15 | 0 | ||||||
| LOCID | Payment cards: Point of receipt for the transaction | LOCID_CC | TCCL | CHAR | 10 | 0 | ||||||
| TRMID | Payment cards: Terminal | TRMID | CHAR | 10 | 0 | |||||||
| CCBTC | Payment cards: Settlement run | CCBTC | CHAR | 10 | 0 | |||||||
| CCTYP | Payment cards: Card category | CCTYP | TVCTY | CHAR | 2 | 0 | ||||||
| CCARD_GUID | Reference to Encrypted Payment Card Data | CCARDEC_GUID | CHAR | 32 | 0 | |||||||
CCDATA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CCDATA | CCINS | CCDATA | CCINS | TVCIN | Payment cards: Type | CCINS |
| CCDATA | CCINS | SYST | MANDT | TVCIN | Payment cards: Type | MANDT |
| CCDATA | CCTYP | SYST | MANDT | TVCTY | Payment card category | MANDT |
| CCDATA | CCTYP | CCDATA | CCTYP | TVCTY | Payment card category | CCTYP |
| CCDATA | CCWAE | SYST | MANDT | TCURC | Currency Codes | MANDT |
| CCDATA | CCWAE | CCDATA | CCWAE | TCURC | Currency Codes | WAERS |
| CCDATA | LOCID | SYST | MANDT | TCCL | Payment cards: Point of receipt for the transaction | MANDT |
| CCDATA | LOCID | CCDATA | LOCID | TCCL | Payment cards: Point of receipt for the transaction | LOCID |
| CCDATA | MERCH | SYST | MANDT | TCCM | Payment cards: Merchant ID | MANDT |
| CCDATA | MERCH | CCDATA | MERCH | TCCM | Payment cards: Merchant ID | MERCH |
