P_BSQPMSBSCRCONTRTOPRVDRCONTR

CDS View

P_BSQPMSBSCRCONTRTOPRVDRCONTR is a CDS View in S/4HANA. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BSQPMSolnQtanItmProcFlw view_entity union COMPOSITE
P_BSQPMSolnQtanProcFlw view_entity union COMPOSITE 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    dataClass:      #TRANSACTIONAL,
    serviceQuality: #A,
    sizeCategory:   #XXL
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_BSQPMSbscrContrToPrvdrContr
  as select from I_ServiceDocumentItem  as ServiceDocumentItem
    inner join   I_ProviderContractItem as ProviderContractItem on ProviderContractItem.CAProviderContractItemUUID = ServiceDocumentItem.SrvcTransChgProcSourceItemUUID
{
  key ServiceDocumentItem.ServiceDocument                                                                          as PrecedingDocument,
  key ServiceDocumentItem.ServiceDocumentItem                                                                      as PrecedingDocumentItem,
      'SUBC'                                                                                                       as PrecedingDocumentCategory,
      // Provider Contract

      ProviderContractItem.ProviderContract                                                                        as SubsequentDocument,
      ProviderContractItem.ProviderContractItem                                                                    as SubsequentDocumentItem,
      'PC'                                                                                                         as SubsequentDocumentCategory
}
where
      ServiceDocumentItem.ServiceObjectType             = 'BUS2000266' // Subscription Contract

//  and ServiceDocumentItem.SubscrpnContrActivationStatus = 'E' //Subscription Contract is Technically Active

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROVIDERCONTRACTITEM",
"I_SERVICEDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More