R_IntOrderSettlementRuleTP

DDL: R_INTORDERSETTLEMENTRULETP Type: view_entity TRANSACTIONAL

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)

SourceAliasJoin Type
I_InternalOrderSettlementRule I_InternalOrderSettlementRule from

Associations (3)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/