A_CePuCoDistrdOutlineAgrmt

DDL: A_CEPUCODISTRDOUTLINEAGRMT SQL: ACNTRLPCDISTROA Type: view COMPOSITE

Distributed Outline Agreement

A_CePuCoDistrdOutlineAgrmt is a Composite CDS View that provides data about "Distributed Outline Agreement" in SAP S/4HANA. It has 2 associations to related views.

11 fields

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_CentralPurchaseContract _CentralPurchaseContract $projection.CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract
[1..1] A_CePuCoDistrdContrPaytTrms _DistributedPaymentTerms $projection.CentralPurchaseContract = _DistributedPaymentTerms.CentralPurchaseContract and $projection.ExtContractForPurg = _DistributedPaymentTerms.ExtContractForPurg and $projection.ProcurementHubSourceSystem = _DistributedPaymentTerms.ProcurementHubSourceSystem

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ACNTRLPCDISTROA view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Distributed Outline Agreement view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract
KEY ExtContractForPurg ExtContractForPurg
KEY ProcurementHubSourceSystem ProcurementHubSourceSystem
CompanyCode CompanyCode
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
PurgDocItemDistributionStatus PurgDocItemDistributionStatus
SourceListIsUpdated SourceListIsUpdated
SourceListChangeConfStatus SourceListChangeConfStatus
_CentralPurchaseContract _CentralPurchaseContract
_DistributedPaymentTerms _DistributedPaymentTerms 
@AbapCatalog.sqlViewName: 'ACNTRLPCDISTROA'
@VDM.viewType : #COMPOSITE
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Distributed Outline Agreement'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel : {
    createEnabled: false,
    updateEnabled: false,
    deleteEnabled: false
}

@AccessControl.personalData.blocking: #REQUIRED
@Metadata.ignorePropagatedAnnotations:true
define view A_CePuCoDistrdOutlineAgrmt as select distinct from I_CntrlPurContrDistribution
 association [1..1] to A_CentralPurchaseContract as _CentralPurchaseContract on $projection.CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract
 association [1..1] to A_CePuCoDistrdContrPaytTrms as _DistributedPaymentTerms on $projection.CentralPurchaseContract = _DistributedPaymentTerms.CentralPurchaseContract
                                                                              and $projection.ExtContractForPurg = _DistributedPaymentTerms.ExtContractForPurg
                                                                              and $projection.ProcurementHubSourceSystem = _DistributedPaymentTerms.ProcurementHubSourceSystem
 {
  
  key    CentralPurchaseContract,
  key    ExtContractForPurg,
  key    ProcurementHubSourceSystem,   
         CompanyCode,       
         PurchasingOrganization,
        
         @ObjectModel.sapObjectNodeTypeReference: 'PurchasingGroup'
         PurchasingGroup,
         PurgDocItemDistributionStatus,
         SourceListIsUpdated,  
         SourceListChangeConfStatus,                       
         _CentralPurchaseContract,
         _DistributedPaymentTerms
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNTRLPURCONTRDISTRIBUTION"
],
"ASSOCIATED":
[
"A_CENTRALPURCHASECONTRACT",
"A_CEPUCODISTRDCONTRPAYTTRMS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More