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 |