SAP ABAP View /TDAG/CPV_ORGPER (Database View for Persons of Organizations)
Hierarchy
☛
TDAGBCA (Software Component) TechniData Basic Components
⤷
EHS (Application Component) Environment, Health and Safety
⤷
/TDAG/CP_IMDS (Package) IMDS Advanced Interface Integration
TDAGBCA (Software Component) TechniData Basic Components⤷
EHS (Application Component) Environment, Health and Safety⤷
/TDAG/CP_IMDS (Package) IMDS Advanced Interface Integration
Basic Data
| View Type | D | Database View |
| Database View | /TDAG/CPV_ORGPER | |
| Short Description | Database View for Persons of Organizations | |
| Root table | /TDAG/CPT_ORGPER | IMDS Contact |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /TDAG/CPT_ORGPER |
/TDAG/CPT_ORGPER | ||
| 2 | /TDAG/CPT_ORGIDS |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /TDAG/CPT_ORGIDS |
MANDT | JL | EQ | 0 | 0 | ||||
| 2 | /TDAG/CPT_ORGPER |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | /TDAG/CPT_ORGIDS |
ORGID | JL | EQ | 0 | 0 | ||||
| 4 | /TDAG/CPT_ORGPER |
ORGID | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
/TDAG/CPT_ORGIDS |
MANDT | MANDT | Client | |||
| 2 | ORGID |
/TDAG/CPT_ORGIDS |
ORGID | /TDAG/CPE_ORGID | Organizational Unit | |||
| 3 | PERSID |
/TDAG/CPT_ORGPER |
PERSID | /TDAG/CPE_CONTACTID | IMDS Contact ID | |||
| 4 | ORGNA |
/TDAG/CPT_ORGIDS |
ORGNA | /TDAG/CPE_ORGNA | Organization Name | |||
| 5 | PERSNAFIRST |
/TDAG/CPT_ORGPER |
PERSNAFIRST | /TDAG/CPE_PERSNAFIRST | First Name | |||
| 6 | PERSNALAST |
/TDAG/CPT_ORGPER |
PERSNALAST | /TDAG/CPE_PERSNALAST | Last Name | |||
| 7 | PHONENO |
/TDAG/CPT_ORGPER |
PHONENO | /TDAG/CPE_PHONE | Phone | |||
| 8 | FAXNO |
/TDAG/CPT_ORGPER |
FAXNO | /TDAG/CPE_FAX | Fax | |||
| 9 | EMAIL |
/TDAG/CPT_ORGPER |
/TDAG/CPE_EMAIL | |||||
| 10 | MAILBOX |
/TDAG/CPT_ORGPER |
MAILBOX | /TDAG/CPE_MAILBOX | Mailbox | |||
| 11 | DEPNAME |
/TDAG/CPT_ORGPER |
DEPNAME | /TDAG/CPE_DEBNAME | Department | |||
| 12 | ISDELETED |
/TDAG/CPT_ORGPER |
ISDELETED | /TDAG/CPE_IMDS_DEL | Deletion Indicator | |||
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 | 20141109 |
| SAP Release Created in | 0207B0406C |
