SAP Table USATOWNS - All Cities in the USA

Field Key Data Element Type Offset Leng Decimals Check Table Text
CLIENT X MANDT CLNT 0 3 0 T000 Client
GUIDTOWN X GEOGUID RAW 3 16 0 GUID 16
LAND1 LAND1 CHAR 19 3 0 T005 Country Key
ZIPCODE CHAR5 CHAR 22 5 0 R/2 table
CITYNAME CHAR30 CHAR 27 30 0 30 Characters
REGION CHAR2 CHAR 57 2 0 Version Number Component
AREACODE CHAR3 CHAR 59 3 0 3-Byte field
COUNTYNAME CHAR30 CHAR 62 30 0 30 Characters
PREFERRED CHAR1 CHAR 92 1 0 Single-Character Indicator
GUIDOBJR GEOGUID RAW 93 16 0 GUID 16