R_IntOrdSettlementDistrRuleTP
Internal Order Distribution Rule
R_IntOrdSettlementDistrRuleTP is a Transactional CDS View that provides data about "Internal Order Distribution Rule" in SAP S/4HANA. It reads from 1 data source (I_IntOrderSettlementDistrRule) and exposes 105 fields with key fields ControllingObject, Ledger, LedgerGroup, SettlementDistributionRuleGrp, SettlmtDistrRuleSequence. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_IntOrderSettlementDistrRule | I_IntOrderSettlementDistrRule | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | R_IntOrdSettlmtDistrRuleRETP | _IntOrdSettlmtDistrRuleRETP | |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| EndUserText.label | Internal Order Distribution Rule | view |
Fields (105)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ControllingObject | ControllingObject | ||
| KEY | Ledger | Ledger | ||
| KEY | LedgerGroup | LedgerGroup | ||
| KEY | SettlementDistributionRuleGrp | SettlementDistributionRuleGrp | ||
| KEY | SettlmtDistrRuleSequence | SettlmtDistrRuleSequence | ||
| ControllingObjectForEdit | ControllingObject | |||
| LedgerForEdit | Ledger | |||
| LedgerGroupForEdit | LedgerGroup | |||
| SettlmtDistributionRuleGrpFoEd | SettlementDistributionRuleGrp | |||
| SettlmtDistrRuleSequenceFoEd | SettlmtDistrRuleSequence | |||
| SettlementType | SettlementType | |||
| SettlmtTypeLanguageDependent | _SettlmtTypeLanguageDependent | SettlmtTypeLanguageDependent | ||
| AccountAssignmentType | AccountAssignmentType | |||
| AcctAsgtTypeLanguageDependent | _AccountAssignmentTypeT | AcctAsgtTypeLanguageDependent | ||
| SettlementReceiver | SettlementReceiver | |||
| SettlementPercentageRate | SettlementPercentageRate | |||
| SettlementEquivalenceFactor | SettlementEquivalenceFactor | |||
| SettlementAmount | SettlementAmount | |||
| SettlementAmountCurrency | SettlementAmountCurrency | |||
| ControllingArea | ControllingArea | |||
| CostCenter | CostCenter | |||
| ProfitabilitySegment | ProfitabilitySegment | |||
| ProfitabilitySegment_2 | ProfitabilitySegment_2 | |||
| WBSElementInternalID | WBSElementInternalID | |||
| WBSElementExternalID | WBSElementExternalID | |||
| ProjectNetwork | ProjectNetwork | |||
| CostObject | CostObject | |||
| BusinessProcess | BusinessProcess | |||
| BusinessArea | BusinessArea | |||
| AssetTransactionType | AssetTransactionType | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| OrderID | OrderID | |||
| CompanyCode | CompanyCode | |||
| ProfitCenter | ProfitCenter | |||
| MasterFixedAsset | MasterFixedAsset | |||
| FixedAsset | FixedAsset | |||
| GLAccount | GLAccount | |||
| ValidityStartFiscalPeriod | ValidityStartFiscalPeriod | |||
| ValidityStartFiscalYear | ValidityStartFiscalYear | |||
| ValidityEndFiscalPeriod | ValidityEndFiscalPeriod | |||
| ValidityEndFiscalYear | ValidityEndFiscalYear | |||
| SettlmtRule1stUsgeFiscalPeriod | SettlmtRule1stUsgeFiscalPeriod | |||
| SettlmtRule1stUsageFiscalYear | SettlmtRule1stUsageFiscalYear | |||
| SettlmtRule1stUsgeFsclYrPeriod | ||||
| SettlmtRuleLastUsgeFsclPeriod | SettlmtRuleLastUsgeFsclPeriod | |||
| SettlmtRuleLastUsageFiscalYear | SettlmtRuleLastUsageFiscalYear | |||
| SettlmtRuleLastUsgeFsclYrPerd | ||||
| SettlmtTracingFctrDetnMethod | SettlmtTracingFctrDetnMethod | |||
| SettlementDistrAmountRuleType | SettlementDistrAmountRuleType | |||
| SettlmtDistrRuleSrceAssignment | SettlmtDistrRuleSrceAssignment | |||
| SettlementSourceStructure | SettlementSourceStructure | |||
| SettlmtDistributionRuleNumber | SettlmtDistributionRuleNumber | |||
| SettlmtDistrManipulationRule | SettlmtDistrManipulationRule | |||
| SettlmtRuleAutomStrategyGnrtn | SettlmtRuleAutomStrategyGnrtn | |||
| SettlementDistrRuleRmngAmount | SettlementDistrRuleRmngAmount | |||
| NetworkActivityInternalID | NetworkActivityInternalID | |||
| ProjectNetworkInternalID | ProjectNetworkInternalID | |||
| NetworkActivity | NetworkActivity | |||
| SettlmtWithFreeDefinedCurrency | SettlmtWithFreeDefinedCurrency | |||
| InternalOrder | InternalOrder | |||
| OrderType | OrderType | |||
| InternalOrderCompanyCode | InternalOrderCompanyCode | |||
| OperatingConcern | OperatingConcern | |||
| SettlmtDistrRuleIsUsedInLedger | SettlmtDistrRuleIsUsedInLedger | |||
| ServiceDocumentType | ServiceDocumentType | |||
| ServiceDocument | ServiceDocument | |||
| ServiceDocumentItem | ServiceDocumentItem | |||
| SettlementDistributionRuleUUID | SettlementDistributionRuleUUID | |||
| SettlementTransaction | SettlementTransaction | |||
| SettlementDistrRuleIsCopied | ||||
| PrftbltySegmentCompanyCode | ||||
| ControllingSettlementProfile | _IntOrderSettlementRuleTP | ControllingSettlementProfile | ||
| _AccountAssignmentTypeT | _AccountAssignmentTypeT | |||
| _CompanyCode | _CompanyCode | |||
| _ControllingArea | _ControllingArea | |||
| _CostCenter | _CostCenter | |||
| _SourceStructureAssignment | _SourceStructureAssignment | |||
| _Currency | _Currency | |||
| _GLAccount | _GLAccount | |||
| _JntVntrMnpltnRuleRecoveryInd | _JntVntrMnpltnRuleRecoveryInd | |||
| _Ledger | _Ledger | |||
| _LedgerGroup | _LedgerGroup | |||
| _OrderID | _OrderID | |||
| _ProjectNetwork | _ProjectNetwork | |||
| _SettlementAutomGnrtnStrategy | _SettlementAutomGnrtnStrategy | |||
| _SettlementType | _SettlementType | |||
| _SettlmtTracingFctrDetnMethod | _SettlmtTracingFctrDetnMethod | |||
| _SettlmtDistrAmountRuleType | _SettlmtDistrAmountRuleType | |||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _IntOrderSettlementRuleTP | _IntOrderSettlementRuleTP | |||
| _SettlmtWithFreeDfndCurrency | _SettlmtWithFreeDfndCurrency | |||
| _InternalOrderCompanyCode | _InternalOrderCompanyCode | |||
| _SettlmtTypeLanguageDependent | _SettlmtTypeLanguageDependent | |||
| _AssetTransactionType | _AssetTransactionType | |||
| _MasterFixedAsset | _MasterFixedAsset | |||
| _FixedAsset | _FixedAsset | |||
| _SalesOrderItem | _SalesOrderItem | |||
| _IntOrdSettlmtDistrRuleRETP | _IntOrdSettlmtDistrRuleRETP | |||
| _NetworkActivityByInternalKey | _NetworkActivityByInternalKey | |||
| _ProjectNetworkBasicData | _ProjectNetworkBasicData | |||
| _BusinessProcess | _BusinessProcess | |||
| _ProfitCenter | _ProfitCenter | |||
| _AcctgSrvcDocumentItemBasic | _AcctgSrvcDocumentItemBasic | |||
| _AcctgServiceDocumentType | _AcctgServiceDocumentType |
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
}
@VDM : {
viewType: #TRANSACTIONAL ,
lifecycle.contract.type:#SAP_INTERNAL_API }
@EndUserText.label: 'Internal Order Distribution Rule'
define view entity R_IntOrdSettlementDistrRuleTP
as select from I_IntOrderSettlementDistrRule
association to parent R_IntOrderSettlementRuleTP as _IntOrderSettlementRuleTP on $projection.ControllingObject = _IntOrderSettlementRuleTP.ControllingObject
composition [0..1] of R_IntOrdSettlmtDistrRuleRETP as _IntOrdSettlmtDistrRuleRETP
{
key ControllingObject,
key Ledger,
key LedgerGroup,
key SettlementDistributionRuleGrp,
key SettlmtDistrRuleSequence,
@ObjectModel:{ editableFieldFor: 'ControllingObject' }
ControllingObject as ControllingObjectForEdit,
@ObjectModel:{ editableFieldFor: 'Ledger' }
Ledger as LedgerForEdit,
@ObjectModel:{ editableFieldFor: 'LedgerGroup' }
LedgerGroup as LedgerGroupForEdit,
@ObjectModel:{ editableFieldFor: 'SettlementDistributionRuleGrp' }
SettlementDistributionRuleGrp as SettlmtDistributionRuleGrpFoEd,
@ObjectModel:{ editableFieldFor: 'SettlmtDistrRuleSequence' }
SettlmtDistrRuleSequence as SettlmtDistrRuleSequenceFoEd,
SettlementType,
_SettlmtTypeLanguageDependent.SettlmtTypeLanguageDependent,
AccountAssignmentType,
_AccountAssignmentTypeT.AcctAsgtTypeLanguageDependent,
SettlementReceiver,
SettlementPercentageRate,
SettlementEquivalenceFactor,
SettlementAmount,
SettlementAmountCurrency,
ControllingArea,
CostCenter,
@VDM.lifecycle: {
status: #DEPRECATED,
successor: 'ProfitabilitySegment_2' }
ProfitabilitySegment,
ProfitabilitySegment_2,
@Semantics.booleanIndicator
cast(
case AccountAssignmentType
when 'EO' then 'X'
else ''
end as profitabilitysegmentisassigned) as ProfitabilitySegmentIsAssigned,
WBSElementInternalID,
WBSElementExternalID,
ProjectNetwork,
CostObject,
BusinessProcess,
BusinessArea,
AssetTransactionType,
SalesOrder,
SalesOrderItem,
OrderID,
CompanyCode,
ProfitCenter,
MasterFixedAsset,
FixedAsset,
GLAccount,
@Semantics.fiscal.period: true
ValidityStartFiscalPeriod,
@Semantics.fiscal.year: true
ValidityStartFiscalYear,
@Semantics.fiscal.yearPeriod: true
// cast( case ValidityStartFiscalYear when '0000' then ''
// else concat( ValidityStartFiscalYear, ValidityStartFiscalPeriod )
// end as fco_stlmt_start_fyearperiod ) as ValidityStartFiscalYearPeriod,
//
cast( case concat(ValidityStartFiscalYear, ValidityStartFiscalPeriod)
when '0000000' then ''
else concat(ValidityStartFiscalYear, ValidityStartFiscalPeriod)
end as fco_stlmt_start_fyearperiod ) as ValidityStartFiscalYearPeriod,
@Semantics.fiscal.period: true
ValidityEndFiscalPeriod,
@Semantics.fiscal.year: true
ValidityEndFiscalYear,
@Semantics.fiscal.yearPeriod: true
// cast( case ValidityEndFiscalYear when '0000' then ''
// else concat( ValidityEndFiscalYear, ValidityEndFiscalPeriod )
// end as fco_stlmt_end_fyearperiod ) as ValidityEndFiscalYearPeriod,
cast( case concat(ValidityEndFiscalYear, ValidityEndFiscalPeriod)
when '0000000' then ''
else concat(ValidityEndFiscalYear, ValidityEndFiscalPeriod)
end as fco_stlmt_end_fyearperiod ) as ValidityEndFiscalYearPeriod,
@Semantics.fiscal.period: true
SettlmtRule1stUsgeFiscalPeriod,
@Semantics.fiscal.year: true
SettlmtRule1stUsageFiscalYear,
@Semantics.fiscal.yearPeriod: true
cast(concat( SettlmtRule1stUsageFiscalYear, SettlmtRule1stUsgeFiscalPeriod ) as fco_stlmt_1stusge_fyearperiod ) as SettlmtRule1stUsgeFsclYrPeriod,
@Semantics.fiscal.period: true
SettlmtRuleLastUsgeFsclPeriod,
@Semantics.fiscal.year: true
SettlmtRuleLastUsageFiscalYear,
@Semantics.fiscal.yearPeriod: true
cast(concat( SettlmtRuleLastUsageFiscalYear, SettlmtRuleLastUsgeFsclPeriod ) as fco_stlmt_lastusge_fyearperiod ) as SettlmtRuleLastUsgeFsclYrPerd,
SettlmtTracingFctrDetnMethod,
SettlementDistrAmountRuleType,
SettlmtDistrRuleSrceAssignment,
SettlementSourceStructure,
SettlmtDistributionRuleNumber,
SettlmtDistrManipulationRule,
SettlmtRuleAutomStrategyGnrtn,
SettlementDistrRuleRmngAmount,
NetworkActivityInternalID,
ProjectNetworkInternalID,
NetworkActivity,
SettlmtWithFreeDefinedCurrency,
InternalOrder,
OrderType,
InternalOrderCompanyCode,
OperatingConcern,
SettlmtDistrRuleIsUsedInLedger,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
SettlementDistributionRuleUUID,
SettlementTransaction,
cast( '' as fco_settlmtdistrrule_is_copied ) as SettlementDistrRuleIsCopied,
cast( '' as fis_bukrs ) as PrftbltySegmentCompanyCode,
_IntOrderSettlementRuleTP.ControllingSettlementProfile,
/* Associations */
_AccountAssignmentTypeT,
_CompanyCode,
_ControllingArea,
_CostCenter,
_SourceStructureAssignment,
_Currency,
_GLAccount,
_JntVntrMnpltnRuleRecoveryInd,
_Ledger,
_LedgerGroup,
_OrderID,
_ProjectNetwork,
_SettlementAutomGnrtnStrategy,
_SettlementType,
_SettlmtTracingFctrDetnMethod,
_SettlmtDistrAmountRuleType,
_WBSElementBasicData,
_IntOrderSettlementRuleTP,
_SettlmtWithFreeDfndCurrency,
_InternalOrderCompanyCode,
_SettlmtTypeLanguageDependent,
_AssetTransactionType,
_MasterFixedAsset,
_FixedAsset,
_SalesOrderItem,
_IntOrdSettlmtDistrRuleRETP,
_NetworkActivityByInternalKey,
_ProjectNetworkBasicData,
_BusinessProcess,
_ProfitCenter,
_AcctgSrvcDocumentItemBasic,
_AcctgServiceDocumentType
}
where
(
SettlmtWithFreeDefinedCurrency = 'L'
and Ledger = '00'
)
or(
SettlmtWithFreeDefinedCurrency <> 'L'
);
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTASSIGNMENTTYPET",
"I_INTORDERSETTLEMENTDISTRRULE",
"I_SETTLMTTYPELANGUAGEDEPENDENT",
"R_INTORDERSETTLEMENTRULETP"
],
"ASSOCIATED":
[
"I_ACCOUNTASSIGNMENTTYPET",
"I_ACCTGSERVICEDOCUMENTTYPE",
"I_ACCTGSRVCDOCUMENTITEMBASIC",
"I_ASSETTRANSACTIONTYPE",
"I_BUSINESSPROCESS",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_CTRLGSTRUCTUREASSIGNMENT",
"I_CURRENCY",
"I_FIXEDASSET",
"I_GLACCOUNT",
"I_JNTVNTRMNPLTNRULERECOVERYIND",
"I_LEDGER",
"I_LEDGERGROUP",
"I_MASTERFIXEDASSET",
"I_NETWORKACTIVITYBYINTERNALKEY",
"I_ORDERBASIC",
"I_PROFITCENTER",
"I_PROJECTNETWORKBASICDATA",
"I_SALESORDERITEM",
"I_SETTLEMENTAUTOMGNRTNSTRATEGY",
"I_SETTLEMENTTYPE",
"I_SETTLMTDISTRAMOUNTRULETYPE",
"I_SETTLMTTRACINGFCTRDETNMETHOD",
"I_SETTLMTTYPELANGUAGEDEPENDENT",
"I_SETTLMTWITHFREEDFNDCURRENCY",
"I_WBSELEMENTBASICDATA",
"R_INTORDERSETTLEMENTRULETP",
"R_INTORDSETTLMTDISTRRULERETP"
],
"BASE":
[
"I_INTORDERSETTLEMENTDISTRRULE"
],
"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