FKK_GPSHAD

Data Extract: Business Partner Data (Faster Access) | #masterdata | #language | Component: Contract Accounts Receivable and Payable
Column Name Description
CLIENT FK Client
PARTNER FK Business Partner Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
TYPE Business Partner Category Show values
INVALID Shadow Table Entry Invalid Show values
VERSION Version of Shadow Table Show values
XPCPT Business Purpose Completed Flag Show values
Column Name Description Domain name
USABLE_FROM Central Data of Business Partner Valid From TZNTSTMPS
USABLE_TO Central Data of Business Partner Valid To TZNTSTMPS
ADDRNUMBER Address Number AD_ADDRNUM
ADDR_USABLE_FROM Business Partner Address Valid From TZNTSTMPS
ADDR_USABLE_TO Business Partner Address Valid To (Inclusive) TZNTSTMPS
BK_USABLE_FROM Bank Details of Business Partner Valid From TZNTSTMPS
BK_USABLE_TO Bank Details of Business Partner Valid To (Inclusive) TZNTSTMPS
CITY1 City TEXT40
CITY2 District TEXT40
PO_BOX_LOC PO Box city TEXT40
POST_CODE1 City postal code CHAR10
POST_CODE2 PO Box Postal Code CHAR10
POST_CODE3 Company Postal Code (for Large Customers) CHAR10
PO_BOX PO Box CHAR10
STREET Street TEXT60
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
TEL_NUMBER Telephone no.: dialling code+number CHAR30
TEL_EXTENS Telephone no.: Extension CHAR10
FAX_NUMBER Fax number: dialling code+number CHAR30
FAX_EXTENS Fax no.: Extension CHAR10
BANKS Country/Region Key of Bank LAND1
BANKL Bank Keys BANKK
BANKN Bank account number BANKN
BKONT Bank Control Key BKONT
BKREF Reference Details for Bank Details CHAR20
KOINH Account Holder Name BU_KOINH
NAME1 Name field 1 (name1/last name) BU_NAME
NAME2 Name field 2 (name2/first name) BU_NAME
CCARD_ID Payment Card ID CHAR6
CCNUM Payment cards: Card number CCNUM
IBAN IBAN (International Bank Account Number) CHAR34
CARD_GUID GUID of a Payment Card SYSUUID
RISK_CLASS Risk Class UKM_RISK_CLASS
Master Data Relations Join Conditions
Bank Details ID
  • Bank Details ID
  • Client
  • Business Partner Number
  • FKK_GPSHAD.BKVID == BUT0BK.BKVID
  • FKK_GPSHAD.CLIENT == BUT0BK.MANDT
  • FKK_GPSHAD.PARTNER == BUT0BK.PARTNER
Payment Card Type
  • FKK_GPSHAD.CLIENT == TB033.MANDT
  • FKK_GPSHAD.CCINS == TB033.CCINS
City code for city/street file
  • Country/Region Key
  • Client
  • City code for city/street file
  • FKK_GPSHAD.COUNTRY == ADRCITY.COUNTRY
  • FKK_GPSHAD.CLIENT == ADRCITY.CLIENT
  • FKK_GPSHAD.CITY_CODE == ADRCITY.CITY_CODE
Client FKK_GPSHAD.CLIENT == T000.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • FKK_GPSHAD.COUNTRY == T005.LAND1
  • FKK_GPSHAD.CLIENT == T005.MANDT
Language Key FKK_GPSHAD.LANGU == T002.SPRAS
Business Partner Number
  • Business Partner Number
  • Client
  • FKK_GPSHAD.PARTNER == BUT000.PARTNER
  • FKK_GPSHAD.CLIENT == BUT000.CLIENT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • FKK_GPSHAD.CLIENT == T005S.MANDT
  • FKK_GPSHAD.COUNTRY == T005S.LAND1
  • FKK_GPSHAD.REGION == T005S.BLAND
Street Number for City/Street File
  • Country/Region Key
  • Street Number for City/Street File
Other Relations | to Master Data Relations ↑ Join Conditions
District code for City and Street file
  • Country/Region Key
  • City code for city/street file
  • District code for City and Street file