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

J_1SSUPBESTAND Table in SAP | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet Table & Fields List

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

  • Table description : IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet
  • Module : IS-M
  • Parent Module : IS
  • Package : J1SC
  • Software Component : IS-M
J_1SSUPBESTAND 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 J_1SSUPBESTAND Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
STRNRPTTIS-M: PTT street number (CH)J_1SSTRPTTNUM06
TABELLECH Postal Upgrade TableJ_1SUPDATABJ_1SUPDATAB
FUNCTIONCH Postal Upgrade FunctionsJ_1SUPDAFUNCJ_1SUPDAFUNC
LAUFNRCharacter field of length 6CHAR006CHAR006
USERFUNCCH Postal Upgrade FunctionsJ_1SUPDAFUNCJ_1SUPDAFUNC
LAND1_ALTCountry KeyLAND1LAND1
ALORT_ALTIS-M: City Number (Unique)JALORTALORT
STRNR_ALTIS-M: Street NumberSTRASSENNRSTRASSENNR
HNRKENNALTIS-M: Identifier for House Number RangeHNRKENNHAUSNRKENN
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
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
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
STRSTAMMIS-M: CH/S: Street MasterJ_1SSTRSTAJ_1SC10
ERWPLZ2-Digit Postal Code Extension CHERWPLZERW_PLZ

J_1SSUPBESTAND related tables

TableNote
J_1SPUPBESTANDIS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet
J_1SSUPBESTANDIS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet
JST_PDU_STATEStatus Table for Postal Data Upgrade
DMC_IU_SYS_DATAMWB - Integrated Upgrade: system data for upgrade
T5V01Table of postal codes (postal code/city)
DMC_IU_HDRMWB Upgrade: Header Table for Integrated Upgrade
A496Postal Charges for Postal Dist.Items (Publication Frequency)
A497Postal Charges (Postal Package Type)
A498Postal Charges (Postal Package Type, Type Variant)
J_1SBUNDAIS-M/SD CH/V: Postal Pack Addrs for Foreign Postal Shipping
TJI25IS-M/SD: Assgmt of Postal Codes to Postal Code Eval.Areas
/MRSS/C_ZIPA_DTPostal Code Areas: Postal Code Assignment
DMC_IU_BUFFERMWB-Upgrade: Extract from Upgrade Buffer Files
DMC_IU_CLIENTUPGMWB Upgrade: Administration of Integrated Upgrade
DMC_IU_PLISTMWB Upgrade: Object List for an Integrated Upgrade
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