FPLTC

Payment cards: Transaction data - SD | #transactional | Component: Payment Cards
Column Name Description
MANDT FK Client
FPLNR FK Billing plan number / invoicing plan number
FPLTR FK Item for billing plan/invoice plan/payment cards
Column Name Description
💲 Currency Key (CCWAE):
AUTWR Payment cards: Authorized amount
AUTWV Payment cards: Amount to be authorized
💲 Currency Key (BKPF.WAERS):
PAYMENT_AMOUNT Amount in document currency
Column Name Description
Column Name Description
_DATAAGING Data Filter Value for Data Aging
DATAB Payment cards: Valid from
DATBI Payment Cards: Valid To
AUDAT Payment cards: Authorization date
AUTIM Payment cards: Authorization time
Column Name Description
CSOUR Payment cards: Entry mode Show values
SETTL Payment cards: Settlement carried out Show values
CCAUA Payment cards: Authorization type Show values
CCALL Payment cards: Status when external system is called? Show values
REACT Payment cards: Response to authorization checks Show values
CCOLD Payment cards: Authorization has expired Show values
CCVAL Payment cards: Amount changed Show values
CCPRE Payment cards: Preauthorization Show values
COPIED_FOR_CREDIT Entry Copied from Sales Process to Credit Memos/Returns Show values
Column Name Description Domain name
CCFOL Payment cards: Payment card suffix CHAR10
CCNAME Payment cards: Name of cardholder TEXT40
AUNUM Payment cards: Authorization number CHAR10
AUTRA Payment cards: Authorizat. reference code of clearing house CHAR15
TRMID Payment cards: Terminal CHAR10
CCBTC Payment cards: Settlement run CCBTC
CCARD_GUID Reference to Encrypted Payment Card Data SYSUUID_C
DP_TOKEN Token for Digital Payment Integration in SD CCNUM
DP_PSP Payment Service Provider for Digital Payments DP_PAYMENT_SERVICE_PROVIDER
DP_PAYID Digital Payments: Payment ID from Payment Service Provider DP_PAYID
DP_PSP_TRANSID SAP Digital Payments: Transaction ID of PSP DP_PSP_TRANS_ID
DP_TRANS_ID Transaction/Payment ID of SAP Digital Payments DP_TRANSID
DP_MERCHANT_ALIAS SAP Digital Payments Add-On: Merchant Alias DP_MERCHANT_ALIAS
DP_AUTH_REL_ID Unique identifier of a previous successful authorization FAR_DP_AUTH_REL_ID
DP_FRAUD_RISK Code of Fraud Risk DP_FRAUD_RISK_CODE
RTEXT Payment cards: Result text TXT40
Master Data Relations Join Conditions
Payment cards: Card type
  • FPLTC.MANDT == TVCIN.MANDT
  • FPLTC.CCINS == TVCIN.CCINS
Payment cards: Card category
  • FPLTC.MANDT == TVCTY.MANDT
  • FPLTC.CCTYP == TVCTY.CCTYP
Currency Key
  • FPLTC.MANDT == TCURC.MANDT
  • FPLTC.CCWAE == TCURC.WAERS
Payment cards: Point of receipt for the transaction
  • FPLTC.MANDT == TCCL.MANDT
  • FPLTC.LOCID == TCCL.LOCID
Client FPLTC.MANDT == T000.MANDT
Payment cards: Merchant ID at the clearing house
  • FPLTC.MANDT == TCCM.MANDT
  • FPLTC.MERCH == TCCM.MERCH
Payment Cards: Result of Address Check (Address Approval)
  • Payment Cards: Result of Address Check (Address Approval)
  • ?
  • Client
  • FPLTC.RCAVA == TCCRC.RCODE
  • FPLTC.[column in domain "RCATG_CC"] == TCCRC.RCATG
  • FPLTC.MANDT == TCCRC.MANDT
Payment Cards: Result of Address Check (Address Result)
  • Payment Cards: Result of Address Check (Address Result)
  • ?
  • Client
  • FPLTC.RCAVR == TCCRC.RCODE
  • FPLTC.[column in domain "RCATG_CC"] == TCCRC.RCATG
  • FPLTC.MANDT == TCCRC.MANDT
Payment Cards: Result of Address Check (ZIP Code Result)
  • Payment Cards: Result of Address Check (ZIP Code Result)
  • ?
  • Client
  • FPLTC.RCAVZ == TCCRC.RCODE
  • FPLTC.[column in domain "RCATG_CC"] == TCCRC.RCATG
  • FPLTC.MANDT == TCCRC.MANDT
Payment cards: Result of card check (response code)
  • Payment cards: Result of card check (response code)
  • ?
  • Client
  • FPLTC.RCRSP == TCCRC.RCODE
  • FPLTC.[column in domain "RCATG_CC"] == TCCRC.RCATG
  • FPLTC.MANDT == TCCRC.MANDT