R_SrvcQtanPartnerTP

DDL: R_SRVCQTANPARTNERTP Type: view_entity TRANSACTIONAL Package: CRMS4_SERVICE_QUOTATION_RAP

Service Quotation Partner - TP

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

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_CustMgmtPartner ServicePartner from
I_ServiceDocument ServiceQuotation inner

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
[0..1] R_SrvcQtanPartnerAddressTP _SrvcQtanPartnerAddressTP

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 Quotation Partner - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ServiceQuotation 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
_SrvcQtanPartnerAddressTP _SrvcQtanPartnerAddressTP
_ServiceQuotationTP _ServiceQuotationTP 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata:
{
  ignorePropagatedAnnotations: true
}
@EndUserText.label: 'Service Quotation Partner - TP'
@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #B,
                sizeCategory:   #L}
}


define view entity R_SrvcQtanPartnerTP
  as select from I_CustMgmtPartner as ServicePartner

    inner join   I_ServiceDocument as ServiceQuotation on  ServicePartner.CustMgmtDocument              = ServiceQuotation.ServiceDocument
                                                       and ServicePartner.CustMgmtObjectType            = ServiceQuotation.ServiceObjectType
                                                       and ServicePartner.CustMgmtDocumentItem          = '000000'
                                                       and ServiceQuotation.ServiceObjectType           = 'BUS2000116'
                                                       and ServiceQuotation.ServiceDocumentIsQuotation  is not initial
                                                       and ServiceQuotation.ServiceDocumentTemplateType is initial

  association        to parent R_ServiceQuotationTP as _ServiceQuotationTP on  $projection.ServiceQuotation = _ServiceQuotationTP.ServiceQuotation
  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
 
  composition [0..1] of R_SrvcQtanPartnerAddressTP  as _SrvcQtanPartnerAddressTP
 
{

       @ObjectModel.foreignKey.association: '_ServiceQuotationTP'
  key  ServicePartner.CustMgmtDocument as ServiceQuotation,

  key  ServicePartner.CustMgmtPartnerFunction,

  key  ServicePartner.CustMgmtBusinessPartner,

       ServicePartner.CustMgmtPartFunctionCategory,

       ServicePartner.CustMgmtPartnerIsMainPartner,

       //Association

       _PartnerFunction,
       _BusinessPartner,
       _SrvcQtanPartnerAddressTP,
       _ServiceQuotationTP
}

//where

//      ServicePartner.CustMgmtObjectType   = 'BUS2000116' // Service Process

//  and ServicePartner.CustMgmtDocumentItem is initial

Learn More