R_PPS_PurContractPartnerTP

DDL: R_PPS_PURCONTRACTPARTNERTP Type: view_entity TRANSACTIONAL

Purchase Contract Partners

R_PPS_PurContractPartnerTP is a Transactional CDS View that provides data about "Purchase Contract Partners" in SAP S/4HANA. It reads from 1 data source (I_Purctrpartners) and exposes 24 fields with key fields PurchaseContract, PurchaseContractItem, PurchasingOrganization, SupplierSubrange, Plant. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Purctrpartners I_Purctrpartners from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_PurContractPartnerFunctionVH _PurContrPartnerFunctionVH _PurContrPartnerFunctionVH.PartnerFunctionLanguageDepdnt = $projection.PartnerFunctionLanguageDepdnt and _PurContrPartnerFunctionVH.PurchasingDocumentType = $projection.PurchasingDocumentType
[0..1] I_PartnerFunctionText _PartnerFunctionText _PartnerFunctionText.PartnerFunction = $projection.PartnerFunction and _PartnerFunctionText.Language = $session.system_language
[0..1] I_PartnerFunction _PartnerFunction _PartnerFunction.PartnerFunction = $projection.PartnerFunction

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Purchase Contract Partners view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract
KEY PurchaseContractItem PurchaseContractItem
KEY PurchasingOrganization PurchasingOrganization
KEY SupplierSubrange SupplierSubrange
KEY Plant Plant
KEY PartnerFunction
KEY PartnerCounter PartnerCounter
PartnerFunctionLanguageDepdnt PartnerFunctionLanguageDepdnt
PurchasingDocumentCategory PurchasingDocumentCategory
PurchaseContractType PurchaseContractType
PurchasingDocumentType _PurchaseContract PurchaseContractType
CreatedByUser CreatedByUser
CreationDate CreationDate
PurchasingDocumentPartnerType _PartnerFunction SDDocumentPartnerType
Supplier Supplier
SupplierContact SupplierContact
DefaultPartner DefaultPartner
PurchasingDocumentPartner PurchasingDocumentPartner
PurchasingDocumentPartnerName PurchasingDocumentPartnerName
LastChangeDateTime _PurchaseContract LastChangeDateTime
_PurchaseContract _PurchaseContract
_PurContrPartnerFunctionVH _PurContrPartnerFunctionVH
_PartnerFunctionText _PartnerFunctionText
_PartnerFunction _PartnerFunction
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Purchase Contract Partners'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.semanticKey:  [ 'PurchaseContract','PurchaseContractItem','PurchasingOrganization','SupplierSubrange','Plant','PartnerFunction','PartnerCounter']
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@Metadata.ignorePropagatedAnnotations: true

//BoC  @JIRA-KEY:S4PPS-7271

define view entity R_PPS_PurContractPartnerTP
  as select from I_Purctrpartners

  association to parent R_PPS_PurchaseContractTP       as _PurchaseContract on _PurchaseContract.PurchaseContract = $projection.PurchaseContract
  association [0..*] to I_PurContractPartnerFunctionVH as _PurContrPartnerFunctionVH on  _PurContrPartnerFunctionVH.PartnerFunctionLanguageDepdnt = $projection.PartnerFunctionLanguageDepdnt 
                                                                                     and _PurContrPartnerFunctionVH.PurchasingDocumentType        = $projection.PurchasingDocumentType                 
  association [0..1] to I_PartnerFunctionText          as _PartnerFunctionText       on  _PartnerFunctionText.PartnerFunction = $projection.PartnerFunction
                                                                                     and _PartnerFunctionText.Language        = $session.system_language
 association [0..1] to I_PartnerFunction               as _PartnerFunction        on  _PartnerFunction.PartnerFunction = $projection.PartnerFunction
  
{
  key PurchaseContract,
  key PurchaseContractItem,
  key PurchasingOrganization,
  key SupplierSubrange,
  key Plant,
  key cast( PartnerFunction as parvw_unv preserving type ) as PartnerFunction,
  key PartnerCounter,
      @Consumption.valueHelp: '_PurContrPartnerFunctionVH'
      PartnerFunctionLanguageDepdnt ,
      PurchasingDocumentCategory,
      PurchaseContractType,
      _PurchaseContract.PurchaseContractType as PurchasingDocumentType,
      CreatedByUser,
      CreationDate,
      _PartnerFunction.SDDocumentPartnerType   as PurchasingDocumentPartnerType,
      Supplier,
      SupplierContact, 
      DefaultPartner,
      @ObjectModel.text.element: [ 'PurchasingDocumentPartnerName' ]
      @Consumption.valueHelp: '_PartnerFunctionText'
      PurchasingDocumentPartner,      
     @Semantics.text: true
      PurchasingDocumentPartnerName,
         
      @Semantics.systemDateTime.lastChangedAt: true
      _PurchaseContract.LastChangeDateTime as LastChangeDateTime,

//     _ControlFlag.Control          "Commented and control table not deleted and entries getting duplicated                                              as ControlFlags,

//      cast ( hextobin( '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' ) as pps_e_control_flag preserving type ) 

//                                                                                          as ControlFlags,

//     

      /* Associations */
      _PurchaseContract,
      _PurContrPartnerFunctionVH,
      _PartnerFunctionText,
      _PartnerFunction
}
//where 

//_PurchaseContract.PurchaseContract is not null


//EoC  @JIRA-KEY:S4PPS-7271

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PARTNERFUNCTION",
"I_PURCTRPARTNERS",
"R_PPS_PURCHASECONTRACTTP"
],
"ASSOCIATED":
[
"I_PARTNERFUNCTION",
"I_PARTNERFUNCTIONTEXT",
"I_PURCONTRACTPARTNERFUNCTIONVH",
"R_PPS_PURCHASECONTRACTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/