SAP ABAP Table J_1SFSPED (IS-M/SD CH/V: Addresses, Orders for Third-Party Shipping)
Hierarchy
☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ J1SC (Package) IS-M/SD CH: Development of Swiss Version
Basic Data
Table Category TRANSP    Transparent table 
Transparent table J_1SFSPED   Table Relationship Diagram
Short Description IS-M/SD CH/V: Addresses, Orders for Third-Party Shipping    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 J_1S_AVNR AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order *
3 VBELN AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order *
4 VERSANDDAT VRSNDDATUM DATUM DATS 8   0   IS-M: Shipping Date  
5 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
6 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
7 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
8 .INCLUDE       0   0   IS-M/SD CH/V: Third Party Forwarding Struc.for Data Transfer  
9 FKUNNR JFKUNNR KUNNR CHAR 10   0   IS-M: Customer Number in Non-SAP System *
10 REFBELEG REMELD_ISP CHAR20 CHAR 20   0   IS-M/SD: Reference Document in Legacy System  
11 ANRED JANRED JANRED CHAR 2   0   IS-M: Form-of-Address Key *
12 TITEL TITEL_ISP TITEL CHAR 15   0   IS-M: Title *
13 NAME1 NAME1_ISP NAME CHAR 35   0   IS-M: Business Partner Name  
14 NAME2 NAME2_ISP NAME CHAR 35   0   IS-M: First Name of Business Partner  
15 NAME3 NAME3_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
16 NAME4 NAME4_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
17 STRAS STRAS_ISP TEXT35 CHAR 35   0   IS-M: Street Name  
18 HAUSN HSNMR1 HAUSNUMMER CHAR 10   0   IS-M: House Number  
19 HSNMR2 HSNMR2 CHAR8 CHAR 8   0   IS-M: House Number Affix  
20 PFACH PFACH_ISP PFACH_ISP CHAR 10   0   IS-M: Post Office Box  
21 LAND1 LAND1 LAND1 CHAR 3   0   Country Key *
22 PSTLZ PLZ_ISP PSTLZ CHAR 10   0   IS-M: Postal Code  
23 ORT01 ORT01_ISP TEXT35 CHAR 35   0   IS-M: City  
24 ORT02 ORT02_ISP TEXT35 CHAR 35   0   IS-M: City District  
25 BOTENBEZ J_1SBOTBEZ J_1SC3 CHAR 3   0   IS-M: Carrier Route (CH)  
26 POSTEINORT JALORT ALORT CHAR 8   0   IS-M: City Number (Unique) JSTORTPRO
27 POSTEINSTR STRASSENNR STRASSENNR CHAR 10   0   IS-M: Street Number JSTSTRPRO
28 ETMENGE ETMENGE MENGGPOS QUAN 10   0   IS-M: Sales Order Schedule Line Quantity  
29 ETMEINS ETMEINS MEINS UNIT 3   0   IS-M: Sales Unit for Sales Order T006
30 KANTON J_1SKANTON J_1SC2 CHAR 2   0   IS-M: CH: Canton  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 J_1SFSPED ETMEINS T006 MSEHI REF C CN
2 J_1SFSPED MANDT T000 MANDT KEY 1 CN
3 J_1SFSPED POSTEINORT JSTORTPRO ALORT REF C CN
4 J_1SFSPED POSTEINSTR JSTSTRPRO STRASSENNR REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in