P_AcctgServiceDocument

@AbapCatalog.sqlViewName: 'PFIACSRVDOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL
    }
//@EndUserText.label: 'Financials View of Service Document'

define view P_AcctgServiceDocument
  as select from fco_srvdoc
{
  key service_doc_type                as ServiceDocumentType,
  key service_doc_id                  as ServiceDocument,
  key service_doc_item_id             as ServiceDocumentItem,
      objnr                           as ControllingObject,
      cast(left(objnr, 2) as j_obart) as ObjectType,
      solution_order_id               as SolutionOrder,
      solution_order_id               as BusinessSolutionOrder,
      company_code                    as CompanyCode,
      controlling_area                as ControllingArea,
      profit_center                   as ProfitCenter,
      functional_area                 as FunctionalArea,
      sales_organization              as SalesOrganization,
      distribution_channel            as DistributionChannel,
      division                        as Division,
      rev_rec_key                     as ResultAnalysisInternalID,
      object_currency                 as Currency,
      costing_sheet                   as CostingSheet,
      service_doc_item_desc           as ServiceDocumentItemDescription,
      object_type                     as ServiceObjectType,
      item_object_type                as ServiceDocumentItemObjectType,
      cast( wbs_elem as ps_s4_pspnr preserving type ) as WBSElementInternalID,
      objnr_sc                        as SrvcContrItmControllingObject,
      service_doc_item_guid_char      as ServiceDocumentItemCharUUID,
      revacc_relevant_type            as SrvcDocItmRevnAcctgRlvnceType
}