FPLTC

Transparent Table Application Table
48 Fields 2 CDS Views

Payment cards: Transaction data - SD

FPLTC is an SAP database table in S/4HANA. Payment cards: Transaction data - SD. It contains 48 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PaymentPlanItemDetails view from BASIC Payment Plan Item Details
I_SDDocumentPaymentCard view from BASIC SD Document Payment Card

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY fplnr FPLNR Bill. Plan No.
KEY fpltr FPLTR Item
_dataaging DATA_TEMPERATURE Data Aging
ccins CCINS Card type
ccnum CCNUM Card number
ccfol CCFOL Suffix
datab DATAB_CC Valid from
datbi DATBI_CC Exp.date
ccname CCNAME Cardholder
csour CSOUR Entry mode
autwr AUTWR Authorized Amt
ccwae WAERS Currency
settl SETTL Settled
aunum AUNUM Auth. Number
autra AUTRA Auth. Ref. Code
audat AUDAT_CC Auth. Date
autim AUTIM Auth. Time
merch MERCH Merchant ID
locid LOCID_CC PointOfReceipt
trmid TRMID Terminal
ccbtc CCBTC Settlement
cctyp CCTYP Card Category
ccard_guid CCARDEC_GUID Reference to Encrypted Payment Card Data
payment_amount WRBTR Amount
dp_token DP_TOKEN Token
dp_psp DP_PAYMENT_SERVICE_PROVIDER Paymnt Serv. Provid.
dp_payid DP_PAYID Payment ID
dp_psp_transid DP_PSP_TRANS_ID PSP Transaction ID
dp_trans_id DP_TRANSID Transaction/Payt ID
dp_merchant_alias DP_MERCHANT_ALIAS Merchant Alias
dp_auth_rel_id FAR_DP_AUTH_REL_ID Auth. Rel. ID
dp_fraud_risk DP_FRAUD_RISK_CODE Fraud Risk Code
dp_charge_trans_id DP_TRANSID Transaction/Payt ID
ccaua CCAUA Auth. Type
ccall CCALL Call status
react REACT_SD Response
autwv AUTWV Amt to Be Auth.
ccold CCOLD Expired
ccval CCVAL Amount changed
ccpre CCPRE Preauth.
ueltr_a UELTR_A High.-lev.auth.
copied_for_credit COPIED_FOR_CREDIT Entry Copied
rcavr RCAVR_CC Address Result
rcava RCAVA_CC Address Check
rcavz RCAVZ_CC ZIP Code Check
rcrsp RCRSP_CC Card check
rtext RTEXT_CC Text

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Payment cards: Transaction data - SD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FPLTC (
    MANDT,               -- Client [MANDT]
    FPLNR,               -- Bill. Plan No. [FPLNR]
    FPLTR,               -- Item [FPLTR]
    _DATAAGING,          -- Data Aging [DATA_TEMPERATURE]
    CCINS,               -- Card type [CCINS]
    CCNUM,               -- Card number [CCNUM]
    CCFOL,               -- Suffix [CCFOL]
    DATAB,               -- Valid from [DATAB_CC]
    DATBI,               -- Exp.date [DATBI_CC]
    CCNAME,              -- Cardholder [CCNAME]
    CSOUR,               -- Entry mode [CSOUR]
    AUTWR,               -- Authorized Amt [AUTWR]
    CCWAE,               -- Currency [WAERS]
    SETTL,               -- Settled [SETTL]
    AUNUM,               -- Auth. Number [AUNUM]
    AUTRA,               -- Auth. Ref. Code [AUTRA]
    AUDAT,               -- Auth. Date [AUDAT_CC]
    AUTIM,               -- Auth. Time [AUTIM]
    MERCH,               -- Merchant ID [MERCH]
    LOCID,               -- PointOfReceipt [LOCID_CC]
    TRMID,               -- Terminal [TRMID]
    CCBTC,               -- Settlement [CCBTC]
    CCTYP,               -- Card Category [CCTYP]
    CCARD_GUID,          -- Reference to Encrypted Payment Card Data [CCARDEC_GUID]
    PAYMENT_AMOUNT,      -- Amount [WRBTR]
    DP_TOKEN,            -- Token [DP_TOKEN]
    DP_PSP,              -- Paymnt Serv. Provid. [DP_PAYMENT_SERVICE_PROVIDER]
    DP_PAYID,            -- Payment ID [DP_PAYID]
    DP_PSP_TRANSID,      -- PSP Transaction ID [DP_PSP_TRANS_ID]
    DP_TRANS_ID,         -- Transaction/Payt ID [DP_TRANSID]
    DP_MERCHANT_ALIAS,   -- Merchant Alias [DP_MERCHANT_ALIAS]
    DP_AUTH_REL_ID,      -- Auth. Rel. ID [FAR_DP_AUTH_REL_ID]
    DP_FRAUD_RISK,       -- Fraud Risk Code [DP_FRAUD_RISK_CODE]
    DP_CHARGE_TRANS_ID,  -- Transaction/Payt ID [DP_TRANSID]
    CCAUA,               -- Auth. Type [CCAUA]
    CCALL,               -- Call status [CCALL]
    REACT,               -- Response [REACT_SD]
    AUTWV,               -- Amt to Be Auth. [AUTWV]
    CCOLD,               -- Expired [CCOLD]
    CCVAL,               -- Amount changed [CCVAL]
    CCPRE,               -- Preauth. [CCPRE]
    UELTR_A,             -- High.-lev.auth. [UELTR_A]
    COPIED_FOR_CREDIT,   -- Entry Copied [COPIED_FOR_CREDIT]
    RCAVR,               -- Address Result [RCAVR_CC]
    RCAVA,               -- Address Check [RCAVA_CC]
    RCAVZ,               -- ZIP Code Check [RCAVZ_CC]
    RCRSP,               -- Card check [RCRSP_CC]
    RTEXT,               -- Text [RTEXT_CC]
    PRIMARY KEY (MANDT, FPLNR, FPLTR)
);

Learn More