SAP ABAP Table J_1SPUPBESTAND (IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet)

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_1SPUPBESTAND	Table Relationship Diagram
Short Description	IS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet

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	ORDNRP	☑	J_1SONRP	J_1SC5	CHAR	5	0	IS-M: Official number P (PTT) (CH)
3	TABELLE	☑	J_1SUPDATAB	J_1SUPDATAB	CHAR	10	0	CH Postal Upgrade Table
4	FUNCTION	☑	J_1SUPDAFUNC	J_1SUPDAFUNC	CHAR	2	0	CH Postal Upgrade Functions
5	LAUFNR	☑	LFDNR	LFDNR	CHAR	3	0	Sequence Number
6	USERFUNC	☐	J_1SUPDAFUNC	J_1SUPDAFUNC	CHAR	2	0	CH Postal Upgrade Functions
7	ORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
8	DOMPLZ	☐	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	*
9	LAND1_ALT	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
10	ALORT_ALT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	JSTORTPRO
11	PLZNEU_ALT	☐	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	JSTPLZPRO
12	PLZLFD_ALT	☐	PLZLFDNR	NUMC3	NUMC	3	0	IS-M/SD: Sequence number for postal code (for history)
13	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
14	ALORT	☐	JALORT	ALORT	CHAR	8	0	IS-M: City Number (Unique)	*
15	PLZNEU	☐	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	*
16	PLZLFD	☐	PLZLFDNR	NUMC3	NUMC	3	0	IS-M/SD: Sequence number for postal code (for history)
17	SUCHFELDO	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
18	ORT_NAME_K	☐	ORT_NAME_K	TEXT25	CHAR	25	0	IS-M: City Name (Short Text)
19	ORT_NAME_L	☐	ORT_NAME_L	TEXT50	CHAR	50	0	IS-M: City name (long text)
20	ORT_NAME_G	☐	ORT_NAME_G	JCHAR50_G	CHAR	50	0	IS-M: City name in block capitals
21	ORT_NAME_S	☐	ORT_NAME_S	CHAR50	CHAR	50	0	IS-M: City Name (Long Text, No Special Characters)
22	HERKKZORT	☐	HERKZORT	HERKUNFTKZ	CHAR	1	0	IS-M: Origin Indicator for City	*
23	HERKKZSTR	☐	HERKZSTR	HERKUNFTKZ	CHAR	1	0	IS-M: Origin Indicator for Street File	*
24	.INCLUDE	☐				0	0	Type of postal code for usage
25	X_ZUSTELL	☐	X_ZUSTELL	XFELD	CHAR	1	0	IS-M: Postal code for home delivery
26	X_POSTFACH	☐	X_POSTFACH	XFELD	CHAR	1	0	IS-M: Postal code for P.O.box
27	X_GRKUNDE	☐	X_GRKUNDE	XFELD	CHAR	1	0	IS-M: Postal code for major customer
28	X_GKGRUPPE	☐	X_GKGRUPPE	XFELD	CHAR	1	0	IS-M: Postal code for major customer group
29	X_AKTION	☐	X_AKTION	XFELD	CHAR	1	0	Indicator: Sales Promotion Postal Code
30	X_SCHALTER	☐	X_SCHALTER	XFELD	CHAR	1	0	Indicator: Postal code for counter collection
31	X_MILITARY	☐	X_MILITARY	XFELD	CHAR	1	0	Military ZIP code
32	ZDPLZ	☐	PLZNEU	NPSTLZ	CHAR	10	0	IS-M: Postal code	*
33	GRUNDPLZ	☐	J_1SGPLZ	J_1SGPLZ	NUMC	4	0	IS-M: CH: 4-Digit Basic Postal Code CH	*
34	ZDORT	☐	J_1SZDORT	J_1SC18	CHAR	18	0	IS-M: CH: Home Delivery for City
35	KANTON	☐	J_1SKANTON	J_1SC2	CHAR	2	0	IS-M: CH: Canton
36	SPRCODE1	☐	J_1SSPRCO1	J_1SC1	CHAR	1	0	IS-M: CH: Language Code 1
37	SPRCODE2	☐	J_1SSPRCO2	J_1SC1	CHAR	1	0	IS-M: CH: Language Code 2
38	KZBOTENF	☐	J_1SZUBOTF	J_1SC1	CHAR	1	0	IS-M: CH: Existing Membership in Carrier File
39	GEMEINDENR	☐	J_1SGNRBFS	CHAR5KONV	CHAR	5	0	IS-M: CH: Municipality Number from Federal Statistics Office
40	GEMEINDENA	☐	J_1SGEMNAM	J_1SC18	CHAR	18	0	IS-M: CH: Municipality Name
41	AGGLOMNR	☐	J_1SAGGLNR	CHAR5KONV	CHAR	5	0	IS-M: CH: Agglomeration Number
42	KANTONPLRE	☐	J_1SKPLREG	J_1SC4	CHAR	4	0	IS-M: Canton planning region (CH)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1SPUPBESTAND	ALORT_ALT	JSTORTPRO	ALORT
2	J_1SPUPBESTAND	LAND1_ALT	T005	LAND1
3	J_1SPUPBESTAND	MANDT	T000	MANDT
4	J_1SPUPBESTAND	PLZNEU_ALT	JSTPLZPRO	PLZNEU

History

Last changed by/on	SAP	20130529
SAP Release Created in