SAP ABAP Table M_MJSSC (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure M_MJSSC   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 ORT_NAME_G ORT_NAME_G JCHAR50_G CHAR 50   0   IS-M: City name in block capitals  
2 STR_NAME_G STR_NAME_G JCHAR50_G CHAR 50   0   IS-M: Street name - upper case for matchcode  
3 HNRKENN HNRKENN HAUSNRKENN CHAR 1   0   IS-M: Identifier for House Number Range  
4 HNR1VON HNR1VON HAUSNUMMER CHAR 10   0   IS-M: House Number From (Numerical)  
5 HNR2VON HNR2VON HNRZUSATZ CHAR 8   0   IS-M/SD: Affix to First House Number (Alphanumeric)  
6 HNR1BIS HNR1BIS HAUSNUMMER CHAR 10   0   IS-M: House Numbers To (Numerical)  
7 HNR2BIS HNR2BIS HNRZUSATZ CHAR 8   0   IS-M/SD: Affix for Last House Number (Alphanumeric)  
8 PLZ_ZSTR PLZ_ZSTR NPSTLZ CHAR 10   0   IS-M: Postal Code of Street Section for Home Delivery JSTPLZPRO
9 STRHNR1000 STRHNR1000 STRHNR1000 CHAR 1   0   IS-M: 1000 column in house number interval  
10 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
11 ALORT JALORT ALORT CHAR 8   0   IS-M: City Number (Unique) JSTORTPRO
12 STRASSENNR STRASSENNR STRASSENNR CHAR 10   0   IS-M: Street Number  
13 ORTZUSA ORTZUSA TEXT30 CHAR 30   0   IS-M: Affix for City Name  
14 KREISG_SCH KREISG_SCH KREISG_SCH CHAR 15   0   IS-M: District Municipality Key JSTKGSPRO
15 GUELTIGAB GUELTIGVON DATUM DATS 8   0   Valid-From Date  
16 GUELTIGBIS GUELTIGBIS DATUM DATS 8   0   Valid-To Date  
17 LOESCH_VM LOEVM_ISP XFELD CHAR 1   0   Deletion Flag for Master Data in Media Sales & Distribution  
18 PREDIRECTIONAL PREDIRECTIONAL DIRECTIONAL CHAR 10   0   Predirectional TJS41
19 SUFFIXABBREV SUFFIXABBREV CHAR04 CHAR 4   0   Suffix to Street Name According to USPS  
20 POSTDIRECTIONAL POSTDIRECTIONAL DIRECTIONAL CHAR 10   0   Postdirectional TJS41
21 RECORDTYPECODE RECORDTYPECODE RECORDTYPECODE CHAR 1   0   Record Type in ZIP+4 File  
22 ADDRSECABBREV ADDRSECABBREV ADDRSECABBREV CHAR 4   0   IS-M: Secondary Address Text TJS43
23 ADDRSECNUMLOW ADDRSECNUMLOW ADDRSECNUMBER CHAR 8   0   IS-M: Secondary Address Number (Lower Limit)  
24 ADDRSECNUMHIGH ADDRSECNUMHIGH ADDRSECNUMBER CHAR 8   0   IS-M: Secondary Address Number  
25 ADDRSECODDEVEN ADDRSECODDEVEN ODDEVENCODE CHAR 1   0   IS-M: Odd/Even Indicator for Secondary Address Number  
26 ZIPADDONLOW JZIPADDONLOW CHAR4 CHAR 4   0   IS-M: Extension of 5-digit ZIP code (lower limit)  
27 ZIPADDONHIGH JZIPADDONHIGH CHAR4 CHAR 4   0   IS-M: Extension of 5-digit ZIP code (upper limit)  
28 ORT_NAME_L ORT_NAME_L TEXT50 CHAR 50   0   IS-M: City name (long text)  
29 STR_NAME_L STR_NAME_L TEXT50 CHAR 50   0   IS-M: Street Name (long)  
30 STATEABBREV REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 M_MJSSC ADDRSECABBREV TJS43 ADDRSECABBREV    
2 M_MJSSC ALORT JSTORTPRO ALORT KEY 1 CN
3 M_MJSSC KREISG_SCH JSTKGSPRO KREISG_SCH KEY 1 CN
4 M_MJSSC LAND1 T005 LAND1 KEY 1 CN
5 M_MJSSC PLZ_ZSTR JSTPLZPRO PLZNEU KEY 1 CN
6 M_MJSSC POSTDIRECTIONAL TJS41 DIRECTIONAL KEY 1 CN
7 M_MJSSC PREDIRECTIONAL TJS41 DIRECTIONAL 1 CN
8 M_MJSSC STATEABBREV T005S BLAND    
History
Last changed by/on SAP  20130529 
SAP Release Created in