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

JSTSTRUPDA Table in SAP | IS-M/SD: Table for Upgrading Table JSTSTRPRO Table & Fields List

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

  • Table description : IS-M/SD: Table for Upgrading Table JSTSTRPRO
  • Module : IS-M-MD
  • Parent Module : IS
  • Package : JMDGEN
  • Software Component : IS-M
JSTSTRUPDA 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 JSTSTRUPDA 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
.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
.INCLUDEIS-PSD: Update Indicator for Postal Upgrade    
DBCODE_ALTDB Code for Structural ChangesDBCODEDBCODE
DBCODE_NEUDB Code for Structural ChangesDBCODEDBCODE
X_ADRESSENIS-M: Update indicator: relevant addresses revisedX_ADRESSENXFELD
X_STRUKTURIS-M: Update indicator, related structures revisedX_STRUKTURXFELD
X_POST_DBIS-M: Update indicator, postal DB editedX_POST_DBXFELD
.INCLUDEChange data for structural changes etc.    
.INCLUDEChange data: Standard references    
AENDNRBISChange Number for To-Date of Structural ChangeAENDNRBISAENDNR
AENDNRBISDDate of Change Number Used to Change To-DateAENDNRBISDAENDNRARTD
AENDNRABChange Number for From-Date of Structure ChangeAENDNRABAENDNR
AENDNRABDDate of Change Number Used to Change From-DateAENDNRABDAENDNRARTD
AENDNRINITInitiating Change NumberAENDNRINITAENDNR
AENDLFDNRISequence Number of Initiating Change NumberAENDLFDNRIAENDLFDNR
AENDNRAKTChange Number in ProcessAENDNRAKTAENDNR
AENDLFDNRASequence Number of Currently Operative Change NumberAENDLFDNRAAENDLFDNR
XAENDERStructure information being changed on other change numberXAENDERXFELD
XSTRUAKTIVStructure information inactiveXSTRUAKTIVXSTRUAKTIV
FCCODEFunction Control Code for Structure ChangesFCCODEFCCODE
DBCODEFREIDB Code for Structural ChangesDBCODEDBCODE
.INCLUDEChange data: Reassignment statements    
AENDNRVONChange Number Used for Transfer FROM Another AssignmentAENDNRVONAENDNR
AENDLFDNRVSequence Number of Change Number Used for TransferAENDLFDNRVAENDLFDNR
AENDNRNACHChange Number Used to Transfer to Another AssignmentAENDNRNACHAENDNR
AENDLFDNRNSequence Number of Change Number Used for TransferAENDLFDNRNAENDLFDNR
HNR1VON_ZUSIS-M: House Number From (Numerical)HNR1VONHAUSNUMMER
HNR2VON_ZUSIS-M/SD: Affix to First House Number (Alphanumeric)HNR2VONHNRZUSATZ
HNR1BIS_ZUSIS-M: House Numbers To (Numerical)HNR1BISHAUSNUMMER
HNR2BIS_ZUSIS-M/SD: Affix for Last House Number (Alphanumeric)HNR2BISHNRZUSATZ
.INCLU--APStructure for Additional Fields for Street CH    
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

JSTSTRUPDA related tables

TableNote
JSTSTRUPDAIS-M/SD: Table for Upgrading Table JSTSTRPRO
JSTALIASUPDAIS-M: Table for Upgrading Table JSTALIAS
P05_TTFM_TTYPETCSV Tax Table Check Report: Tax Table Type Text Table
SCTC_TESTTABL_1SCTC internal Test Table 1: Simple Table used as S-Table
SCTC_TESTTABL_1TCTC internal Test Table 1T: Text Table for Test Table 1
ACDELIVERYTAlert Configuration : Text Table for Delivery Table
ACTCMB_STXT_TABText table for the custmozing table for the status comb.
AGS_WORK_VIEW_TText table for table AGS_WORK_VIEW
AKB_CI_TABCHECKControl Table for Table Check with the Code Inspection
ALAVLWORKCCMS: Dummy Table for Config. Table Controls
AUTTABLOGTText Table for Customizing of Table Logging
AUT_C_TABLOGTAudit Trail (ILM): Text Table Customizing Table Log
AXT_CT_CHAR_UNBCheck table for char data type without text table
AXT_RUN_KEY_MAPTable Key Mapping Table (for parent - child relations)
AXT_RUT_CT_CHARCheck table for char data type without text table
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