UPOV_NETOBJ_WITH_PN
Network Obect and related PN
UPOV_NETOBJ_WITH_PN is a CDS View in S/4HANA. Network Obect and related PN. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| UPOV_PR_MP_UOM | view | left_outer | Measurement Point (UOM) | |
| UPOV_PR_WC_UOM | view | left_outer | UOM: Well Completion | |
| UPOV_WCDTR_WC_DATA | view | left_outer | Contains Well comp reason code data |
@AbapCatalog.sqlViewName: 'UPOS_NOBJ_PN'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Network Obect and related PN'
define view UPOV_NETOBJ_WITH_PN
as select distinct from UPOV_NETOBJ_FROM_MODELING as objLink
{
min(objLink.ProductionNetwork) as ProductionNetwork,
objLink.NetObject,
objLink.gho_netobj_type,
min(objLink.datva) as datva,
min(objLink.zeitva) as zeitva,
max(objLink.datvb) as datvb,
max(objLink.zeitvb) as zeitvb
}
group by
objLink.ProductionNetwork,
objLink.NetObject,
objLink.gho_netobj_type
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UPOV_NETOBJ_FROM_MODELING"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/