I_ServiceEntrySheet

@AbapCatalog.sqlViewName: 'ISRVCENTRSHT'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.privilegedAssociations: [ '_SESWorkflowStatus', '_WorkflowStatusText' ]
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType : #COMPOSITE
@EndUserText.label: 'Service Entry Sheet'

@ObjectModel: {
   compositionRoot: true,
   representativeKey: 'ServiceEntrySheet',
   createEnabled,
   deleteEnabled,
   updateEnabled: 'EXTERNAL_CALCULATION',
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #L,
   usageType.dataClass: #MIXED
}

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_ServiceEntrySheet
  as select from I_ServiceEntrySheetBasic as Document
  association [1..*] to I_ServiceEntrySheetItem      as _ServiceEntrySheetItem      on $projection.ServiceEntrySheet = _ServiceEntrySheetItem.ServiceEntrySheet
//  association [0..1] to I_SrvcEntrShtItmTotNetAmt    as _SrvcEntrShtItmTotNetAmt    on $projection.ServiceEntrySheet = _SrvcEntrShtItmTotNetAmt.ServiceEntrySheet

  association [0..*] to I_SrvcEntrShtApprvlStsTxt    as _ApprovalStatusText         on $projection.ApprovalStatus = _ApprovalStatusText.ApprovalStatus
  association [1..1] to I_SESWorkflowStatus          as _SESWorkflowStatus          on  $projection.ServiceEntrySheet = _SESWorkflowStatus.ServiceEntrySheet
  association [0..1] to I_SESWorkflowStatusValueHelp as _WorkflowStatusValueHelp    on  $projection.sesworkflowstatus = _WorkflowStatusValueHelp.SESWorkflowStatus
  association [0..*] to I_SESWorkflowStatusText      as _WorkflowStatusText         on $projection.sesworkflowstatus = _WorkflowStatusText.SESWorkflowStatus
  association [0..*] to I_SrvcEntrShtPurOrdValueHelp as _SrvcEntrShtPurOrdValueHelp on _SrvcEntrShtPurOrdValueHelp.PurchaseOrder = $projection.PurchaseOrder
  association [0..1] to I_PurchaseOrder              as _PurchaseOrder              on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association [0..1] to I_Currency                   as _DocumentCurrency           on $projection.Currency = _DocumentCurrency.Currency

  ----Extension Association
  association [1..1] to E_ServiceEntrySheet          as _ServiceEntrySheetExtension on $projection.ServiceEntrySheet = _ServiceEntrySheetExtension.ServiceEntrySheet

{
      @ObjectModel.mandatory: true
      @ObjectModel.readOnly: true
  key Document.ServiceEntrySheet,

      @ObjectModel.mandatory: true
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      Document.ServiceEntrySheetName,

      @ObjectModel.readOnly: true
      @ObjectModel.text.element: [ 'SupplierName' ]
      Document.Supplier,

      @Semantics.text: true
      @ObjectModel.readOnly: true
      cast(_Supplier.SupplierName as bu_name1tx)                                                       as SupplierName,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      //@ObjectModel.foreignKey.association: '_SrvcEntrShtPurOrdValueHelp'

      @Consumption.valueHelp: '_SrvcEntrShtPurOrdValueHelp'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      Document.PurchaseOrder,

      @Semantics.currencyCode:true
      @ObjectModel.readOnly: true
      @ObjectModel.foreignKey.association: '_PurchaseOrderCurrency'
      @Consumption.valueHelp: '_PurchaseOrderCurrency'
      _PurchaseOrder.DocumentCurrency                                                                  as PurchaseOrderCurrency,

      Document.IsDeleted,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      @ObjectModel.text.association: '_ApprovalStatusText'
      @ObjectModel.foreignKey.association: '_ApprovalStatusValueHelp'
      Document.ApprovalStatus,


      @ObjectModel.readOnly: true
      @ObjectModel.text.association: '_WorkflowStatusText'
      @ObjectModel.foreignKey.association: '_WorkflowStatusValueHelp'
      _SESWorkflowStatus.SESWorkflowStatus,

      Document.ApprovalDateTime,

      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      Document.ResponsiblePerson,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      Document.OriginObjectType,

      @Semantics.currencyCode:true
      @ObjectModel.readOnly: true
      @ObjectModel.foreignKey.association: '_DocumentCurrency'
      @Consumption.valueHelp: '_DocumentCurrency'
      Document.Currency,

      Document.MaterialDocument,
      Document.MaterialDocumentYear,

      @ObjectModel.readOnly: true
      cast(CreationDateTime as mmpur_ses_created_on)                                                   as CreationDateTime,

      @ObjectModel.readOnly: true
      @Semantics.user.createdBy: true
      Document.CreatedByUser,

      @ObjectModel.readOnly: true
      cast(Document.LastChangeDateTime as mmpur_ses_changed_on)                                        as LastChangeDateTime,

      @ObjectModel.readOnly: true
      @Semantics.user.lastChangedBy: true
      Document.LastChangeUser,

      @ObjectModel.readOnly: true
      Document.PurchasingOrganization,

      @ObjectModel.readOnly: true
      Document.PurchasingGroup,

      Document.IsEndOfPurposeBlocked,
      Document.PurgDocExternalSystem,
      Document.PurgDocExternalReference,
      Document.ExternalRevisionDateTime,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      Document.PostingDate,
      Document.PricingDocument,

      @Semantics.amount.currencyCode: 'Currency'
      @ObjectModel.readOnly: true
      @Aggregation.default: #NONE
      cast( 0 as mmpur_ses_confirmedvalue )                      as TotalNetAmount,

      @Semantics.amount.currencyCode: 'Currency'
      @ObjectModel.readOnly: true
      @Aggregation.default: #NONE
      cast( 0 as mmpur_ses_total_conf_val_w_tax ) as TotalSESNetAmountInclSalesTax,

      Document._ApprovalStatusValueHelp,
      Document._ResponsiblePersonValueHelp,
      Document._Supplier,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _ServiceEntrySheetItem,
      _CreatedByUser,
      _LastChangeUser,

      _DocumentCurrency,
      _PurchaseOrder._DocumentCurrency                                                                 as _PurchaseOrderCurrency,
      _SrvcEntrShtPurOrdValueHelp,
      _ApprovalStatusText,
//      _SrvcEntrShtItmTotNetAmt,


      _SESWorkflowStatus,
      _WorkflowStatusValueHelp,
      _WorkflowStatusText
}