1. Home
  2. Resources
  3. SAP Tables
  4. NGPA - IS-H: Business Partners

SAP Table NGPA

IS-H: Business Partners

NGPA (IS-H: Business Partners) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link NGPA to other SAP tables.

NGPA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
GPART IS-H: Business Partner GPARTNER CHAR 10 0
INSTN IS-H: Institute Indicator INSTNR CHAR 10 0
NAME1 IS-H: Last Name/ 1st Name GPNAM1 CHAR 35 0
NAM1S IS-H: Standardized Last Name of Business Partner GPNAM1S CHAR 35 0
NAME2 First Name / Second Name GPNAM2 CHAR 35 0
NAM2S Standardized First Name/2nd Name of Business Partner GPNAM2S CHAR 35 0
NAME3 Third Name GPNAM3 CHAR 35 0
KNAME IS-H: Short Name of Business Partner KZNAME CHAR 12 0
NPKZ IS-H: Indicator for Natural Person (for Address Control) NATPERKZ CHAR 1 0
X Yes
NULL No
SPRAS IS-H: Language of Business Partner SPRAS_GP T002 LANG 1 0
ANRED IS-H: Form-of-Address Key RI_ANRDS CHAR 2 0
TITEL IS-H: Title RI_TITEL CHAR 15 0
NAMZU IS-H: Name Affix RI_NAMZU CHAR 15 0
VORSW IS-H: Name Prefix RI_VORSW CHAR 15 0
GSCHL IS-H: Sex Indicator - Internal GSCHL CHAR 1 0
1 male
2 female
3 unknown
LAND IS-H: Country of Business Partner LAND_GP T005 CHAR 3 0
REGIO IS-H: Region (Federal State, Province, County) ISH_REGION T005S CHAR 3 0
PSTLZ IS-H: Postal Code of Business Partner PSTLZ_GP CHAR 10 0
PFACH IS-H: PO Box of Business Partner PFACH_GP CHAR 10 0
PLZPF IS-H: Postal Code for PO Box of Business Partner PLZPF_GP CHAR 10 0
ORT IS-H: City of Business Partner ORT_GP CHAR 25 0
ORTS Standardized Name of City where Business Partner is Located ORTS_GP CHAR 30 0
ORT2 District of Business Partner ORT2_GP CHAR 25 0
STRAS IS-H: Street Name and Street Number of Business Partner STRASSE_GP CHAR 30 0
TELFN IS-H: Telephone Number of Business Partner TELEFON_GP CHAR 16 0
TELFX Fax Number of Business Partner TELEFAX_GP CHAR 31 0
TELEX Telex Number of Business Partner TELEX_GP CHAR 30 0
KZTXT IS-H: Comment on Business Partner TEXT_GPA CHAR 50 0
LGTXT Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
LOEKZ Deletion Flag/Indicator RI_LOEKZ CHAR 1 0
X Yes
NULL No
LOUSR User Who Deleted Record RI_LOUSR CHAR 12 0
LODAT Date of Deletion RI_LODAT DATS 8 0
SPVON Blocking Date From (Entry Block) ISH_SPERRV DATS 8 0
SPBIS IS-H: Blocking Date To (Entry Block To) ISH_SPERRB DATS 8 0
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0
GPAR IS-H: Text Designating the General Business Partner Function GPART CHAR 1 0
PERS IS-H: Text Designating the EMPLOYEE Function PERS_D CHAR 1 0
KOSTR IS-H: Text Designating the INSURANCE PROVIDER Function KOSTR CHAR 1 0
DEBIT Text Designating the CUSTOMER Function DEBIT CHAR 1 0
ARBTG IS-H: Text Designating the EMPLOYER Function ARBTG CHAR 1 0
KRKHS IS-H: Text Designating the HOSPITAL Function KRKHS CHAR 1 0
KNAMS Standard Short Name for Search KZNAMS CHAR 12 0
SPTXT Reason for Blocking ISH_SPTEXT CHAR 50 0
SPTKZ Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
ADRNR IS-H: Address Number ISH_ADRNR NADR CHAR 10 0
ADROB IS-H: Address Object ISH_ADROBJ CHAR 4 0
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
STCD1 Tax Number 1 STCD1 CHAR 16 0
PNUMB IS-H: External Partner Number ISH_PNUMB CHAR 15 0
PARTNER_GUID IS-H: GUID of Business Partner ISH_PARTNER_GUID RAW 16 0
TITEL1 IS-H: Title RI_TITEL CHAR 15 0
MIG_DONE Indicator Specifying Record Is Migrated to BP Table ISH_BPMIG_DONE CHAR 1 0
M Master Data Migrated
R Relationships Migrated
NULL Not Migrated
E Errors in Migration

NGPA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NGPA ADRNR NGPA MANDT NADR IS-H: Addresses (Central Address Management) MANDT
NGPA ADRNR NGPA ADRNR NADR IS-H: Addresses (Central Address Management) ADRNR
NGPA ADRNR NGPA ADROB NADR IS-H: Addresses (Central Address Management) ADROB
NGPA LAND NGPA MANDT T005 Countries MANDT
NGPA LAND NGPA LAND T005 Countries LAND1
NGPA MANDT NGPA MANDT T000 Clients MANDT
NGPA REGIO NGPA MANDT T005S Taxes: Region (Province) Key MANDT
NGPA REGIO NGPA LAND T005S Taxes: Region (Province) Key LAND1
NGPA REGIO NGPA REGIO T005S Taxes: Region (Province) Key BLAND
NGPA SPRAS NGPA SPRAS T002 Language Keys (Component BC-I18) SPRAS