A_CommsnContrSettlmtAgreement

DDL: A_COMMSNCONTRSETTLMTAGREEMENT Type: view_entity CONSUMPTION
19 Fields 1 Data Sources 1 OData Services

Settlement Agreement

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

Data Sources (1)

SourceAliasJoin Type
I_CommsnContrSettlmtAgrmtByTme SettlementAgreement from

Annotations (10)

NameValueLevelField
EndUserText.label Settlement 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
OData.entityType.name CommsnContrSettlementAgreement_Type view
ObjectModel.sapObjectNodeType.name CommsnContrSettlementAgreement 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 (19)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication I_CommsnContrSettlmtAgrmtByTme CommissionApplication Commission Appl
KEY CommissionContract I_CommsnContrSettlmtAgrmtByTme CommissionContract
KEY CommsnContrEffctvFrmDateTime I_CommsnContrSettlmtAgrmtByTme CommsnContrEffctvFrmDateTime
KEY CommsnContrEffctvToDateTime I_CommsnContrSettlmtAgrmtByTme CommsnContrEffctvToDateTime
KEY CommissionContractAgreement I_CommsnContrSettlmtAgrmtByTme CommissionContractAgreement
KEY CommsnContrAgreementRule I_CommsnContrSettlmtAgrmtByTme CommsnContrAgreementRule
CommsnAgrmtEffctvFrmDteTme I_CommsnContrSettlmtAgrmtByTme CommsnAgrmtEffctvFrmDteTme
CommsnAgrmtEffctvToDteTme I_CommsnContrSettlmtAgrmtByTme CommsnAgrmtEffctvToDteTme
CommissionContractPersonnel I_CommsnContrSettlmtAgrmtByTme CommissionContractPersonnel
CommissionContractPayeeAccount I_CommsnContrSettlmtAgrmtByTme CommissionContractPayeeAccount
CommsnContractPaymentRecipient I_CommsnContrSettlmtAgrmtByTme CommsnContractPaymentRecipient
CommsnContrOthSystemRecipient I_CommsnContrSettlmtAgrmtByTme CommsnContrOthSystemRecipient
CommissionContractCAAccount I_CommsnContrSettlmtAgrmtByTme CommissionContractCAAccount
CommsnContractSettlementType I_CommsnContrSettlmtAgrmtByTme CommsnContractSettlementType
CommissionContractVersion I_CommsnContrSettlmtAgrmtByTme CommissionContractVersion
CommsnContractAgreementVersion I_CommsnContrSettlmtAgrmtByTme CommsnContractAgreementVersion
CommissionVersionIsInvalid I_CommsnContrSettlmtAgrmtByTme CommissionVersionIsInvalid
CommsnContrChangeReason I_CommsnContrSettlmtAgrmtByTme 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_CommsnContrSettlmtAgreement.
-- 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_CommsnContrSettlmtAgreement AS
SELECT
  SettlementAgreement.CommissionApplication AS CommissionApplication,
  SettlementAgreement.CommissionContract AS CommissionContract,
  SettlementAgreement.CommsnContrEffctvFrmDateTime AS CommsnContrEffctvFrmDateTime,
  SettlementAgreement.CommsnContrEffctvToDateTime AS CommsnContrEffctvToDateTime,
  SettlementAgreement.CommissionContractAgreement AS CommissionContractAgreement,
  SettlementAgreement.CommsnContrAgreementRule AS CommsnContrAgreementRule,
  SettlementAgreement.CommsnAgrmtEffctvFrmDteTme AS CommsnAgrmtEffctvFrmDteTme,
  SettlementAgreement.CommsnAgrmtEffctvToDteTme AS CommsnAgrmtEffctvToDteTme,
  SettlementAgreement.CommissionContractPersonnel AS CommissionContractPersonnel,
  SettlementAgreement.CommissionContractPayeeAccount AS CommissionContractPayeeAccount,
  SettlementAgreement.CommsnContractPaymentRecipient AS CommsnContractPaymentRecipient,
  SettlementAgreement.CommsnContrOthSystemRecipient AS CommsnContrOthSystemRecipient,
  SettlementAgreement.CommissionContractCAAccount AS CommissionContractCAAccount,
  SettlementAgreement.CommsnContractSettlementType AS CommsnContractSettlementType,
  SettlementAgreement.CommissionContractVersion AS CommissionContractVersion,
  SettlementAgreement.CommsnContractAgreementVersion AS CommsnContractAgreementVersion,
  SettlementAgreement.CommissionVersionIsInvalid AS CommissionVersionIsInvalid,
  SettlementAgreement.CommsnContrChangeReason AS CommsnContrChangeReason
FROM I_CommsnContrSettlmtAgrmtByTme AS SettlementAgreement
;

Learn More