R_SrvcContrItemPartnerTP

DDL: R_SRVCCONTRITEMPARTNERTP Type: view_entity TRANSACTIONAL

Service Contract Item Partner - TP

R_SrvcContrItemPartnerTP is a Transactional CDS View that provides data about "Service Contract Item Partner - TP" in SAP S/4HANA. It reads from 2 data sources (I_CustMgmtPartner, I_ServiceDocumentItem) and exposes 10 fields with key fields ServiceContract, ServiceContractItem, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 3 associations to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_CustMgmtPartner I_CustMgmtPartner from
I_ServiceDocumentItem ServiceContractItem inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] R_ServiceContractTP _ServiceContractTP $projection.ServiceContract = _ServiceContractTP.ServiceContract
[0..1] I_CustMgmtPartnerFuncText _PartnerFunction $projection.CustMgmtPartnerFunction = _PartnerFunction.PartnerFunction and _PartnerFunction.Language = $session.system_language
[0..1] I_BusinessPartner _BusinessPartner $projection.CustMgmtBusinessPartner = _BusinessPartner.BusinessPartner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Service Contract Item Partner - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract I_ServiceDocumentItem ServiceDocument
KEY ServiceContractItem I_ServiceDocumentItem ServiceDocumentItem
KEY CustMgmtPartnerFunction I_CustMgmtPartner CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner I_CustMgmtPartner CustMgmtBusinessPartner
CustMgmtPartFunctionCategory I_CustMgmtPartner CustMgmtPartFunctionCategory
CustMgmtPartnerIsMainPartner I_CustMgmtPartner CustMgmtPartnerIsMainPartner
_PartnerFunction _PartnerFunction
_BusinessPartner _BusinessPartner
_ServiceContractItemTP _ServiceContractItemTP
_ServiceContractTP _ServiceContractTP 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Service Contract Item Partner - TP'
@ObjectModel: {

   semanticKey: ['CustMgmtBusinessPartner','CustMgmtPartnerFunction'],
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #B,
                sizeCategory:   #L}
}
define view entity R_SrvcContrItemPartnerTP
  as select from I_CustMgmtPartner

  //  inner join R_ServiceContractItemTP as ServiceContractItem on  I_CustMgmtPartner.CustMgmtDocument     = ServiceContractItem.ServiceContract

  //                                                            and I_CustMgmtPartner.CustMgmtDocumentItem = ServiceContractItem.SrvcDocItmPartReferenceItem

  //                                                            and I_CustMgmtPartner.CustMgmtObjectType   = ServiceContractItem.ServiceObjectType

    inner join   I_ServiceDocumentItem as ServiceContractItem on  I_CustMgmtPartner.CustMgmtDocument     = ServiceContractItem.ServiceDocument
                                                              and I_CustMgmtPartner.CustMgmtDocumentItem = ServiceContractItem.SrvcDocItmPartReferenceItem
                                                              and I_CustMgmtPartner.CustMgmtObjectType   = ServiceContractItem.ServiceObjectType
                                                              and ServiceContractItem.ServiceObjectType  = 'BUS2000112'

  association        to parent R_ServiceContractItemTP as _ServiceContractItemTP on  $projection.ServiceContract     = _ServiceContractItemTP.ServiceContract
                                                                                 and $projection.ServiceContractItem = _ServiceContractItemTP.ServiceContractItem

  association [0..1] to R_ServiceContractTP            as _ServiceContractTP     on  $projection.ServiceContract = _ServiceContractTP.ServiceContract

  association [0..1] to I_CustMgmtPartnerFuncText      as _PartnerFunction       on  $projection.CustMgmtPartnerFunction = _PartnerFunction.PartnerFunction
                                                                                 and _PartnerFunction.Language           = $session.system_language
  association [0..1] to I_BusinessPartner              as _BusinessPartner       on  $projection.CustMgmtBusinessPartner = _BusinessPartner.BusinessPartner

{

       //  key  CustMgmtDocument     as ServiceContract,

       //

       //  key  CustMgmtDocumentItem as ServiceContractItem,

       //

       //  key  CustMgmtPartnerFunction,

       //

       //  key  CustMgmtBusinessPartner,

       //

       //       CustMgmtPartFunctionCategory,


      key  ServiceContractItem.ServiceDocument     as ServiceContract,
      
      key  ServiceContractItem.ServiceDocumentItem as ServiceContractItem,
      
      key  I_CustMgmtPartner.CustMgmtPartnerFunction as CustMgmtPartnerFunction,
    
      key  I_CustMgmtPartner.CustMgmtBusinessPartner as CustMgmtBusinessPartner,
    
           I_CustMgmtPartner.CustMgmtPartFunctionCategory as CustMgmtPartFunctionCategory,
           
           I_CustMgmtPartner.CustMgmtPartnerIsMainPartner as CustMgmtPartnerIsMainPartner,

       //Association

       _PartnerFunction,
       _BusinessPartner,
       _ServiceContractItemTP,
       _ServiceContractTP //added for strict


}

//where

//      CustMgmtObjectType   = 'BUS2000112' // Service Contract

//  and CustMgmtDocumentItem is not initial

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTMGMTPARTNER",
"I_SERVICEDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CUSTMGMTPARTNERFUNCTEXT",
"R_SERVICECONTRACTITEMTP",
"R_SERVICECONTRACTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More