I_CommissionRulePeriodEnd

DDL: I_COMMISSIONRULEPERIODEND Type: view_entity BASIC
8 Fields 1 Data Sources

Commsn Rule ID Period End Date

I_CommissionRulePeriodEnd is a Basic CDS View that provides data about "Commsn Rule ID Period End Date" in SAP S/4HANA. It reads from 1 data source (tcacs_prd) and exposes 8 fields with key fields CommissionApplication, CommissionPeriodRule, CommsnDocCalculatingObjVers, CommsnDocPeriodRuleID, 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 End 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 (8)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication appl Rep. Model
KEY CommissionPeriodRule rule_id Rule ID
KEY CommsnDocCalculatingObjVers rule_version Version
KEY CommsnDocPeriodRuleID Period No.
KEY CommsnDocValuationVersion version XML Vers.
CommissionPeriodEndDate
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_CommissionRulePeriodEnd.
-- 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_CommissionRulePeriodEnd AS
SELECT
  appl AS CommissionApplication,
  rule_id AS CommissionPeriodRule,
  rule_version AS CommsnDocCalculatingObjVers,
  ( cast( period_no as abap.int4 ) - 1 ) AS CommsnDocPeriodRuleID,
  version AS CommsnDocValuationVersion,
  dats_add_days(period_begin, -1,'INITIAL' ) AS CommissionPeriodEndDate,
  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