I_ServiceEntrySheetItemTP

@AbapCatalog.sqlViewName: 'ISRVCENTRSH000TP'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Service Entry Sheet Item with Draft'
@ObjectModel.writeDraftPersistence: 'SRVCENTRSHTITM_D'
@ObjectModel.writeActivePersistence: 'ISRVCENTRSH000TP'
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
//@AccessControl.privilegedAssociations: [ '_SrvcEntrShtItmOpnAmtOrdCrcy' ]


@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.semanticKey: ['ServiceEntrySheet', 'ServiceEntrySheetItem']
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.sapObjectNodeType.name: 'ServiceEntrySheet'

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_ServiceEntrySheetItemTP
  as select from I_ServiceEntrySheetItem as Document

  association [1..1] to I_ServiceEntrySheetTP         as _ServiceEntrySheet            on  _ServiceEntrySheet.ServiceEntrySheet = $projection.ServiceEntrySheet
  association [1..*] to I_SESAccountAssignmentTP      as _AccountAssignment            on  _AccountAssignment.ServiceEntrySheet     = $projection.ServiceEntrySheet
                                                                                       and _AccountAssignment.ServiceEntrySheetItem = $projection.ServiceEntrySheetItem
  association [1..*] to I_SESPricingElementTP         as _SESPricingElementTP          on  _SESPricingElementTP.ServiceEntrySheet     = $projection.ServiceEntrySheet
                                                                                       and _SESPricingElementTP.ServiceEntrySheetItem = $projection.ServiceEntrySheetItem
  association [0..1] to I_Material                    as _Material                     on  _Material.Material = $projection.Service
  association [0..*] to I_MaterialText                as _MaterialText                 on  _MaterialText.Material = $projection.Service
  association [0..1] to I_AccountAssignmentCategory   as _AccountAssignmentCategory    on  _AccountAssignmentCategory.AccountAssignmentCategory = $projection.AccountAssignmentCategory
  association [0..1] to I_AcctAssignmentCategoryText  as _AcctAssignmentCategoryText   on  _AcctAssignmentCategoryText.AccountAssignmentCategory = $projection.AccountAssignmentCategory
                                                                                       and _AcctAssignmentCategoryText.Language                  = $session.system_language
  association [0..1] to I_UnitOfMeasure               as _UnitValueHelp                on  _UnitValueHelp.UnitOfMeasure = $projection.QuantityUnit
  association [0..*] to I_UnitOfMeasureText           as _UnitText                     on  _UnitText.UnitOfMeasure = $projection.QuantityUnit
  association [0..1] to I_UnitOfMeasure               as _PurOrdUnitOfMsrValHelp       on  _PurOrdUnitOfMsrValHelp.UnitOfMeasure = $projection.PurchaseOrderItemQuantityUnit
  association [0..*] to I_UnitOfMeasureText           as _PurOrdUnitOfMsrTxt           on  _PurOrdUnitOfMsrTxt.UnitOfMeasure = $projection.PurchaseOrderItemQuantityUnit
  association [0..1] to I_BusinessPartner             as _BusinessPartner              on  _BusinessPartner.BusinessPartner = $projection.ServicePerformer
  association [0..1] to I_BPCurrentDefaultAddress     as _BPCurrentDefaultAddress      on  _BPCurrentDefaultAddress.BusinessPartner = $projection.ServicePerformer //Performance

  association [0..1] to I_SrvcEntrShtServPrfValHelp   as _ServicePerformerValueHelp    on  $projection.ServicePerformer = _ServicePerformerValueHelp.ServicePerformer
                                                                                       and $projection.Supplier         = _ServicePerformerValueHelp.Supplier
  association [0..1] to I_SrvcEntrShtPurOrdItmVH      as _PurchaseOrderItemVH          on  $projection.PurchaseOrder     = _PurchaseOrderItemVH.PurchaseOrder
                                                                                       and $projection.PurchaseOrderItem = _PurchaseOrderItemVH.PurchaseOrderItem
  association [0..1] to P_SRVCENTRSHTITMTOTCONFDQTY   as _SrvcEntrShtItmTotConfdQty    on  _SrvcEntrShtItmTotConfdQty.PurchaseOrder     = $projection.PurchaseOrder
                                                                                       and _SrvcEntrShtItmTotConfdQty.PurchaseOrderItem = $projection.PurchaseOrderItem
  association [0..1] to I_SrvcEntrShtItmOpnAmtOrdCrcy as _SrvcEntrShtItmOpnAmtOrdCrcy  on  _SrvcEntrShtItmOpnAmtOrdCrcy.ServiceEntrySheet     = $projection.ServiceEntrySheet
                                                                                       and _SrvcEntrShtItmOpnAmtOrdCrcy.ServiceEntrySheetItem = $projection.ServiceEntrySheetItem
  association [0..1] to I_MltplAcctAssgmtDistr        as _MltplAcctAssgmtDistr         on  $projection.MultipleAcctAssgmtDistribution = _MltplAcctAssgmtDistr.MultipleAcctAssgmtDistribution
  
  association [0..1] to I_PurOrdDeliveryAddressTP      as _PurOrdDeliveryAddressTP      on  _PurOrdDeliveryAddressTP.PurchaseOrder     = $projection.PurchaseOrder
                                                                                        and _PurOrdDeliveryAddressTP.PurchaseOrderItem = $projection.PurchaseOrderItem

 association [0..1] to I_PurgDocumentItemCategoryText as _PurgDocumentItemCategoryText on _PurgDocumentItemCategoryText.Language = $session.system_language
                                                                                       and _PurgDocumentItemCategoryText.PurchasingDocumentItemCategory = Document.PurchaseOrderItemCategory

