C_CtrlgObjectSettlementRule
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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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 (39)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ControllingObject | ControllingObject | ||
| KEY | Ledger | Ledger | ||
| KEY | SettlmtDistrRuleSequence | SettlmtDistrRuleSequence | ||
| KEY | SettlementDistributionRuleGrp | SettlementDistributionRuleGrp | ||
| KEY | LedgerGroup | LedgerGroup | ||
| AccountAssignmentType | AccountAssignmentType | |||
| SettlementTransaction | SettlementTransaction | |||
| SettlementDefaultRule | SettlementDefaultRule | |||
| SettlementReceiver | SettlementReceiver | |||
| SettlementReceiverObject | ||||
| SettlementReceiverText | ||||
| SettlementReceiverTypeText | ||||
| SettlementPercentageRate | SettlementPercentageRate | |||
| SettlementAmount | SettlementAmount | |||
| SettlementAmountCurrency | SettlementAmountCurrency | |||
| SettlementType | SettlementType | |||
| SettlementTypeDesc | ||||
| ValidityStartFiscalPeriod | ValidityStartFiscalPeriod | |||
| ValidityStartFiscalYear | ValidityStartFiscalYear | |||
| ValidityEndFiscalPeriod | ValidityEndFiscalPeriod | |||
| ValidityEndFiscalYear | ValidityEndFiscalYear | |||
| ControllingArea | ControllingArea | |||
| ProfitCenter | ProfitCenter | |||
| GLAccount | GLAccount | |||
| MasterFixedAsset | MasterFixedAsset | |||
| FixedAsset | FixedAsset | |||
| CostCenter | CostCenter | |||
| Material | Material | |||
| BusinessProcess | BusinessProcess | |||
| ProjectNetwork | ProjectNetwork | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| CompanyCode | CompanyCode | |||
| WBSElementExternalID | WBSElementExternalID | |||
| WBSElementInternalID | WBSElementInternalID | |||
| OrderID | OrderID | |||
| ProfitabilitySegment | ProfitabilitySegment | |||
| CostObject | CostObject | |||
| OrderItem | OrderItem |
@AbapCatalog.sqlViewName: 'CCTLOBJSTLMTRULE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Controlling Object Settlement Rule'
define view C_CtrlgObjectSettlementRule
as select distinct from I_CtrlgObjSettlmtDistrRule
{
@UI.hidden: true
key ControllingObject,
@UI.hidden: true
key Ledger,
@UI.lineItem: { position: 60 }
@Semantics.fiscal.period: true
key SettlmtDistrRuleSequence,
@UI.hidden: true
key SettlementDistributionRuleGrp,
key LedgerGroup,
@UI.hidden: true
AccountAssignmentType,
@UI.hidden: true
SettlementTransaction,
@UI.hidden: true
SettlementDefaultRule,
@UI.hidden: true
SettlementReceiver,
@UI.lineItem: { position: 10 }
@ObjectModel.text.element: 'SettlementReceiverText'
@UI.textArrangement: #TEXT_LAST
@ObjectModel: {
readOnly: true,
virtualElement,
virtualElementCalculatedBy: 'ABAP:CL_FCO_SETTL_REC_INFO_CDS_EXIT'
}
cast( '' as fco_stlmnt_receiver_id_out ) as SettlementReceiverObject,
@ObjectModel: {
readOnly: true,
virtualElement,
virtualElementCalculatedBy: 'ABAP:CL_FCO_SETTL_REC_INFO_CDS_EXIT'
}
@UI.lineItem: { position: 15 }
cast( '' as fco_stlmnt_receiver_txt ) as SettlementReceiverText,
@UI.lineItem: { position: 20 }
@Semantics.text: true
cast( _AccountAssignmentTypeT.AccountAssignmentTypeName as fco_settlmt_rec_type_text ) as SettlementReceiverTypeText,
@UI.lineItem: { position: 30 }
SettlementPercentageRate,
@UI.lineItem: { position: 40 }
SettlementAmount,
@UI.hidden: true
SettlementAmountCurrency,
@UI.lineItem: { position: 50 }
@ObjectModel.text.element: 'SettlementTypeDesc'
@UI.textArrangement: #TEXT_ONLY
SettlementType,
@UI.hidden: true
@Semantics.text: true
cast( _SettlementTypeText.SettlementTypeDesc as ddtext ) as SettlementTypeDesc,
@UI.lineItem: { position: 70, importance: #HIGH }
@Semantics.fiscal.yearPeriod: true
cast( case ValidityStartFiscalYear when '0000' then ''
else concat( ValidityStartFiscalYear, ValidityStartFiscalPeriod )
end as fco_stlmt_start_fyearperiod ) as ValidityStartFiscalYearPeriod,
@UI.lineItem: { position: 80, importance: #HIGH }
@Semantics.fiscal.yearPeriod: true
cast( case ValidityEndFiscalYear when '0000' then ''
else concat( ValidityEndFiscalYear, ValidityEndFiscalPeriod )
end as fco_stlmt_end_fyearperiod ) as ValidityEndFiscalYearPeriod,
@UI.hidden: true
ValidityStartFiscalPeriod,
@UI.hidden: true
ValidityStartFiscalYear,
@UI.hidden: true
ValidityEndFiscalPeriod,
@UI.hidden: true
ValidityEndFiscalYear,
@UI.hidden: true
ControllingArea,
@UI.hidden: true
ProfitCenter,
@UI.hidden: true
GLAccount,
@UI.hidden: true
MasterFixedAsset,
@UI.hidden: true
FixedAsset,
@UI.hidden: true
CostCenter,
@UI.hidden: true
Material,
@UI.hidden: true
BusinessProcess,
@UI.hidden: true
ProjectNetwork,
@UI.hidden: true
SalesOrder,
@UI.hidden: true
SalesOrderItem,
@UI.hidden: true
CompanyCode,
@UI.hidden: true
WBSElementExternalID,
@UI.hidden: true
WBSElementInternalID,
@UI.hidden: true
OrderID,
@UI.hidden: true
ProfitabilitySegment,
@UI.hidden: true
CostObject,
@UI.hidden: true
OrderItem
}
where
Ledger = '00'
or Ledger = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTASSIGNMENTTYPET",
"I_CTRLGOBJSETTLMTDISTRRULE",
"I_SETTLEMENTTYPETEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA