DFKKOPC

Transparent Table Application Table
48 Fields 1 CDS Views

Card Data Supplement for Business Partner Item

DFKKOPC is an SAP database table in S/4HANA. Card Data Supplement for Business Partner Item. It contains 48 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CADocumentBPItemPaymentData view from BASIC Document BP Item Payment Data

Fields (48)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY opbel OPBEL_KK Document Number
KEY pygrp PYGRP_KK Pymt Grouping
ccins CC_INSTITUTE Card type
ccnum CCNUM Card number
ccfol CCFOL Suffix
datab CC_DATAB Valid from
datbi CC_DATBI Valid To
ccname CCNAME Cardholder
aunum AUNUM_KK AuthorizationNo
autra AUTRA_KK Auth. Ref. No.
audat AUDAT_CC Auth. Date
autim AUTIM Auth. Time
auart AUART_KK AuthType
autwr AUTWR Authorized Amt
ccwae WAERS Currency
merch MERCH Merchant ID
expdt EXPDT_KK Expiration Date
exptm EXPTM_KK Auth. Exp. Time
extmp EXTMP_KK Time Stamp
autmp AUTMP_KK Auth. Timestamp
aucid AUCID_KK Payment ID
avref AVREF_KK Pymt Adv. Note Ref.
dp_auth_rel_id FAR_DP_AUTH_REL_ID Auth. Rel. ID
dp_fraud_risk DP_FRAUD_RISK_CODE Fraud Risk Code
cvval CVVAL_KK CVC Number
cvvct CVVCT_KK Cont.Field CVV
cvvst CVVST_KK CVC Usage
cguid CARD_GUID GUID of a Payment Card
enctp CCSECA_ENCTYPE Encryption Type
xguid XGUID_PC_KK Pmt Card Suppl.
srqid SRQID_KK Billing ID
opbel_ori OPBEL_KK Document Number
pays_prov PSPID_KK Payt Service Prov.
pays_tran FPS_TRANSACTION PSP Payment Ref.
orig_pays_tran FPS_TRANSACTION PSP Payment Ref.
orig_credit ORIG_CREDIT_KK Origin
_dataaging DATA_TEMPERATURE Data Aging
masked_id DP_MASK_NUMBER Card Number
iban IBAN IBAN
swift SWIFT SWIFT/BIC
koinh_ip BU_KOINH Account Holder
txtvw TXTVW_KK Usage Text
meref_ip MEREF_IP Merchant Alias
bkref_ip BKREF_IP Bank Reference
pyref_ip PYREF_IP Payment Reference
dp_payment_type DP_PAYMENT_TYPE Payment Type
dp_trans_id DP_TRANSID Transaction/Payt ID

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.

-- Card Data Supplement for Business Partner Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKOPC (
    MANDT,            -- Client [MANDT]
    OPBEL,            -- Document Number [OPBEL_KK]
    PYGRP,            -- Pymt Grouping [PYGRP_KK]
    CCINS,            -- Card type [CC_INSTITUTE]
    CCNUM,            -- Card number [CCNUM]
    CCFOL,            -- Suffix [CCFOL]
    DATAB,            -- Valid from [CC_DATAB]
    DATBI,            -- Valid To [CC_DATBI]
    CCNAME,           -- Cardholder [CCNAME]
    AUNUM,            -- AuthorizationNo [AUNUM_KK]
    AUTRA,            -- Auth. Ref. No. [AUTRA_KK]
    AUDAT,            -- Auth. Date [AUDAT_CC]
    AUTIM,            -- Auth. Time [AUTIM]
    AUART,            -- AuthType [AUART_KK]
    AUTWR,            -- Authorized Amt [AUTWR]
    CCWAE,            -- Currency [WAERS]
    MERCH,            -- Merchant ID [MERCH]
    EXPDT,            -- Expiration Date [EXPDT_KK]
    EXPTM,            -- Auth. Exp. Time [EXPTM_KK]
    EXTMP,            -- Time Stamp [EXTMP_KK]
    AUTMP,            -- Auth. Timestamp [AUTMP_KK]
    AUCID,            -- Payment ID [AUCID_KK]
    AVREF,            -- Pymt Adv. Note Ref. [AVREF_KK]
    DP_AUTH_REL_ID,   -- Auth. Rel. ID [FAR_DP_AUTH_REL_ID]
    DP_FRAUD_RISK,    -- Fraud Risk Code [DP_FRAUD_RISK_CODE]
    CVVAL,            -- CVC Number [CVVAL_KK]
    CVVCT,            -- Cont.Field CVV [CVVCT_KK]
    CVVST,            -- CVC Usage [CVVST_KK]
    CGUID,            -- GUID of a Payment Card [CARD_GUID]
    ENCTP,            -- Encryption Type [CCSECA_ENCTYPE]
    XGUID,            -- Pmt Card Suppl. [XGUID_PC_KK]
    SRQID,            -- Billing ID [SRQID_KK]
    OPBEL_ORI,        -- Document Number [OPBEL_KK]
    PAYS_PROV,        -- Payt Service Prov. [PSPID_KK]
    PAYS_TRAN,        -- PSP Payment Ref. [FPS_TRANSACTION]
    ORIG_PAYS_TRAN,   -- PSP Payment Ref. [FPS_TRANSACTION]
    ORIG_CREDIT,      -- Origin [ORIG_CREDIT_KK]
    _DATAAGING,       -- Data Aging [DATA_TEMPERATURE]
    MASKED_ID,        -- Card Number [DP_MASK_NUMBER]
    IBAN,             -- IBAN [IBAN]
    SWIFT,            -- SWIFT/BIC [SWIFT]
    KOINH_IP,         -- Account Holder [BU_KOINH]
    TXTVW,            -- Usage Text [TXTVW_KK]
    MEREF_IP,         -- Merchant Alias [MEREF_IP]
    BKREF_IP,         -- Bank Reference [BKREF_IP]
    PYREF_IP,         -- Payment Reference [PYREF_IP]
    DP_PAYMENT_TYPE,  -- Payment Type [DP_PAYMENT_TYPE]
    DP_TRANS_ID,      -- Transaction/Payt ID [DP_TRANSID]
    PRIMARY KEY (MANDT, OPBEL, PYGRP)
);

Learn More