{
      //      @ObjectModel.readOnly: true

  key Document.ServiceEntrySheet,
  key Document.ServiceEntrySheetItem,

      Document.PurchaseOrder,

      Document.PurchaseOrderItem,

      @ObjectModel.readOnly: true
      Document.IsDeleted,

      @ObjectModel.text.association: '_MaterialText'
      Document.Service,

      Document.ServiceEntrySheetItemDesc,

      @ObjectModel.text.element: 'ServicePerformerName'
      Document.ServicePerformer,

      @Semantics.text: true
      cast(_BusinessPartner.BusinessPartnerName as ad_namtext)                                                                  as ServicePerformerName,
      @Semantics.text: true
      @ObjectModel.readOnly: true
//      cast(_BusinessPartner._CurrentDefaultAddress.AddressID as ad_addrnum)                                                     as FormattedAddress,

      cast(_BPCurrentDefaultAddress.AddressID as ad_addrnum preserving type )                                                   as FormattedAddress,

      @Semantics.text: true
      @ObjectModel.readOnly: true
//      _BusinessPartner._CurrentDefaultAddress._StandardAddress._DefaultPhoneNumber.InternationalPhoneNumber                     as InternationalPhoneNumber,

//      _BPCurrentDefaultAddress._StandardAddress._DefaultPhoneNumber.InternationalPhoneNumber                                    as InternationalPhoneNumber,

      _BPCurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber             as InternationalPhoneNumber,
      @Semantics.text: true
      @ObjectModel.readOnly: true
//      _BusinessPartner._CurrentDefaultAddress._StandardAddress._DefaultMobilePhoneNumber.PhoneNumber                            as MobilePhoneNumber,

//      _BPCurrentDefaultAddress._StandardAddress._DefaultMobilePhoneNumber.PhoneNumber                                           as MobilePhoneNumber,

      _BPCurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltMobilePhoneNumber.InternationalPhoneNumber             as MobilePhoneNumber,
      @Semantics.text: true
      @ObjectModel.readOnly: true
//      _BusinessPartner._CurrentDefaultAddress._StandardAddress._DefaultEmailAddress.EmailAddress                                as EmailAddress,

//      _BPCurrentDefaultAddress._StandardAddress._DefaultEmailAddress.EmailAddress                                               as EmailAddress,

      _BPCurrentDefaultAddress._AddressDefaultRepresentation._CurrentDfltEmailAddress.EmailAddress                              as EmailAddress,

      Document.AccountAssignmentCategory,

      @Consumption.valueHelp: '_MltplAcctAssgmtDistr'
      @ObjectModel.foreignKey.association: '_MltplAcctAssgmtDistr'
      Document.MultipleAcctAssgmtDistribution,

      Document.WorkItem,

      Document.ConfirmedQuantity,

      Document.QuantityUnit,

      @Semantics.unitOfMeasure: true
      Document.OrderPriceUnit,

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

      Document.OrderPriceUnitToOrderUnitNmrtr,

      Document.OrdPriceUnitToOrderUnitDnmntr,

      Document.QtyInPurchaseOrderPriceUnit,

      Document.ServicePerformanceDate,

      Document.ServicePerformanceEndDate,

      Document.PerformancePeriodStartDate,

      Document.PerformancePeriodEndDate,

      //      @ObjectModel.readOnly: true

      Document.OriginObject,

      @Semantics.currencyCode:true
      Document.Currency,

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

      cast( ' ' as ismaterialgroupinitial) as SESItemMaterialGroupIsInitial,
      Document.MaterialGroup,

      Document.IsEndOfPurposeBlocked,

      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      Document.NetAmount,

      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      Document.NetAmountInPurchaseOrderCrcy,

      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      Document.SESNetAmountInclSalesTax,

      Document.CreationDateTime,
      //      @ObjectModel.readOnly: true

      cast(Document.CreatedByUser as mmpur_ses_createdbyuser preserving type )                                                  as CreatedByUser,
      //      Document.CreatedByUser,

      Document.LastChangeDateTime,
      //      @ObjectModel.readOnly: true

      cast(Document.LastChangeUser as mmpur_ses_lastchangeuser preserving type )                                                as LastChangeUser,
      //      Document.LastChangeUser,


      Document.PurchasingOrganization,
      Document.PurchasingGroup,
      Document.Supplier,
      Document.PurchaseOrderItemMaterialGroup,

      @Aggregation.default: #NONE
      @DefaultAggregation:null
      Document.PurchaseOrderItemQuantity,
      Document.PurchaseOrderItemQuantityUnit,

      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      @Aggregation.default: #NONE
      @DefaultAggregation:null
      Document.PurchaseOrderItemNetAmount,
      @Semantics.currencyCode:true
      Document.PurchaseOrderCurrency,

      Document.Plant,
      Document.PurgDocItemExternalReference,
      Document.PurchaseContract,
      Document.PurchaseContractItem,
      Document.PurchaseOrderItemCompanyCode,
      Document.OverdelivTolrtdLmtRatioInPct,
      //      @ObjectModel.readOnly: true

      Document.PurchaseOrderItemCategory,
      _PurgDocumentItemCategoryText.PurgDocExternalItemCategory  as PurgDocExternalItemCategory,
      _PurgDocumentItemCategoryText.PurgDocItemCategoryName      as PurchaseOrderItemCategoryName,

      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      Document.ExpectedOverallLimitAmount,
      Document.OverallLimitAmount,

      //      case

      //        when _SrvcEntrShtItmTotConfdQty.TotalConfirmedQuantity is null then cast(0 as mmpur_ses_confirmedquantity)

      //      // when editing a service entry sheet item: the total confirmed quantity has to be reduced by the current value otherwise

      //      // (in case that the ses item consumes the whole/remaining quantity) the user cannot edit the ses at all

      //        else cast ( ( _SrvcEntrShtItmTotConfdQty.TotalConfirmedQuantity - Document.ConfirmedQuantity ) as mmpur_ses_confirmedquantity  )

      //      end                                                                                                   as TotalConfirmedQuantity,


      //      @ObjectModel.readOnly: true

      cast ( ( _SrvcEntrShtItmTotConfdQty.TotalConfirmedQuantity - Document.ConfirmedQuantity ) as mmpur_ses_confirmedquantity) as TotalConfirmedQuantity,

      //      @ObjectModel.readOnly: true

      case
        when Document.PurchaseOrderItemCategory = 'A'
        then cast( 0 as mmpur_ses_openquantity )
        else cast( coalesce( (Document.PurchaseOrderItemQuantity - _SrvcEntrShtItmTotConfdQty.TotalConfirmedQuantity),
                             Document.PurchaseOrderItemQuantity )
             as mmpur_ses_openquantity )
      end                                                                                                                       as OpenQuantity,

      //      cast(

      //          case

      //            when Document.PurchaseOrderItemCategory = 'A'

      //            then _SrvcEntrShtItmOpnAmtOrdCrcy.OpenAmountInPurchaseOrderCrcy

      //            else 0

      //      end as mmpur_ses_open_amount_po_crcy )                                                                as OpenAmountInPurchaseOrderCrcy,


      //      @ObjectModel.readOnly: true

      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      cast( _SrvcEntrShtItmOpnAmtOrdCrcy.OpenAmountInPurchaseOrderCrcy as mmpur_ses_open_amount_po_crcy preserving type )       as OpenAmountInPurchaseOrderCrcy,

      //      @ObjectModel.readOnly: true

      //      @Semantics.amount.currencyCode: 'Currency'

      //      @DefaultAggregation: #NONE

      //      cast(

      //        case

      //          when Document.PurchaseOrderItemCategory = 'A'

      //          then

      //            case

      //              when Document.PurchaseOrderCurrency <> Document.Currency

      //              then currency_conversion( amount => _SrvcEntrShtItmOpnAmtOrdCrcy.OpenAmountInPurchaseOrderCrcy,

      //                                        source_currency => Document.PurchaseOrderCurrency,

      //                                        round => 'X',

      //                                        target_currency => Document.Currency,

      //                                        exchange_rate_date => Document.ServicePerformanceDate,

      //                                        error_handling => 'SET_TO_NULL' )

      //              else _SrvcEntrShtItmOpnAmtOrdCrcy.OpenAmountInPurchaseOrderCrcy

      //              end

      //          else 0

      //      end as mmpur_ses_open_amount )                                                                        as OpenAmountInTransCrcy,


      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'Currency'
      @Aggregation.default: #NONE
      cast(
        case
          when Document.PurchaseOrderItemCategory = 'A' and Document.Currency <> ''
          then _SrvcEntrShtItmOpnAmtOrdCrcy.OpenAmountInPurchaseOrderCrcy
          else 0
      end as mmpur_ses_open_amount preserving type )                                                                            as OpenAmountInTransCrcy,

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

      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION'}
      Document.TaxCode,
      cast( ' ' as istaxcodeinitial) as SESItemTaxCodeIsInitial,

      @ObjectModel: { readOnly: true}
      Document.TaxCountry,
      cast( ' ' as istaxcountrycodeinitial) as SESItemTaxCountryCodeIsInitial,

      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION'}
      Document.TaxDeterminationDate,

      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION'}
      Document.TaxJurisdiction,
      cast( ' ' as istaxjurisdictioncodeinitial) as SESItmTaxJurisdictionIsInitial,

      @ObjectModel: { readOnly: true}
      Document.TaxCalculationProcedure,

      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION'}
      Document.PurgDocPriceDate,
      Document.SESItemIsFinalEntry,

      Document.MaterialType,
      Document.ConsumptionPosting,
      Document.InventorySpecialStockType,

      Document.ProductType,
      Document._ProductTypeText.Name                                                                                            as ProductTypeName,

      Document._DocumentCurrency,
      Document._MaterialGroup,
      Document._MaterialGroupValueHelp, //to be deleted

      Document._MaterialGroupText,
      Document._SrvcEntrShtAcctAssgmtCat,
      Document._WorkItemText,

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _ServiceEntrySheet,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _AccountAssignment,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _SESPricingElementTP,
      _PurOrdDeliveryAddressTP,
      _Material,
      _MaterialText,
      _AccountAssignmentCategory,
      _AcctAssignmentCategoryText,
      _UnitValueHelp,
      _UnitText,
      _ServicePerformerValueHelp,
      _PurOrdUnitOfMsrValHelp,
      _PurOrdUnitOfMsrTxt,
      _BusinessPartner,
      _PurchaseOrderItemVH,
      //      @Consumption.hidden: true

      _MltplAcctAssgmtDistr,
      _ProductTypeText
}
where
  Document.IsDeleted = ' '