I_SrvcTransMstrAgrmtPartner

DDL: I_SRVCTRANSMSTRAGRMTPARTNER Type: view_entity COMPOSITE

Master Agreement Partner

I_SrvcTransMstrAgrmtPartner is a Composite CDS View that provides data about "Master Agreement Partner" in SAP S/4HANA. It reads from 2 data sources (I_SrvcTransMasterAgreement, I_CustMgmtPartner) and exposes 9 fields with key fields SrvcTransMstrAgrmtID, CustMgmtPartnerFunction, CustMgmtBusinessPartner. It has 3 associations to related views.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_SrvcTransMasterAgreement MstrAgrmt inner
I_CustMgmtPartner MstrAgrmtPartner from

Associations (3)

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
[1..1] I_SrvcTransMasterAgreement _MasterAgreement $projection.SrvcTransMstrAgrmtID = _MasterAgreement.SrvcTransMstrAgrmtID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Master Agreement Partner view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SrvcTransMstrAgrmtID I_CustMgmtPartner CustMgmtDocument
KEY CustMgmtPartnerFunction I_CustMgmtPartner CustMgmtPartnerFunction
KEY CustMgmtBusinessPartner I_CustMgmtPartner CustMgmtBusinessPartner
CustMgmtPartFunctionCategory I_CustMgmtPartner CustMgmtPartFunctionCategory
CustMgmtPartner I_CustMgmtPartner CustMgmtPartner
CustMgmtPartnerNumberType I_CustMgmtPartner CustMgmtPartnerNumberType
_PartnerFunction _PartnerFunction
_BusinessPartner _BusinessPartner
_MasterAgreement _MasterAgreement 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}

@EndUserText.label: 'Master Agreement Partner'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
}
define view entity I_SrvcTransMstrAgrmtPartner
  as select from I_CustMgmtPartner          as MstrAgrmtPartner
    inner join   I_SrvcTransMasterAgreement as MstrAgrmt on  MstrAgrmtPartner.CustMgmtObjectType   = MstrAgrmt.SrvcTransMstrAgrmtType
                                                         and MstrAgrmtPartner.CustMgmtDocument     = MstrAgrmt.SrvcTransMstrAgrmtID
                                                         and MstrAgrmtPartner.CustMgmtDocumentItem = '000000'
                                                         and MstrAgrmt.SrvcTransMstrAgrmtType      = 'BUS2000267'
  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 [1..1] to I_SrvcTransMasterAgreement as _MasterAgreement on  $projection.SrvcTransMstrAgrmtID = _MasterAgreement.SrvcTransMstrAgrmtID

{
  key  MstrAgrmtPartner.CustMgmtDocument             as SrvcTransMstrAgrmtID,
  key  MstrAgrmtPartner.CustMgmtPartnerFunction      as CustMgmtPartnerFunction,
  key  MstrAgrmtPartner.CustMgmtBusinessPartner      as CustMgmtBusinessPartner,
       MstrAgrmtPartner.CustMgmtPartFunctionCategory as CustMgmtPartFunctionCategory,
       MstrAgrmtPartner.CustMgmtPartner              as CustMgmtPartner,
       MstrAgrmtPartner.CustMgmtPartnerNumberType    as CustMgmtPartnerNumberType,

       //Asscoiation

       _PartnerFunction,
       _BusinessPartner,       
       _MasterAgreement
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTMGMTPARTNER",
"I_SRVCTRANSMASTERAGREEMENT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CUSTMGMTPARTNERFUNCTEXT",
"I_SRVCTRANSMASTERAGREEMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More