A_CommsnContrTargetAgreement

DDL: A_COMMSNCONTRTARGETAGREEMENT Type: view_entity CONSUMPTION
16 Fields 1 Data Sources

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.

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

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication I_CommsnContrTargetAgrmtByTime CommissionApplication Commission Appl
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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_CommsnContrTargetAgreement.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_CommsnContrTargetAgreement AS
SELECT
  TargetAgrmt.CommissionApplication AS CommissionApplication,
  TargetAgrmt.CommissionContract AS CommissionContract,
  TargetAgrmt.CommsnContrEffctvFrmDateTime AS CommsnContrEffctvFrmDateTime,
  TargetAgrmt.CommsnContrEffctvToDateTime AS CommsnContrEffctvToDateTime,
  TargetAgrmt.CommissionStandardAgreement AS CommissionStandardAgreement,
  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
FROM I_CommsnContrTargetAgrmtByTime AS TargetAgrmt
;

Learn More