R_SrvcContrPartnerTP

DDL: R_SRVCCONTRPARTNERTP Type: view_entity TRANSACTIONAL Package: CRMS4_SERVICE_CONTRACT_RAP

Service Contract Partner - TP

R_SrvcContrPartnerTP is a Transactional CDS View that provides data about "Service Contract Partner - TP" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocument, I_CustMgmtPartner) and exposes 10 fields with key fields ServiceContract, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 4 associations to related views. Part of development package CRMS4_SERVICE_CONTRACT_RAP.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocument ServiceContract inner
I_CustMgmtPartner ServicePartner from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_CustMgmtPartnerFuncText _PartnerFunction $projection.CustMgmtPartnerFunction = _PartnerFunction.PartnerFunction and _PartnerFunction.Language = $session.system_language
[0..1] I_BusinessPartner _BusinessPartner $projection.CustMgmtBusinessPartner = _BusinessPartner.BusinessPartner
[0..*] I_SrvcMgmtPartnerFunctionText _SrvcMgmtPartnerFunctionText $projection.CustMgmtPartnerFunction = _SrvcMgmtPartnerFunctionText.CustMgmtPartnerFunction
[0..1] R_SrvcContrPartnerAddressTP _SrvcContrPartnerAddressTP

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 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_CustMgmtPartner CustMgmtDocument
KEY CustMgmtPartnerFunction I_CustMgmtPartner CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner I_CustMgmtPartner CustMgmtBusinessPartner
CustMgmtPartFunctionCategory I_CustMgmtPartner CustMgmtPartFunctionCategory
CustMgmtPartnerIsMainPartner I_CustMgmtPartner CustMgmtPartnerIsMainPartner
_PartnerFunction _PartnerFunction
_BusinessPartner _BusinessPartner
_SrvcMgmtPartnerFunctionText _SrvcMgmtPartnerFunctionText
_ServiceContractTP _ServiceContractTP
_SrvcContrPartnerAddressTP _SrvcContrPartnerAddressTP 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Service Contract Partner - TP'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #B,
                sizeCategory:   #L}
}


define view entity R_SrvcContrPartnerTP
  as select from I_CustMgmtPartner as ServicePartner 
      inner join   I_ServiceDocument  as ServiceContract on  ServicePartner.CustMgmtDocument     = ServiceContract.ServiceDocument
                                                        and ServicePartner.CustMgmtObjectType      = ServiceContract.ServiceObjectType     
                                                        and ServicePartner.CustMgmtDocumentItem    = '000000'
                                                        and ServiceContract.ServiceObjectType      = 'BUS2000112'
                                                        and ServiceContract.ServiceDocumentTemplateType is initial
                                                      
  association        to parent 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

  association [0..*] to I_SrvcMgmtPartnerFunctionText  as _SrvcMgmtPartnerFunctionText on $projection.CustMgmtPartnerFunction = _SrvcMgmtPartnerFunctionText.CustMgmtPartnerFunction

  composition [0..1] of R_SrvcContrPartnerAddressTP as _SrvcContrPartnerAddressTP

{

       @ObjectModel.foreignKey.association: '_ServiceContractTP'
  key  ServicePartner.CustMgmtDocument as ServiceContract,
       
       @ObjectModel.text.association:'_SrvcMgmtPartnerFunctionText'
  key  ServicePartner.CustMgmtPartnerFunction,

  key  ServicePartner.CustMgmtBusinessPartner,

       ServicePartner.CustMgmtPartFunctionCategory,

       ServicePartner.CustMgmtPartnerIsMainPartner,

       //Association

       _PartnerFunction,
       _BusinessPartner,
       _SrvcMgmtPartnerFunctionText,
       _ServiceContractTP,
       _SrvcContrPartnerAddressTP
}

Learn More