SAP ABAP Table PIQAPP_RELPADDR (Related Person (Standard Address))

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ (Package) Campus Management

Basic Data

Table Category	INTTAB	Structure
Structure	PIQAPP_RELPADDR	Table Relationship Diagram
Short Description	Related Person (Standard Address)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	RELPERSID_ADR	☐	PIQRELPERSID	NUMC2	NUMC	2	0	Identification Number of the Related Person
2	.INCLU-ADR	☐				0	0	Application: Address (Central Address Mgmt)
3	STANDARDADDRESSADR	☐	BU_XDFADR	XFELD	CHAR	1	0	Indicator: Address is standard address
4	C_O_NAMEADR	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
5	CITYADR	☐	AD_CITY1	TEXT40	CHAR	40	0	City
6	DISTRICTADR	☐	AD_CITY2	TEXT40	CHAR	40	0	District
7	REGIOGROUPADR	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
8	POSTL_COD1ADR	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
9	POSTL_COD2ADR	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
10	POSTL_COD3ADR	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
11	PCODE1_EXTADR	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
12	PCODE2_EXTADR	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
13	PCODE3_EXTADR	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
14	PO_BOXADR	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
15	PO_W_O_NOADR	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
16	PO_BOX_CITADR	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
17	PO_BOX_REGADR	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
18	POBOX_CTRYADR	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
19	STREETADR	☐	AD_STREET	TEXT60	CHAR	60	0	Street
20	STR_ABBRADR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	ADRSTRTYPE
21	HOUSE_NOADR	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
22	HOUSE_NO2ADR	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
23	HOUSE_NO3ADR	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
24	STR_SUPPL1ADR	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
25	STR_SUPPL2ADR	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
26	STR_SUPPL3ADR	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
27	LOCATIONADR	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
28	BUILDINGADR	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
29	FLOORADR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
30	ROOM_NOADR	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
31	COUNTRYADR	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
32	REGIONADR	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
33	TIME_ZONEADR	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
34	TAXJURCODEADR	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
35	HOME_CITYADR	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
36	LANGUADR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
37	VALIDFROMDATEADR	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
38	VALIDTODATEADR	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
39	ADDRESSIDADR	☐	PIQADDRESSID	NUMC2	NUMC	2	0	Address Identification Number (ISR)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAPP_RELPADDR	COUNTRYADR	T005	LAND1	REF	1	CN
2	PIQAPP_RELPADDR	POBOX_CTRYADR	T005	LAND1	REF	C	CN
3	PIQAPP_RELPADDR	PO_BOX_REGADR	T005S	BLAND		C	CN
4	PIQAPP_RELPADDR	REGIOGROUPADR	ADRREGGRP	REGIOGROUP	REF	C	CN
5	PIQAPP_RELPADDR	REGIONADR	T005S	BLAND	REF	C	CN
6	PIQAPP_RELPADDR	STR_ABBRADR	ADRSTRTYPE	STRTYPEAB	REF	C	CN
7	PIQAPP_RELPADDR	TIME_ZONEADR	TTZZ	TZONE	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in