I_CommissionContract

DDL: I_COMMISSIONCONTRACT Type: view_entity BASIC Package: CACSVDM_CONTRACT
33 Fields 1 Data Sources

Commission contract

I_CommissionContract is a Basic CDS View that provides data about "Commission contract" in SAP S/4HANA. It reads from 1 data source (cacs_ctrtbu) and exposes 33 fields with key fields CommissionApplication, CommissionContract, CommissionContractVersion. Part of development package CACSVDM_CONTRACT.

Data Sources (1)

SourceAliasJoin Type
cacs_ctrtbu cacs_ctrtbu from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Commission contract view
VDM.viewType #BASIC view
ObjectModel.representativeKey CommissionContract view
ObjectModel.sapObjectNodeType.name CommissionContract view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication appl Rep. Model
KEY CommissionContract ctrtbu_id Contract Number
KEY CommissionContractVersion version XML Vers.
CommissionStandardContract ctrtst_id Standard Ctrct
CommissionContractPartner gpart Tech. BPartner
CommsnContrStartDate ctrtbu_bdate Contract Start
CommsnContrEndDate ctrtbu_edate Contract End
CommsnRecipientEntryDate entr_date Entry Date
CommsnRecipientLeavingDate leav_date Leaving Date
CommissionContractCurrency con_curr Contract Curr.
CommsnContrChangeReason chg_reason ReasonForChange
CommsnContrEffctvFrmDateTime Effective from
CommsnContrEffctvToDateTime Effective Until
CommsnContrChangeTransaction chg_tcode Transaction
CommsnContrLastChangedBy chg_usr Changed By
CommsnContrCorrespncRcpnt receiver Recipient
CommsnContrCorrespncRcpntDesc receiver_dsc RecipientDescriptn
CommsnContrCorrespncActyKey ind_receiv Activity
CommsnContrCorrespncVariant coprc Corresp.Variant
CommsnContrInternalTitle int_title Internal Title
CommsnContrNoticePeriod term_of_not Notice period
CommsnContrCancellationPeriod term_date Cancel Date
CommsnContrActivityFilter filterid Activity Filter
CommsnContrExternalIdentifier ctrtbu_id_ext Ext.Contract No.
CommsnContrTerminationReason lvrsid TerminateReason
CommsnContrPrtnAddressType adr_kind_ct Address Type
CommsnContrPrtnAddressNumber addrnumber_ct Address Number
CommsnContrApprovalStatus apr_stat Appr Status
CommsnContrRejectionReason rej_reason Rejection Reason
CommissionVersionIsInvalid flg_cancel_vers Invalid Version
CommissionNumberRange
CommsnContrEffctvFrmNewDteTme Effective from
CommsnContrEffctvToNewDteTme Effective Until

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_CommissionContract.
-- 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_CommissionContract AS
SELECT
  appl AS CommissionApplication,
  ctrtbu_id AS CommissionContract,
  version AS CommissionContractVersion,
  ctrtst_id AS CommissionStandardContract,
  gpart AS CommissionContractPartner,
  ctrtbu_bdate AS CommsnContrStartDate,
  ctrtbu_edate AS CommsnContrEndDate,
  entr_date AS CommsnRecipientEntryDate,
  leav_date AS CommsnRecipientLeavingDate,
  con_curr AS CommissionContractCurrency,
  chg_reason AS CommsnContrChangeReason,
  cast( busi_begin as cacs_busitime_b_vdm ) AS CommsnContrEffctvFrmDateTime,
  cast( busi_end as cacs_busitime_e_vdm ) AS CommsnContrEffctvToDateTime,
  chg_tcode AS CommsnContrChangeTransaction,
  chg_usr AS CommsnContrLastChangedBy,
  receiver AS CommsnContrCorrespncRcpnt,
  receiver_dsc AS CommsnContrCorrespncRcpntDesc,
  ind_receiv AS CommsnContrCorrespncActyKey,
  coprc AS CommsnContrCorrespncVariant,
  int_title AS CommsnContrInternalTitle,
  term_of_not AS CommsnContrNoticePeriod,
  term_date AS CommsnContrCancellationPeriod,
  filterid AS CommsnContrActivityFilter,
  ctrtbu_id_ext AS CommsnContrExternalIdentifier,
  lvrsid AS CommsnContrTerminationReason,
  adr_kind_ct AS CommsnContrPrtnAddressType,
  addrnumber_ct AS CommsnContrPrtnAddressNumber,
  apr_stat AS CommsnContrApprovalStatus,
  rej_reason AS CommsnContrRejectionReason,
  flg_cancel_vers AS CommissionVersionIsInvalid,
  cast( '~~' as cacs_nrrngct ) AS CommissionNumberRange,
  cast( busi_begin as cacs_busitime_b_vdm ) AS CommsnContrEffctvFrmNewDteTme,
  cast( busi_end as cacs_busitime_e_vdm ) AS CommsnContrEffctvToNewDteTme
FROM cacs_ctrtbu
;

Learn More