J_1SSTRKUN SAP (IS-M/SD CH/S: Assign Street Data for Individual Customers) Table details

Dictionary Type: Table
Description: IS-M/SD CH/S: Assign Street Data for Individual Customers




ABAP Code to SELECT data from J_1SSTRKUN
Related tables to J_1SSTRKUN
Access table J_1SSTRKUN




Table field list including key, data, relationships and ABAP select examples

J_1SSTRKUN is a standard SAP Table which is used to store IS-M/SD CH/S: Assign Street Data for Individual Customers data and is available within R/3 SAP systems depending on the version and release level.

The J_1SSTRKUN table consists of various fields, each holding specific information or linking keys about IS-M/SD CH/S: Assign Street Data for Individual Customers data available in SAP. These include ALORT (IS-M: City Number (Unique)), INT_NR (IS-M: PTT street number (CH)), KENNUNG (IS-M: CH/S: Customer-Specific Street Identifier), STRASSENNR (IS-M: Street Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP J_1SSTRKUN table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
LAND1Country Key LAND1CHAR3T005LAND1LND
ALORTIS-M: City Number (Unique) JALORTCHAR8JSTORTPROALPHAALORTJSO
INT_NRIS-M: PTT street number (CH) J_1SSTRPTTNUMC6NUM06
KENNUNGIS-M: CH/S: Customer-Specific Street Identifier J_1SKENNCHAR6J_1SKENN
STRASSENNRIS-M: Street Number STRASSENNRCHAR10JSTSTRPROALPHASTRASSENNRJSS
STRNRPTTIS-M: PTT street number (CH) J_1SSTRPTTNUMC6NUM06
STRARTIS-M: CH/S: Street Type J_1SSTRARTCHAR2J_1STJ1S3J_1SSTRART
PRAEPCODEIS-M: CH/S: Preposition Code J_1SPRPCODCHAR2J_1STJ1S2J_1SPRPCOD
SPRCODEIS-M: CH: Language Code J_1SSPRCODCHAR1J_1SC1
GRUNDPLZIS-M: CH: 4-Digit Basic Postal Code CH J_1SGPLZNUMC4J_1STJ1S1J_1SGPLZ
STRSTAMMIS-M: CH/S: Street Master J_1SSTRSTACHAR10J_1SC10
X_UPDATEIS-M: Processing indicator for J_1SSTRKUN (CH) J_1SBEARBCHAR1J_1SSTRKUN
SUCHFELDSSearch field for accessing postal structures w/o matchcode SUCHFELDCHAR40CHAR40
STR_NAME_KIS-M: Street Name (Short) STR_NAME_KCHAR25TEXT25
STR_NAME_LIS-M: Street Name (long) STR_NAME_LCHAR50TEXT50JSN
STR_NAME_GIS-M: Street name - upper case for matchcode STR_NAME_GCHAR50JYTNFJCHAR50_GJSN
STR_NAME_SIS-M: Street Name (Long Without Special Characters) STR_NAME_SCHAR50CHAR50
OTL_KEYIS-M: City District Number OTL_KEYCHAR3Assigned to domainALPHAOTL_KEY
KREISG_SCHIS-M: District Municipality Key KREISG_SCHCHAR15Assigned to domainALPHAKREISG_SCH
HNRKENNIS-M: Identifier for House Number Range HNRKENNCHAR1HAUSNRKENN
HNR1VONIS-M: House Number From (Numerical) HNR1VONCHAR10HAUSNUMMER
HNR2VONIS-M/SD: Affix to First House Number (Alphanumeric) HNR2VONCHAR8HNRZUSATZ
HNR1BISIS-M: House Numbers To (Numerical) HNR1BISCHAR10HAUSNUMMER
HNR2BISIS-M/SD: Affix for Last House Number (Alphanumeric) HNR2BISCHAR8HNRZUSATZ
PLZ_ZSTRIS-M: Postal Code of Street Section for Home Delivery PLZ_ZSTRCHAR10Assigned to domainNPSTLZ
STR_NRPOSTIS-M: Street number from German postal service STR_NRPOSTCHAR15ALPHASTR_NRPOST
STRHNR1000IS-M: 1000 column in house number interval STRHNR1000CHAR1STRHNR1000
STR_CODEIS-M: Street code for coding street sections STR_CODECHAR3ALPHASTR_CODE
X_FEHLERIS-M: Incorrect data record X_FEHLERCHAR1ANKREUZ
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT
VERSION_JIS-M: Version year VERSION_JNUMC4JAHR
VERSION_MIS-M: Version month VERSION_MNUMC2AM_MONAT
VERSION_TIS-M: Version day VERSION_TNUMC2AM_TAG
VERSION_NRIS-M: Version number VERSION_NRCHAR5Assigned to domainALPHAVERSION_NR
GUELTIGABValid-From Date GUELTIGVONDATS8DATUMJSA
GUELTIGBISValid-To Date GUELTIGBISDATS8DATUMJSB
LOESCH_VMDeletion Flag for Master Data in Media Sales & Distribution LOEVM_ISPCHAR1XFELD
PREDIRECTIONALPredirectional PREDIRECTIONALCHAR10TJS41DIRECTIONAL
SUFFIXABBREVSuffix to Street Name According to USPS SUFFIXABBREVCHAR4CHAR04
POSTDIRECTIONALPostdirectional POSTDIRECTIONALCHAR10TJS41DIRECTIONAL
RECORDTYPECODERecord Type in ZIP+4 File RECORDTYPECODECHAR1RECORDTYPECODE
CARRIERROUTEIDIndicates Whether Truck Routes are for Drop-Off or Delivery CARRIERROUTEIDCHAR4CHAR04
BUILDINGFIRMNAMEBuilding or Company Name BUILDINGFIRMNAMECHAR40TEXT40
ADDRSECABBREVIS-M: Secondary Address Text ADDRSECABBREVCHAR4TJS43ADDRSECABBREV
ADDRSECNUMLOWIS-M: Secondary Address Number (Lower Limit) ADDRSECNUMLOWCHAR8ALPHAADDRSECNUMBER
ADDRSECNUMHIGHIS-M: Secondary Address Number ADDRSECNUMHIGHCHAR8ALPHAADDRSECNUMBER
ADDRSECODDEVENIS-M: Odd/Even Indicator for Secondary Address Number ADDRSECODDEVENCHAR1ODDEVENCODE
ZIPADDONLOWIS-M: Extension of 5-digit ZIP code (lower limit) JZIPADDONLOWCHAR4CHAR4
ZIPADDONHIGHIS-M: Extension of 5-digit ZIP code (upper limit) JZIPADDONHIGHCHAR4CHAR4
LACSSTATUSINDLocatable Address Conversion Service (LACS) indicator LACSSTATUSINDCHAR1CHAR01
GOVTBLDGINDBuilding Type GOVTBLDGINDCHAR1GOVTBLDGINDICATOR
FINANCENOFinance Number; Required by USPS FINANCENOCHAR6CHAR06
STATEABBREVSTATE (State, Province, County) REGIOCHAR3T005SREGIO
COUNTYNOCounty Code COUNCCHAR3T005ECOUNC
CONGRDISTRICTNOCode for District in a Geographical Area CONGRDISTRICTNOCHAR2CHAR02
PREFCITYSTATEKEYCity Number from City State Product File CITYSTATEKEYCHAR6CHAR06
.INCLU--AP 0
STREETNAME_NENStreet Name (NEN Standard) STREETNAME_NENCHAR24TEXT24
STREETNAME_PTTStreet Name (PTT Standard) STREETNAME_PTTCHAR17CHAR17
SERIESINDICATORIndicator in PTT Postal Data: Street, Houseboat or Trailer SERIESINDICATORCHAR1SERIESINDICATOR
J_1SAENDERChange Number AENDNRCHAR9Assigned to domainALPHAAENDNRJARMJVAENDNR

Key field Non-key field



How do I retrieve data from SAP table J_1SSTRKUN using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_1SSTRKUN to SELECT all data from the table
DATA: WA_J_1SSTRKUN TYPE J_1SSTRKUN.

SELECT SINGLE *
FROM J_1SSTRKUN
INTO CORRESPONDING FIELDS OF WA_J_1SSTRKUN
WHERE...

How to access SAP table J_1SSTRKUN

Within an ECC or HANA version of SAP you can also view further information about J_1SSTRKUN and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!