I_CommissionRulePeriodBegin

DDL: I_COMMISSIONRULEPERIODBEGIN Type: view_entity BASIC
9 Fields 1 Data Sources

Commsn Rule ID Period Begin Date

I_CommissionRulePeriodBegin is a Basic CDS View that provides data about "Commsn Rule ID Period Begin Date" in SAP S/4HANA. It reads from 1 data source (tcacs_prd) and exposes 9 fields with key fields CommissionApplication, CommissionPeriodRule, CommsnDocCalculatingObjVers, CommsnDistributeActyPercent, CommsnDocValuationVersion.

Data Sources (1)

SourceAliasJoin Type
tcacs_prd tcacs_prd from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Commsn Rule ID Period Begin Date view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication appl Rep. Model
KEY CommissionPeriodRule rule_id Rule ID
KEY CommsnDocCalculatingObjVers rule_version Version
KEY CommsnDistributeActyPercent Period No.
KEY CommsnDocValuationVersion version XML Vers.
CommissionPeriodNumber period_no Period No.
CommissionPeriodStartDate period_begin Period Start
CommsnContrEffctvFrmDateTime Effective from
CommsnContrEffctvToDateTime 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_CommissionRulePeriodBegin.
-- 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_CommissionRulePeriodBegin AS
SELECT
  appl AS CommissionApplication,
  rule_id AS CommissionPeriodRule,
  rule_version AS CommsnDocCalculatingObjVers,
  cast( period_no as abap.int4 ) AS CommsnDistributeActyPercent,
  version AS CommsnDocValuationVersion,
  period_no AS CommissionPeriodNumber,
  period_begin AS CommissionPeriodStartDate,
  cast ( busi_begin as cacs_busitime_b_vdm ) AS CommsnContrEffctvFrmDateTime,
  cast ( busi_end as cacs_busitime_e_vdm ) AS CommsnContrEffctvToDateTime
FROM tcacs_prd
;

Learn More