FKK_GPSHAD - Data Extract: Business Partner Data (Faster Access)

Data Extract: Business Partner Data (Faster Access) information is stored in SAP table FKK_GPSHAD.
It is part of development package FKK_BUPA in software component FI-CA. This development package consists of objects that can be grouped under "FI-CA: Business Partner".

Fields for table FKK_GPSHAD

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	T000
PARTNER	Business Partner Number	X	BU_PARTNER	CHAR	20	BUT000
USABLE_FROM	Central Data of Business Partner Valid From		FKK_BP_USABLE_FROM	DEC	8
USABLE_TO	Central Data of Business Partner Valid To		FKK_BP_USABLE_TO	DEC	8
ADDRNUMBER	Address Number		AD_ADDRNUM	CHAR	20
ADDR_USABLE_FROM	Business Partner Address Valid From		FKK_ADDR_USABLE_FROM	DEC	8
ADDR_USABLE_TO	Business Partner Address Valid To (Inclusive)		FKK_ADDR_USABLE_TO	DEC	8
BKVID	Bank Details ID		BU_BKVID	CHAR	8	BUT0BK
BK_USABLE_FROM	Bank Details of Business Partner Valid From		FKK_BK_USABLE_FROM	DEC	8
BK_USABLE_TO	Bank Details of Business Partner Valid To (Inclusive)		FKK_BK_USABLE_TO	DEC	8
TYPE	Business Partner Category		BU_TYPE	CHAR	2
LANGU	Language Key		SPRAS	LANG	2	T002
COUNTRY	Country/Region Key		LAND1	CHAR	6	T005
REGION	Region (State, Province, County)		REGIO	CHAR	6	T005S
CITY1	City		AD_CITY1	CHAR	80
CITY2	District		AD_CITY2	CHAR	80
PO_BOX_LOC	PO Box city		AD_POBXLOC	CHAR	80
POST_CODE1	City postal code		AD_PSTCD1	CHAR	20
POST_CODE2	PO Box Postal Code		AD_PSTCD2	CHAR	20
POST_CODE3	Company Postal Code (for Large Customers)		AD_PSTCD3	CHAR	20
PO_BOX	PO Box		AD_POBX	CHAR	20
STREET	Street		AD_STREET	CHAR	120
HOUSE_NUM1	House Number		AD_HSNM1	CHAR	20
HOUSE_NUM2	House number supplement		AD_HSNM2	CHAR	20
TEL_NUMBER	Telephone no.: dialling code+number		AD_TLNMBR	CHAR	60
TEL_EXTENS	Telephone no.: Extension		AD_TLXTNS	CHAR	20
FAX_NUMBER	Fax number: dialling code+number		AD_FXNMBR	CHAR	60
FAX_EXTENS	Fax no.: Extension		AD_FXXTNS	CHAR	20
BANKS	Country/Region Key of Bank		BANKS	CHAR	6
BANKL	Bank Keys		BANKK	CHAR	30
BANKN	Bank account number		BANKN	CHAR	36
BKONT	Bank Control Key		BKONT	CHAR	4
BKREF	Reference Details for Bank Details		BKREF	CHAR	40
KOINH	Account Holder Name		BU_KOINH	CHAR	120
.INCLUDE				BUS000_NAM	0
NAME1	Name field 1 (name1/last name)		BU_NAME1	CHAR	80
NAME2	Name field 2 (name2/first name)		BU_NAME2	CHAR	80
CCARD_ID	Payment Card ID		BU_CCID	CHAR	12
CCINS	Payment Card Type		CC_INSTITUTE	CHAR	8	TB033
CCNUM	Payment cards: Card number		CCNUM	CHAR	50
CITY_CODE	City code for city/street file		AD_CITYNUM	CHAR	24	ADRCITY
CITYP_CODE	District code for City and Street file		AD_CITYPNM	CHAR	16	ADRCITYPRT
STREETCODE	Street Number for City/Street File		AD_STRNUM	CHAR	24	ADRSTREET
INVALID	Shadow Table Entry Invalid		FKK_INVALID	CHAR	2
IBAN	IBAN (International Bank Account Number)		FKK_IBAN	CHAR	68
CARD_GUID	GUID of a Payment Card		CARD_GUID	RAW	16
VERSION	Version of Shadow Table		GPSHAD_VERSION_KK	CHAR	4
XPCPT	Business Purpose Completed Flag		BU_XPCPT	CHAR	2
RISK_CLASS	Risk Class		UKM_RISK_CLASS	CHAR	6