C_CtrlgObjectSettlementRule

DDL: C_CTRLGOBJECTSETTLEMENTRULE SQL: CCTLOBJSTLMTRULE Type: view CONSUMPTION
45 Fields

Controlling Object Settlement Rule

C_CtrlgObjectSettlementRule is a Consumption CDS View that provides data about "Controlling Object Settlement Rule" in SAP S/4HANA.

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCTLOBJSTLMTRULE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Controlling Object Settlement Rule view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject ControllingObject Object number
KEY Ledger Ledger Ledger
KEY SettlmtDistrRuleSequence SettlmtDistrRuleSequence
KEY SettlementDistributionRuleGrp SettlementDistributionRuleGrp
KEY LedgerGroup LedgerGroup Ledger Group
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
SettlementTransaction SettlementTransaction
SettlementDefaultRule SettlementDefaultRule
SettlementReceiver SettlementReceiver
SettlementReceiverObject
SettlementReceiverText
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
SalesOrderItem SalesOrderItem Sales Order Item
CompanyCode CompanyCode Receiver Company Code
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
OrderID OrderID Order ID
ProfitabilitySegment ProfitabilitySegment Profitability Segment
CostObject CostObject Cost Object
OrderItem OrderItem
Plant Plant Valuation Area
FunctionalArea _ProjectNetwork FunctionalArea Sendr Fctl Area
ResponsibleCostCenter _ProjectNetwork ResponsibleCostCenter Responsible Cost Center
ProjectType
ProjectInternalID
_Project

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_CtrlgObjectSettlementRule.
-- 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: CCTLOBJSTLMTRULE

CREATE VIEW C_CtrlgObjectSettlementRule AS
SELECT
  ControllingObject,
  Ledger,
  SettlmtDistrRuleSequence,
  SettlementDistributionRuleGrp,
  LedgerGroup,
  AccountAssignmentType,
  SettlementTransaction,
  SettlementDefaultRule,
  SettlementReceiver,
  cast( '' as fco_stlmnt_receiver_id_out ) AS SettlementReceiverObject,
  cast( '' as fco_stlmnt_receiver_txt ) AS SettlementReceiverText,
  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,
  SalesOrderItem,
  CompanyCode,
  WBSElementExternalID,
  WBSElementInternalID,
  OrderID,
  ProfitabilitySegment,
  CostObject,
  OrderItem,
  Plant,
  _ProjectNetwork.FunctionalArea AS FunctionalArea,
  _ProjectNetwork.ResponsibleCostCenter AS ResponsibleCostCenter,
  _ProjectNetwork._WBSElementBasicData.ProjectType AS ProjectType,
  cast( _ProjectNetwork._WBSElementBasicData.ProjectInternalID as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  _ProjectNetwork._WBSElementBasicData._Project AS _Project
;

Learn More