SAP ABAP View SH_TESPT_IDE (View Between TESPT and TSPA)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-IDE (Application Component) Intercompany Data Exchange
     ⤷ EECC_EDI (Package) IS-U: Deregulation

Basic Data

View Type	D	Database View
Database View	SH_TESPT_IDE
Short Description	View Between TESPT and TSPA
Root table	TESPT	Alloc. of Div. Cat. to Div.

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TESPT	TESPT
2	TSPA
3	TSPAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TSPA	MANDT	JL	EQ				0	0
2	TESPT	MANDT	JR	EQ			AND	0	0
3	TSPA	SPART	JL	EQ				0	0
4	TESPT	SPARTE	JR	EQ			AND	0	0
5	TSPA	MANDT	JL	EQ				0	0
6	TSPAT	MANDT	JR	EQ			AND	0	0
7	TSPA	SPART	JL	EQ				0	0
8	TSPAT	SPART	JR	EQ			AND	0	0
9	TESPT	SPARTYP		NE	'99'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TESPT	MANDT		☐	MANDT	☐	Client
2	SPARTE	TESPT	SPARTE		☐	SPARTE	☐	Division
3	SPRAS	TSPAT	SPRAS		☐	SPRAS	☐	Language Key
4	VTEXT	TSPAT	VTEXT		☐	VTXTK	☐	Name
5	SPARTYP	TESPT	SPARTYP		☐	SPARTYP	☐	Division category

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	463