DFKK1099 SAP table for – 1099 Statutory Reporting Data

Here we would like to draw your attention to DFKK1099 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). DFKK1099 is a SAP standard transp table used for storing 1099 Statutory Reporting Data related data in SAP. It comes under the package FKKB.

SAP DFKK1099 table

Table DFKK1099 technical data

TableDFKK1099
Data storing1099 Statutory Reporting Data
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKK1099 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 DFKK1099 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GPART : Business Partner Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • OPUPW : Repetition Item in Contract Account Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • 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
  • OPUPZ : Subitem for a Partial Clearing in Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • CREATETIME : Created: UTC Date+Time
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • AUGBL : Clearing Document or Printed Document
    Its data type is CHAR (Character String) with field length 12
  • NAUGH : Net clearing amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • AQSBH : Proportional Withholding Tax Amount In Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • QSSKZ : Withholding Tax Code
    Its data type is CHAR (Character String) with field length 2
  • EMADR : Address number
    Its data type is CHAR (Character String) with field length 10
  • HVORG : Main Transaction for Line Item
    Its data type is CHAR (Character String) with field length 4
  • TVORG : Subtransaction for Document Item
    Its data type is CHAR (Character String) with field length 4
  • REPDT : Reporting Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8