FPLTC - Payment cards: Transaction data - SD
Payment cards: Transaction data - SD information is stored in SAP table FPLTC.
It is part of development package VFC in software component SD-BIL-IV-PC. This development package consists of objects that can be grouped under "Application development R/3 billing docs.: Payment cards".
It is part of development package VFC in software component SD-BIL-IV-PC. This development package consists of objects that can be grouped under "Application development R/3 billing docs.: Payment cards".
Fields for table FPLTC
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| FPLNR | Billing plan number / invoicing plan number | X | FPLNR | CHAR | 20 | FPLA |
| FPLTR | Item for billing plan/invoice plan/payment cards | X | FPLTR | NUMC | 12 | FPLT |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 | ||
| .INCLUDE | CCDATA | 0 | ||||
| CCINS | Payment cards: Card type | CCINS | CHAR | 8 | TVCIN | |
| CCNUM | Payment cards: Card number | CCNUM | CHAR | 50 | * | |
| CCFOL | Payment cards: Payment card suffix | CCFOL | CHAR | 20 | ||
| DATAB | Payment cards: Valid from | DATAB_CC | DATS | 16 | ||
| DATBI | Payment Cards: Valid To | DATBI_CC | DATS | 16 | ||
| CCNAME | Payment cards: Name of cardholder | CCNAME | CHAR | 80 | ||
| CSOUR | Payment cards: Entry mode | CSOUR | CHAR | 2 | ||
| AUTWR | Payment cards: Authorized amount | AUTWR | CURR | 8 | ||
| CCWAE | Currency Key | WAERS | CUKY | 10 | TCURC | |
| SETTL | Payment cards: Settlement carried out | SETTL | CHAR | 2 | ||
| AUNUM | Payment cards: Authorization number | AUNUM | CHAR | 20 | ||
| AUTRA | Payment cards: Authorizat. reference code of clearing house | AUTRA | CHAR | 30 | ||
| AUDAT | Payment cards: Authorization date | AUDAT_CC | DATS | 16 | ||
| AUTIM | Payment cards: Authorization time | AUTIM | TIMS | 12 | ||
| MERCH | Payment cards: Merchant ID at the clearing house | MERCH | CHAR | 30 | TCCM | |
| LOCID | Payment cards: Point of receipt for the transaction | LOCID_CC | CHAR | 20 | TCCL | |
| TRMID | Payment cards: Terminal | TRMID | CHAR | 20 | ||
| CCBTC | Payment cards: Settlement run | CCBTC | CHAR | 20 | ||
| CCTYP | Payment cards: Card category | CCTYP | CHAR | 4 | TVCTY | |
| CCARD_GUID | Reference to Encrypted Payment Card Data | CCARDEC_GUID | CHAR | 64 | ||
| PAYMENT_AMOUNT | Amount in document currency | WRBTR | CURR | 12 | ||
| DP_TOKEN | Token for Digital Payment Integration in SD | DP_TOKEN | CHAR | 50 | * | |
| DP_PSP | Payment Service Provider for Digital Payments | DP_PAYMENT_SERVICE_PROVIDER | CHAR | 8 | ||
| DP_PAYID | Digital Payments: Payment ID from Payment Service Provider | DP_PAYID | CHAR | 80 | ||
| DP_PSP_TRANSID | SAP Digital Payments: Transaction ID of PSP | DP_PSP_TRANS_ID | CHAR | 80 | ||
| DP_TRANS_ID | Transaction/Payment ID of SAP Digital Payments | DP_TRANSID | CHAR | 88 | ||
| DP_MERCHANT_ALIAS | SAP Digital Payments Add-On: Merchant Alias | DP_MERCHANT_ALIAS | CHAR | 30 | ||
| DP_AUTH_REL_ID | Unique identifier of a previous successful authorization | FAR_DP_AUTH_REL_ID | CHAR | 88 | ||
| DP_FRAUD_RISK | Code of Fraud Risk | DP_FRAUD_RISK_CODE | CHAR | 30 | ||
| .INCLUDE | CCDATS | 0 | ||||
| CCAUA | Payment cards: Authorization type | CCAUA | CHAR | 2 | ||
| CCALL | Payment cards: Status when external system is called? | CCALL | CHAR | 2 | ||
| REACT | Payment cards: Response to authorization checks | REACT_SD | CHAR | 2 | ||
| AUTWV | Payment cards: Amount to be authorized | AUTWV | CURR | 8 | ||
| CCOLD | Payment cards: Authorization has expired | CCOLD | CHAR | 2 | ||
| CCVAL | Payment cards: Amount changed | CCVAL | CHAR | 2 | ||
| CCPRE | Payment cards: Preauthorization | CCPRE | CHAR | 2 | ||
| UELTR_A | Higher-level authorization for billing plan | UELTR_A | NUMC | 12 | FPLT | |
| COPIED_FOR_CREDIT | Entry Copied from Sales Process to Credit Memos/Returns | COPIED_FOR_CREDIT | CHAR | 2 | ||
| .INCLUDE | CCRCODES | 0 | ||||
| RCAVR | Payment Cards: Result of Address Check (Address Result) | RCAVR_CC | CHAR | 8 | TCCRC | |
| RCAVA | Payment Cards: Result of Address Check (Address Approval) | RCAVA_CC | CHAR | 8 | TCCRC | |
| RCAVZ | Payment Cards: Result of Address Check (ZIP Code Result) | RCAVZ_CC | CHAR | 8 | TCCRC | |
| RCRSP | Payment cards: Result of card check (response code) | RCRSP_CC | CHAR | 8 | TCCRC | |
| RTEXT | Payment cards: Result text | RTEXT_CC | CHAR | 80 |