I_CntrlPurContrItemPartnerTP

DDL: I_CNTRLPURCONTRITEMPARTNERTP SQL: ICPCITMPTNR Type: view TRANSACTIONAL

BO View for Partners in Central Contract Item Distribution

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

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurchaseContractPartner I_CntrlPurchaseContractPartner from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CentralPurchaseContractTP _CentralPurchaseContractTP _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract
[1..1] I_CntrlPurchaseContractItemTP _CntrlPurchaseContractItemTP _CntrlPurchaseContractItemTP.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem and _CntrlPurchaseContractItemTP.CentralPurchaseContract = $projection.CentralPurchaseContract
[1..1] I_CntrlPurContrDistributionTP _CntrlPurContrDistributionTP _CntrlPurContrDistributionTP.CentralPurchaseContract = $projection.CentralPurchaseContract and _CntrlPurContrDistributionTP.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem and _CntrlPurContrDistributionTP.DistributionKey = $projection.DistributionKey

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICPCITMPTNR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label BO View for Partners in Central Contract Item Distribution view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.writeDraftPersistence CNTRLPCITMPTNR_D view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract
KEY CentralPurchaseContractItem CentralPurchaseContractItem
KEY DistributionKey DistributionKey
KEY PartnerCounter PartnerCounter
PartnerFunction
ExtPlantForPurg ExtPlantForPurg
Supplier Supplier
SupplierSubrange SupplierSubrange
PurchasingOrganization PurchasingOrganization
_CentralPurchaseContractTP _CentralPurchaseContractTP
_CntrlPurContrDistributionTP _CntrlPurContrDistributionTP 
@AbapCatalog.sqlViewName: 'ICPCITMPTNR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'BO View for Partners in Central Contract Item Distribution'
@VDM.viewType:#TRANSACTIONAL

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.createEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.updateEnabled: true

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

@ObjectModel.semanticKey: ['CentralPurchaseContract', 'CentralPurchaseContractItem', 'DistributionKey', 'PartnerFunction', 'ExtPlantForPurg']
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.writeDraftPersistence: 'CNTRLPCITMPTNR_D'
 
define view I_CntrlPurContrItemPartnerTP
  as select from I_CntrlPurchaseContractPartner

  association [1..1] to I_CentralPurchaseContractTP   as _CentralPurchaseContractTP   on  _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract

  association [1..1] to I_CntrlPurchaseContractItemTP as _CntrlPurchaseContractItemTP on _CntrlPurchaseContractItemTP.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem
                                                                                      and  _CntrlPurchaseContractItemTP.CentralPurchaseContract     = $projection.CentralPurchaseContract

  association [1..1] to I_CntrlPurContrDistributionTP as _CntrlPurContrDistributionTP on  _CntrlPurContrDistributionTP.CentralPurchaseContract     = $projection.CentralPurchaseContract
                                                                                      and _CntrlPurContrDistributionTP.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem
                                                                                      and _CntrlPurContrDistributionTP.DistributionKey             = $projection.DistributionKey

{
  key CentralPurchaseContract,
  key CentralPurchaseContractItem,
  key DistributionKey,
  key PartnerCounter,
      cast( PartnerFunction as parvw ) as PartnerFunction,
      ExtPlantForPurg,
      Supplier,
      SupplierSubrange,
      PurchasingOrganization,

      /* Associations */
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT ]
      _CentralPurchaseContractTP,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT ]
      _CntrlPurContrDistributionTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNTRLPURCHASECONTRACTPARTNER"
],
"ASSOCIATED":
[
"I_CENTRALPURCHASECONTRACTTP",
"I_CNTRLPURCHASECONTRACTITEMTP",
"I_CNTRLPURCONTRDISTRIBUTIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More