PIQDB_NL_ADDR - Maintain GBA Address

Maintain GBA Address information is stored in SAP table PIQDB_NL_ADDR.
It is part of development package PMIQ_NL in software component IS-HER-CM-NL. This development package consists of objects that can be grouped under "Student Lifecycle Management - Netherlands".

Fields for table PIQDB_NL_ADDR

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	*
STUDENT	Student Number	X	PIQSTUDENT12	CHAR	24
USNAM	User Name		USNAM	CHAR	24	*
CPUDT	Day On Which Accounting Document Was Entered		CPUDT	DATS	16
CPUTM	Time of Entry		CPUTM	TIMS	12
.INCLUDE				BAPIBUS1006_ADDRESS	0
STANDARDADDRESS	Indicator: Address is standard address		BU_XDFADR	CHAR	2
C_O_NAME	c/o name		AD_NAME_CO	CHAR	80
CITY	City		AD_CITY1	CHAR	80
DISTRICT	District		AD_CITY2	CHAR	80
REGIOGROUP	Regional structure grouping		REGIOGROUP	CHAR	16	ADRREGGRP
POSTL_COD1	City postal code		AD_PSTCD1	CHAR	20
POSTL_COD2	PO Box Postal Code		AD_PSTCD2	CHAR	20
POSTL_COD3	Company Postal Code (for Large Customers)		AD_PSTCD3	CHAR	20
PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code		AD_PST1XT	CHAR	20
PCODE2_EXT	(Not Supported) PO Box Postal Code Extension		AD_PST2XT	CHAR	20
PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension		AD_PST3XT	CHAR	20
PO_BOX	PO Box		AD_POBX	CHAR	20
PO_W_O_NO	Flag: PO Box Without Number		AD_POBXNUM	CHAR	2
PO_BOX_CIT	PO Box city		AD_POBXLOC	CHAR	80
PO_BOX_REG	Region for PO Box (Country/Region, State, Province, ...)		AD_POBXREG	CHAR	6	T005S
POBOX_CTRY	PO Box of Country/Region		AD_POBXCTY	CHAR	6	T005
PO_CTRYISO	ISO Code of the Country/Region		INTCA	CHAR	4
STREET	Street		AD_STREET	CHAR	120
STR_ABBR	(Not Supported) Abbreviation of Street Name		AD_STRABBR	CHAR	4	ADRSTRTYPE
HOUSE_NO	House Number		AD_HSNM1	CHAR	20
HOUSE_NO2	House number supplement		AD_HSNM2	CHAR	20
HOUSE_NO3	(Not supported) House Number Range		AD_HSNM3	CHAR	20
STR_SUPPL1	Street 2		AD_STRSPP1	CHAR	80
STR_SUPPL2	Street 3		AD_STRSPP2	CHAR	80
STR_SUPPL3	Street 4		AD_STRSPP3	CHAR	80
LOCATION	Street 5		AD_LCTN	CHAR	80
BUILDING	Building (Number or Code)		AD_BLDNG	CHAR	40
FLOOR	Floor in building		AD_FLOOR	CHAR	20
ROOM_NO	Room or Apartment Number		AD_ROOMNUM	CHAR	20
COUNTRY	Country/Region Key		LAND1	CHAR	6	T005
COUNTRYISO	ISO Code of the Country/Region		INTCA	CHAR	4
REGION	Region (State, Province, County)		REGIO	CHAR	6	T005S
TIME_ZONE	Address time zone		AD_TZONE	CHAR	12	TTZZ
TAXJURCODE	Tax Jurisdiction		AD_TXJCD	CHAR	30
HOME_CITY	City (different from postal city)		AD_CITY3	CHAR	80
TRANSPZONE	Transportation zone to or from which the goods are delivered		LZONE	CHAR	20	*
LANGU	Language Key		SPRAS	LANG	2	*
LANGUISO	2-Character SAP Language Code		LAISO	CHAR	4
COMM_TYPE	Communication Method (Key) (Business Address Services)		AD_COMM	CHAR	6	*
EXTADDRESSNUMBER	Address number in external system		BU_ADEXT	CHAR	40
DONT_USE_P	PO Box Address Undeliverable Flag		AD_NO_USEP	CHAR	8	*
DONT_USE_S	Street Address Undeliverable Flag		AD_NO_USES	CHAR	8	*
MOVE_DATE	Date of Move		BU_MOVEDAT	DATS	16
MOVE_ADDRESS	Number of Move Target Address for Address Moves		BU_MOVE_ADDR	CHAR	20	*
VALIDFROMDATE	Validity Date (Valid From)		BU_DATFROM	DATS	16
VALIDTODATE	Validity Date (Valid To)		BU_DATTO	DATS	16
MOVE_ADDR_GUID	UUID in character form		SYSUUID_C	CHAR	64
CITY_NO	City code for city/street file		AD_CITYNUM	CHAR	24	*
DISTRCT_NO	District code for City and Street file		AD_CITYPNM	CHAR	16	*
CHCKSTATUS	City file test status		AD_CHECKST	CHAR	2
PBOXCIT_NO	City PO box code (City file)		AD_CIT2NUM	CHAR	24	*
STREET_NO	Street Number for City/Street File		AD_STRNUM	CHAR	24	*
HOMECITYNO	Different city for city/street file		AD_CITYHNM	CHAR	24	*
PO_BOX_LOBBY	PO Box Lobby		AD_PO_BOX_LBY	CHAR	80
DELI_SERV_TYPE	Type of Delivery Service		AD_DELIVERY_SERVICE_TYPE	CHAR	8	*
DELI_SERV_NUMBER	Number of Delivery Service		AD_DELIVERY_SERVICE_NUMBER	CHAR	20
COUNTY	County		AD_COUNTY	CHAR	80
COUNTY_NO	County code for county		AD_CNTYNUM	CHAR	16	*
TOWNSHIP	Township		AD_TOWNSHIP	CHAR	80
TOWNSHIP_NO	Township code for Township		AD_TWSHPNUM	CHAR	16	*