P_SRVCDOCITEMADMISSIBLEPARTNER

CDS View

P_SRVCDOCITEMADMISSIBLEPARTNER 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_SrvcDocItemPartner view_entity inner COMPOSITE Service Transaction Item Partner
P_SrvcTransMstrAgrmtItmPartner view_entity inner COMPOSITE 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@VDM.private: true 
@VDM.viewType: #COMPOSITE
define view entity P_SrvcDocItemAdmissiblePartner 
  // Item categories with a strict PDP assigned

  as select from I_ServiceDocItemCategory     as ItemCategory
     inner join  I_SrvcMgmtPrtnDetnProcedure  as PDP              on  ItemCategory.SrvcMgmtPrtnDetnProcedure = PDP.SrvcMgmtPrtnDetnProcedure
     inner join  I_SrvcMgmtPrtnDetnProcedFunc as PDPFunction      on  PDP.SrvcMgmtPrtnDetnProcedure = PDPFunction.SrvcMgmtPrtnDetnProcedure
{ 
  key ItemCategory.ServiceDocItemCategory,
  key PDPFunction.CustMgmtPartnerFunction  
}
  where PDP.SrvcMgmtPrtnDetnProcedureScope = 'A'
// Item categories with an open PDP assigned

  union all  
     select from I_ServiceDocItemCategory     as ItemCategory
     inner join  I_SrvcMgmtPrtnDetnProcedure  as PDP              on  ItemCategory.SrvcMgmtPrtnDetnProcedure = PDP.SrvcMgmtPrtnDetnProcedure
     cross join  I_SrvcMgmtPartnerFunction    as PartnerFunction
{ 
  key ItemCategory.ServiceDocItemCategory,
  key PartnerFunction.CustMgmtPartnerFunction  
} 
  where PDP.SrvcMgmtPrtnDetnProcedureScope <> 'A'
  and   PartnerFunction.SrvcMgmtPrtnFuncApplication = 'CRM'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCITEMCATEGORY",
"I_SRVCMGMTPARTNERFUNCTION",
"I_SRVCMGMTPRTNDETNPROCEDFUNC",
"I_SRVCMGMTPRTNDETNPROCEDURE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More