NGPA SAP (IS-H: Business Partners) Table details
Dictionary Type: Table
Description: IS-H: Business Partners
Description: IS-H: Business Partners
Table field list including key, data, relationships and ABAP select examples
NGPA is a standard SAP Table which is used to store IS-H: Business Partners data and is available within R/3 SAP systems depending on the version and release level.
The NGPA table consists of various fields, each holding specific information or linking keys about IS-H: Business Partners data available in SAP. These include GPART (IS-H: Business Partner), INSTN (IS-H: Institute Indicator), NAME1 (IS-H: Last Name/ 1st Name), NAM1S (IS-H: Standardized Last Name of Business Partner).. 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 NGPA 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
GPART | IS-H: Business Partner | GPARTNER | CHAR | 10 | ALPHA | RI_KUNNR | NGP | ||
INSTN | IS-H: Institute Indicator | INSTNR | CHAR | 10 | ALPHA | INSTNR | |||
NAME1 | IS-H: Last Name/ 1st Name | GPNAM1 | CHAR | 35 | NAME | NA1 | |||
NAM1S | IS-H: Standardized Last Name of Business Partner | GPNAM1S | CHAR | 35 | NAM35 | ||||
NAME2 | First Name / Second Name | GPNAM2 | CHAR | 35 | NAME | ||||
NAM2S | Standardized First Name/2nd Name of Business Partner | GPNAM2S | CHAR | 35 | NAM35 | ||||
NAME3 | Third Name | GPNAM3 | CHAR | 35 | NAME | ||||
KNAME | IS-H: Short Name of Business Partner | KZNAME | CHAR | 12 | ISH_C12 | ||||
NPKZ | IS-H: Indicator for Natural Person (for Address Control) | NATPERKZ | CHAR | 1 | XFELD | ||||
SPRAS | IS-H: Language of Business Partner | SPRAS_GP | LANG | 1 | T002 | ISOLA | SPRAS | ||
ANRED | IS-H: Form-of-Address Key | RI_ANRDS | CHAR | 2 | Assigned to domain | RI_ANRDS | |||
TITEL | IS-H: Title | RI_TITEL | CHAR | 15 | Assigned to domain | TITEL | |||
NAMZU | IS-H: Name Affix | RI_NAMZU | CHAR | 15 | Assigned to domain | TITEL | |||
VORSW | IS-H: Name Prefix | RI_VORSW | CHAR | 15 | Assigned to domain | TITEL | |||
GSCHL | IS-H: Sex Indicator - Internal | GSCHL | CHAR | 1 | GSCHL | ||||
LAND | IS-H: Country of Business Partner | LAND_GP | CHAR | 3 | T005 | LAND1 | |||
REGIO | IS-H: Region (Federal State, Province, County) | ISH_REGION | CHAR | 3 | T005S | REGIO | |||
PSTLZ | IS-H: Postal Code of Business Partner | PSTLZ_GP | CHAR | 10 | PSTLZ | ||||
PFACH | IS-H: PO Box of Business Partner | PFACH_GP | CHAR | 10 | ISH_PFACH | ||||
PLZPF | IS-H: Postal Code for PO Box of Business Partner | PLZPF_GP | CHAR | 10 | ISH_PLZPF | ||||
ORT | IS-H: City of Business Partner | ORT_GP | CHAR | 25 | TEXT25 | ||||
ORTS | Standardized Name of City where Business Partner is Located | ORTS_GP | CHAR | 30 | ISH30 | ||||
ORT2 | District of Business Partner | ORT2_GP | CHAR | 25 | TEXT25 | ||||
STRAS | IS-H: Street Name and Street Number of Business Partner | STRASSE_GP | CHAR | 30 | STRAS | ||||
TELFN | IS-H: Telephone Number of Business Partner | TELEFON_GP | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number of Business Partner | TELEFAX_GP | CHAR | 31 | TEXT31 | ||||
TELEX | Telex Number of Business Partner | TELEX_GP | CHAR | 30 | TEXT30 | ||||
KZTXT | IS-H: Comment on Business Partner | TEXT_GPA | CHAR | 50 | TEXT50 | ||||
LGTXT | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
LOEKZ | Deletion Flag/Indicator | RI_LOEKZ | CHAR | 1 | XFELD | ||||
LOUSR | User Who Deleted Record | RI_LOUSR | CHAR | 12 | USNAM | ||||
LODAT | Date of Deletion | RI_LODAT | DATS | 8 | RI_DATUM | ||||
SPVON | Blocking Date From (Entry Block) | ISH_SPERRV | DATS | 8 | RI_DATUM | ||||
SPBIS | IS-H: Blocking Date To (Entry Block To) | ISH_SPERRB | DATS | 8 | RI_DATUM | ||||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
GPAR | IS-H: Text Designating the General Business Partner Function | GPART | CHAR | 1 | RI_ROLLE | ||||
PERS | IS-H: Text Designating the EMPLOYEE Function | PERS_D | CHAR | 1 | RI_ROLLE | ||||
KOSTR | IS-H: Text Designating the INSURANCE PROVIDER Function | KOSTR | CHAR | 1 | RI_ROLLE | ||||
DEBIT | Text Designating the CUSTOMER Function | DEBIT | CHAR | 1 | RI_ROLLE | ||||
ARBTG | IS-H: Text Designating the EMPLOYER Function | ARBTG | CHAR | 1 | RI_ROLLE | ||||
KRKHS | IS-H: Text Designating the HOSPITAL Function | KRKHS | CHAR | 1 | RI_ROLLE | ||||
KNAMS | Standard Short Name for Search | KZNAMS | CHAR | 12 | ISH_C12 | ||||
SPTXT | Reason for Blocking | ISH_SPTEXT | CHAR | 50 | TEXT50 | ||||
SPTKZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
ADRNR | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | NADR | ALPHA | ISH_ADRNR | ||
ADROB | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
PNUMB | IS-H: External Partner Number | ISH_PNUMB | CHAR | 15 | CHAR15 | ||||
PARTNER_GUID | IS-H: GUID of Business Partner | ISH_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
TITEL1 | IS-H: Title | RI_TITEL | CHAR | 15 | Assigned to domain | TITEL | |||
MIG_DONE | Indicator Specifying Record Is Migrated to BP Table | ISH_BPMIG_DONE | CHAR | 1 | ISH_BPMIG_DONE |
Key field | Non-key field |
How do I retrieve data from SAP table NGPA using ABAP code
The following ABAP code Example will allow you to do a basic selection on NGPA to SELECT all data from the tableDATA: WA_NGPA TYPE NGPA.
SELECT SINGLE *
FROM NGPA
INTO CORRESPONDING FIELDS OF WA_NGPA
WHERE...
How to access SAP table NGPA
Within an ECC or HANA version of SAP you can also view further information about NGPA 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