SAP NGPA Table in S/4 HANA - Business Partners
NGPA is a standard SAP Table which is used to store Business Partners data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the NGPA table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: NGPA
NGPA table structure field list
Below is the full NGPA field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
GPART | Business Partner | GPARTNER | CHAR | 10(0) | ALPHA | RI_KUNNR | ||||
INSTN | Institute Indicator | INSTNR | CHAR | 10(0) | ALPHA | INSTNR | ||||
NAME1 | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40(0) | BU_NAME | |||||
NAM1S | Standardized Last Name for Business Partner | ISH_NAMLS | CHAR | 40(0) | NAM40 | |||||
NAME2 | First name of business partner (person) | BU_NAMEP_F | CHAR | 40(0) | BU_NAME | |||||
NAM2S | Standardized First Name for Business Partner | ISH_NAMFS | CHAR | 40(0) | NAM40 | |||||
NAME3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40(0) | BU_NAME | |||||
KNAME | Short Name of Business Partner | KZNAME | CHAR | 12(0) | ISH_C12 | |||||
NPKZ | Indicator for Natural Person (for Address Control) | NATPERKZ | CHAR | 1(0) | XFELD | |||||
SPRAS | Business partner: Language | BU_LANGU | LANG | 1(0) | T002 | ISOLA | SPRAS | |||
ANRED | Form-of-Address Key | AD_TITLE | CHAR | 4(0) | AD_TITLE | |||||
TITEL | Academic Title: Key | AD_TITLE1 | CHAR | 4(0) | AD_TITLE1 | AD_TITLE1 | TITLE_KEY | |||
NAMZU | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4(0) | AD_TITLES | |||||
VORSW | Name Prefix (Key) | AD_PREFIX | CHAR | 4(0) | AD_PREFIX | |||||
GSCHL | Patient Gender | NPA_GENDER | CHAR | 1(0) | AD_SEX | |||||
KZTXT | Comment on Business Partner | TEXT_GPA | CHAR | 50(0) | TEXT50 | |||||
LGTXT | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1(0) | XFELD | |||||
LOEKZ | Deletion Flag/Indicator | RI_LOEKZ | CHAR | 1(0) | XFELD | |||||
LOUSR | User Who Deleted Record | RI_LOUSR | CHAR | 12(0) | USNAM | |||||
LODAT | Date of Deletion | RI_LODAT | DATS | 8(0) | RI_DATUM | |||||
SPVON | Blocking Date From (Entry Block) | ISH_SPERRV | DATS | 8(0) | RI_DATUM | |||||
SPBIS | Blocking Date To (Entry Block To) | ISH_SPERRB | DATS | 8(0) | RI_DATUM | |||||
ERDAT | Date on which the object was created | BU_CRDAT | DATS | 8(0) | DATUM | |||||
ERUSR | User who created the object | BU_CRUSR | CHAR | 12(0) | USNAM | |||||
UPDAT | Date when object was last changed | BU_CHDAT | DATS | 8(0) | DATUM | |||||
UPUSR | Last user to change object | BU_CHUSR | CHAR | 12(0) | USNAM | |||||
GPAR | Text Designating the General Business Partner Function | GPART | CHAR | 1(0) | RI_ROLLE | |||||
PERS | Text Designating the EMPLOYEE Function | PERS_D | CHAR | 1(0) | RI_ROLLE | |||||
KOSTR | Text Designating the INSURANCE PROVIDER Function | KOSTR | CHAR | 1(0) | RI_ROLLE | |||||
DEBIT | Text Designating the CUSTOMER Function | DEBIT | CHAR | 1(0) | RI_ROLLE | |||||
ARBTG | Text Designating the EMPLOYER Function | ARBTG | CHAR | 1(0) | RI_ROLLE | |||||
KRKHS | Text Designating the HOSPITAL Function | KRKHS | CHAR | 1(0) | RI_ROLLE | |||||
KNAMS | Standard Short Name for Search | KZNAMS | CHAR | 12(0) | ISH_C12 | |||||
SPTXT | Reason for Blocking | ISH_SPTEXT | CHAR | 50(0) | TEXT50 | |||||
SPTKZ | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1(0) | XFELD | |||||
ADRNR | Address Number | ISH_ADRNR | CHAR | 10(0) | NADR | ALPHA | ISH_ADRNR | |||
ADROB | Address Object | ISH_ADROBJ | CHAR | 4(0) | ISH_ADROBJ | |||||
STCD1 | Tax Number 1 | STCD1 | CHAR | 16(0) | STCD1 | |||||
PNUMB | Business Partner Number in External System | BU_BPEXT | CHAR | 20(0) | CHAR20 | |||||
PARTNER_GUID | GUID of Business Partner | ISH_PARTNER_GUID | RAW | 16(0) | SYSUUID | |||||
TITEL1 | Second academic title (key) | AD_TITLE2 | CHAR | 4(0) | AD_TITLE1 | |||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10(0) | ALPHA | BU_PARTNER | BPA | BUPA | PARTNER |
Search for further information about these or an SAP related objects