Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

The following are recognized output fields that you can use in the output mapping for the Geocoder transform. The fields are listed alphabetically.
 

Name

Description

Assignment_Level

The level to which this transform matched the address to the data in the reference fields (directories). PRE: Primary Number Exact assigns to the exact location of the address; for example, 123 Main St. This is the most precise level of assignment. To obtain the PRE, you must map either the POI_Type input field or the Primary_Name and Primary_Number input fields.
PRI: Primary Number Interpolated assigns to the level of the address range; for example, 100-500 Main St.
L1-4: Locality1-4 assigns to the level of city, town, or suburb.
P1: Postcode1 assigns to the level of Postcode1.
P2P: Postcode2 Partial assigns the full Postcode1 and the first few characters of Postcode2.
PF: Postcode Full assigns to the level of Postcode1 and Postcode2, when available. |

Assignment_Level_Locality

The level to which this transform assigned the locality. L1-4: Returns up to 4 locality levels. L1 is the most general and L4 is the most specific.

Assignment_Level_Postcode

The level to which this transform assigns the Postcode. P1: Postcode1 assigns to the level of Postcode1.
P2P: Postcode2 Partial assigns the full Postcode1 and the first few characters of Postcode2.
PF: Postcode Full assigns to the level of Postcode1 and 2, when available.

Census_Tract_Block

The census tract and block numbering area code as defined by the government for reporting census information. Census tracts are small, relatively permanent statistical subdivisions of a county. Block numbering areas are small statistical subdivisions of a county for grouping and numbering blocks.

Census_Tract_Block _Prev

The census tract and block numbering area in the previous version of census data.

Census_Tract_Block_Group

The census tract and block group code as defined by the government for reporting census information. These codes are used for matching with demographic-coding databases. In the USA, the first six digits contain the tract number (for example, 002689); the first of the last four digits contains the BG number within the tract. The BG is a cluster of census blocks having the same first digit within a census tract. For example, BG 6 includes all blocks numbered from 6000 to 6999.

Census_Tract_Block_Group_Prev

The census tract and block group code in the previous version of census data.

Country_Code

The two-character ISO country code.

Distance

The distance from the input address, geographical coordinates, or point of interest to the closet address or point of interest.

Gov_County_Code

A unique county code as defined by the government for reporting census information. For example, in the USA, this is a Federal Information Processing Standard (FIPS) three-digit county code.

Gov_Locality1_Code

A unique code for an incorporated municipality such as a city, town, or locality as defined by the government for reporting census information.

Gov_Region1_Code

A unique region code as defined by the government for reporting census information. For example, in the USA, this is a Federal Information Processing Standard (FIPS) two-digit state code.

Info_Code

A three-character code that provides information about the geocoding results. The status for address and point-of-interest geocoding assignment is indicated in the third character. The status for reverse geocoding assignment is indicated in the second and third characters. If assigned to the best level, the Info_Code field is blank. The first character is not used at this time. 1: Reference data not available. The data for the input country is unavailable. Verify that the directory is installed and the reference path to the directory is valid.
2: Address data not available. When Best Assignment Level is set to Primary Number and the address directory is unavailable or doesn't exist, you see this code.
3: Centroid data not available. When Best Assignment Level is set to Locality or Postcode, and the address directory is unavailable or doesn't exist, you see this code.
4: Assignment is limited. When Best Assignment Level is set to Locality or Postcode, and the input record is insufficient or incorrect, you see this code. The assignment may be made to a lower assignment level than the one specified. For example, if you choose Primary Number, and the Primary Number field is blank, you see this code; and the assignment may be at the Postcode or Locality level, if the data is available.
5: No data match. When the input record does not match the directory data for the Best Assignment Level, you see this code.
6: Ambiguous assignment. There is a tie for the Best Assignment Level.
7: Invalid input. Either the data is blank or invalid.
8: Insufficient input data. When the input data for the selected Best Assignment Level is blank, you see this code. For example, you see this code when you set the Best Assignment Level to Primary Number and the input data is blank for Primary Number.
9: Invalid POI_Type input.
A: No POI input data used.
B: Reference point not found.
C: Not all results returned, because the number of results exceed the specified Max_Record.
D: Not all results returned, because the results exceed the field length available in the Result_List XML output field.

Latitude

The latitude at the best assigned level (0-90 degrees north or south of the equator) in the format 45.32861.

Latitude_Locality

The latitude at the locality level centroid of the city, town, locality, or suburb in the format 45.32861.

Latitude_Postcode

The latitude at the Postcode level centroid of the Postcode in the format 45.32861.

Latitude_Primary_Number

The latitude at the primary number level centroid of the primary number in the format 45.32861.

Locality1--4

The city, town, or suburb and any additional related information.

Longitude

The longitude at the best assigned level (0-180 degrees east or west of Greenwich meridian) in the format 123.45833.

Longitude_Locality

The longitude at the locality level centroid of the city, town, locality, or suburb in the format 123.45833.

Longitude_Postcode

The longitude at the Postcode level centroid of the Postcode in the format 123.45833.

Longitude_Primary_Number

The longitude at the primary number level centroid of the primary number in the format 123.45833.

Metro_Stat_Area_Code

The metropolitan statistical area. For example, in the USA, the 0000 code indicates the address does not lie in a metropolitan statistical area; usually a rural area. A metropolitan statistical area has a large population that has a high degree of social and economic integration with the core of the area. The area is defined by the government for reporting census information.

Metro_Stat_Area_Code_Prev

The metropolitan statistical area in the previous version of census data.

Minor_Div_Code

The minor civil division or census county division code when the minor civil division is not available. The minor civil division designates the primary government and/or administrative divisions of a county such as a civil township or precinct. Census county division are defined in a state or province that does not have a well-defined minor civil division. The area is defined by the government for reporting census information.

Minor_Div_Code_Prev

The minor civil division or census county division code in the previous version of census data.

POI_Name

The point of interest name, such as the Washington Monument.

POI_Type

The point of interest type expressed as a four-digit number; for example, 5999 (historical monument).

Population_Class_Locality1

Indicates that the population falls within a certain size. 0: Undefined. The population may be too large or small to provide accurate data.
1: Over 1 million.
2: 500,000 to 999,9999.
3: 100,000 to 499,999.
4: 50,000 to 99,999.
5: 10,000 to 49,999.
6: Less than 10,000.

Postcode1--2

The postal code and a secondary postal code, if available.

Primary_Name1--4

The street name.

Primary_Number

The premise number.

Primary_Postfix1

Abbreviated directional (N, S, NW, SE) that follows a street name.

Primary_Prefix1

Abbreviated directional (N, S, NW, SE) that precedes a street name.

Primary_Range_High

The high value of a primary number range.

Primary_Range_Low

The low value of a primary number range.

Primary_Type1--4

Abbreviated type of primary name (St., Ave., or Pl.).

Ranking

A numberic value that indicates how well the returned records match the input field based on the match score. A record with a ranking of 1 has the highest match score.

Region1--2

The region symbol of the state, province, or territory.

Result_List

The XML output when multiple records are returned for a search.

Result_List_Count

The number of results in the Result_List output field.

Side_Of_Primary_Address

Indicates that the location is on the L (left) or R (right) side of the street when moving north, northeast, northwest or east.

Stat_Area_Code

A core based statistical area code where an area has a high degree of social and economic integration within the core that the area surrounds. The area is defined by the government for reporting census information.

Stat_Area_Code_Prev

The statistical area code in the previous version of census data.


 Geocoder Transform
  • No labels