A_CommsnContrTargetAgreement

DDL: A_COMMSNCONTRTARGETAGREEMENT Type: view_entity CONSUMPTION Package: CACSVDM_CONTRACT

Target agreement

A_CommsnContrTargetAgreement is a Consumption CDS View that provides data about "Target agreement" in SAP S/4HANA. It reads from 1 data source (I_CommsnContrTargetAgrmtByTime) and exposes 16 fields with key fields CommissionApplication, CommissionContract, CommsnContrEffctvFrmDateTime, CommsnContrEffctvToDateTime, CommissionStandardAgreement. It is exposed through 1 OData service (API_COMMISSIONCONTRACT). Part of development package CACSVDM_CONTRACT.

1 data source(s) Exposed by 1 service(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_CommsnContrTargetAgrmtByTime TargetAgrmt from

Annotations (10)

NameValueLevelField
EndUserText.label Target agreement view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
ObjectModel.sapObjectNodeType.name CommsnContractTargetAgreement view
OData.entityType.name CommsnContractTargetAgreement_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_COMMISSIONCONTRACT API_COMMISSIONCONTRACT V4 C2 C1

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication I_CommsnContrTargetAgrmtByTime CommissionApplication
KEY CommissionContract I_CommsnContrTargetAgrmtByTime CommissionContract
KEY CommsnContrEffctvFrmDateTime I_CommsnContrTargetAgrmtByTime CommsnContrEffctvFrmDateTime
KEY CommsnContrEffctvToDateTime I_CommsnContrTargetAgrmtByTime CommsnContrEffctvToDateTime
KEY CommissionStandardAgreement I_CommsnContrTargetAgrmtByTime CommissionStandardAgreement
KEY CommissionContractAgreement I_CommsnContrTargetAgrmtByTime CommissionContractAgreement
CommsnAgrmtEffctvFrmDteTme I_CommsnContrTargetAgrmtByTime CommsnAgrmtEffctvFrmDteTme
CommsnAgrmtEffctvToDteTme I_CommsnContrTargetAgrmtByTime CommsnAgrmtEffctvToDteTme
CommissionContractVersion I_CommsnContrTargetAgrmtByTime CommissionContractVersion
CommsnContrAgreementRule I_CommsnContrTargetAgrmtByTime CommsnContrAgreementRule
CommsnContractAgreementVersion I_CommsnContrTargetAgrmtByTime CommsnContractAgreementVersion
CommissionContractCurrency I_CommsnContrTargetAgrmtByTime CommissionContractCurrency
CommsnContrAgreementIsLocked I_CommsnContrTargetAgrmtByTime CommsnContrAgreementIsLocked
CommissionVersionIsInvalid I_CommsnContrTargetAgrmtByTime CommissionVersionIsInvalid
CommsnContrChangeReason I_CommsnContrTargetAgrmtByTime CommsnContrChangeReason
_CommissionContract _CommissionContract 
@EndUserText.label: 'Target agreement'
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #CONSUMPTION
@ObjectModel.sapObjectNodeType.name: 'CommsnContractTargetAgreement'
@OData.entityType.name: 'CommsnContractTargetAgreement_Type'
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
//@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]

@Metadata.ignorePropagatedAnnotations: true
define view entity A_CommsnContrTargetAgreement
  as select from I_CommsnContrTargetAgrmtByTime as TargetAgrmt

  association to parent A_CommissionContract as _CommissionContract on  $projection.CommissionApplication        = _CommissionContract.CommissionApplication
                                                                    and $projection.CommissionContract           = _CommissionContract.CommissionContract
                                                                    and $projection.CommsnContrEffctvFrmDateTime = _CommissionContract.CommsnContrEffctvFrmDateTime
                                                                    and $projection.CommsnContrEffctvToDateTime  = _CommissionContract.CommsnContrEffctvToDateTime

{
  key TargetAgrmt.CommissionApplication          as CommissionApplication,
  key TargetAgrmt.CommissionContract             as CommissionContract,
  key TargetAgrmt.CommsnContrEffctvFrmDateTime   as CommsnContrEffctvFrmDateTime,
  key TargetAgrmt.CommsnContrEffctvToDateTime    as CommsnContrEffctvToDateTime,
  key TargetAgrmt.CommissionStandardAgreement    as CommissionStandardAgreement,
  key TargetAgrmt.CommissionContractAgreement    as CommissionContractAgreement,
      TargetAgrmt.CommsnAgrmtEffctvFrmDteTme     as CommsnAgrmtEffctvFrmDteTme,
      TargetAgrmt.CommsnAgrmtEffctvToDteTme      as CommsnAgrmtEffctvToDteTme,

      TargetAgrmt.CommissionContractVersion      as CommissionContractVersion,
      TargetAgrmt.CommsnContrAgreementRule       as CommsnContrAgreementRule,
      TargetAgrmt.CommsnContractAgreementVersion as CommsnContractAgreementVersion,

      TargetAgrmt.CommissionContractCurrency     as CommissionContractCurrency,
      TargetAgrmt.CommsnContrAgreementIsLocked   as CommsnContrAgreementIsLocked,
      TargetAgrmt.CommissionVersionIsInvalid     as CommissionVersionIsInvalid,

      TargetAgrmt.CommsnContrChangeReason        as CommsnContrChangeReason,

      @ObjectModel.sort.enabled: false
      @ObjectModel.filter.enabled: false
      _CommissionContract
}

Learn More