SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

JST_STR_CONS Table in SAP | IS-M: Table for Street Consolidation Table & Fields List

JST_STR_CONS is a SAP table coming under IS module and IS-M component.View details, Fields & related tables of JST_STR_CONS in SAP.

  • Table description : IS-M: Table for Street Consolidation
  • Module : IS-M-MD
  • Parent Module : IS
  • Package : JMDGEN
  • Software Component : IS-M
JST_STR_CONS table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP JST_STR_CONS Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
LAND1_ALTCountry KeyLAND1LAND1
ALORT_ALTIS-M: City Number (Unique)JALORTALORT
STRNR_ALTIS-M: Street NumberSTRASSENNRSTRASSENNR
LAND1Country KeyLAND1LAND1
ALORTIS-M: City Number (Unique)JALORTALORT
STRASSENNRIS-M: Street NumberSTRASSENNRSTRASSENNR
VERSION   
STR_STATUS   
.INCLUDEIS-PSD: Include with Attributes of Table JSTSTRPRO    
SUCHFELDSSearch field for accessing postal structures w/o matchcodeSUCHFELDCHAR40
STR_NAME_KIS-M: Street Name (Short)STR_NAME_KTEXT25
STR_NAME_LIS-M: Street Name (long)STR_NAME_LTEXT50
STR_NAME_GIS-M: Street name - upper case for matchcodeSTR_NAME_GJCHAR50_G
STR_NAME_SIS-M: Street Name (Long Without Special Characters)STR_NAME_SCHAR50
OTL_KEYIS-M: City District NumberOTL_KEYOTL_KEY
KREISG_SCHIS-M: District Municipality KeyKREISG_SCHKREISG_SCH
HNRKENNIS-M: Identifier for House Number RangeHNRKENNHAUSNRKENN
HNR1VONIS-M: House Number From (Numerical)HNR1VONHAUSNUMMER
HNR2VONIS-M/SD: Affix to First House Number (Alphanumeric)HNR2VONHNRZUSATZ
HNR1BISIS-M: House Numbers To (Numerical)HNR1BISHAUSNUMMER
HNR2BISIS-M/SD: Affix for Last House Number (Alphanumeric)HNR2BISHNRZUSATZ
PLZ_ZSTRIS-M: Postal Code of Street Section for Home DeliveryPLZ_ZSTRNPSTLZ
STR_NRPOSTIS-M: Street number from German postal serviceSTR_NRPOSTSTR_NRPOST
STRHNR1000IS-M: 1000 column in house number intervalSTRHNR1000STRHNR1000
STR_CODEIS-M: Street code for coding street sectionsSTR_CODESTR_CODE
X_FEHLERIS-M: Incorrect data recordX_FEHLERANKREUZ
.INCLUDECreated-By Data (Medium Scope)    
ERFUSERCreated ByERFUSERUSNAM
ERFDATECreated OnERFDATEDATUM
ERFTIMETime CreatedERFTIMEUZEIT
AENUSERLast Changed ByAENUSERUSNAM
AENDATEDate of Last ChangeAENDATEDATUM
AENTIMETime of Last ChangeAENTIMEUZEIT
.INCLUDEVersion (for upgrade procedures for postal data)    
VERSION_JIS-M: Version yearVERSION_JJAHR
VERSION_MIS-M: Version monthVERSION_MAM_MONAT
VERSION_TIS-M: Version dayVERSION_TAM_TAG
VERSION_NRIS-M: Version numberVERSION_NRVERSION_NR
GUELTIGABValid-From DateGUELTIGVONDATUM
GUELTIGBISValid-To DateGUELTIGBISDATUM
LOESCH_VMDeletion Flag for Master Data in Media Sales & DistributionLOEVM_ISPXFELD
.INCLUDEIS-M: Additional Fields in JSTSTRPRO for US Country Version    
PREDIRECTIONALPredirectionalPREDIRECTIONALDIRECTIONAL
SUFFIXABBREVSuffix to Street Name According to USPSSUFFIXABBREVCHAR04
POSTDIRECTIONALPostdirectionalPOSTDIRECTIONALDIRECTIONAL
RECORDTYPECODERecord Type in ZIP+4 FileRECORDTYPECODERECORDTYPECODE
CARRIERROUTEIDIndicates Whether Truck Routes are for Drop-Off or DeliveryCARRIERROUTEIDCHAR04
BUILDINGFIRMNAMEBuilding or Company NameBUILDINGFIRMNAMETEXT40
.INCLUDEIS-M: Structure for Enhanced Address Data    
.INCLUDESecondary Address (Without ZIP Add-On)    
ADDRSECABBREVIS-M: Secondary Address TextADDRSECABBREVADDRSECABBREV
ADDRSECNUMLOWIS-M: Secondary Address Number (Lower Limit)ADDRSECNUMLOWADDRSECNUMBER
ADDRSECNUMHIGHIS-M: Secondary Address NumberADDRSECNUMHIGHADDRSECNUMBER
ADDRSECODDEVENIS-M: Odd/Even Indicator for Secondary Address NumberADDRSECODDEVENODDEVENCODE
ZIPADDONLOWIS-M: Extension of 5-digit ZIP code (lower limit)JZIPADDONLOWCHAR4
ZIPADDONHIGHIS-M: Extension of 5-digit ZIP code (upper limit)JZIPADDONHIGHCHAR4
LACSSTATUSINDLocatable Address Conversion Service (LACS) indicatorLACSSTATUSINDCHAR01
GOVTBLDGINDBuilding TypeGOVTBLDGINDGOVTBLDGINDICATOR
FINANCENOFinance Number; Required by USPSFINANCENOCHAR06
STATEABBREVRegion (State, Province, County)REGIOREGIO
COUNTYNOCounty CodeCOUNCCOUNC
CONGRDISTRICTNOCode for District in a Geographical AreaCONGRDISTRICTNOCHAR02
PREFCITYSTATEKEYCity Number from City State Product FileCITYSTATEKEYCHAR06
.INCLU--APStructure for Additional Street Fields (NL)    
STREETNAME_NENStreet Name (NEN Standard)STREETNAME_NENTEXT24
STREETNAME_PTTStreet Name (PTT Standard)STREETNAME_PTTCHAR17
SERIESINDICATORIndicator in PTT Postal Data: Street, Houseboat or TrailerSERIESINDICATORSERIESINDICATOR
ST_NAMEALTIS-M: Street Name (long)STR_NAME_LTEXT50
STR_NRPALTIS-M: Street number from German postal serviceSTR_NRPOSTSTR_NRPOST
HNRKENNALTIS-M: Identifier for House Number RangeHNRKENNHAUSNRKENN
HNR1000ALTIS-M: 1000 column in house number intervalSTRHNR1000STRHNR1000
HNR1VONALTIS-M: House Number From (Numerical)HNR1VONHAUSNUMMER
HNR2VONALTIS-M/SD: Affix to First House Number (Alphanumeric)HNR2VONHNRZUSATZ
HNR1BISALTIS-M: House Numbers To (Numerical)HNR1BISHAUSNUMMER
HNR2BISALTIS-M/SD: Affix for Last House Number (Alphanumeric)HNR2BISHNRZUSATZ
STRNRPTTIS-M: PTT street number (CH)J_1SSTRPTTNUM06
STRARTIS-M: CH/S: Street TypeJ_1SSTRARTJ_1SSTRART
PRAEPCODEIS-M: CH/S: Preposition CodeJ_1SPRPCODJ_1SPRPCOD
SPRCODEIS-M: CH: Language CodeJ_1SSPRCODJ_1SC1
GRUNDPLZIS-M: CH: 4-Digit Basic Postal Code CHJ_1SGPLZJ_1SGPLZ
ERWPLZ2-Digit Postal Code Extension CHERWPLZERW_PLZ
STRSTAMMIS-M: CH/S: Street MasterJ_1SSTRSTAJ_1SC10

JST_STR_CONS related tables

TableNote
JST_STR_CONSIS-M: Table for Street Consolidation
TF189AInactive Consolidation Units per Consolidation Group
ADRDIF_STStreet Difference Table for Quarterly Adjustment
EWM_ELWEG_INDEXIndex Table for Street Route
JSTSTRDAVERWReference Table for Street Records from DBP
A360Location / Service type / Material - Street price
A361LocationID/Material - Street price
ADRSTRCONVConversion of Street Sections
ADRSTRPCDStreet (section)/postal code: Assignment
ADRSTRTCCSDivision-Dependent Data for Street
ADRSTRTISUIS-U Applic. Data for Street
ADRSTRTKONFranchise Contracts for Street
ADRSTRTMRUMRUs for Street
ADRSTRTYPEStreet type
ADRSTRTYPTStreet type (long texts)
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com