SAP ABAP Table NGPA (IS-H: Business Partners)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NBAS (Package) Appl. development Hospital System master data, catalogs

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	NGPA	Table Relationship Diagram
Short Description	IS-H: Business Partners

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	GPART	☑	GPARTNER	RI_KUNNR	CHAR	10	0	IS-H: Business Partner
3	INSTN	☐	INSTNR	INSTNR	CHAR	10	0	IS-H: Institute Indicator
4	NAME1	☐	GPNAM1	NAME	CHAR	35	0	IS-H: Last Name/ 1st Name
5	NAM1S	☐	GPNAM1S	NAM35	CHAR	35	0	IS-H: Standardized Last Name of Business Partner
6	NAME2	☐	GPNAM2	NAME	CHAR	35	0	IS-H: First Name / 2nd Name
7	NAM2S	☐	GPNAM2S	NAM35	CHAR	35	0	Standardized First Name/2nd Name of Business Partner
8	NAME3	☐	GPNAM3	NAME	CHAR	35	0	Third Name
9	KNAME	☐	KZNAME	ISH_C12	CHAR	12	0	IS-H: Short Name of Business Partner
10	NPKZ	☐	NATPERKZ	XFELD	CHAR	1	0	IS-H: Indicator for Natural Person (for Address Control)
11	SPRAS	☐	SPRAS_GP	SPRAS	LANG	1	0	IS-H: Language of Business Partner	T002
12	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key	*
13	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*
14	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	*
15	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	*
16	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
17	LAND	☐	LAND_GP	LAND1	CHAR	3	0	IS-H: Country of Business Partner	T005
18	REGIO	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	T005S
19	PSTLZ	☐	PSTLZ_GP	PSTLZ	CHAR	10	0	IS-H: Postal Code of Business Partner
20	PFACH	☐	PFACH_GP	ISH_PFACH	CHAR	10	0	IS-H: PO Box of Business Partner
21	PLZPF	☐	PLZPF_GP	ISH_PLZPF	CHAR	10	0	IS-H: Postal Code for PO Box of Business Partner
22	ORT	☐	ORT_GP	TEXT25	CHAR	25	0	IS-H: City of Business Partner
23	ORTS	☐	ORTS_GP	ISH30	CHAR	30	0	Standardized Name of City where Business Partner is Located
24	ORT2	☐	ORT2_GP	TEXT25	CHAR	25	0	District of Business Partner
25	STRAS	☐	STRASSE_GP	STRAS	CHAR	30	0	IS-H: Street Name and Street Number of Business Partner
26	TELFN	☐	TELEFON_GP	TEXT16	CHAR	16	0	IS-H: Telephone Number of Business Partner
27	TELFX	☐	TELEFAX_GP	TEXT31	CHAR	31	0	Fax Number of Business Partner
28	TELEX	☐	TELEX_GP	TEXT30	CHAR	30	0	Telex Number of Business Partner
29	KZTXT	☐	TEXT_GPA	TEXT50	CHAR	50	0	IS-H: Comment on Business Partner
30	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
31	LOEKZ	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
32	LOUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
33	LODAT	☐	RI_LODAT	RI_DATUM	DATS	8	0	IS-H: Date of Deletion
34	SPVON	☐	ISH_SPERRV	RI_DATUM	DATS	8	0	IS-H: Blocking Date from (Entry Block)
35	SPBIS	☐	ISH_SPERRB	RI_DATUM	DATS	8	0	IS-H: Blocking Date To (Entry Block To)
36	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
37	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
38	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
39	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
40	GPAR	☐	GPART	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the General Business Partner Function
41	PERS	☐	PERS_D	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYEE Function
42	KOSTR	☐	KOSTR	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the INSURANCE PROVIDER Function
43	DEBIT	☐	DEBIT	RI_ROLLE	CHAR	1	0	Text Designating the CUSTOMER Function
44	ARBTG	☐	ARBTG	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the EMPLOYER Function
45	KRKHS	☐	KRKHS	RI_ROLLE	CHAR	1	0	IS-H: Text Designating the HOSPITAL Function
46	KNAMS	☐	KZNAMS	ISH_C12	CHAR	12	0	Standard Short Name for Search
47	SPTXT	☐	ISH_SPTEXT	TEXT50	CHAR	50	0	Reason for Blocking
48	SPTKZ	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
49	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
50	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
51	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
52	PNUMB	☐	ISH_PNUMB	CHAR15	CHAR	15	0	IS-H: External Partner Number
53	PARTNER_GUID	☐	ISH_PARTNER_GUID	SYSUUID	RAW	16	0	IS-H: GUID of Business Partner
54	TITEL1	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NGPA	ADRNR	NADR	ADRNR	REF	C	C
2	NGPA	LAND	T005	LAND1	REF	1	CN
3	NGPA	MANDT	T000	MANDT	KEY	1	CN
4	NGPA	REGIO	T005S	BLAND	REF	C	CN
5	NGPA	SPRAS	T002	SPRAS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in