SAP ABAP View V_SORDOD_P (SAPoffice: Join for Selecting Unviewed Shared Documents)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
⤷ SO (Package) SAPoffice
⤷ BC-SRV-COM (Application Component) Communication Services: Mail, Fax, SMS, Telephony
⤷ SO (Package) SAPoffice
Basic Data
View Type | D | Database View |
Database View | V_SORDOD_P | |
Short Description | SAPoffice: Join for Selecting Unviewed Shared Documents | |
Root table | SORD | SAPoffice: Viewed Records for Shared Folders |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | SORD | SORD | ||
2 | SOOD | |||
3 | SOFM |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | SOOD | MANDT | JL | EQ | 0 | 0 | ||||
2 | SORD | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | SOOD | OBJTP | JL | EQ | 0 | 0 | ||||
4 | SORD | OBJTP | JR | EQ | AND | 0 | 0 | |||
5 | SOOD | OBJYR | JL | EQ | 0 | 0 | ||||
6 | SORD | OBJYR | JR | EQ | AND | 0 | 0 | |||
7 | SOOD | OBJNO | JL | EQ | 0 | 0 | ||||
8 | SORD | OBJNO | JR | EQ | AND | 0 | 0 | |||
9 | SOOD | MANDT | JL | EQ | 0 | 0 | ||||
10 | SOFM | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | SOOD | OBJTP | JL | EQ | 0 | 0 | ||||
12 | SOFM | DOCTP | JR | EQ | AND | 0 | 0 | |||
13 | SOOD | OBJYR | JL | EQ | 0 | 0 | ||||
14 | SOFM | DOCYR | JR | EQ | AND | 0 | 0 | |||
15 | SOOD | OBJNO | JL | EQ | 0 | 0 | ||||
16 | SOFM | DOCNO | JR | EQ | AND | 0 | 0 | |||
17 | SORD | FOLTP | JL | EQ | 0 | 0 | ||||
18 | SOFM | FOLTP | JR | EQ | AND | 0 | 0 | |||
19 | SORD | FOLYR | JL | EQ | 0 | 0 | ||||
20 | SOFM | FOLYR | JR | EQ | AND | 0 | 0 | |||
21 | SORD | FOLNO | JL | EQ | 0 | 0 | ||||
22 | SOFM | FOLNO | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | SORD | MANDT | MANDT | Client | |||
2 | FOLTP | SORD | FOLTP | SO_FOL_TP | Object folder: Object type from ID | |||
3 | FOLYR | SORD | FOLYR | SO_FOL_YR | Object folder: Year from ID | |||
4 | FOLNO | SORD | FOLNO | SO_FOL_NO | Object folder: Number from ID | |||
5 | USRTP | SORD | USRTP | SO_USR_TP | User type from ID | |||
6 | USRYR | SORD | USRYR | SO_USR_YR | User year from the ID | |||
7 | USRNO | SORD | USRNO | SO_USR_NO | User number from the ID | |||
8 | DOCTP | SORD | OBJTP | SO_OBJ_TP | Code for document class | |||
9 | DOCYR | SORD | OBJYR | SO_OBJ_YR | Object: Year from ID | |||
10 | DOCNO | SORD | OBJNO | SO_OBJ_NO | Object: Number from ID | |||
11 | DOCNAM | SOOD | OBJNAM | SO_OBJ_NAM | Name of document, folder or distribution list | |||
12 | DOCDES | SOOD | OBJDES | SO_OBJ_DES | Short description of contents | |||
13 | DOCLA | SOOD | OBJLA | SO_OBJ_LA | Language in Which Document Is Created | |||
14 | CRDAT | SOOD | CRDAT | SO_DAT_CR | Date created | |||
15 | CRTIM | SOOD | CRTIM | SO_TIM_CR | Time created | |||
16 | CHDAT | SOOD | CHDAT | SO_DAT_CH | Date of Last Change | |||
17 | CHTIM | SOOD | CHTIM | SO_TIM_CH | Time of Last Change | |||
18 | LADAT | SOOD | LADAT | SO_DAT_LA | Date of last access | |||
19 | DLDAT | SOFM | DLDAT | SO_DAT_DL | Document Expiration Date | |||
20 | OWNTP | SOOD | OWNTP | SO_OWN_TP | Owner type from ID | |||
21 | OWNYR | SOOD | OWNYR | SO_OWN_YR | Owner year from the ID | |||
22 | OWNNO | SOOD | OWNNO | SO_OWN_NO | Owner number from the ID | |||
23 | ENCCNT | SOOD | ENCCNT | SO_ENC_CNT | Number of attachments for the object | |||
24 | VMTYP | SOOD | VMTYP | SO_VM_TYP | Execute: Type (Report, Dialog Module, ...) | |||
25 | OBJCP | SOOD | OBJCP | SO_OBJ_CP | Document cannot be changed | |||
26 | FILE_EXT | SOOD | FILE_EXT | SO_FILEEXT | File extension for PC application | |||
27 | ARCHI | SOOD | ARCHI | SO_ARCHI | The document is stored in archive | |||
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 | 20010619 |
SAP Release Created in |