SAP ABAP View V_OIUOW_UNIT_JV (OIUOW: Database view for Unit Venture)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-PRA-REV-OW (Application Component) Ownership
⤷ OIU_RVOW (Package) PRA Ownership (Revenue)
⤷ IS-OIL-PRA-REV-OW (Application Component) Ownership
⤷ OIU_RVOW (Package) PRA Ownership (Revenue)
Basic Data
View Type | D | Database View |
Database View | V_OIUOW_UNIT_JV | |
Short Description | OIUOW: Database view for Unit Venture | |
Root table | OIUOW_UNIT_JV | Unit Venture Information |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | OIUOW_UNIT_JV | OIUOW_UNIT_JV | ||
2 | OIU_DO_JV | |||
3 | OIU_DO_PUC |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | OIU_DO_JV | MANDT | JL | EQ | 0 | 0 | ||||
2 | OIUOW_UNIT_JV | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | OIU_DO_JV | BUKRS | JL | EQ | 0 | 0 | ||||
4 | OIUOW_UNIT_JV | BUKRS | JR | EQ | AND | 0 | 0 | |||
5 | OIU_DO_JV | VNAME | JL | EQ | 0 | 0 | ||||
6 | OIUOW_UNIT_JV | UNIT_VNAME | JR | EQ | AND | 0 | 0 | |||
7 | OIU_DO_JV | MANDT | JL | EQ | 0 | 0 | ||||
8 | OIU_DO_PUC | MANDT | JR | EQ | AND | 0 | 0 | |||
9 | OIU_DO_JV | BUKRS | JL | EQ | 0 | 0 | ||||
10 | OIU_DO_PUC | BUKRS | JR | EQ | AND | 0 | 0 | |||
11 | OIU_DO_JV | VNAME | JL | EQ | 0 | 0 | ||||
12 | OIU_DO_PUC | UNIT_VNAME | JR | EQ | AND | 0 | 0 | |||
13 | OIU_DO_JV | UNIT_FL | EQ | 'X' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | OIUOW_UNIT_JV | MANDT | MANDT | Client | |||
2 | BUKRS | OIUOW_UNIT_JV | BUKRS | BUKRS | Company Code | |||
3 | UNIT_VNAME | OIUOW_UNIT_JV | UNIT_VNAME | JV_NAME | Joint venture | |||
4 | COMB_PD_CD | OIUOW_UNIT_JV | COMB_PD_CD | OIU_COMB_PD_CD | Combined product code | |||
5 | VNAME_INT_CD | OIU_DO_JV | VNAME_INT_CD | OIU_VNAME_INT_CD | Venture Interest Code | |||
6 | STS_CODE | OIU_DO_JV | STS_CODE | OIU_VNAME_STATUS | Venture Status | |||
7 | STS_EFF_DT | OIU_DO_JV | STS_EFF_DT | OIU_STS_EFF_DT | Status Effective Date | |||
8 | TYPE_CD | OIU_DO_JV | TYPE_CD | OIU_VNAME_TYPE_CD | Venture Usage Type | |||
9 | UNIT_FL | OIU_DO_JV | UNIT_FL | OIU_UNIT_FL | Unit venture flag | |||
10 | DOI_BY_TR_FL | OIU_DO_JV | DOI_BY_TR_FL | OIU_DOI_BY_TR_FL | DOI by tract flag | |||
11 | UPDT_UNIT_JV_FL | OIUOW_UNIT_JV | UPDT_UNIT_JV_FL | OIUOW_UPDT_UNIT_JV_FL | Unit JV flag | |||
12 | VNAME_NM | OIU_DO_JV | VNAME_NM | OIU_VNAME_NM | venture name | |||
13 | SHTXT | OIU_DO_JV | SHTXT | OIU_SHTXT | Description | |||
14 | EFF_FROM_DT | OIU_DO_PUC | EFF_FROM_DT | OIU_EFF_FROM_DT | Effective from date | |||
15 | EFF_TO_DT | OIU_DO_PUC | EFF_TO_DT | OIU_EFF_TO_DT | Effective To Date | |||
16 | PUC_NO | OIU_DO_PUC | PUC_NO | OIU_PUC_NO | Property Unit Use Control Number | |||
17 | TOT_TPF_PC | OIU_DO_PUC | TOT_TPF_PC | OIU_TOT_TPF_PC | Total Tract Participation Factor Decimal | |||
18 | APPR_FL | OIU_DO_PUC | APPR_FL | OIU_APPR_FL | Approval Flag | |||
19 | OIU_CRUSER | OIUOW_UNIT_JV | OIU_CRUSER | ERNAM | Name of Person who Created the Object | |||
20 | OIU_TIMESTAMP | OIUOW_UNIT_JV | OIU_TIMESTAMP | TZNTSTMPS | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | |||
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 |