I_ACMAPPLDOCLTSTVERS

@AbapCatalog.sqlViewName: 'IAPPLDOCLTSTVERS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@EndUserText.label: 'ACM Application Document Latest Version Data'
define view I_ACMApplDocLtstVers

  as select from /accgo/t_appdata as ApplicationData
{
  key appl_guid                     as ContractApplicationUUID,
  key appl_version                  as ContractApplicationVersion,
      contract_num                  as TradingContractNumber,
      contract_item                 as TradingContractItem,
      commodity_item                as ContractCommodityItem,
      cast( appl_status as char1  ) as ContractApplicationStatus,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      appl_qty                      as Quantity,
      @Semantics.unitOfMeasure: true
      uom                           as TrdgContractApplUnitOfMeasure,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      underfill_qty                 as UnderfillQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      overfill_qty                  as OverfillQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      overfill_pro                  as ProvisionalOverfillQuantity,
      a_guid                        as ContractItemAssignmentUUID,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      ApplicationData.adjusted_qty  as AdjustedQuantity,
      appl_id                       as ContractApplicationID,
      @Semantics.booleanIndicator: true
      appl_intransit                as IsApplicationItemInTransit,
      appl_parent_item              as ACMReferenceDocumentItemNumber,
      appl_seq_no                   as ContractApplSequenceNumber,
      appl_type                     as ContractApplicationType,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      assgd_quan                    as AssignmentQuantity,
      assgd_uom                     as AssignmentUoM,
      assign_status                 as AssignmentStatus,
      call_off_mode                 as ContractItemCallOffMode,
      ApplicationData.changed_by    as ApplDocumentChangedBy,

      tstmp_to_dats( ApplicationData.changed_on,                                       //Convert To Date

                    abap_system_timezone( $session.client,'NULL' ),
                    $session.client,
                    'NULL' )        as ApplicationItemChangedOnDate,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      compute_qty                   as ContractItemComputeQuantity,
      ApplicationData.created_by    as ApplDocumentCreatedBy,

      tstmp_to_dats( ApplicationData.created_on,                                       //Convert To Date

                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )       as ApplicationItemCreatedOnDate,

      deletion                      as DeletionIndicator,
      delivery_date                 as DeliveryDate,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      diff_qty                      as DifferenceQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      diversion_qty                 as DiversionQuantity,
      dpqs_eval                     as DPQSEvaluatedIndicator,
      finished_good                 as FinishedGoodIndicator,
      firmed                        as FirmingIndicator,
      higher_item                   as SuccessorItem,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      item_quan                     as ItemQuantity,
      ApplicationData.item_uom      as AssignmentQuantityUoM,
      latest_qrep_ver               as LatestGroupVersion,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      of_assgd_quan                 as OverfillAssignmentQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      old_assgd_quan                as OldAssignmentQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      old_of_quan                   as OldOverfillAssignmentQuantity,
      optionalities_ev              as OptionalitiesEvaluatedFlag,
      overfill_id                   as OverfillID,
      pred_doc                      as PredecessorDocumentNumber,
      pred_doc_item                 as PredecessorDocumentItem,
      pred_seq_no                   as PredecessorDocumentSeqNumber,
      ApplicationData.qrep_guid     as ContractApplRepositoryUUID,
      ApplicationData.qrep_version  as ACMRepositoryWeightAppVersion,
      ref_appl_guid                 as ApplUniversallyUniIdentifier,
      ref_appl_version              as ReferenceApplicationVersion,
      refdoc                        as ReferenceApplicationDocument,
      refdoc_item                   as ReferenceApplicationItem,
      refdoc_side                   as ReferenceApplicationSide,
      refdoc_sub_item               as ReferenceApplicationSubItem,
      refdoc_type                   as ACMReferenceDocumentCategory,
      rel_for_gm                    as RelevantForGoodMovementFlag,
      rel_for_pricing               as RelevantForPricingFlag,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      return_qty                    as ContractApplReturnQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      setl_adj_qty                  as SettlementAdjustedQuantity,
      shipping_toleran              as ShippingTolerance,
      tolerence                     as ToleranceIndicator,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      trade_quan                    as ContractTradeQuantity,
      trade_unit                    as ContractTradeUnit,
      ApplicationData.umren         as Denominator,
      ApplicationData.umrez         as Numerator,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      underfill_pro                 as ProvisionalUnderfillQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      appl_qty_dec                  as ACMAppliedQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      overfill_qty_dec              as ACMOverfillQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      underfill_qty_dec             as TrdgContrItemUnderFillQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      underfill_pro_dec             as ContrItmPrvsnlUnderFillQty,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      overfill_pro_dec              as ContrItmProvisionalOverFillQty
}

where
  (
       ApplicationData.refdoc_type = 'ZA'
    or ApplicationData.refdoc_type = 'ZR'
  )
  and  ApplicationData.is_active   = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/ACCGO/T_APPDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/