SAP ABAP View SH_ESERVPROV_DST (Search Help View for Service Provider (Distributor Only))

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_ESERVPROV_DST
Short Description	Search Help View for Service Provider (Distributor Only)
Root table	ESERVPROV	Service provider

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ESERVPROV	ESERVPROV
2	ESERVPROVT
3	TECDE
4	TECDET

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ESERVPROV	MANDT	JL	EQ				0	0
2	ESERVPROVT	MANDT	JR	EQ			AND	0	0
3	ESERVPROV	SERVICEID	JL	EQ				0	0
4	ESERVPROVT	SERVICEID	JR	EQ			AND	0	0
5	TECDE	MANDT	JL	EQ				0	0
6	ESERVPROV	MANDT	JR	EQ			AND	0	0
7	TECDE	SERVICE	JL	EQ				0	0
8	ESERVPROV	SERVICE	JR	EQ			AND	0	0
9	TECDE	MANDT	JL	EQ				0	0
10	TECDET	MANDT	JR	EQ			AND	0	0
11	TECDE	SERVICE	JL	EQ				0	0
12	TECDET	SERVICE	JR	EQ			AND	0	0
13	TECDET	SPRAS	JL	EQ				0	0
14	ESERVPROVT	SPRAS	JR	EQ			AND	0	0
15	TECDE	INTCODE		EQ	'01'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	ESERVPROV	MANDT		☐	MANDT	☐	Client
2	SERVICEID	ESERVPROV	SERVICEID		☐	SERVICE_PROV	☐	Service Provider
3	SERVICE	TECDE	SERVICE		☐	SERCODE	☐	Service Type
4	SPRAS	ESERVPROVT	SPRAS		☐	SPRAS	☐	Language Key
5	SP_NAME	ESERVPROVT	SP_NAME		☐	SERVICE_PROV_TEXT	☐	Name of service provider
6	PROV_BUKRS	ESERVPROV	PROV_BUKRS		☐	BUKRS_PR	☐	Company Code of Service Provider
7	EXTERNALID	ESERVPROV	EXTERNALID		☐	DUNSNR	☐	External Number
8	OWN_LOG_SYS	ESERVPROV	OWN_LOG_SYS		☐	OWN_LOG_SYS	☐	Service Provider is Managed in Own System
9	DIVISION	TECDE	DIVISION		☐	SPARTE	☐	Division
10	INTCODE	TECDE	INTCODE		☐	INTCODE	☐	Service Category
11	SERVICETEXT	TECDET	SERVICETEXT		☐	SERVICETEXT	☐	Text for Service Type

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