SAP ABAP Table NLADR (REPER Address Data (Return Structure for Addresses))
Hierarchy
☛ SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
   ⤷ PA-PA-NL (Application Component) Netherlands
     ⤷ PB05 (Package) HR Master Data: Netherlands
Basic Data
Table Category INTTAB    Structure 
Structure NLADR   Table Relationship Diagram
Short Description REPER Address Data (Return Structure for Addresses)    
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 .INCLUDE       0   0   Address selection parameter  
2 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
3 ADDRHANDLE AD_HANDLE TEXT140 CHAR 140   0   Handle for Creating Addresses/Persons (Bus. Addr. Services)  
4 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses *
5 DATE AD_DATE DATUM DATS 8   0   Date referred to  
6 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
7 DATE_TO AD_DATE_TO DATUM DATS 8   0   Valid-to date in current Release only 99991231 possible  
8 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
9 KNAAM AD_NAME1 TEXT40 CHAR 40   0   Name 1  
10 LNAAM AD_NAME2 TEXT40 CHAR 40   0   Name 2  
11 AFDLG AD_NAME3 TEXT40 CHAR 40   0   Name 3  
12 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
13 NAME_TXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
14 KPERS AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
15 ORT01 AD_CITY1 TEXT40 CHAR 40   0   City  
16 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
17 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
18 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
19 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
20 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file ADRCITY
21 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
22 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
23 PSTLZ AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
24 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
25 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
26 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
27 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
28 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
29 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
30 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
31 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
32 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
33 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
34 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
35 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
36 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
37 STRAS AD_STREET TEXT60 CHAR 60   0   Street  
38 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
39 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
40 HSNMR AD_HSNM1 TEXT10 CHAR 10   0   House Number  
41 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
42 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
43 LOCAT AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
44 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
45 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
46 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
47 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
48 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
49 POSTA AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
50 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
51 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
52 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
53 SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
54 SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
55 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
56 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) TSAD6
57 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
58 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
59 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
60 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
61 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
62 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
63 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language T002
64 DEFLT_COMM AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) TSAC
65 TELNR AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
66 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
67 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
68 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
69 ADDR_GROUP AD_GROUP AD_GROUP CHAR 4   0   Address Group (Key) (Business Address Services) *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 NLADR ADDRORIGIN TSAD6 ORIGIN REF C CN
2 NLADR CITYH_CODE ADRCITY CITY_CODE REF C CN
3 NLADR CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
4 NLADR CITY_CODE ADRCITY CITY_CODE REF C CN
5 NLADR CITY_CODE2 ADRCITY CITY_CODE REF C CN
6 NLADR COUNTRY T005 LAND1 REF C CN
7 NLADR DEFLT_COMM TSAC COMM_TYPE REF C CN
8 NLADR LANGU T002 SPRAS REF C CN
9 NLADR LANGU_CREA T002 SPRAS REF C CN
10 NLADR PO_BOX_CTY T005 LAND1 REF C CN
11 NLADR PO_BOX_REG T005S BLAND REF C CN
12 NLADR REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
13 NLADR REGION T005S BLAND REF C CN
14 NLADR STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
15 NLADR STREETCODE ADRSTREET STRT_CODE REF C CN
16 NLADR TIME_ZONE TTZZ TZONE REF C CN
17 NLADR TITLE TSAD3 TITLE REF C CN
18 NLADR TRANSPZONE TZONE ZONE1 REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 46C