DFKKORDERPOS SAP table for – Requests: Items

Here we would like to draw your attention to DFKKORDERPOS 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). DFKKORDERPOS is a SAP standard transp table used for storing Requests: Items related data in SAP. It comes under the package FKK_ORDER.

SAP DFKKORDERPOS table

Table DFKKORDERPOS technical data

TableDFKKORDERPOS
Data storingRequests: Items
ModuleFI
Sub ModuleFI-CA
SAP PackageFKK_ORDER
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ORDNR : Request Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • VERSN : Execution Period of a Standing Request
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • LINENR : Line Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUKRS_BP : Company Code of Business Partner Item
    Its data type is CHAR (Character String) with field length 4
  • GPART : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • VKONT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • VTREF : Reference Specifications from Contract
    Its data type is CHAR (Character String) with field length 20
  • 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
  • KOFIZ : Account Determination ID
    Its data type is CHAR (Character String) with field length 2
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • SPART : Division
    Its data type is CHAR (Character String) with field length 2
  • HKONT_BP : Reconciliation Account
    Its data type is CHAR (Character String) with field length 10
  • TEXTPOS : Item Text for Request
    Its data type is CHAR (Character String) with field length 50
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • FAEDN : Due date for net payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FAEDS : Due Date for Cash Discount
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DISC_DAYS : Cash Discount Days
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SKTPZ : Cash discount rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • BETRH : Amount In Local Currency With +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • KURSF : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PYBLOCK : Payment Lock
    Its data type is CHAR (Character String) with field length 1
  • PYMET : Payment Method
    Its data type is CHAR (Character String) with field length 1
  • GRKEY : Grouping Key for Displaying Open Items
    Its data type is CHAR (Character String) with field length 3
  • MAHNV : Dunning Procedure
    Its data type is CHAR (Character String) with field length 2
  • DNBLOCK : Dunning Lock
    Its data type is CHAR (Character String) with field length 1
  • INTBLOCK : Interest Lock
    Its data type is CHAR (Character String) with field length 1
  • CRLBLOCK : Clearing Lock
    Its data type is CHAR (Character String) with field length 1
  • EMGPA : Alternative business partner for payments
    Its data type is CHAR (Character String) with field length 10
  • EMBVT : Bank Details ID of Payee
    Its data type is CHAR (Character String) with field length 4
  • EMMND : SEPA Mandate Identification
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • EMCRD : Alternative Payment Card ID in Document
    Its data type is CHAR (Character String) with field length 6
  • PERSL : Key for Period Assignment
    Its data type is CHAR (Character String) with field length 4
  • ABRZU : Lower Limit of Settlement Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ABRZO : Upper Limit of the Billing Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUKRS : Company Code of G/L Account Item
    Its data type is CHAR (Character String) with field length 4
  • HKONT : G/L Account
    Its data type is CHAR (Character String) with field length 10
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • KDAUF : Sales Order Number
    Its data type is CHAR (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • KDEIN : Delivery schedule for sales order
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • PASUBNR : Profitability Segment Changes (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • HKONT_TAX : Tax G/L Account
    Its data type is CHAR (Character String) with field length 10
  • KTOSL : Transaction Key
    Its data type is CHAR (Character String) with field length 3
  • STPRZ : Tax rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • KSCHL : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • SBASW : Amount Subject to Tax in Transaction Currency (Tax Base Amt)
    Its data type is CURR (Currency Field) with field length 13
  • SBETW : Tax Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • TXDAT : Decisive Date for Calculating Taxes
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALDAT : Validity Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IKEY : Interest Key
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Structure for Revenue Distribution
  • FINRE : Contract Account of Final Recipient
    Its data type is CHAR (Character String) with field length 12
  • RDSTA : Current Distribution Status
    Its data type is CHAR (Character String) with field length 1
  • RDSTB : Last Distribution Status Reported
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Public Sector: Fields for Business Partner Items
  • .INCLUDE : Include for FM Integration (OI)
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • FDGRP : Planning Group
    Its data type is CHAR (Character String) with field length 10
  • FDLEV : Planning level
    Its data type is CHAR (Character String) with field length 2
  • FDZTG : Additional Days for Cash Management
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DOCCR : Document can be created
    Its data type is CHAR (Character String) with field length 1
  • ORDCLS : Request Class
    Its data type is CHAR (Character String) with field length 1
  • SUBAP : Subapplication in Contract Accounts Receivable and Payable
    Its data type is CHAR (Character String) with field length 1
  • PSGRP : Grouping Key for Document Items
    Its data type is CHAR (Character String) with field length 4
  • STAKZ : Type of statistical item
    Its data type is CHAR (Character String) with field length 1
  • XANZA : Item is a Down Payment/Down Payment Request
    Its data type is CHAR (Character String) with field length 1
  • KONTT_BP : Category for Additional Acct Assnmt for Bus. Partner Line
    Its data type is CHAR (Character String) with field length 2
  • KONTL_BP : Acct Assgnt Toolbar for Appl-Specific Act Assts for BP Lines
    Its data type is CHAR (Character String) with field length 50
  • KONTT_AC : Cat. of Additional Acct Assnmt for G/L Account Lines
    Its data type is CHAR (Character String) with field length 2
  • KONTL_AC : Acct Assgt Toolbar for Appl-Spec.AcctAssgmts for G/L A-Lines
    Its data type is CHAR (Character String) with field length 50
  • ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • ANBWA : Asset Transaction Type
    Its data type is CHAR (Character String) with field length 3
  • BZDAT : Asset Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • XEIBH : Create Separate Document in General Ledger
    Its data type is CHAR (Character String) with field length 1
  • XEIPH : Create Line Item in General Ledger
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Include for Funds Commitment (OPK)
  • EFCIR : Indicator: Earmarked Funds Created from Request
    Its data type is CHAR (Character String) with field length 1
  • EFLC : Indicator: Last Request Line for Earmarked Funds
    Its data type is CHAR (Character String) with field length 1