I_CntrlPurchaseContractPartner

DDL: I_CNTRLPURCHASECONTRACTPARTNER SQL: ICPCPARTNER Type: view BASIC

Basic View for Partners in Central Contract Distribution

I_CntrlPurchaseContractPartner is a Basic CDS View that provides data about "Basic View for Partners in Central Contract Distribution" in SAP S/4HANA. It reads from 1 data source (P_CntrlPurchaseContractPartner) and exposes 11 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey, PartnerCounter. It has 4 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
P_CntrlPurchaseContractPartner P_CntrlPurchaseContractPartner from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_CentralPurchaseContract _CentralPurchaseContract _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract
[1..1] I_CntrlPurchaseContractItem _CntrlPurchaseContractItem _CntrlPurchaseContractItem.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem and _CntrlPurchaseContractItem.CentralPurchaseContract = $projection.CentralPurchaseContract
[1..1] I_CntrlPurContrDistribution _CntrlPurContrDistribution _CntrlPurContrDistribution.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrDistribution.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem and _CntrlPurContrDistribution.DistributionKey = $projection.DistributionKey
[1..1] P_CntrlPurContrDistribution _CntrlPurContrDistrInternal _CntrlPurContrDistrInternal.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrDistrInternal.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem and _CntrlPurContrDistrInternal.DistributionKey = $projection.DistributionKey

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICPCPARTNER view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic View for Partners in Central Contract Distribution view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract purchasingdocument
KEY CentralPurchaseContractItem purchasingdocumentitem
KEY DistributionKey distributionnumber
KEY PartnerCounter partnercounter
PartnerFunction
ExtPlantForPurg extplantforpurg
Supplier supplier
SupplierSubrange suppliersubrange
PurchasingOrganization
_CentralPurchaseContract _CentralPurchaseContract
_CntrlPurContrDistribution _CntrlPurContrDistribution 
@AbapCatalog.sqlViewName: 'ICPCPARTNER'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Basic View for Partners in Central Contract Distribution'

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED

define view I_CntrlPurchaseContractPartner
  as select from P_CntrlPurchaseContractPartner
  association [1..1] to I_CentralPurchaseContract   as _CentralPurchaseContract    on  _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract

  association [1..1] to I_CntrlPurchaseContractItem as _CntrlPurchaseContractItem  on  _CntrlPurchaseContractItem.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem
                                                                                   and _CntrlPurchaseContractItem.CentralPurchaseContract     = $projection.CentralPurchaseContract

  association [1..1] to I_CntrlPurContrDistribution as _CntrlPurContrDistribution  on  _CntrlPurContrDistribution.CentralPurchaseContract     = $projection.CentralPurchaseContract
                                                                                   and _CntrlPurContrDistribution.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem
                                                                                   and _CntrlPurContrDistribution.DistributionKey             = $projection.DistributionKey
  association [1..1] to P_CntrlPurContrDistribution as _CntrlPurContrDistrInternal on  _CntrlPurContrDistrInternal.CentralPurchaseContract     = $projection.CentralPurchaseContract
                                                                                   and _CntrlPurContrDistrInternal.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem
                                                                                   and _CntrlPurContrDistrInternal.DistributionKey             = $projection.DistributionKey


{
  key purchasingdocument                                                                      as CentralPurchaseContract,
  key purchasingdocumentitem                                                                  as CentralPurchaseContractItem,
  key distributionnumber                                                                      as DistributionKey,
  key partnercounter                                                                          as PartnerCounter,
      @UI: { lineItem: [{position: 20,importance: #HIGH, label: 'Partner Function' }],
        identification: [{position: 20, label: 'Partner Function' }] }
      cast( partnerfunction as parvw_unv )                                                    as PartnerFunction,
      extplantforpurg                                                                         as ExtPlantForPurg,
      @UI: { lineItem: [{position: 10,importance: #HIGH, label: 'Partner' }],
        identification: [{position: 10, label: 'Partner' }] }
      supplier                                                                                as Supplier,
      @UI: { lineItem: [{position: 30,importance: #HIGH, label: 'Supplier Subrange' }],
        identification: [{position: 30, label: 'Supplier Subrange' }] }
      suppliersubrange                                                                        as SupplierSubrange,

      @UI: { lineItem: [{position: 40,importance: #HIGH, label: 'Purchasing Organization' }],
        identification: [{position: 40, label: 'Purchasing Organization' }] }
      coalesce( _CntrlPurContrDistrInternal.PurchasingOrganization , purchasingorganization  ) as PurchasingOrganization,

      /* Associations */
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT ]
      _CentralPurchaseContract,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT ]
      _CntrlPurContrDistribution
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CNTRLPURCHASECONTRACTPARTNER",
"P_CNTRLPURCONTRDISTRIBUTION"
],
"ASSOCIATED":
[
"I_CENTRALPURCHASECONTRACT",
"I_CNTRLPURCHASECONTRACTITEM",
"I_CNTRLPURCONTRDISTRIBUTION",
"P_CNTRLPURCONTRDISTRIBUTION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More