FKK_GPSHAD SAP (Data Extract: Business Partner Data (Faster Access)) Table details
Description: Data Extract: Business Partner Data (Faster Access)
Table field list including key, data, relationships and ABAP select examples
FKK_GPSHAD is a standard SAP Table which is used to store Data Extract: Business Partner Data (Faster Access) data and is available within R/3 SAP systems depending on the version and release level.
The FKK_GPSHAD table consists of various fields, each holding specific information or linking keys about Data Extract: Business Partner Data (Faster Access) data available in SAP. These include PARTNER (Business Partner Number), USABLE_FROM (Central Data of Business Partner Valid From), USABLE_TO (Central Data of Business Partner Valid To), ADDRNUMBER (Address number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FKK_GPSHAD table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
USABLE_FROM | Central Data of Business Partner Valid From | FKK_BP_USABLE_FROM | DEC | 15 | TZNTSTMPS | ||||
USABLE_TO | Central Data of Business Partner Valid To | FKK_BP_USABLE_TO | DEC | 15 | TZNTSTMPS | ||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ADDR_USABLE_FROM | Business Partner Address Valid From | FKK_ADDR_USABLE_FROM | DEC | 15 | TZNTSTMPS | ||||
ADDR_USABLE_TO | Business Partner Address Valid To (Inclusive) | FKK_ADDR_USABLE_TO | DEC | 15 | TZNTSTMPS | ||||
BKVID | Bank details ID | BU_BKVID | CHAR | 4 | BUT0BK | CHAR4 | |||
BK_USABLE_FROM | Bank Details of Business Partner Valid From | FKK_BK_USABLE_FROM | DEC | 15 | TZNTSTMPS | ||||
BK_USABLE_TO | Bank Details of Business Partner Valid To (Inclusive) | FKK_BK_USABLE_TO | DEC | 15 | TZNTSTMPS | ||||
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
LANGU | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
COUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
BANKS | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BANKN | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BKONT | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BKREF | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
KOINH | Account Holder Name | BU_KOINH | CHAR | 60 | BU_KOINH | ||||
NAME1 | Name field 1 (name1/last name) | BU_NAME1 | CHAR | 40 | BU_NAME | ||||
NAME2 | Name field 2 (name2/first name) | BU_NAME2 | CHAR | 40 | BU_NAME | ||||
CCARD_ID | Payment Card ID | BU_CCID | CHAR | 6 | CHAR6 | ||||
CCINS | Payment card type | CC_INSTITUTE | CHAR | 4 | TB033 | CC_INSTITUTE | |||
CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | Assigned to domain | CCNUM | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ADRCITY | ALPHA | CITY_CODE | ||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ADRCITYPRT | ALPHA | CITYP_CODE | ||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ADRSTREET | ALPHA | STRT_CODE | ||
INVALID | Shadow Table Entry Invalid | FKK_INVALID | CHAR | 1 | XFELD | ||||
IBAN | IBAN (International Bank Account Number) | FKK_IBAN | CHAR | 34 | CHAR34 | ||||
CARD_GUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | SYSUUID | ||||
VERSION | Version of Shadow Table | GPSHAD_VERSION_KK | CHAR | 2 | CHAR2 | ||||
XPCPT | Business Purpose Completed Flag | BU_XPCPT | CHAR | 1 | BU_XPCPT |
Key field | Non-key field |
How do I retrieve data from SAP table FKK_GPSHAD using ABAP code
The following ABAP code Example will allow you to do a basic selection on FKK_GPSHAD to SELECT all data from the tableDATA: WA_FKK_GPSHAD TYPE FKK_GPSHAD.
SELECT SINGLE *
FROM FKK_GPSHAD
INTO CORRESPONDING FIELDS OF WA_FKK_GPSHAD
WHERE...
How to access SAP table FKK_GPSHAD
Within an ECC or HANA version of SAP you can also view further information about FKK_GPSHAD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects