C_BPSupplierPartnerFunction

DDL: C_BPSUPPLIERPARTNERFUNCTION SQL: CBPSUPLRPARTFUNC Type: view CONSUMPTION

Supplier Partner Function WYT3

C_BPSupplierPartnerFunction is a Consumption CDS View that provides data about "Supplier Partner Function WYT3" in SAP S/4HANA. It reads from 1 data source (I_BPSupplierPartnerFunctionTP) and exposes 22 fields with key fields BusinessPartner, PurchasingOrganization, PartnerFunction, PartnerCounter. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPSupplierPartnerFunctionTP SupplierPartnerFunction from

Associations (8)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartnerSupplier _BPSupplier $projection.BusinessPartner = _BPSupplier.BusinessPartner
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerPurgOrg _BusinessPartnerPO $projection.BusinessPartner = _BusinessPartnerPO.BusinessPartner and $projection.PurchasingOrganization = _BusinessPartnerPO.PurchasingOrganization
[0..1] I_BPSuplrPartFunctionValueHelp _PartnerFunctionValueHelp $projection.PartnerFunctionForEdit = _PartnerFunctionValueHelp.PartnerFunction and $projection.BusinessPartnerGrouping = _PartnerFunctionValueHelp.BusinessPartnerGrouping
[0..1] I_Supplier_VH _PartnerNameValueHelp $projection.Supplier = _PartnerNameValueHelp.Supplier
[0..1] C_BPPartnerFunctionNumberVH _PartnerNumberValueHelp $projection.ReferenceSupplier = _PartnerNumberValueHelp.BusinessPartner and $projection.PartnerFunctionType = _PartnerNumberValueHelp.PartnerFunctionType
[0..1] I_ContactPerson _ContactPersonValueHelp $projection.ContactPerson = _ContactPersonValueHelp.ContactPerson
[0..*] C_Partfunctextvhtemp _PartFuncText $projection.PartnerFunction = _PartFuncText.PartnerFunction

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CBPSUPLRPARTFUNC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supplier Partner Function WYT3 view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.writeEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
UI.headerInfo.typeName Partner Function view
UI.headerInfo.typeNamePlural Partner Function view
UI.headerInfo.title.label Partner Function Description view
UI.headerInfo.title.value PartnerFunctionName view
VDM.viewType #CONSUMPTION view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPSupplierPartnerFunctionTP BusinessPartner
KEY PurchasingOrganization I_BPSupplierPartnerFunctionTP PurchasingOrganization
KEY PartnerFunction I_BPSupplierPartnerFunctionTP PartnerFunction
KEY PartnerCounter I_BPSupplierPartnerFunctionTP PartnerCounter
Supplier I_BPSupplierPartnerFunctionTP Supplier
ReferenceSupplier I_BPSupplierPartnerFunctionTP ReferenceSupplier
PartnerFunctionType I_BPSupplierPartnerFunctionTP PartnerFunctionType
ContactPerson I_BPSupplierPartnerFunctionTP ContactPerson
PartnerFunctionForEdit I_BPSupplierPartnerFunctionTP PartnerFunctionForEdit
DefaultPartner I_BPSupplierPartnerFunctionTP DefaultPartner
PartnerFunctionName I_BPSupplierPartnerFunctionTP PartnerFunctionName
Partner I_BPSupplierPartnerFunctionTP Partner
BusinessPartnerName I_BPSupplierPartnerFunctionTP BusinessPartnerName
BusinessPartnerGrouping I_BPSupplierPartnerFunctionTP BusinessPartnerGrouping
_BPSupplier _BPSupplier
_BusinessPartner _BusinessPartner
_BusinessPartnerPO _BusinessPartnerPO
_PartnerNameValueHelp _PartnerNameValueHelp
_PartnerNumberValueHelp _PartnerNumberValueHelp
_ContactPersonValueHelp _ContactPersonValueHelp
_PartFuncText _PartFuncText
_PartnerFunctionValueHelp _PartnerFunctionValueHelp
@AbapCatalog.sqlViewName: 'CBPSUPLRPARTFUNC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Supplier Partner Function WYT3'
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.allowExtensions: true
@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel.semanticKey: [ 'PurchasingOrganization','PartnerFunctionForEdit','PartnerCounter','BusinessPartner']
@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

@UI.headerInfo:{
  typeName: 'Partner Function',
  typeNamePlural: 'Partner Function',
  title:  { label:'Partner Function Description', value: 'PartnerFunctionName' }
  }

@VDM.viewType: #CONSUMPTION

