R_IntOrderSettlementRuleTP
Internal Order Settlement Rule
R_IntOrderSettlementRuleTP is a Transactional CDS View that provides data about "Internal Order Settlement Rule" in SAP S/4HANA. It reads from 1 data source (I_InternalOrderSettlementRule) and exposes 45 fields with key field ControllingObject. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_InternalOrderSettlementRule | I_InternalOrderSettlementRule | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_StatusObjectStatusBasic | _IntOrdSettlementRuleIsCreated | I_InternalOrderSettlementRule.ControllingObject = _IntOrdSettlementRuleIsCreated.StatusObject and ( _IntOrdSettlementRuleIsCreated.StatusCode = 'I0028' or _IntOrdSettlementRuleIsCreated.StatusCode = 'I0027' ) and _IntOrdSettlementRuleIsCreated.StatusIsInactive = '' |
| [0..*] | R_IntOrdSettlementDistrRuleTP | _IntOrdSettlementDistrRuleTP | |
| [0..*] | R_IntOrdSettlmtHistPerLedgerTP | _IntOrdSettlmtHistPerLedgerTP | |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.sapObjectNodeType.name | InternalOrderSettlementRule | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| EndUserText.label | Internal Order Settlement Rule | view |
Fields (45)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ControllingObject | ControllingObject | ||
| CreatedByUser | CreatedByUser | |||
| CreationDate | CreationDate | |||
| LastChangedByUser | LastChangedByUser | |||
| LastChangeDate | LastChangeDate | |||
| CtrlgObjectSettlementRuleName | CtrlgObjectSettlementRuleName | |||
| AllocationStructure | AllocationStructure | |||
| SettlementSourceStructure | SettlementSourceStructure | |||
| ControllingSettlementProfile | ControllingSettlementProfile | |||
| AssetValueDate | AssetValueDate | |||
| SettlementSequentialNumber | SettlementSequentialNumber | |||
| ProfitabilityAcctgTransfStruc | ProfitabilityAcctgTransfStruc | |||
| SettlmtRuleProcessingSequence | SettlmtRuleProcessingSequence | |||
| SettlmtRuleAutoGnrtnStrgySqnc | SettlmtRuleAutoGnrtnStrgySqnc | |||
| SettlmtWithFreeDefinedCurrency | SettlmtWithFreeDefinedCurrency | |||
| InternalOrder | InternalOrder | |||
| InternalOrderDescription | InternalOrderDescription | |||
| OrderType | OrderType | |||
| ControllingArea | ControllingArea | |||
| InternalOrderLastChangedByUser | InternalOrderLastChangedByUser | |||
| InternalOrderLastChangeDate | InternalOrderLastChangeDate | |||
| CompanyCode | CompanyCode | |||
| InternalOrderControllingObject | InternalOrderControllingObject | |||
| IntOrderSystemStatusShortName | IntOrderSystemStatusShortName | |||
| InternalOrderSystemStatusName | InternalOrderSystemStatusName | |||
| IsStatisticalOrder | IsStatisticalOrder | |||
| ControllingObjectStatus | _SystemStatus | ControllingObjectStatus | ||
| _AllocationStructure | _AllocationStructure | |||
| _ControllingArea | _ControllingArea | |||
| _SourceStructure | _SourceStructure | |||
| _CreatedByUser | _CreatedByUser | |||
| _LastChangedByUser | _LastChangedByUser | |||
| _CtrlgObjSettlmtDistrRule | _CtrlgObjSettlmtDistrRule | |||
| _PrftbltyAcctgTransfStructure | _PrftbltyAcctgTransfStructure | |||
| _ControllingSettlementProfile | _ControllingSettlementProfile | |||
| _SettlmtAutomGnrtnStrgySqnc | _SettlmtAutomGnrtnStrgySqnc | |||
| _SettlmtWithFreeDfndCurrency | _SettlmtWithFreeDfndCurrency | |||
| _IntOrdSettlementDistrRuleTP | _IntOrdSettlementDistrRuleTP | |||
| _IntOrdSettlmtHistPerLedgerTP | _IntOrdSettlmtHistPerLedgerTP | |||
| _IntOrderLastChangedByUser | _IntOrderLastChangedByUser | |||
| _InternalOrderTypeText | _InternalOrderTypeText | |||
| _CompanyCode | _CompanyCode | |||
| _IntOrderActiveSystemStatus | _IntOrderActiveSystemStatus | |||
| _IntOrderActiveUserStatus | _IntOrderActiveUserStatus | |||
| _LdgrSpcfcAllocStruc | _LdgrSpcfcAllocStruc |
@AccessControl.authorizationCheck: #CHECK
@ObjectModel:{
usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
} ,
sapObjectNodeType.name: 'InternalOrderSettlementRule'
}
@VDM : {
viewType: #TRANSACTIONAL ,
lifecycle.contract.type:#SAP_INTERNAL_API }
@EndUserText.label: 'Internal Order Settlement Rule'
define root view entity R_IntOrderSettlementRuleTP
as select from I_InternalOrderSettlementRule
composition [0..*] of R_IntOrdSettlementDistrRuleTP as _IntOrdSettlementDistrRuleTP
composition [0..*] of R_IntOrdSettlmtHistPerLedgerTP as _IntOrdSettlmtHistPerLedgerTP
association [0..1] to I_StatusObjectStatusBasic as _IntOrdSettlementRuleIsCreated on I_InternalOrderSettlementRule.ControllingObject = _IntOrdSettlementRuleIsCreated.StatusObject
and (
_IntOrdSettlementRuleIsCreated.StatusCode = 'I0028'
or _IntOrdSettlementRuleIsCreated.StatusCode = 'I0027'
)
and _IntOrdSettlementRuleIsCreated.StatusIsInactive = ''
{
key ControllingObject,
CreatedByUser,
CreationDate,
LastChangedByUser,
LastChangeDate,
CtrlgObjectSettlementRuleName,
AllocationStructure,
SettlementSourceStructure,
ControllingSettlementProfile,
AssetValueDate,
SettlementSequentialNumber,
ProfitabilityAcctgTransfStruc,
SettlmtRuleProcessingSequence,
SettlmtRuleAutoGnrtnStrgySqnc,
SettlmtWithFreeDefinedCurrency,
InternalOrder,
InternalOrderDescription,
OrderType,
ControllingArea,
InternalOrderLastChangedByUser,
InternalOrderLastChangeDate,
CompanyCode,
InternalOrderControllingObject,
IntOrderSystemStatusShortName,
InternalOrderSystemStatusName,
IsStatisticalOrder,
@ObjectModel.text.association:null
_SystemStatus.ControllingObjectStatus,
case _IntOrdSettlementRuleIsCreated.StatusIsInactive
when 'X' then cast ('' as fco_io_distr_rule_created preserving type )
when '' then cast ('X' as fco_io_distr_rule_created preserving type )
else cast ('' as fco_io_distr_rule_created preserving type )
end as IntOrdSettlementRuleIsCreated,
case _IntOrdIsMarkedForDeletion.StatusIsInactive
when 'X' then cast ('' as fco_io_markedfordeletion preserving type )
when '' then cast ('X' as fco_io_markedfordeletion preserving type )
else cast ('' as fco_io_markedfordeletion preserving type )
end as InternalOrderIsDeleted,
case _IntOrdDeletionFlagIsSet.StatusIsInactive
when 'X' then cast ('' as fco_io_deletionflag preserving type )
when '' then cast ('X' as fco_io_deletionflag preserving type )
else cast ('' as fco_io_deletionflag preserving type )
end as InternalOrderDeletionFlagIsSet,
case _InternalOrderIsLocked.StatusIsInactive
when 'X' then cast ('' as fco_io_lock preserving type )
when '' then cast ('X' as fco_io_lock preserving type )
else cast ('' as fco_io_lock preserving type )
end as InternalOrderIsLocked,
case SettlmtWithFreeDefinedCurrency
when 'L' then cast ( '' as fco_sr_io_parlledgersisinactv preserving type )
else cast ( 'X' as fco_sr_io_parlledgersisinactv preserving type)
end as SettlmtParlLedgersIsInactive,
@Semantics.systemDateTime.lastChangedAt: true
cast(
dats_tims_to_tstmp(
LastChangeDate,
cast('000000' as co_chg_time ) ,
abap_system_timezone( $session.client,'NULL' ),
$session.client,
'NULL'
) as timestamp
) as LastChangeDateTime,
/* Associations */
_AllocationStructure,
_ControllingArea,
_SourceStructure,
_CreatedByUser,
_LastChangedByUser,
_CtrlgObjSettlmtDistrRule,
_PrftbltyAcctgTransfStructure,
_ControllingSettlementProfile,
_SettlmtAutomGnrtnStrgySqnc,
_SettlmtWithFreeDfndCurrency,
_IntOrdSettlementDistrRuleTP,
_IntOrdSettlmtHistPerLedgerTP,
_IntOrderLastChangedByUser,
_InternalOrderTypeText,
_CompanyCode,
_IntOrderActiveSystemStatus,
_IntOrderActiveUserStatus,
_LdgrSpcfcAllocStruc
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INTERNALORDERSETTLEMENTRULE",
"I_INTERNALORDERSYSTEMSTATUS",
"I_STATUSOBJECTSTATUSBASIC"
],
"ASSOCIATED":
[
"I_ALLOCATIONSTRUCTURE",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_CONTROLLINGSETTLEMENTPROFILE",
"I_CONTROLLINGSTRUCTURE",
"I_CTRLGOBJSETTLMTDISTRRULE",
"I_INTERNALORDERTYPETEXT",
"I_INTORDERACTIVESYSTEMSTATUS",
"I_INTORDERACTIVEUSERSTATUS",
"I_LDGRSPCFCALLOCSTRUC",
"I_PRFTBLTYACCTGTRANSFSTRUCTURE",
"I_SETTLMTAUTOMGNRTNSTRGYSQNC",
"I_SETTLMTWITHFREEDFNDCURRENCY",
"I_USERCONTACTCARD",
"R_INTORDSETTLEMENTDISTRRULETP",
"R_INTORDSETTLMTHISTPERLEDGERTP"
],
"BASE":
[
"I_INTERNALORDERSETTLEMENTRULE"
],
"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