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

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

SAP FKK_GPSHAD table

Table FKK_GPSHAD technical data

TableFKK_GPSHAD
Data storingData Extract: Business Partner Data (Faster Access)
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PARTNER : Business Partner Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • USABLE_FROM : Central Data of Business Partner Valid From
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • USABLE_TO : Central Data of Business Partner Valid To
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ADDRNUMBER : Address number
    Its data type is CHAR (Character String) with field length 10
  • ADDR_USABLE_FROM : Business Partner Address Valid From
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • ADDR_USABLE_TO : Business Partner Address Valid To (Inclusive)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • BKVID : Bank details ID
    Its data type is CHAR (Character String) with field length 4
  • BK_USABLE_FROM : Bank Details of Business Partner Valid From
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • BK_USABLE_TO : Bank Details of Business Partner Valid To (Inclusive)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TYPE : Business partner category
    Its data type is CHAR (Character String) with field length 1
  • LANGU : Language Key
    Its data type is LANG (Language key character with length 1) 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
  • TEL_NUMBER : Telephone no.: dialling code+number
    Its data type is CHAR (Character String) with field length 30
  • TEL_EXTENS : Telephone no.: Extension
    Its data type is CHAR (Character String) with field length 10
  • FAX_NUMBER : Fax number: dialling code+number
    Its data type is CHAR (Character String) with field length 30
  • FAX_EXTENS : Fax no.: Extension
    Its data type is CHAR (Character String) with field length 10
  • BANKS : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • BANKL : Bank Keys
    Its data type is CHAR (Character String) with field length 15
  • BANKN : Bank account number
    Its data type is CHAR (Character String) with field length 18
  • BKONT : Bank Control Key
    Its data type is CHAR (Character String) with field length 2
  • BKREF : Reference specifications for bank details
    Its data type is CHAR (Character String) with field length 20
  • KOINH : Account Holder Name
    Its data type is CHAR (Character String) with field length 60
  • .INCLUDE : CBP: Name fields combined (lower case)
  • 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
  • CCARD_ID : Payment Card ID
    Its data type is CHAR (Character String) with field length 6
  • 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
  • CITY_CODE : City code for city/street file
    Its data type is CHAR (Character String) with field length 12
  • CITYP_CODE : District code for City and Street file
    Its data type is CHAR (Character String) with field length 8
  • STREETCODE : Street Number for City/Street File
    Its data type is CHAR (Character String) with field length 12
  • INVALID : Shadow Table Entry Invalid
    Its data type is CHAR (Character String) with field length 1
  • IBAN : IBAN (International Bank Account Number)
    Its data type is CHAR (Character String) with field length 34
  • CARD_GUID : GUID of a Payment Card
    Its data type is RAW (Byte string) with field length 16
  • VERSION : Version of Shadow Table
    Its data type is CHAR (Character String) with field length 2