1. SAP Tutorial
  2. FI Module

DFKKGP_SHORT SAP table for – Data Extract: BP Data

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

SAP DFKKGP_SHORT table

Table DFKKGP_SHORT technical data

TableDFKKGP_SHORT
Data storingData Extract: BP Data
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GJAHR : Posting year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • PARTNER : Business Partner Number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • BKVID : Business partner category
    Its data type is CHAR (Character String) with field length 1
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • REGION : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • CITY1 : City
    Its data type is CHAR (Character String) with field length 40
  • CITY2 : District
    Its data type is CHAR (Character String) with field length 40
  • PO_BOX_LOC : PO Box city
    Its data type is CHAR (Character String) with field length 40
  • POST_CODE1 : City postal code
    Its data type is CHAR (Character String) with field length 10
  • POST_CODE2 : PO Box postal code
    Its data type is CHAR (Character String) with field length 10
  • POST_CODE3 : Company postal code (for large customers)
    Its data type is CHAR (Character String) with field length 10
  • PO_BOX : PO Box
    Its data type is CHAR (Character String) with field length 10
  • STREET : Street
    Its data type is CHAR (Character String) with field length 60
  • HOUSE_NUM1 : House Number
    Its data type is CHAR (Character String) with field length 10
  • HOUSE_NUM2 : House number supplement
    Its data type is CHAR (Character String) with field length 10
  • KOINH : Account Holder Name
    Its data type is CHAR (Character String) with field length 60
  • NAME1 : Name field 1 (name1/last name)
    Its data type is CHAR (Character String) with field length 40
  • NAME2 : Name field 2 (name2/first name)
    Its data type is CHAR (Character String) with field length 40
  • EXTRACT_ID : Extract Identification
    Its data type is CHAR (Character String) with field length 20
  • TYPE : Business partner category
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • DFKKGP_SHORT related tables

    • TFK042AXL : Payment Program: Bank Selection – ID (Values)
    • TFKZRGRT : Description of Reset Reasons for Doubtful Items/IVA
    • TFK042W : Payment Program: Valid Currencies for Payment Method
    • TFK006XS : Exception Accounts for Clarification Proposal
    • DFKKOPK_SHORT : Offsetting Items for FI-CA Document – Extracts
    • DFKKDT : Accounting Data (INDX Structure)
    • FKK042ZA : Work table for country payment methods (data in TFK042ZA)
    • TFKAWM003T : Foreign Trade Reporting: Report Key in Directory
    • TFK047HT : Text for dunning charges type
    • TFK045E : Returns Activities (Returns Lot)
    • TFK051A : Transfer Reasons
    • TFK_ODNGRP : Grouping for Official Document Number (ODN)
    • TFKZVARI : Value Adjustment Variants
    • TFK013 : Find Payments via Search Engine
    • TFKCVS_CODE : Code in Payment Lot for Payments from Ext. Payment Collector
    • FKKDISTOP : FI-CA: Flag for exiting jobs early
    • DFKKOP : Items in contract account document
    • DFKKPPROPEXC : Exceptions for Due Date Determination and Last Payments
    • TFK006A : Object Types for Contract Acct Search
    • TFK042FF : Level of Detail When Creating Payment Medium

    DFKKGP_SHORT related transaction codes under SAP package FKKB

    • FQ_ENH_BROKR : Create Enhancement: Broker
    • FPBCD : FI-CA Data Transfer Changes
    • FQTFK020C : FI-CA Maintenance Table TFK020C
    • FPDE_IMP : Document Extracts – Import
    • FPU6 : History of Transfer
    • S_KK4_74002178 : IMG Activity: _FICABTPY_FQZI
    • FQZ26 : Collection Agencies
    • S_KK4_74002260 : IMG Activity: _FICABTDCSV_FQZ14
    • S_KK4_74002349 : IMG Activity: _FICABFDP_TFK000S
    • FPO6 : Evaluation of Report Totals
    • FPG2 : Reconcile with General Ledger
    • S_KK4_74002286 : IMG Activity: _ISUFICABFDP_000053
    • S_KK4_74002151 : IMG Activity: _ISISFICA_VSC01
    • S_KK4_74002162 : IMG Activity: _FICABTPYPP_FPN3
    • FP09FS : Field Selection Returns Lot Header
    • FQ0061 : FI-CA: Late Payment Surcharge
    • S_KK4_74002092 : IMG Activity: _ISISFICA_TKKVTXB
    • FPZW : Receivables correction
    • FPAC05 : Activate AS for contract acct arch.
    • FPARM0 : Define FICA Dun. Archiving Runtime

    Related References

    Related Tutorials

    FKK_GPSHAD SAP table for – Data Extract: Business Partner Data (Faster Access)

    FKK_GPSHAD table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKCUST_SHORT SAP table for – Data Extract: Customizing

    DFKKCUST_SHORT table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKCJMT SAP table for – Text Table for Cash Journal Master Data

    DFKKCJMT table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKREP07_T SAP table for – Tax Report Data (Additional Data for Transfer Posting)

    DFKKREP07_T table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKBRLEVYREC SAP table for – Levy Way: Data from Payment Lot for Levy Way report (Brazil)

    DFKKBRLEVYREC table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKMDUK SAP table for – Master Data Lot: Header Data

    DFKKMDUK table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    J_2IEXTRCT SAP table for – Data Extract table for Excise Registers

    J_2IEXTRCT table in SAP FI (Localization in FI) module. This table is used for storing data of Data Extract table...

    «
    »