P_ACCTGSERVICEDOCUMENTITEM

CDS View

P_ACCTGSERVICEDOCUMENTITEM is a CDS View in S/4HANA. It contains 1 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 1 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_AccountingServiceDocument view_entity from COMPOSITE Accounting Service Document
I_AcctgServiceDocumentItemVH view from COMPOSITE Service Document Item ID Value Help
I_AcctgServiceDocumentType view_entity from COMPOSITE Accounting Service Document Type
I_AcctgServiceDocumentTypeVH view from COMPOSITE Service Document Type Value Help
I_AcctgServiceDocumentVH view from COMPOSITE Service Document ID Value Help
I_ServiceOrderDocumentItemVH view from COMPOSITE Service Order Document Item ID
I_ServiceOrderDocumentTypeVH view from COMPOSITE Service Order Document Type
I_ServiceOrderDocumentVH view from COMPOSITE Service Order Document ID

Fields (1)

KeyField CDS FieldsUsed in Views
KEY ServiceDocumentType ServiceDocumentType 2 
@AbapCatalog.sqlViewName: 'PFIACSRVDOCITM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL
    }
//@EndUserText.label: 'Financials View of Service Document'

define view P_AcctgServiceDocumentItem 
  as select from I_AcctgServiceDocumentItem
  association [1..*] to I_ProductText as _ProductText               on  $projection.OriginallyRequestedProduct = _ProductText.Product
{
  key ServiceDocumentType,
  key ServiceDocument,
  key ServiceDocumentItem,
      ControllingObject,
      CompanyCode,
      ControllingArea,
      ProfitCenter,
      FunctionalArea,
      ResultAnalysisInternalID,
      Currency,
      
      cast(_ServiceDocument.ServiceDocumentDescription as fco_srvdoc_description)                                                as ServiceDocumentDescription,
      _ServiceDocumentItem.ServiceDocItemCategory                                                                                as ServiceDocItemCategory,
      ServiceDocumentItemDescription,
      ////cast(_ServiceDocumentItem.OriginallyRequestedProduct as productnumber)                                                     as OriginallyRequestedProduct,

      _ServiceDocumentItem.OriginallyRequestedProduct                                                                            as OriginallyRequestedProduct,
      cast(_ServiceDocument.PostingDate as fco_srvdoc_date)                                                                      as PostingDate,
      _ServiceDocumentType[1: Language = $session.system_language].ServiceDocumentTypeName                                       as ServiceDocumentTypeName,
      _ServiceDocumentItem._ServiceDocItemCategory._ServiceDocItemCategoryText[1: Language = $session.system_language].ServiceDocItemCategoryName as ServiceDocItemCategoryName,
      ////_ProfitCenter[1: Language = $session.system_language].ProfitCenterName                                                     as ProfitCenterName,

      _ServiceDocumentItem.SrvcOrderConfirmationRelevance                                                                        as SrvcOrderConfirmationRelevance,
      
      _ProductText          
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCTGSERVICEDOCUMENTITEM",
"I_SERVICEDOCITEMCATEGORY",
"I_SERVICEDOCITEMCATEGORYTEXT",
"I_SERVICEDOCUMENT",
"I_SERVICEDOCUMENTITEM",
"I_SERVICEDOCUMENTTYPETEXT"
],
"ASSOCIATED":
[
"I_PRODUCTTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More