P_BusSolnOrdSlsOrdFlw15

DDL: P_BUSSOLNORDSLSORDFLW15 Type: view CONSUMPTION Package: CRMS4_SOLUTION_ORDER_PROGRESS

Soluiton order Sales order flow level 15

P_BusSolnOrdSlsOrdFlw15 is a Consumption CDS View that provides data about "Soluiton order Sales order flow level 15" in SAP S/4HANA. It reads from 2 data sources (P_BusSolnOrdSlsOrdFlwLvl1, I_SDDocumentProcessFlow) and exposes 11 fields with key fields PrecedingDocument, PrecedingDocumentItem, PrecedingDocumentCategory, SubsequentDocument, SubsequentDocumentItem. Part of development package CRMS4_SOLUTION_ORDER_PROGRESS.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
P_BusSolnOrdSlsOrdFlwLvl1 Level1 from
I_SDDocumentProcessFlow Level15 inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PBSOSLSOFLWLVL15 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 Soluiton order Sales order flow level 15 view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument I_SDDocumentProcessFlow PrecedingDocument
KEY PrecedingDocumentItem I_SDDocumentProcessFlow PrecedingDocumentItem
KEY PrecedingDocumentCategory I_SDDocumentProcessFlow PrecedingDocumentCategory
KEY SubsequentDocument I_SDDocumentProcessFlow SubsequentDocument
KEY SubsequentDocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY SubsequentDocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
BusinessSolutionOrder P_BusSolnOrdSlsOrdFlwLvl1 BusinessSolutionOrder
BusinessSolutionOrderItem P_BusSolnOrdSlsOrdFlwLvl1 BusinessSolutionOrderItem
ServiceObjectType P_BusSolnOrdSlsOrdFlwLvl1 ServiceObjectType
SalesOrder P_BusSolnOrdSlsOrdFlwLvl1 SalesOrder
SalesOrderItem P_BusSolnOrdSlsOrdFlwLvl1 SalesOrderItem 
@AbapCatalog: {
    sqlViewName:            'PBSOSLSOFLWLVL15',
    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: 'Soluiton order Sales order flow level 15'

// Sales Order -> Invoice 2EQ Sales of Service

define view P_BusSolnOrdSlsOrdFlw15
  as select from P_BusSolnOrdSlsOrdFlwLvl1 as Level1
  
    inner join   I_SDDocumentProcessFlow   as Level15 on  Level15.PrecedingDocument          = Level1.SalesOrder
                                                      and Level15.PrecedingDocumentItem      = Level1.SalesOrderItem
                                                      and Level15.SubsequentDocumentCategory = 'M'
{
  key Level15.PrecedingDocument          as PrecedingDocument,
  key Level15.PrecedingDocumentItem      as PrecedingDocumentItem,
  key Level15.PrecedingDocumentCategory  as PrecedingDocumentCategory,
  key Level15.SubsequentDocument         as SubsequentDocument,
  key Level15.SubsequentDocumentItem     as SubsequentDocumentItem,
  key Level15.SubsequentDocumentCategory as SubsequentDocumentCategory,

      // For filtering

      Level1.BusinessSolutionOrder,
      Level1.BusinessSolutionOrderItem,
      Level1.ServiceObjectType,
      Level1.SalesOrder,
      Level1.SalesOrderItem
}

Learn More