The FPLTC table in SAP ERP or S/4HANA stores Payment cards: Transaction data – SD data. There are total 45 fields in FPLTC table. The Payment cards: Transaction data – SD table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FPLTC table. It is in Application development R/3 billing docs.: Payment cards (VFC) ABAP package and is part of the Payment Cards (SD-BIL-IV-PC) module.
SAP FPLTC Table Fields
Following is the list of fields that are available in SAP FPLTC table. The primary key fields of the table are MANDT (Client), FPLNR (Billing plan number / invoicing plan number), FPLTR (Item for billing plan/invoice plan/payment cards).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| FPLNR | Billing plan number / invoicing plan number | FPLNR | FPLA | CHAR (10) |
| FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | FPLT | NUMC (6) |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS (8) | |
| CCINS | Payment cards: Card type | CCINS | TVCIN | CHAR (4) |
| CCNUM | Payment cards: Card number | CCNUM | * | CHAR (25) |
| CCFOL | Payment cards: Payment card suffix | CCFOL | CHAR (10) | |
| DATAB | Payment cards: Valid from | DATAB_CC | DATS (8) | |
| DATBI | Payment Cards: Valid To | DATBI_CC | DATS (8) | |
| CCNAME | Payment cards: Name of cardholder | CCNAME | CHAR (40) | |
| CSOUR | Payment cards: Entry mode | CSOUR | CHAR (1) | |
| AUTWR | Payment cards: Authorized amount | AUTWR | CURR (15) | |
| CCWAE | Currency Key | WAERS | TCURC | CUKY (5) |
| SETTL | Payment cards: Settlement carried out | SETTL | CHAR (1) | |
| AUNUM | Payment cards: Authorization number | AUNUM | CHAR (10) | |
| AUTRA | Payment cards: Authorizat. reference code of clearing house | AUTRA | CHAR (15) | |
| AUDAT | Payment cards: Authorization date | AUDAT_CC | DATS (8) | |
| AUTIM | Payment cards: Authorization time | AUTIM | TIMS (6) | |
| MERCH | Payment cards: Merchant ID at the clearing house | MERCH | TCCM | CHAR (15) |
| LOCID | Payment cards: Point of receipt for the transaction | LOCID_CC | TCCL | CHAR (10) |
| TRMID | Payment cards: Terminal | TRMID | CHAR (10) | |
| CCBTC | Payment cards: Settlement run | CCBTC | CHAR (10) | |
| CCTYP | Payment cards: Card category | CCTYP | TVCTY | CHAR (2) |
| CCARD_GUID | Reference to Encrypted Payment Card Data | CCARDEC_GUID | CHAR (32) | |
| PAYMENT_AMOUNT | Amount in document currency | WRBTR | CURR (23) | |
| DP_TOKEN | Token for Digital Payment Integration in SD | DP_TOKEN | * | CHAR (25) |
| DP_PSP | Payment Service Provider for Digital Payments | DP_PAYMENT_SERVICE_PROVIDER | CHAR (4) | |
| DP_PAYID | Digital Payments: Payment ID from Payment Service Provider | DP_PAYID | CHAR (40) | |
| DP_PSP_TRANSID | SAP Digital Payments: Transaction ID of PSP | DP_PSP_TRANS_ID | CHAR (40) | |
| DP_TRANS_ID | Transaction/Payment ID of SAP Digital Payments | DP_TRANSID | CHAR (44) | |
| DP_MERCHANT_ALIAS | SAP Digital Payments Add-On: Merchant Alias | DP_MERCHANT_ALIAS | CHAR (15) | |
| CCAUA | Payment cards: Authorization type | CCAUA | CHAR (1) | |
| CCALL | Payment cards: Status when external system is called? | CCALL | CHAR (1) | |
| REACT | Payment cards: Response to authorization checks | REACT_SD | CHAR (1) | |
| AUTWV | Payment cards: Amount to be authorized | AUTWV | CURR (15) | |
| CCOLD | Payment cards: Authorization has expired | CCOLD | CHAR (1) | |
| CCVAL | Payment cards: Amount changed | CCVAL | CHAR (1) | |
| CCPRE | Payment cards: Preauthorization | CCPRE | CHAR (1) | |
| UELTR_A | Higher-level authorization for billing plan | UELTR_A | FPLT | NUMC (6) |
| COPIED_FOR_CREDIT | Entry Copied from Sales Process to Credit Memos/Returns | COPIED_FOR_CREDIT | CHAR (1) | |
| RCAVR | Payment Cards: Result of Address Check (Address Result) | RCAVR_CC | TCCRC | CHAR (4) |
| RCAVA | Payment Cards: Result of Address Check (Address Approval) | RCAVA_CC | TCCRC | CHAR (4) |
| RCAVZ | Payment Cards: Result of Address Check (ZIP Code Result) | RCAVZ_CC | TCCRC | CHAR (4) |
| RCRSP | Payment cards: Result of card check (response code) | RCRSP_CC | TCCRC | CHAR (4) |
| RTEXT | Payment cards: Result text | RTEXT_CC | CHAR (40) |
