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
////-> comment

//  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_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('' as ad_namtext)                                                                                                    as ServicePerformerName,
      @Semantics.text: true
      @ObjectModel.readOnly: true
//      cast(_BusinessPartner._CurrentDefaultAddress.AddressID as ad_addrnum)                                                     as FormattedAddress,

      cast('' as ad_addrnum )                                                                                                   as FormattedAddress,

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

      cast( '' as ad_telnrlg )                                                                                                  as InternationalPhoneNumber,
      @Semantics.text: true
      @ObjectModel.readOnly: true
//      _BPCurrentDefaultAddress._StandardAddress._DefaultMobilePhoneNumber.PhoneNumber                                           as MobilePhoneNumber,

      cast( '' as ad_telnrlg )                                                                                                  as MobilePhoneNumber,
      @Semantics.text: true
      @ObjectModel.readOnly: true
//      _BPCurrentDefaultAddress._StandardAddress._DefaultEmailAddress.EmailAddress                                               as EmailAddress,

      cast( '' as ad_smtpadr )                                                                                                  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,

////////-> insert

      cast( 0 as mmpur_ses_confirmedquantity)                          as TotalConfirmedQuantity,
      cast( 0 as mmpur_ses_openquantity)                               as OpenQuantity,

      @Semantics.amount.currencyCode: 'PurchaseOrderCurrency'
      cast( 0 as mmpur_ses_open_amount_po_crcy)                        as OpenAmountInPurchaseOrderCrcy,
      
      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'Currency'
      @Aggregation.default: #NONE
      cast( 0 as mmpur_ses_open_amount)                                as OpenAmountInTransCrcy,
////////<-

////-> comment/delete

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

////

////      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,

////

////      @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'

////      @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,
      
      _ServiceEntrySheet.PricingDocument,

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

      _Material,
      _MaterialText,
      _AccountAssignmentCategory,
      _AcctAssignmentCategoryText,
      _UnitValueHelp,
      _UnitText,
      _ServicePerformerValueHelp,
      _PurOrdUnitOfMsrValHelp,
      _PurOrdUnitOfMsrTxt,
//      _BusinessPartner,

      _PurchaseOrderItemVH,
      //      @Consumption.hidden: true

      _MltplAcctAssgmtDistr,
      _ProductTypeText
}
where
  Document.IsDeleted = ' '