I_CommsnFlatRateRmnrtnAgrmt

DDL: I_COMMSNFLATRATERMNRTNAGRMT Type: view_entity BASIC Package: CACSVDM_CONTRACT
13 Fields 1 Data Sources

Flat rate remuneration

I_CommsnFlatRateRmnrtnAgrmt is a Basic CDS View that provides data about "Flat rate remuneration" in SAP S/4HANA. It reads from 1 data source (cacs_remaru) and exposes 13 fields with key fields CommissionApplication, CommissionContract, CommissionContractAgreement, CommsnContrAgreementRule, CommsnContractAgreementVersion. Part of development package CACSVDM_CONTRACT.

Data Sources (1)

SourceAliasJoin Type
cacs_remaru cacs_remaru from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Flat rate remuneration view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name CommsnFlatRateRmnrtnAgreement 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 Remun. Agreem.
KEY CommsnContrAgreementRule remru_id FR Rem. Rule No
KEY CommsnContractAgreementVersion version XML Vers.
CommsnAgrmtRmnrtnStrtDteTme FR Remun. From
CommsnAgrmtRmnrtnEndDteTime Remun.Amt Until
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_CommsnFlatRateRmnrtnAgrmt.
-- 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_CommsnFlatRateRmnrtnAgrmt AS
SELECT
  appl AS CommissionApplication,
  ctrtbu_id AS CommissionContract,
  cast ( remagr_id as cacs_agrmt_id ) AS CommissionContractAgreement,
  remru_id AS CommsnContrAgreementRule,
  version AS CommsnContractAgreementVersion,
  cast( rem_begin as cacs_agrmt_begin ) AS CommsnAgrmtRmnrtnStrtDteTme,
  cast( rem_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_remaru
;

Learn More