SAP ABAP Table FKK_GPSHAD (Data Extract: Business Partner Data (Faster Access))

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKKB (Package) Contract A/R & A/P: Central Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FKK_GPSHAD	Table Relationship Diagram
Short Description	Data Extract: Business Partner Data (Faster Access)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PARTNER	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
3	USABLE_FROM	☐	FKK_BP_USABLE_FROM	TZNTSTMPS	DEC	15	0	Central Data of Business Partner Valid From
4	USABLE_TO	☐	FKK_BP_USABLE_TO	TZNTSTMPS	DEC	15	0	Central Data of Business Partner Valid To
5	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
6	ADDR_USABLE_FROM	☐	FKK_ADDR_USABLE_FROM	TZNTSTMPS	DEC	15	0	Business Partner Address Valid From
7	ADDR_USABLE_TO	☐	FKK_ADDR_USABLE_TO	TZNTSTMPS	DEC	15	0	Business Partner Address Valid To (Inclusive)
8	BKVID	☐	BU_BKVID	CHAR4	CHAR	4	0	Bank details ID	BUT0BK
9	BK_USABLE_FROM	☐	FKK_BK_USABLE_FROM	TZNTSTMPS	DEC	15	0	Bank Details of Business Partner Valid From
10	BK_USABLE_TO	☐	FKK_BK_USABLE_TO	TZNTSTMPS	DEC	15	0	Bank Details of Business Partner Valid To (Inclusive)
11	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
12	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
13	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
14	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
15	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
16	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
17	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
18	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
19	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
20	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
21	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
22	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
23	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
24	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
25	TEL_NUMBER	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
26	TEL_EXTENS	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
27	FAX_NUMBER	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
28	FAX_EXTENS	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
29	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
30	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
31	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
32	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
33	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
34	KOINH	☐	BU_KOINH	BU_KOINH	CHAR	60	0	Account Holder Name
35	.INCLUDE	☐				0	0	CBP: Name fields combined (lower case)
36	NAME1	☐	BU_NAME1	BU_NAME	CHAR	40	0	Name field 1 (name1/last name)
37	NAME2	☐	BU_NAME2	BU_NAME	CHAR	40	0	Name field 2 (name2/first name)
38	CCARD_ID	☐	BU_CCID	CHAR6	CHAR	6	0	Payment Card ID
39	CCINS	☐	CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment card type	TB033
40	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
41	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
42	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	ADRCITYPRT
43	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
44	INVALID	☐	FKK_INVALID	XFELD	CHAR	1	0	Shadow Table Entry Invalid
45	IBAN	☐	FKK_IBAN	CHAR34	CHAR	34	0	IBAN (International Bank Account Number)
46	CARD_GUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
47	VERSION	☐	GPSHAD_VERSION_KK	CHAR2	CHAR	2	0	Version of Shadow Table

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FKK_GPSHAD	BKVID	BUT0BK	BKVID
2	FKK_GPSHAD	CCINS	TB033	CCINS	REF	1	CN
3	FKK_GPSHAD	CITYP_CODE	ADRCITYPRT	CITYP_CODE
4	FKK_GPSHAD	CITY_CODE	ADRCITY	CITY_CODE
5	FKK_GPSHAD	CLIENT	T000	MANDT
6	FKK_GPSHAD	COUNTRY	T005	LAND1	REF	1	CN
7	FKK_GPSHAD	LANGU	T002	SPRAS	REF	C	CN
8	FKK_GPSHAD	PARTNER	BUT000	PARTNER	KEY	1	CN
9	FKK_GPSHAD	REGION	T005S	BLAND	REF	C	CN
10	FKK_GPSHAD	STREETCODE	ADRSTREET	STRT_CODE

History

Last changed by/on	SAP	20130529
SAP Release Created in