UPOV_PR_FIELD

@AbapCatalog.sqlViewName: 'UPOS_PR_FIELD'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Oil & Gas Entity: Field'

define view UPOV_PR_FIELD
  as
  // picking non migration data from PRA side

  select from       UPOV_PR_FLD_PRA as nonmig_fields
    left outer join upot_int_entity as field_id on  field_id.converted_label = nonmig_fields.field
                                                and field_id.gho_pe_type     = 'FIELD'
{

  key nonmig_fields.field         as FIELD,
      nonmig_fields.name          as NAME,
      nonmig_fields.shtxt         as SHTXT,
      nonmig_fields.majpd_cd      as MAJPD_CD,
      nonmig_fields.water_depth_u as WATER_DEPTH_U,
      nonmig_fields.water_depth   as WATER_DEPTH,
      nonmig_fields.fl_grp        as FL_GRP,
      nonmig_fields.oiu_cruser    as OIU_CRUSER,
      nonmig_fields.oiu_timestamp as OIU_TIMESTAMP
}
where
  field_id.converted_label is null

union

select from UPOV_PR_FLD_UOM as uom_fld_data
{
  key uom_fld_data.FIELD                                     as FIELD, // Field ID

      uom_fld_data.NAME                                      as NAME, // Field Name

      uom_fld_data.SHTXT                                     as SHTXT, // Description

      uom_fld_data.MAJPD_CD                                  as MAJPD_CD, // Major product code

      uom_fld_data.WATER_DEPTH_U                             as WATER_DEPTH_U, // Water depth unit

      uom_fld_data.WATER_DEPTH                               as WATER_DEPTH, // Water depth

      cast ('' as oiu_fl_grp )                               as FL_GRP,      // Field group

      uom_fld_data.OIU_CRUSER                                as OIU_CRUSER, // Name of Person Who Created Object

      uom_fld_data.OIU_TIMESTAMP                             as OIU_TIMESTAMP // UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UPOV_PR_FLD_PRA",
"UPOV_PR_FLD_UOM",
"UPOT_INT_ENTITY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/