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
Here is some free PDF files that you can download free for your reference.
Download Now
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
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
STRNRPTT | IS-M: PTT street number (CH) | J_1SSTRPTT | NUM06 |
TABELLE | CH Postal Upgrade Table | J_1SUPDATAB | J_1SUPDATAB |
FUNCTION | CH Postal Upgrade Functions | J_1SUPDAFUNC | J_1SUPDAFUNC |
LAUFNR | Character field of length 6 | CHAR006 | CHAR006 |
USERFUNC | CH Postal Upgrade Functions | J_1SUPDAFUNC | J_1SUPDAFUNC |
LAND1_ALT | Country Key | LAND1 | LAND1 |
ALORT_ALT | IS-M: City Number (Unique) | JALORT | ALORT |
STRNR_ALT | IS-M: Street Number | STRASSENNR | STRASSENNR |
HNRKENNALT | IS-M: Identifier for House Number Range | HNRKENN | HAUSNRKENN |
HNR1VONALT | IS-M: House Number From (Numerical) | HNR1VON | HAUSNUMMER |
HNR2VONALT | IS-M/SD: Affix to First House Number (Alphanumeric) | HNR2VON | HNRZUSATZ |
HNR1BISALT | IS-M: House Numbers To (Numerical) | HNR1BIS | HAUSNUMMER |
HNR2BISALT | IS-M/SD: Affix for Last House Number (Alphanumeric) | HNR2BIS | HNRZUSATZ |
LAND1 | Country Key | LAND1 | LAND1 |
ALORT | IS-M: City Number (Unique) | JALORT | ALORT |
STRASSENNR | IS-M: Street Number | STRASSENNR | STRASSENNR |
.INCLUDE | IS-PSD: Include with Attributes of Table JSTSTRPRO | ||
SUCHFELDS | Search field for accessing postal structures w/o matchcode | SUCHFELD | CHAR40 |
STR_NAME_K | IS-M: Street Name (Short) | STR_NAME_K | TEXT25 |
STR_NAME_L | IS-M: Street Name (long) | STR_NAME_L | TEXT50 |
STR_NAME_G | IS-M: Street name - upper case for matchcode | STR_NAME_G | JCHAR50_G |
STR_NAME_S | IS-M: Street Name (Long Without Special Characters) | STR_NAME_S | CHAR50 |
OTL_KEY | IS-M: City District Number | OTL_KEY | OTL_KEY |
KREISG_SCH | IS-M: District Municipality Key | KREISG_SCH | KREISG_SCH |
HNRKENN | IS-M: Identifier for House Number Range | HNRKENN | HAUSNRKENN |
HNR1VON | IS-M: House Number From (Numerical) | HNR1VON | HAUSNUMMER |
HNR2VON | IS-M/SD: Affix to First House Number (Alphanumeric) | HNR2VON | HNRZUSATZ |
HNR1BIS | IS-M: House Numbers To (Numerical) | HNR1BIS | HAUSNUMMER |
HNR2BIS | IS-M/SD: Affix for Last House Number (Alphanumeric) | HNR2BIS | HNRZUSATZ |
PLZ_ZSTR | IS-M: Postal Code of Street Section for Home Delivery | PLZ_ZSTR | NPSTLZ |
STR_NRPOST | IS-M: Street number from German postal service | STR_NRPOST | STR_NRPOST |
STRHNR1000 | IS-M: 1000 column in house number interval | STRHNR1000 | STRHNR1000 |
STR_CODE | IS-M: Street code for coding street sections | STR_CODE | STR_CODE |
X_FEHLER | IS-M: Incorrect data record | X_FEHLER | ANKREUZ |
.INCLUDE | Created-By Data (Medium Scope) | ||
ERFUSER | Created By | ERFUSER | USNAM |
ERFDATE | Created On | ERFDATE | DATUM |
ERFTIME | Time Created | ERFTIME | UZEIT |
AENUSER | Last Changed By | AENUSER | USNAM |
AENDATE | Date of Last Change | AENDATE | DATUM |
AENTIME | Time of Last Change | AENTIME | UZEIT |
.INCLUDE | Version (for upgrade procedures for postal data) | ||
VERSION_J | IS-M: Version year | VERSION_J | JAHR |
VERSION_M | IS-M: Version month | VERSION_M | AM_MONAT |
VERSION_T | IS-M: Version day | VERSION_T | AM_TAG |
VERSION_NR | IS-M: Version number | VERSION_NR | VERSION_NR |
GUELTIGAB | Valid-From Date | GUELTIGVON | DATUM |
GUELTIGBIS | Valid-To Date | GUELTIGBIS | DATUM |
LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | XFELD |
.INCLUDE | IS-M: Additional Fields in JSTSTRPRO for US Country Version | ||
PREDIRECTIONAL | Predirectional | PREDIRECTIONAL | DIRECTIONAL |
SUFFIXABBREV | Suffix to Street Name According to USPS | SUFFIXABBREV | CHAR04 |
POSTDIRECTIONAL | Postdirectional | POSTDIRECTIONAL | DIRECTIONAL |
RECORDTYPECODE | Record Type in ZIP+4 File | RECORDTYPECODE | RECORDTYPECODE |
CARRIERROUTEID | Indicates Whether Truck Routes are for Drop-Off or Delivery | CARRIERROUTEID | CHAR04 |
BUILDINGFIRMNAME | Building or Company Name | BUILDINGFIRMNAME | TEXT40 |
.INCLUDE | IS-M: Structure for Enhanced Address Data | ||
.INCLUDE | Secondary Address (Without ZIP Add-On) | ||
ADDRSECABBREV | IS-M: Secondary Address Text | ADDRSECABBREV | ADDRSECABBREV |
ADDRSECNUMLOW | IS-M: Secondary Address Number (Lower Limit) | ADDRSECNUMLOW | ADDRSECNUMBER |
ADDRSECNUMHIGH | IS-M: Secondary Address Number | ADDRSECNUMHIGH | ADDRSECNUMBER |
ADDRSECODDEVEN | IS-M: Odd/Even Indicator for Secondary Address Number | ADDRSECODDEVEN | ODDEVENCODE |
ZIPADDONLOW | IS-M: Extension of 5-digit ZIP code (lower limit) | JZIPADDONLOW | CHAR4 |
ZIPADDONHIGH | IS-M: Extension of 5-digit ZIP code (upper limit) | JZIPADDONHIGH | CHAR4 |
LACSSTATUSIND | Locatable Address Conversion Service (LACS) indicator | LACSSTATUSIND | CHAR01 |
GOVTBLDGIND | Building Type | GOVTBLDGIND | GOVTBLDGINDICATOR |
FINANCENO | Finance Number; Required by USPS | FINANCENO | CHAR06 |
STATEABBREV | Region (State, Province, County) | REGIO | REGIO |
COUNTYNO | County Code | COUNC | COUNC |
CONGRDISTRICTNO | Code for District in a Geographical Area | CONGRDISTRICTNO | CHAR02 |
PREFCITYSTATEKEY | City Number from City State Product File | CITYSTATEKEY | CHAR06 |
.INCLU--AP | Structure for Additional Street Fields (NL) | ||
STREETNAME_NEN | Street Name (NEN Standard) | STREETNAME_NEN | TEXT24 |
STREETNAME_PTT | Street Name (PTT Standard) | STREETNAME_PTT | CHAR17 |
SERIESINDICATOR | Indicator in PTT Postal Data: Street, Houseboat or Trailer | SERIESINDICATOR | SERIESINDICATOR |
STRART | IS-M: CH/S: Street Type | J_1SSTRART | J_1SSTRART |
PRAEPCODE | IS-M: CH/S: Preposition Code | J_1SPRPCOD | J_1SPRPCOD |
SPRCODE | IS-M: CH: Language Code | J_1SSPRCOD | J_1SC1 |
GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | J_1SGPLZ | J_1SGPLZ |
STRSTAMM | IS-M: CH/S: Street Master | J_1SSTRSTA | J_1SC10 |
ERWPLZ | 2-Digit Postal Code Extension CH | ERWPLZ | ERW_PLZ |
J_1SSUPBESTAND related tables
Table | Note |
---|---|
J_1SPUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet |
J_1SSUPBESTAND | IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet |
JST_PDU_STATE | Status Table for Postal Data Upgrade |
DMC_IU_SYS_DATA | MWB - Integrated Upgrade: system data for upgrade |
T5V01 | Table of postal codes (postal code/city) |
DMC_IU_HDR | MWB Upgrade: Header Table for Integrated Upgrade |
A496 | Postal Charges for Postal Dist.Items (Publication Frequency) |
A497 | Postal Charges (Postal Package Type) |
A498 | Postal Charges (Postal Package Type, Type Variant) |
J_1SBUNDA | IS-M/SD CH/V: Postal Pack Addrs for Foreign Postal Shipping |
TJI25 | IS-M/SD: Assgmt of Postal Codes to Postal Code Eval.Areas |
/MRSS/C_ZIPA_DT | Postal Code Areas: Postal Code Assignment |
DMC_IU_BUFFER | MWB-Upgrade: Extract from Upgrade Buffer Files |
DMC_IU_CLIENTUPG | MWB Upgrade: Administration of Integrated Upgrade |
DMC_IU_PLIST | MWB Upgrade: Object List for an Integrated Upgrade |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP