I_SourceNominationSchedPartner

@AbapCatalog.sqlViewName: 'ISRCENOMSCHDPART'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'I_SourceSchedulePartnerTP'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:{
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #XXL,
    usageType.dataClass: #TRANSACTIONAL,
    semanticKey:  ['NominationDoc', 'NominationDocItem', 'OriginLocID', 'TransportSystem', 'PartnerFunction', 'SourceScheduleRank'],
    representativeKey:  ['NominationDoc', 'NominationDocItem', 'PartnerFunction'],
    updateEnabled: true
    }

define view I_SourceNominationSchedPartner
  as select from oij09_schedpart as _SchedulePartner 
    inner join   oij09_schedsrc  as _ScheduleSource      on  _ScheduleSource.nomtk = _SchedulePartner.nomtk
                                                         and _ScheduleSource.nomit = _SchedulePartner.nomit
                                                         and _ScheduleSource.guid  = _SchedulePartner.guid
    inner join   oijts           as _TransportSystem     on _TransportSystem.tsyst = _ScheduleSource.tsyst
    inner join   toigs           as _ShipmentType        on _ShipmentType.shtyp = _TransportSystem.shtype
    inner join   tvfp            as _ShipmentCostPurData on  _ShipmentCostPurData.tplst = _TransportSystem.tplst
                                                         and _ShipmentCostPurData.fkart = _ShipmentType.fkart
 
  association [0..1] to I_NominationSchedBPPurgOrgVH as _NominationSchedBPPurgOrgVH on  _NominationSchedBPPurgOrgVH.BusinessPartner        = $projection.BusinessPartner
                                                                                    and _NominationSchedBPPurgOrgVH.PurchasingOrganization = $projection.PurchasingOrganization
                                                                                    and _NominationSchedBPPurgOrgVH.PurchasingGroup        = $projection.PurchasingGroup
  association [0..1] to I_Supplier                   as _Supplier                   on  _Supplier.Supplier = $projection.BusinessPartner

{
  key _ScheduleSource.nomtk                                            as  NominationDoc,
  key _ScheduleSource.nomit                                            as  NominationDocItem,
  key _ScheduleSource.guid                                             as  NominationSourceScheduleUUID,
      @ObjectModel.readOnly: true
  key parvw                                                            as  PartnerFunction,
      ekorg                                                            as  PurchasingOrganization,
      ekgrp                                                            as  PurchasingGroup,
      @ObjectModel.readOnly: true
      vtxtk                                                            as  PartnerFunctionDesc,
      @Consumption.valueHelp: '_NominationSchedBPPurgOrgVH'
      partner                                                          as  BusinessPartner,
      _NominationSchedBPPurgOrgVH,
      _Supplier
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"OIJ09_SCHEDPART",
"OIJ09_SCHEDSRC",
"OIJTS",
"TOIGS",
"TVFP"
],
"ASSOCIATED":
[
"I_NOMINATIONSCHEDBPPURGORGVH",
"I_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/