What is C_ControllingSettlementRule in SAP S/4HANA?

C_ControllingSettlementRule is a consumption CDS view in SAP S/4HANA. Controlling Settlement Rule It contains 31 fields.

What VDM layer is C_ControllingSettlementRule?

C_ControllingSettlementRule is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ControllingSettlementRule

DDL: C_CONTROLLINGSETTLEMENTRULE SQL: CCTRLGSTLMTRULE Type: view CONSUMPTION Package: ODATA_SETTLEMENT

31 Fields 8 Associations

Controlling Settlement Rule

C_ControllingSettlementRule is a Consumption CDS View that provides data about "Controlling Settlement Rule" in SAP S/4HANA. It has 8 associations to related views. Part of development package ODATA_SETTLEMENT.

Associations (8)

Cardinality	Target	Alias	Condition
[0..1]	I_Order	_Order	`$projection.ControllingObject = _Order.ObjectInternalID`
[0..1]	I_GlAccountTextInCompanycode	_GlAccountTextInCompanycode	`$projection.GLAccount = _GlAccountTextInCompanycode.GLAccount and $projection.CompanyCode = _GlAccountTextInCompanycode.CompanyCode and _GlAccountTextInCompanycode.Language = $session.system_language`
[0..1]	I_FixedAsset	_FixedAsset	`$projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset and $projection.CompanyCode = _FixedAsset.CompanyCode`
[0..1]	I_ProjectNetwork	_ProjectNetwork	`$projection.ProjectNetwork = _ProjectNetwork.ProjectNetwork`
[0..1]	I_OrderItem	_OrderItem	`$projection.SalesOrder = _OrderItem.SalesOrder`
[0..1]	I_CostCenterText	_CostCenterText	`$projection.CostCenter = _CostCenterText.CostCenter and $projection.ControllingArea = _CostCenterText.ControllingArea and _CostCenterText.Language = $session.system_language`
[0..1]	I_MaterialText	_MaterialText	`$projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language`
[0..1]	I_BusinessProcessText	_BusinessProcessText	`$projection.BusinessProcess = _BusinessProcessText.BusinessProcess and $projection.ControllingArea = _BusinessProcessText.ControllingArea and _BusinessProcessText.Language = $session.system_language`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CCTRLGSTLMTRULE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ClientHandling.type	#INHERITED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	C_CtrlgObjectSettlementRule	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Controlling Settlement Rule	view

Fields (31)

Key	Field	Source Table	Source Field	Description
KEY	ControllingObject		ControllingObject	Object number
KEY	Ledger		Ledger	Ledger
KEY	SettlmtDistrRuleSequence		SettlmtDistrRuleSequence
KEY	SettlementDistributionRuleGrp		SettlementDistributionRuleGrp
	AccountAssignmentType		AccountAssignmentType	Sndr AcctAssgmt Type
	SettlementTransaction		SettlementTransaction
	SettlementDefaultRule		SettlementDefaultRule
	SettlementReceiver		SettlementReceiver
	SettlementReceiverTypeText
	SettlementPercentageRate		SettlementPercentageRate
	SettlementAmount		SettlementAmount
	SettlementAmountCurrency		SettlementAmountCurrency
	SettlementType		SettlementType	Settlement Type
	SettlementTypeDesc
	ValidityStartFiscalPeriod		ValidityStartFiscalPeriod
	ValidityStartFiscalYear		ValidityStartFiscalYear
	ValidityEndFiscalPeriod		ValidityEndFiscalPeriod
	ValidityEndFiscalYear		ValidityEndFiscalYear
	ControllingArea		ControllingArea	Controlling Area
	ProfitCenter		ProfitCenter	Profit Center
	GLAccount		GLAccount	General Ledger
	MasterFixedAsset		MasterFixedAsset	Fixed Asset
	FixedAsset		FixedAsset	Sub-number
	CostCenter		CostCenter	Cost Center
	Material		Material	Vehicle Model
	BusinessProcess		BusinessProcess	Business Process
	ProjectNetwork		ProjectNetwork	Order
	SalesOrder		SalesOrder	SD Document
	CompanyCode		CompanyCode	Receiver Company Code
	WBSElementInternalID	I_CtrlgObjSettlmtDistrRule	WBSElementInternalID	WBS Internal ID
	_WBSElementBasicData	I_CtrlgObjSettlmtDistrRule	_WBSElementBasicData

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 C_ControllingSettlementRule.
-- 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.
-- SQL view name: CCTRLGSTLMTRULE

CREATE VIEW C_ControllingSettlementRule AS
SELECT
  ControllingObject,
  Ledger,
  SettlmtDistrRuleSequence,
  SettlementDistributionRuleGrp,
  AccountAssignmentType,
  SettlementTransaction,
  SettlementDefaultRule,
  SettlementReceiver,
  cast( _AccountAssignmentTypeT.AccountAssignmentTypeName as fco_settlmt_rec_type_text ) AS SettlementReceiverTypeText,
  SettlementPercentageRate,
  SettlementAmount,
  SettlementAmountCurrency,
  SettlementType,
  cast( _SettlementTypeText.SettlementTypeDesc as ddtext ) AS SettlementTypeDesc,
  ValidityStartFiscalPeriod,
  ValidityStartFiscalYear,
  ValidityEndFiscalPeriod,
  ValidityEndFiscalYear,
  ControllingArea,
  ProfitCenter,
  GLAccount,
  MasterFixedAsset,
  FixedAsset,
  CostCenter,
  Material,
  BusinessProcess,
  ProjectNetwork,
  SalesOrder,
  CompanyCode,
  I_CtrlgObjSettlmtDistrRule.WBSElementInternalID AS WBSElementInternalID,
  I_CtrlgObjSettlmtDistrRule._WBSElementBasicData AS _WBSElementBasicData
LEFT OUTER JOIN I_Order AS _Order ON ControllingObject = _Order.ObjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GlAccountTextInCompanycode ON GLAccount = _GlAccountTextInCompanycode.GLAccount AND CompanyCode = _GlAccountTextInCompanycode.CompanyCode AND _GlAccountTextInCompanycode.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset AND CompanyCode = _FixedAsset.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON SalesOrder = _OrderItem.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CostCenterText ON CostCenter = _CostCenterText.CostCenter AND ControllingArea = _CostCenterText.ControllingArea AND _CostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcessText AS _BusinessProcessText ON BusinessProcess = _BusinessProcessText.BusinessProcess AND ControllingArea = _BusinessProcessText.ControllingArea AND _BusinessProcessText.Language = $session.system_language  -- association [0..1]
;

Depth:

C_ControllingSettlementRule view