A_CommsnContrRtntnAgreement

DDL: A_COMMSNCONTRRTNTNAGREEMENT Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 1 OData Services

Retention Agreement

A_CommsnContrRtntnAgreement is a Consumption CDS View that provides data about "Retention Agreement" in SAP S/4HANA. It reads from 1 data source (I_CommsnContrRtntnAgrmtByTime) and exposes 17 fields with key fields CommissionApplication, CommissionContract, CommsnContrEffctvFrmDateTime, CommsnContrEffctvToDateTime, CommissionContractAgreement. It is exposed through 1 OData service (API_COMMISSIONCONTRACT).

Data Sources (1)

SourceAliasJoin Type
I_CommsnContrRtntnAgrmtByTime RetentionAgreement from

Annotations (10)

NameValueLevelField
EndUserText.label Retention 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 CommsnContrRetentionAgreement view
OData.entityType.name CommsnContrRetentionAgreement_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 (17)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication I_CommsnContrRtntnAgrmtByTime CommissionApplication Commission Appl
KEY CommissionContract I_CommsnContrRtntnAgrmtByTime CommissionContract
KEY CommsnContrEffctvFrmDateTime I_CommsnContrRtntnAgrmtByTime CommsnContrEffctvFrmDateTime
KEY CommsnContrEffctvToDateTime I_CommsnContrRtntnAgrmtByTime CommsnContrEffctvToDateTime
KEY CommissionContractAgreement I_CommsnContrRtntnAgrmtByTime CommissionContractAgreement
KEY CommsnContrAgreementRule I_CommsnContrRtntnAgrmtByTime CommsnContrAgreementRule
CommsnAgrmtEffctvFrmDteTme I_CommsnContrRtntnAgrmtByTime CommsnAgrmtEffctvFrmDteTme
CommsnAgrmtEffctvToDteTme I_CommsnContrRtntnAgrmtByTime CommsnAgrmtEffctvToDteTme
CommissionContractCurrency I_CommsnContrRtntnAgrmtByTime CommissionContractCurrency
CommsnAgrmtMaxRetentionAmount I_CommsnContrRtntnAgrmtByTime CommsnAgrmtMaxRetentionAmount
CommsnAgrmtRetentionPercent I_CommsnContrRtntnAgrmtByTime CommsnAgrmtRetentionPercent
CommsnContrRtntnThldAmount I_CommsnContrRtntnAgrmtByTime CommsnContrRtntnThldAmount
CommissionContractVersion I_CommsnContrRtntnAgrmtByTime CommissionContractVersion
CommsnContractAgreementVersion I_CommsnContrRtntnAgrmtByTime CommsnContractAgreementVersion
CommissionVersionIsInvalid I_CommsnContrRtntnAgrmtByTime CommissionVersionIsInvalid
CommsnContrChangeReason I_CommsnContrRtntnAgrmtByTime 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_CommsnContrRtntnAgreement.
-- 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_CommsnContrRtntnAgreement AS
SELECT
  RetentionAgreement.CommissionApplication AS CommissionApplication,
  RetentionAgreement.CommissionContract AS CommissionContract,
  RetentionAgreement.CommsnContrEffctvFrmDateTime AS CommsnContrEffctvFrmDateTime,
  RetentionAgreement.CommsnContrEffctvToDateTime AS CommsnContrEffctvToDateTime,
  RetentionAgreement.CommissionContractAgreement AS CommissionContractAgreement,
  RetentionAgreement.CommsnContrAgreementRule AS CommsnContrAgreementRule,
  RetentionAgreement.CommsnAgrmtEffctvFrmDteTme AS CommsnAgrmtEffctvFrmDteTme,
  RetentionAgreement.CommsnAgrmtEffctvToDteTme AS CommsnAgrmtEffctvToDteTme,
  RetentionAgreement.CommissionContractCurrency AS CommissionContractCurrency,
  RetentionAgreement.CommsnAgrmtMaxRetentionAmount AS CommsnAgrmtMaxRetentionAmount,
  RetentionAgreement.CommsnAgrmtRetentionPercent AS CommsnAgrmtRetentionPercent,
  RetentionAgreement.CommsnContrRtntnThldAmount AS CommsnContrRtntnThldAmount,
  RetentionAgreement.CommissionContractVersion AS CommissionContractVersion,
  RetentionAgreement.CommsnContractAgreementVersion AS CommsnContractAgreementVersion,
  RetentionAgreement.CommissionVersionIsInvalid AS CommissionVersionIsInvalid,
  RetentionAgreement.CommsnContrChangeReason AS CommsnContrChangeReason
FROM I_CommsnContrRtntnAgrmtByTime AS RetentionAgreement
;

Learn More