I_CommsnContrPaytRelAgreement

DDL: I_COMMSNCONTRPAYTRELAGREEMENT Type: view_entity BASIC
11 Fields 1 Data Sources

Agreement for Settlement Release

I_CommsnContrPaytRelAgreement is a Basic CDS View that provides data about "Agreement for Settlement Release" in SAP S/4HANA. It reads from 1 data source (cacs_pragr) and exposes 11 fields with key fields CommissionApplication, CommissionContract, CommissionContractAgreement, CommsnContractAgreementVersion, CommsnContrAgreementRule.

Data Sources (1)

SourceAliasJoin Type
cacs_pragr cacs_pragr from

Annotations (7)

NameValueLevelField
EndUserText.label Agreement for Settlement Release view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name CommsnContrPaytRelAgreement view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication appl Rep. Model
KEY CommissionContract ctrtbu_id Contract Number
KEY CommissionContractAgreement No.SttRelAg
KEY CommsnContractAgreementVersion version XML Vers.
KEY CommsnContrAgreementRule Release Rule
CommsnAgrmtRmnrtnStrtDteTme StValidSttRelAgmt
CommsnAgrmtRmnrtnEndDteTime EndValSttRelAgrmt
CommsnContrAgrmtPriorityValue priority Workflow priority
CommsnAgrmtEffctvFrmDteTme Effective from
CommsnAgrmtEffctvToDteTme Effective Until
CommissionVersionIsInvalid flg_cancel_vers Invalid Version

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 I_CommsnContrPaytRelAgreement.
-- 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 I_CommsnContrPaytRelAgreement AS
SELECT
  appl AS CommissionApplication,
  ctrtbu_id AS CommissionContract,
  cast ( relagr_id as cacs_agrmt_id ) AS CommissionContractAgreement,
  version AS CommsnContractAgreementVersion,
  cast( relruid as cacs_agr_rule_id ) AS CommsnContrAgreementRule,
  cast( relru_begin as cacs_agrmt_begin ) AS CommsnAgrmtRmnrtnStrtDteTme,
  cast( relru_end as cacs_agrmt_end ) AS CommsnAgrmtRmnrtnEndDteTime,
  priority AS CommsnContrAgrmtPriorityValue,
  cast( busi_begin as cacs_agrmt_efffrom ) AS CommsnAgrmtEffctvFrmDteTme,
  cast( busi_end as cacs_agrmt_effto ) AS CommsnAgrmtEffctvToDteTme,
  flg_cancel_vers AS CommissionVersionIsInvalid
FROM cacs_pragr
;

Learn More