P_BusSolnOrdSrvcContrFlwLvl51

DDL: P_BUSSOLNORDSRVCCONTRFLWLVL51 Type: view CONSUMPTION Package: CRMS4_SOLUTION_ORDER_PROGRESS

Solution Order Service Contract Level51

P_BusSolnOrdSrvcContrFlwLvl51 is a Consumption CDS View that provides data about "Solution Order Service Contract Level51" in SAP S/4HANA. It reads from 2 data sources (P_BusSolnOrdSrvcContrFlwLvl4, I_JournalEntry) and exposes 10 fields with key fields PrecedingDocument, PrecedingDocumentItem, PrecedingDocumentCategory, SubsequentDocument, SubsequentDocumentItem. Part of development package CRMS4_SOLUTION_ORDER_PROGRESS.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
P_BusSolnOrdSrvcContrFlwLvl4 Level4 from
I_JournalEntry Level51 inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PBSOCNTRPF51LVL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Solution Order Service Contract Level51 view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument P_BusSolnOrdSrvcContrFlwLvl4 SubsequentDocument
KEY PrecedingDocumentItem P_BusSolnOrdSrvcContrFlwLvl4 SubsequentDocumentItem
KEY PrecedingDocumentCategory P_BusSolnOrdSrvcContrFlwLvl4 SubsequentDocumentCategory
KEY SubsequentDocument I_JournalEntry AccountingDocument
KEY SubsequentDocumentItem
KEY SubsequentDocumentCategory
BusinessSolutionOrder P_BusSolnOrdSrvcContrFlwLvl4 BusinessSolutionOrder
ServiceObjectType P_BusSolnOrdSrvcContrFlwLvl4 ServiceObjectType
ServiceContract ServiceContract
ServiceContractItem ServiceContractItem 
@AbapCatalog: {
    sqlViewName:            'PBSOCNTRPF51LVL',
    compiler.compareFilter: true,
    preserveKey:            true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
    dataClass:      #MIXED,
    serviceQuality: #C,
    sizeCategory:   #XL
}

@VDM: {
    viewType: #CONSUMPTION,
    private: true
}

@EndUserText.label: 'Solution Order Service Contract Level51'

// Invoice -> Journal Entry

define view P_BusSolnOrdSrvcContrFlwLvl51
  as select from P_BusSolnOrdSrvcContrFlwLvl4 as Level4
    inner join   I_JournalEntry               as Level51 on Level51.OriginalReferenceDocument = Level4.SubsequentDocument
                                                         and(
                                                           Level51.ReferenceDocumentType      = 'RMRP' --> Invoice Receipt
                                                           or Level51.ReferenceDocumentType   = 'VBRK' --> Billing Document
                                                         )

{
  key Level4.SubsequentDocument         as PrecedingDocument,
  key Level4.SubsequentDocumentItem     as PrecedingDocumentItem,
  key Level4.SubsequentDocumentCategory as PrecedingDocumentCategory,
  key Level51.AccountingDocument        as SubsequentDocument,
  key cast(''  as posnr_nach)           as SubsequentDocumentItem,
  key '+'                               as SubsequentDocumentCategory,
        
      // For filtering

      Level4.BusinessSolutionOrder,
      Level4.ServiceObjectType,
      ServiceContract,
      ServiceContractItem
}

Learn More