define view C_BPSupplierPartnerFunction as select from I_BPSupplierPartnerFunctionTP as SupplierPartnerFunction
//  association [1..1] to C_BusinessPartnerSupplier   as _BusinessPartnerSupplier  on  $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner

  association [1..1] to C_BusinessPartnerSupplier   as _BPSupplier              on  $projection.BusinessPartner = _BPSupplier.BusinessPartner  
  association [1..1] to C_BusinessPartner           as _BusinessPartner          on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [1..1] to C_BusinessPartnerPurgOrg    as _BusinessPartnerPO        on  $projection.BusinessPartner     = _BusinessPartnerPO.BusinessPartner
                                                                                 and $projection.PurchasingOrganization = _BusinessPartnerPO.PurchasingOrganization
  //association [0..1] to C_PartnerFunctionValHelp    as _PartnerFunctionValueHelp on  $projection.PartnerFunctionForEdit  = _PartnerFunctionValueHelp.PartnerFunction

  association [0..1] to I_BPSuplrPartFunctionValueHelp      as _PartnerFunctionValueHelp on  $projection.PartnerFunctionForEdit  = _PartnerFunctionValueHelp.PartnerFunction
                                                                                 and $projection.BusinessPartnerGrouping = _PartnerFunctionValueHelp.BusinessPartnerGrouping
                                                                                                                                                                  
  //Langauage Independent value helps                                                                              

  association [0..1] to I_Supplier_VH               as _PartnerNameValueHelp     on  $projection.Supplier = _PartnerNameValueHelp.Supplier
  association [0..1] to C_BPPartnerFunctionNumberVH as _PartnerNumberValueHelp   on  $projection.ReferenceSupplier  = _PartnerNumberValueHelp.BusinessPartner
                                                                                 and $projection.PartnerFunctionType = _PartnerNumberValueHelp.PartnerFunctionType
  association [0..1] to I_ContactPerson             as _ContactPersonValueHelp   on  $projection.ContactPerson = _ContactPersonValueHelp.ContactPerson
  
  //TExt views

  //association [0..*] to I_PartnerFunctionText        as _PartFuncText             on  $projection.PartnerFunction = _PartFuncText.PartnerFunction

    association [0..*] to C_Partfunctextvhtemp        as _PartFuncText             on  $projection.PartnerFunction = _PartFuncText.PartnerFunction
   
 {
 @ObjectModel.readOnly
 key SupplierPartnerFunction.BusinessPartner    as  BusinessPartner,
 key SupplierPartnerFunction.PurchasingOrganization as PurchasingOrganization,
 //@ObjectModel.text.association: '_PartFuncText'

 key SupplierPartnerFunction.PartnerFunction as PartnerFunction,
 key SupplierPartnerFunction.PartnerCounter as  PartnerCounter,
 SupplierPartnerFunction.Supplier,
@ObjectModel: {
          foreignKey.association: '_PartnerNumberValueHelp'          }
      /*@Consumption.valueHelp: '_PartnerNumberValueHelp'*/
//      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

//      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'

 SupplierPartnerFunction.ReferenceSupplier,
 @ObjectModel.readOnly: true
 SupplierPartnerFunction.PartnerFunctionType,
 SupplierPartnerFunction.ContactPerson,
 
 //SupplierPartnerFunction.BusinessPartnerForEdit,

 //SupplierPartnerFunction.PurchasingOrganizationForEdit,

 @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
 @ObjectModel.text.association: '_PartFuncText'
 SupplierPartnerFunction.PartnerFunctionForEdit as PartnerFunctionForEdit,
 //SupplierPartnerFunction.PartnerCounterForEdit,

 SupplierPartnerFunction.DefaultPartner,
 SupplierPartnerFunction.PartnerFunctionName,
 @ObjectModel.readOnly:true
 SupplierPartnerFunction.Partner,
 @ObjectModel.readOnly:true
 SupplierPartnerFunction.BusinessPartnerName,
 SupplierPartnerFunction.BusinessPartnerGrouping as BusinessPartnerGrouping,
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _BPSupplier,
//      _BusinessPartnerSupplier,

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _BusinessPartner,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _BusinessPartnerPO,
      _PartnerNameValueHelp,
      _PartnerNumberValueHelp,
      _ContactPersonValueHelp,
      _PartFuncText,
      _PartnerFunctionValueHelp
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPSUPPLIERPARTNERFUNCTIONTP"
],
"ASSOCIATED":
[
"C_BPPARTNERFUNCTIONNUMBERVH",
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERPURGORG",
"C_BUSINESSPARTNERSUPPLIER",
"C_PARTFUNCTEXTVHTEMP",
"I_BPSUPLRPARTFUNCTIONVALUEHELP",
"I_CONTACTPERSON",
"I_SUPPLIER_VH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/