SAP ABAP View SH_TECDE (View Between TECDE and TESPT)
Hierarchy
☛
IS-UT (Software Component) SAP Utilities/Telecommunication
⤷ IS-U-IDE (Application Component) Intercompany Data Exchange
⤷ EECC_EDI (Package) IS-U: Deregulation
⤷ IS-U-IDE (Application Component) Intercompany Data Exchange
⤷ EECC_EDI (Package) IS-U: Deregulation
Basic Data
View Type | D | Database View |
Database View | SH_TECDE | |
Short Description | View Between TECDE and TESPT | |
Root table | TECDE | Service Types |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | TECDE | TECDE | ||
2 | TECDET | |||
3 | TESPT |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | TECDE | MANDT | JL | EQ | 0 | 0 | ||||
2 | TECDET | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | TECDE | SERVICE | JL | EQ | 0 | 0 | ||||
4 | TECDET | SERVICE | JR | EQ | AND | 0 | 0 | |||
5 | TESPT | MANDT | JL | EQ | 0 | 0 | ||||
6 | TECDE | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | TESPT | SPARTE | JL | EQ | 0 | 0 | ||||
8 | TECDE | DIVISION | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | TECDE | MANDT | MANDT | Client | |||
2 | SERVICE | TECDE | SERVICE | SERCODE | Service Type | |||
3 | DIVISION | TECDE | DIVISION | SPARTE | Division | |||
4 | SPRAS | TECDET | SPRAS | SPRAS | Language Key | |||
5 | SERVICETEXT | TECDET | SERVICETEXT | SERVICETEXT | Text for Service Type | |||
6 | SPARTYP | TESPT | SPARTYP | SPARTYP | Division category | |||
7 | DISPLAY | TECDE | DISPLAY | DISPLAY_SERVICE | Display point of delivery service in the CIC | |||
8 | MOVE_OUT_STAY | TECDE | MOVE_OUT_STAY | MOVE_OUT_STAY | Service Type Retained After Move-Out | |||
9 | INTCODE | TECDE | INTCODE | INTCODE | Service Category | |||
Maintenance Status
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 |