P_AcctgServiceDocument

DDL: P_ACCTGSERVICEDOCUMENT SQL: PFIACSRVDOC Type: view BASIC

P_AcctgServiceDocument is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (fco_srvdoc) and exposes 20 fields with key fields ServiceDocumentType, ServiceDocument, ServiceDocumentItem.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
fco_srvdoc fco_srvdoc from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFIACSRVDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType service_doc_type
KEY ServiceDocument service_doc_id
KEY ServiceDocumentItem service_doc_item_id
ControllingObject objnr
ObjectType
SolutionOrder solution_order_id
BusinessSolutionOrder solution_order_id
CompanyCode company_code
ControllingArea controlling_area
ProfitCenter profit_center
FunctionalArea functional_area
SalesOrganization sales_organization
DistributionChannel distribution_channel
Division division
ResultAnalysisInternalID rev_rec_key
Currency object_currency
CostingSheet costing_sheet
ServiceDocumentItemDescription service_doc_item_desc
ServiceObjectType object_type
ServiceDocumentItemObjectType item_object_type 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCO_SRVDOC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More