I_ServiceEntrySheetItem

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

@ObjectModel: {
   representativeKey:  'ServiceEntrySheetItem',
   createEnabled,
   updateEnabled,
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #L,
   usageType.dataClass: #MIXED
}

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_ServiceEntrySheetItem
  as select from I_ServiceEntrySheetItemBasic as Document

  association [1..1] to I_ServiceEntrySheet            as _ServiceEntrySheet             on  $projection.ServiceEntrySheet = _ServiceEntrySheet.ServiceEntrySheet
  association [1..*] to I_ServiceEntrySheetAcctAssgmt  as _AccountAssignment             on  $projection.ServiceEntrySheet     = _AccountAssignment.ServiceEntrySheet
                                                                                         and $projection.ServiceEntrySheetItem = _AccountAssignment.ServiceEntrySheetItem

  association [0..1] to I_MaterialGroup                as _MaterialGroupValueHelp        on  $projection.PurchaseOrderItemMaterialGroup = _MaterialGroupValueHelp.MaterialGroup //to de deleted

  association [0..*] to I_MaterialGroupText            as _MaterialGroupText             on  $projection.MaterialGroup = _MaterialGroupText.MaterialGroup
  association [0..1] to I_AcctAssignmentCategoryText   as _AcctAssignmentCategoryText    on  $projection.AccountAssignmentCategory = _AcctAssignmentCategoryText.AccountAssignmentCategory

                                                                                         and _AcctAssignmentCategoryText.Language  = $session.system_language
  association [0..1] to I_SrvcEntrShtAcctAssgmtCat     as _SrvcEntrShtAcctAssgmtCat      on  _SrvcEntrShtAcctAssgmtCat.AccountAssignmentCategory = $projection.AccountAssignmentCategory
  association [0..1] to I_PurchaseOrder                as _PurchaseOrder                 on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association [0..1] to R_PurchaseOrderItem            as _PurchaseOrderItem             on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                                         and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
  association [0..1] to I_ProductTypeCodeText          as _ProductTypeText               on  _ProductTypeText.ProductTypeCode = $projection.ProductType
                                                                                         and _ProductTypeText.Language        = $session.system_language

  association [0..1] to I_PurgDocScheduleLine          as _ScheduleLine                  on  $projection.PurchaseOrder     = _ScheduleLine.PurchasingDocument
                                                                                         and $projection.PurchaseOrderItem = _ScheduleLine.PurchasingDocumentItem
  association [0..1] to I_Currency                     as _DocumentCurrency              on  $projection.Currency = _DocumentCurrency.Currency
  association [0..*] to I_UnitOfMeasureText            as _UnitText                      on  $projection.QuantityUnit = _UnitText.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _PurOrdUnitOfMsrValHelp        on  $projection.PurchaseOrderItemQuantityUnit = _PurOrdUnitOfMsrValHelp.UnitOfMeasure
  association [0..*] to I_UnitOfMeasureText            as _PurOrdUnitOfMsrTxt            on  $projection.PurchaseOrderItemQuantityUnit = _PurOrdUnitOfMsrTxt.UnitOfMeasure
  association [0..1] to I_WorkItemText                 as _WorkItemText                  on  $projection.WorkItem   = _WorkItemText.WorkItem
                                                                                         and _WorkItemText.Language = $session.system_language
  association [0..*] to I_SESPricingElement            as _SESPricingElement             on  $projection.ServiceEntrySheet     = _SESPricingElement.ServiceEntrySheet
                                                                                         and $projection.ServiceEntrySheetItem = _SESPricingElement.ServiceEntrySheetItem
                                                                                         and $projection.ServiceEntrySheetItem is not initial
  ----Extension Association
  association [1..1] to E_ServiceEntrySheetItem        as _ServiceEntrySheetItmExtension on  $projection.ServiceEntrySheet     = _ServiceEntrySheetItmExtension.ServiceEntrySheet
                                                                                        and $projection.ServiceEntrySheetItem = _ServiceEntrySheetItmExtension.ServiceEntrySheetItem
{
      @ObjectModel.foreignKey.association: '_ServiceEntrySheet'
  key Document.ServiceEntrySheet,

  key Document.ServiceEntrySheetItem,

      @EndUserText.label: 'Reference Purchase Order'
      Document.PurchaseOrder,

      Document.PurchaseOrderItem,

      Document.IsDeleted,

      Document.Service,

      Document.ServiceEntrySheetItemDesc,

      Document.ServicePerformer,

      @ObjectModel.text.association: '_AcctAssignmentCategoryText'
      @ObjectModel.foreignKey.association: '_SrvcEntrShtAcctAssgmtCat'
      Document.AccountAssignmentCategory,

      Document.MultipleAcctAssgmtDistribution,

      @ObjectModel.text.association: '_WorkItemText'
      Document.WorkItem,

      Document.ConfirmedQuantity,

      @ObjectModel.text.association: '_UnitText'
      Document.QuantityUnit,

      Document.OrderPriceUnit,

      Document.OrderPriceUnitToOrderUnitNmrtr,

      Document.OrdPriceUnitToOrderUnitDnmntr,

      Document.QtyInPurchaseOrderPriceUnit,

      @Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
      Document.NetPriceQuantity,

      Document.ServicePerformanceDate,

      case
        when Document.ServicePerformanceEndDate is initial
        then Document.ServicePerformanceDate
        else Document.ServicePerformanceEndDate
      end as ServicePerformanceEndDate,

      _ScheduleLine.PerformancePeriodStartDate,

      _ScheduleLine.PerformancePeriodEndDate,

      Document.OriginObject,

      @Semantics.currencyCode:true
      Document.Currency,

      @Semantics.amount.currencyCode: 'Currency'
      Document.NetPriceAmount,

      @ObjectModel.text.association: '_MaterialGroupText'
      Document.MaterialGroup,

      Document.IsEndOfPurposeBlocked,

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

      Document.CreatedByUser,

      Document.LastChangeDateTime,

      Document.LastChangeUser,

      Document.Plant,

      Document.PurgDocItemExternalReference,

      Document.PurchaseContract,

      Document.PurchaseContractItem,

      Document.PurchasingOrganization,

      Document.PurchasingGroup,

      Document.ParentObjectIsDeleted,

      cast('    ' as ewerk)                                           as PurOrderItemPlant, // to be deleted (as soon as possible)

      cast('    ' as esart)                                           as PurchaseOrderType, // to be deleted (as soon as possible)


      @ObjectModel.readOnly: true
      _PurchaseOrder.Supplier                                         as Supplier,

      _PurchaseOrderItem.MaterialGroup                                as PurchaseOrderItemMaterialGroup,

      @ObjectModel.readOnly: true
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderItemQuantityUnit'
      @Aggregation.default: #NONE
      _PurchaseOrderItem.OrderQuantity                                as PurchaseOrderItemQuantity,

      @ObjectModel.readOnly: true
      //@ObjectModel.text.association: '_PurOrdUnitOfMsrTxt'

      @ObjectModel.foreignKey.association: '_PurOrdUnitOfMsrValHelp'
      @Semantics.unitOfMeasure: true
      _PurchaseOrderItem.PurchaseOrderQuantityUnit                    as PurchaseOrderItemQuantityUnit,

      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      @Aggregation.default: #NONE
      _PurchaseOrderItem.NetAmount                                    as PurchaseOrderItemNetAmount,

      @EndUserText.label: 'Purchase Order Currency'
      @ObjectModel.readOnly: true
      @ObjectModel.foreignKey.association: '_DocumentCurrency'
      @Consumption.valueHelp: '_DocumentCurrency'
      @Semantics.currencyCode:true
      _PurchaseOrderItem.DocumentCurrency                             as PurchaseOrderCurrency,

      @ObjectModel.readOnly: true
      _PurchaseOrderItem.CompanyCode                                  as PurchaseOrderItemCompanyCode,

      @ObjectModel.readOnly: true
      _PurchaseOrderItem.OverdelivTolrtdLmtRatioInPct,

      _PurchaseOrderItem.PurchaseOrderItemCategory,

      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      @Aggregation.default: #NONE
      _PurchaseOrderItem.ExpectedOverallLimitAmount,

      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      @Aggregation.default: #NONE
      _PurchaseOrderItem.OverallLimitAmount,

      @ObjectModel.readOnly: true
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderItemQuantityUnit'
      @Aggregation.default: #NONE
      cast(0 as mmpur_ses_confirmedquantity)                          as TotalConfirmedQuantity,

      @ObjectModel.readOnly: true
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderItemQuantityUnit'
      @Aggregation.default: #NONE
      cast(0 as mmpur_ses_openquantity)                               as OpenQuantity,

      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      @Aggregation.default: #NONE
      cast(0 as mmpur_ses_open_amount_po_crcy)                        as OpenAmountInPurchaseOrderCrcy,

      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'Currency'
      @Aggregation.default: #NONE
      Document.NetAmount,
      //      cast(

      //        case

      //          when _PurchaseOrderItem.PurchaseOrderItemCategory = 'A'

      //          then cast( round( Document.NetPriceAmount * Document.ConfirmedQuantity, 2) as mmpur_ses_confirmedvalue)

      //          else

      //            case

      //              when _PurchaseOrderItem.OrderQuantity = 0

      //              then cast(0 as mmpur_ses_confirmedvalue)

      //              else cast( round( division( (_PurchaseOrderItem.NetAmount * Document.ConfirmedQuantity), _PurchaseOrderItem.OrderQuantity, 6), 2) as mmpur_ses_confirmedvalue)

      //            end

      //        end as mmpur_ses_confirmedvalue)                                                     as NetAmount,


      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      @Aggregation.default: #NONE
      Document.NetAmount                                              as NetAmountInPurchaseOrderCrcy,
      //      cast(

      //        case

      //          when Currency <> _PurchaseOrderItem.DocumentCurrency

      //          then currency_conversion( amount => NetAmount,

      //                                    source_currency => Currency,

      //                                    round => 'X',

      //                                    target_currency => _PurchaseOrderItem.DocumentCurrency,

      //                                    exchange_rate_date => ServicePerformanceDate,

      //                                    error_handling => 'SET_TO_NULL' )

      //          else NetAmount

      //      end as mmpur_ses_netprice_purord_crcy)                                                 as NetAmountInPurchaseOrderCrcy,


      @Semantics.amount.currencyCode: 'Currency'
      Document.NonDeductibleInputTaxAmount,

      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'Currency'
      @Aggregation.default: #NONE
      cast( (Document.NetAmount + Document.NonDeductibleInputTaxAmount ) as mmpur_ses_confirmedvalue_w_tax ) as SESNetAmountInclSalesTax,



      Document.TaxCode,

      Document.TaxCountry,

      Document.TaxDeterminationDate,

      Document.TaxJurisdiction,

      Document.TaxCalculationProcedure,

      Document.PurgDocPriceDate,
      Document.SESItemIsFinalEntry,

      @ObjectModel.readOnly: true
      _Material.MaterialType,

      @ObjectModel.readOnly: true
      _AccountAssignmentCategory.ConsumptionPosting,

      @ObjectModel.readOnly: true
      _AccountAssignmentCategory.InventorySpecialStockType,

      @ObjectModel.readOnly: true
      _PurchaseOrderItem.ProductType                                  as ProductType,

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT , #TO_COMPOSITION_ROOT ]
      _ServiceEntrySheet,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _AccountAssignment,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _SESPricingElement,


      Document._Material,
      Document._MaterialGroup,
      Document._AccountAssignmentCategory,
      Document._UnitValueHelp,

      _MaterialGroupText,
      _MaterialGroupValueHelp, //to de deleted

      _AcctAssignmentCategoryText,
      _SrvcEntrShtAcctAssgmtCat,
      _DocumentCurrency,
      _UnitText,
      _PurOrdUnitOfMsrValHelp,
      _PurOrdUnitOfMsrTxt,
      _WorkItemText,
      _ProductTypeText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTASSIGNMENTCATEGORY",
"I_MATERIAL",
"I_PURCHASEORDER",
"I_PURGDOCSCHEDULELINE",
"I_SERVICEENTRYSHEETITEMBASIC",
"R_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"E_SERVICEENTRYSHEETITEM",
"I_ACCOUNTASSIGNMENTCATEGORY",
"I_ACCTASSIGNMENTCATEGORYTEXT",
"I_CURRENCY",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_MATERIALGROUPTEXT",
"I_PRODUCTTYPECODETEXT",
"I_PURCHASEORDER",
"I_PURGDOCSCHEDULELINE",
"I_SERVICEENTRYSHEET",
"I_SERVICEENTRYSHEETACCTASSGMT",
"I_SESPRICINGELEMENT",
"I_SRVCENTRSHTACCTASSGMTCAT",
"I_UNITOFMEASURE",
"I_UNITOFMEASURETEXT",
"I_WORKITEMTEXT",
"R_PURCHASEORDERITEM"
],
"BASE":
[
"I_SERVICEENTRYSHEETITEMBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/