DFKKOPKC SAP table for – Card Data Appendix for FICA Document

Here we would like to draw your attention to DFKKOPKC table in SAP. As we know it is being mainly used with the SAP FI-CA (Contract Accounts Receivable and Payable in FI) component which is coming under FI module (Financial Accounting). DFKKOPKC is a SAP standard transp table used for storing Card Data Appendix for FICA Document related data in SAP. It comes under the package FKKB.

SAP DFKKOPKC table

Table DFKKOPKC technical data

TableDFKKOPKC
Data storingCard Data Appendix for FICA Document
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKOPKC Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in DFKKOPKC table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • OPUPK : Item number in contract account document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Payment Cards: Card Data
  • CCINS : Payment card type
    Its data type is CHAR (Character String) with field length 4
  • CCNUM : Payment cards: Card number
    Its data type is CHAR (Character String) with field length 25
  • CCFOL : Payment cards: Payment card suffix
    Its data type is CHAR (Character String) with field length 10
  • DATAB : Payment cards: Valid from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATBI : Payment Cards: Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CCNAME : Payment Cards: Name of Cardholder
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Payment Cards: Data for Authorization
  • AUNUM : Payment cards: Authorization number
    Its data type is CHAR (Character String) with field length 25
  • AUTRA : Payment Cards: Authorization Reference Number
    Its data type is CHAR (Character String) with field length 25
  • AUDAT : Payment cards: Authorization date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUTIM : Payment cards: Authorization time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AUART : Payment cards: Authorization type
    Its data type is CHAR (Character String) with field length 1
  • AUTWR : Payment cards: Authorized amount
    Its data type is CURR (Currency Field) with field length 15
  • CCWAE : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MERCH : Payment cards: Merchant ID at the clearing house
    Its data type is CHAR (Character String) with field length 15
  • .INCLUDE : Payment Cards: Doc Data
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Payment Cards: Data for Billing/Reporting
  • XSETT : Billing Status
    Its data type is CHAR (Character String) with field length 1
  • LAUFI : Payment cards: Run ID of billing run
    Its data type is CHAR (Character String) with field length 16
  • STDOC : Document Number of Billing Document
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Payment Cards: Data from Payment Program
  • LAUFD_PYP : Date ID
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAUFI_PYP : Identification for the payment run
    Its data type is CHAR (Character String) with field length 5
  • ORIGN_PYP : Source of the payment data
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Payment Cards: Payment Data for Card Organization
  • ANZRATE : No. of Installments
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Card Verification Code (Card Check Number)
  • CVVAL : Card Verification Code (Check Number on Card, CVC Number)
    Its data type is CHAR (Character String) with field length 6
  • CVVCT : Control Field for Card Verification Value
    Its data type is CHAR (Character String) with field length 1
  • CVVST : Usage Status of Card Verification Code
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Payment Cards: Data for Encryption
  • CGUID : GUID of a Payment Card
    Its data type is RAW (Byte string) with field length 16
  • ENCTP : Type of Encryption
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes