I_CmsnConGuarRmnrtnAgreement

DDL: I_CMSNCONGUARRMNRTNAGREEMENT Type: view_entity BASIC
13 Fields 1 Data Sources

Guarantee Remuneration

I_CmsnConGuarRmnrtnAgreement is a Basic CDS View that provides data about "Guarantee Remuneration" in SAP S/4HANA. It reads from 1 data source (cacs_warru) and exposes 13 fields with key fields CommissionApplication, CommissionContract, CommissionContractAgreement, CommsnContrAgreementRule, CommsnContractAgreementVersion.

Data Sources (1)

SourceAliasJoin Type
cacs_warru cacs_warru from

Annotations (7)

NameValueLevelField
EndUserText.label Guarantee Remuneration view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name CommsnContrGuarRmnrtnAgreement view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication appl Rep. Model
KEY CommissionContract ctrtbu_id Contract Number
KEY CommissionContractAgreement Guar. Agree No.
KEY CommsnContrAgreementRule Guar. Rule No.
KEY CommsnContractAgreementVersion version XML Vers.
CommsnAgrmtRmnrtnStrtDteTme Guarantee Start
CommsnAgrmtRmnrtnEndDteTime Guarantee End
CommsnAgrmtRemunerationAmount amnt WTax Amt in LC
CommissionContractCurrency
CommsnRemunerationType remuneration RemuneratType
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_CmsnConGuarRmnrtnAgreement.
-- 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_CmsnConGuarRmnrtnAgreement AS
SELECT
  appl AS CommissionApplication,
  ctrtbu_id AS CommissionContract,
  cast( warragr_id as cacs_agrmt_id ) AS CommissionContractAgreement,
  cast( warru_id as cacs_agr_rule_id ) AS CommsnContrAgreementRule,
  version AS CommsnContractAgreementVersion,
  cast( warr_begin as cacs_agrmt_begin ) AS CommsnAgrmtRmnrtnStrtDteTme,
  cast( warr_end as cacs_agrmt_end ) AS CommsnAgrmtRmnrtnEndDteTime,
  amnt AS CommsnAgrmtRemunerationAmount,
  cast( '' as cacsconcurr ) AS CommissionContractCurrency,
  remuneration AS CommsnRemunerationType,
  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_warru
;

Learn More