JST_ORT_CONS is a SAP table coming under IS module and IS-M component.View details, Fields & related tables of JST_ORT_CONS in SAP.
- Table description : IS-M: Table for City Consolidation
- Module : IS-M-MD
- Parent Module : IS
- Package : JMDGEN
- 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 JST_ORT_CONS Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| LAND1_ALT | Country Key | LAND1 | LAND1 |
| ALORT_ALT | IS-M: City Number (Unique) | JALORT | ALORT |
| LAND1 | Country Key | LAND1 | LAND1 |
| ALORT | IS-M: City Number (Unique) | JALORT | ALORT |
| VERSION | |||
| ORT_STATUS | |||
| .INCLUDE | IS-PSD: Include with Attributes of Table JSTORTPRO | ||
| SUCHFELDO | Search field for accessing postal structures w/o matchcode | SUCHFELD | CHAR40 |
| ORT_NAME_K | IS-M: City Name (Short Text) | ORT_NAME_K | TEXT25 |
| ORT_NAME_L | IS-M: City name (long text) | ORT_NAME_L | TEXT50 |
| ORT_NAME_G | IS-M: City name in block capitals | ORT_NAME_G | JCHAR50_G |
| ORT_NAME_S | IS-M: City Name (Long Text, No Special Characters) | ORT_NAME_S | CHAR50 |
| ORTZUSA | IS-M: Affix for City Name | ORTZUSA | TEXT30 |
| KREISG_SCH | IS-M: District Municipality Key | KREISG_SCH | KREISG_SCH |
| HERKKZORT | IS-M: Origin Indicator for City | HERKZORT | HERKUNFTKZ |
| HERKKZSTR | IS-M: Origin Indicator for Street File | HERKZSTR | HERKUNFTKZ |
| XSTRMANUEL | IS-M: Additional Streets were Entered Manually | XSTRMANUEL | XFELD |
| 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 JSTORTPRO for US Country Version | ||
| CITYSTATEFACCODE | Type of Location Defined by the City Name | CITYSTATEFACCODE | CITYSTATEFACCODE |
| PREFCITYSTATEKEY | Preferred city number from city state product file | PREFCITYSTATEKEY | CHAR06 |
| PREFCITYSTNAME | Preferred city name | PREFCITYSTNAME | TEXT28 |
| CITYDELIND | Indicates Whether Carrier Routes Defined | CITYDELIND | CHAR01 |
| CARRRTESORTIND | Indicates Whether Price Reduction Possible for Letter Post | CARRRTESORTIND | CHAR01 |
| UNIQUEZIPIND | Indicates Whether or not ZIP Code is Unique | UNIQUEZIPIND | CHAR01 |
| FINANCENO | Finance Number; Required by USPS | FINANCENO | CHAR06 |
| STATEABBREV | Region (State, Province, County) | REGIO | REGIO |
| COUNTYNO | County Code | COUNC | COUNC |
| ORT_NAME_AL | IS-M: Alternative City Name | ORT_NAME_AL | TEXT50 |
| .INCLU--AP | Structure for Additional City Fields (NL) | ||
| CEBUCOCODE | Cebuco Code | CEBUCOCODE | CEBUCOCODE |
| CITYNAME_NEN | City Name (NEN Standard) | CITYNAME_NEN | CHAR24 |
| ORTNAMEALT | IS-M: City name (long text) | ORT_NAME_L | TEXT50 |
JST_ORT_CONS related tables
| Table | Note |
|---|---|
| JST_ORT_CONS | IS-M: Table for City Consolidation |
| JST_OTL_CONS | IS-M: Table for City District Consolidation |
| TF189A | Inactive Consolidation Units per Consolidation Group |
| ADRDIF_CT | City Difference Table for Quarterly Adjustment |
| ADRPCDCITY | Postal code/city: Assignment table |
| T5V01 | Table of postal codes (postal code/city) |
| T706_CITY_CD_46C | Table for Specifying the City Code/Community Code Number |
| T706_CITY_CODE | Table for Specifying the City Code/Community Code Number |
| A042 | Country/State/City/Customer Classif.3/Material Classif.3 |
| A292 | BR: ISS from SD: Ship-to-City |
| ADRCITYCCS | Division-Dependent Data for City |
| ADRCITYKON | Franch. Contracts for City |
| ADRCITYMRU | MRUs for City |
| CDBC_TAXJUR_CITY | Tax Jurisdiction codes by City |
| COMC_TAXJUR_CITY | Tax Jurisdiction codes by City |
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