R_InternalOrderTP

DDL: R_INTERNALORDERTP Type: view_entity TRANSACTIONAL

Internal Order

R_InternalOrderTP is a Transactional CDS View that provides data about "Internal Order" in SAP S/4HANA. It reads from 1 data source (I_InternalOrder) and exposes 129 fields with key fields InternalOrder, InternalOrderDraftInternalUUID. It has 10 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InternalOrder I_InternalOrder from

Associations (10)

CardinalityTargetAliasCondition
[0..1] I_StatusObjectStatusBasic _InternalOrderIsLocked I_InternalOrder.ControllingObject = _InternalOrderIsLocked.StatusObject and _InternalOrderIsLocked.StatusCode = 'I0043'
[0..1] I_StatusObjectStatusBasic _IntOrdSettlementRuleIsCreated I_InternalOrder.ControllingObject = _IntOrdSettlementRuleIsCreated.StatusObject and ( _IntOrdSettlementRuleIsCreated.StatusCode = 'I0028' or _IntOrdSettlementRuleIsCreated.StatusCode = 'I0027' ) and _IntOrdSettlementRuleIsCreated.StatusIsInactive = ''
[0..1] I_StatusObjectStatusBasic _IntOrdDeletionFlagIsSet I_InternalOrder.ControllingObject = _IntOrdDeletionFlagIsSet.StatusObject and _IntOrdDeletionFlagIsSet.StatusCode = 'I0076'
[0..1] I_StatusObjectStatusBasic _IntOrdIsMarkedForDeletion I_InternalOrder.ControllingObject = _IntOrdIsMarkedForDeletion.StatusObject and _IntOrdIsMarkedForDeletion.StatusCode = 'I0013'
[0..1] I_TaxJurisdiction _TaxJurisdiction $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction
[0..*] R_InternalOrderSystemStatusTP _InternalOrderSystemStatusTP
[0..*] R_IntOrderNumberedUserStatusTP _IntOrderNumberedUserStatusTP
[0..*] R_IntOrdUnnumberedUserStatusTP _IntOrdUnnumberedUserStatusTP
[0..*] R_IntOrdOverallSystemStatusTP _IntOrdOverallSystemStatusTP
[0..*] R_IntOrdLongDescriptionDraftTP _IntOrdLongDescriptionDraftTP

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Internal Order view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name InternalOrder view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (129)

KeyFieldSource TableSource FieldDescription
KEY InternalOrder InternalOrder
KEY InternalOrderDraftInternalUUID
InternalOrderForEdit InternalOrder
InternalOrderDescription
OrderCategory OrderCategory
BusinessArea BusinessArea
ControllingArea ControllingArea
Plant Plant
Currency Currency
IsStatisticalOrder IsStatisticalOrder
ReferenceOrder ReferenceOrder
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
WBSElementInternalID WBSElementInternalID
WBSElementExternalID _WBSElementBasicData WBSElementExternalID
RequestingCostCenter RequestingCostCenter
RequestingCompanyCode RequestingCompanyCode
RequestingOrder RequestingOrder
InternalOrderLocation InternalOrderLocation
LocationPlant LocationPlant
ExternalOrder ExternalOrder
ActualPostedCostCenter ActualPostedCostCenter
CostCenter CostCenter
LogicalSystem LogicalSystem
OrdIsUsedInIntegratedPlanning OrdIsUsedInIntegratedPlanning
ResultAnalysisInternalID ResultAnalysisInternalID
ConditionUsage ConditionUsage
ConditionApplication ConditionApplication
CostingSheet CostingSheet
OverheadCode OverheadCode
OrderInterestCalcProfile OrderInterestCalcProfile
IntOrderSettlementCostElement IntOrderSettlementCostElement
BasicSettlementGLAccount BasicSettlementGLAccount
IntOrderIndividualField1Value IntOrderIndividualField1Value
IntOrderIndividualField2Value IntOrderIndividualField2Value
IntOrderIndividualField3Value IntOrderIndividualField3Value
IntOrderIndividualField4Value IntOrderIndividualField4Value
IntOrderIndividualField5Amount IntOrderIndividualField5Amount
IntOrderIndividualField6Date IntOrderIndividualField6Date
IntOrderIndividualField7Value IntOrderIndividualField7Value
IntOrderIndividualField8Date IntOrderIndividualField8Date
IntOrderIndividualField9Date IntOrderIndividualField9Date
IntOrderIndividualField10Value
OrderProcessingGroup OrderProcessingGroup
InvestmentProfile InvestmentProfile
InvestmentScale InvestmentScale
InvestmentReason InvestmentReason
EnvironmentalInvestmentReason EnvironmentalInvestmentReason
JointVenture JointVenture
JointVentureRecoveryCode JointVentureRecoveryCode
JointVentureEquityType JointVentureEquityType
JointVentureOriginalCostObject JointVentureOriginalCostObject
JointVentureObjectType JointVentureObjectType
JointVentureClass JointVentureClass
JointVentureSubClass JointVentureSubClass
CreationDate CreationDate
CreationTime CreationTime
CreatedByUser CreatedByUser
LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
ControllingObject ControllingObject
CompanyCode CompanyCode
ProfitCenter ProfitCenter
FunctionalArea FunctionalArea
ControllingObjectClass ControllingObjectClass
OrderType OrderType
ResponsibleCostCenter ResponsibleCostCenter
InternalOrderResponsibleUser InternalOrderResponsibleUser
ControllingObjectStatus _SystemStatus ControllingObjectStatus
IntOrderSystemStatusShortName
InternalOrderSystemStatusName
TaxJurisdiction TaxJurisdiction
_ActualPostedCostCenter _ActualPostedCostCenter
_BasicSettlementGLAccount _BasicSettlementGLAccount
_CompanyCode _CompanyCode
_ConditionApplication _ConditionApplication
_ConditionUsage _ConditionUsage
_ControllingArea _ControllingArea
_ControllingAreaText _ControllingAreaText
_ControllingObjectClass _ControllingObjectClass
_CostCenter _CostCenter
_CostCenterData _CostCenterData
_CostingSheetProcedure _CostingSheetProcedure
_EnvrnmtlInvestmentReason _EnvrnmtlInvestmentReason
_FunctionalArea _FunctionalArea
_InternalOrderType _InternalOrderType
_InternalOrderTypeText _InternalOrderTypeText
_IntOrderSettlementCostElement _IntOrderSettlementCostElement
_InvestmentObjectScale _InvestmentObjectScale
_InvestmentProfile _InvestmentProfile
_InvestmentReason _InvestmentReason
_JntIntrstBillgClass _JntIntrstBillgClass
_JntIntrstBillgSubclass _JntIntrstBillgSubclass
_JntVntrEquityTypeMaster _JntVntrEquityTypeMaster
_JointVentureRecovery _JointVentureRecovery
_Location _Location
_LocationPlant _LocationPlant
_LogicalSystem _LogicalSystem
_OrderProcessingGroup _OrderProcessingGroup
_ProfitCenter _ProfitCenter
_RequestingCompanyCode _RequestingCompanyCode
_RequestingCostCenter _RequestingCostCenter
_RequestingOrder _RequestingOrder
_ResultsAnalysisKey _ResultsAnalysisKey
_ResponsibleUser _ResponsibleUser
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_CurRespCostCenterText _CurRespCostCenterText
_CurRequestingCostCenterText _CurRequestingCostCenterText
_CurCostCenterDataText _CurCostCenterDataText
_SystemStatus _SystemStatus
_WBSElementBasicData _WBSElementBasicData
_Currency _Currency
_OrderCategory _OrderCategory
_Plant _Plant
_BusinessArea _BusinessArea
_CurProfitCenterText _CurProfitCenterText
_CurActualPostedCostCenterText _CurActualPostedCostCenterText
_InternalOrderIsLocked _InternalOrderIsLocked
_IntOrdSettlementRuleIsCreated _IntOrdSettlementRuleIsCreated
_IntOrdDeletionFlagIsSet _IntOrdDeletionFlagIsSet
_IntOrdIsMarkedForDeletion _IntOrdIsMarkedForDeletion
_InternalOrderSystemStatusTP _InternalOrderSystemStatusTP
_IntOrdUnnumberedUserStatusTP _IntOrdUnnumberedUserStatusTP
_IntOrderNumberedUserStatusTP _IntOrderNumberedUserStatusTP
_IntOrdOverallSystemStatusTP _IntOrdOverallSystemStatusTP
_IntOrdLongDescriptionDraftTP _IntOrdLongDescriptionDraftTP
_TaxJurisdiction _TaxJurisdiction
 @AccessControl: {
  authorizationCheck: #CHECK,
  privilegedAssociations: [
  '_InternalOrderIsLocked',
  '_IntOrdSettlementRuleIsCreated'
  ]
}
@EndUserText.label: 'Internal Order'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.semanticKey: [ 'InternalOrder' ]
@ObjectModel.sapObjectNodeType.name: 'InternalOrder'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

define root view entity R_InternalOrderTP
  as select from I_InternalOrder

  composition [0..*] of R_InternalOrderSystemStatusTP  as _InternalOrderSystemStatusTP

  composition [0..*] of R_IntOrderNumberedUserStatusTP as _IntOrderNumberedUserStatusTP

  composition [0..*] of R_IntOrdUnnumberedUserStatusTP as _IntOrdUnnumberedUserStatusTP

  composition [0..*] of R_IntOrdOverallSystemStatusTP  as _IntOrdOverallSystemStatusTP

  composition [0..*] of R_IntOrdLongDescriptionDraftTP as _IntOrdLongDescriptionDraftTP

  association [0..1] to I_StatusObjectStatusBasic      as _InternalOrderIsLocked         on  I_InternalOrder.ControllingObject = _InternalOrderIsLocked.StatusObject
                                                                                         and _InternalOrderIsLocked.StatusCode = 'I0043'

  association [0..1] to I_StatusObjectStatusBasic      as _IntOrdSettlementRuleIsCreated on  I_InternalOrder.ControllingObject               = _IntOrdSettlementRuleIsCreated.StatusObject
                                                                                         and (
                                                                                            _IntOrdSettlementRuleIsCreated.StatusCode        = 'I0028'
                                                                                            or _IntOrdSettlementRuleIsCreated.StatusCode     = 'I0027'
                                                                                          )
                                                                                         and _IntOrdSettlementRuleIsCreated.StatusIsInactive = ''

  association [0..1] to I_StatusObjectStatusBasic      as _IntOrdDeletionFlagIsSet       on  I_InternalOrder.ControllingObject   = _IntOrdDeletionFlagIsSet.StatusObject
                                                                                         and _IntOrdDeletionFlagIsSet.StatusCode = 'I0076'

  association [0..1] to I_StatusObjectStatusBasic      as _IntOrdIsMarkedForDeletion     on  I_InternalOrder.ControllingObject     = _IntOrdIsMarkedForDeletion.StatusObject
                                                                                         and _IntOrdIsMarkedForDeletion.StatusCode = 'I0013'

  association [0..1] to I_TaxJurisdiction              as _TaxJurisdiction               on  $projection.TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction

{
  key InternalOrder,
  key cast('00000000000000000000000000000000' as sysuuid_c32)                           as InternalOrderDraftInternalUUID,
      @ObjectModel.editableFieldFor: 'InternalOrder'
      InternalOrder                                                                     as InternalOrderForEdit,
      cast( InternalOrderDescription as kltxt )                                         as InternalOrderDescription,
      OrderCategory,
      BusinessArea,
      @ObjectModel.text.association:null
      ControllingArea,
      Plant,
      Currency,
      IsStatisticalOrder,
      ReferenceOrder,
      SalesOrder,
      SalesOrderItem,
      WBSElementInternalID,
      _WBSElementBasicData.WBSElementExternalID,
      RequestingCostCenter,
      RequestingCompanyCode,
      RequestingOrder,
      InternalOrderLocation,
      LocationPlant,
      ExternalOrder,
      ActualPostedCostCenter,
      CostCenter,
      LogicalSystem,
      OrdIsUsedInIntegratedPlanning,
      ResultAnalysisInternalID,
      ConditionUsage,
      ConditionApplication,
      CostingSheet,
      OverheadCode,
      OrderInterestCalcProfile,
      IntOrderSettlementCostElement,
      BasicSettlementGLAccount,
      IntOrderIndividualField1Value,
      IntOrderIndividualField2Value,
      IntOrderIndividualField3Value,
      IntOrderIndividualField4Value,
      IntOrderIndividualField5Amount,
      IntOrderIndividualField6Date,
      IntOrderIndividualField7Value,
      IntOrderIndividualField8Date,
      IntOrderIndividualField9Date,
      cast ( IntOrderIndividualField10Value as fco_io_aufuser9 preserving type )        as IntOrderIndividualField10Value,
      OrderProcessingGroup,
      InvestmentProfile,
      InvestmentScale,
      InvestmentReason,
      EnvironmentalInvestmentReason,
      JointVenture,
      JointVentureRecoveryCode,
      JointVentureEquityType,
      JointVentureOriginalCostObject,
      JointVentureObjectType,
      JointVentureClass,
      JointVentureSubClass,
      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,
      CreationDate,
      CreationTime,
      CreatedByUser,
      cast ( LastChangedByUser as fco_io_aufaenam preserving type )                     as LastChangedByUser,
      LastChangeDate,
      LastChangeTime,

      @Semantics.systemDateTime.lastChangedAt: true
      cast( dats_tims_to_tstmp( LastChangeDate,
                          LastChangeTime,
                          abap_system_timezone( $session.client,'NULL' ),
                          $session.client,
                         'NULL' ) as timestamp )                                        as LastChangeDateTime,

      ControllingObject,
      CompanyCode,
      ProfitCenter,
      FunctionalArea,
      ControllingObjectClass,
      @ObjectModel.text.association:null
      OrderType,
      ResponsibleCostCenter,
      InternalOrderResponsibleUser,
      case _InternalOrderType.CommitmentsMgmtActvtnStatus
        when '' then cast( '' as fins_co_io_obligo )
        when '1' then cast( 'X' as fins_co_io_obligo )
      end                                                                               as CommitmentsMgmtActvtnStatus,

      case substring(CostCollector, 1, 1)
        when '1'
          then cast( '' as erloese )
        when '2'
          then cast( 'X' as erloese )
      end                                                                               as RevenuePostingIsAllowed,
      @ObjectModel.text.association:null
      _SystemStatus.ControllingObjectStatus,
      _SystemStatus._Text[1: Language = $session.system_language].SystemStatusShortName as IntOrderSystemStatusShortName,
      _SystemStatus._Text[1: Language = $session.system_language].StatusName            as InternalOrderSystemStatusName,
      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 _IntOrdSettlementRuleIsCreated.StatusIsInactive
        when 'X' then cast ('' as fco_io_settl_rule_created preserving type )
        when '' then cast ('X' as fco_io_settl_rule_created preserving type )
        else cast ('' as fco_io_settl_rule_created preserving type )
        end                                                                             as IntOrdSettlementRuleIsCreated,
      TaxJurisdiction,

      /* Associations */
      _ActualPostedCostCenter,
      _BasicSettlementGLAccount,
      _CompanyCode,
      _ConditionApplication,
      _ConditionUsage,
      _ControllingArea,
      _ControllingAreaText,
      _ControllingObjectClass,
      _CostCenter,
      _CostCenterData,
      _CostingSheetProcedure,
      _EnvrnmtlInvestmentReason,
      _FunctionalArea,
      _InternalOrderType,
      _InternalOrderTypeText,
      _IntOrderSettlementCostElement,
      _InvestmentObjectScale,
      _InvestmentProfile,
      _InvestmentReason,
      _JntIntrstBillgClass,
      _JntIntrstBillgSubclass,
      _JntVntrEquityTypeMaster,
      _JointVentureRecovery,
      _Location,
      _LocationPlant,
      _LogicalSystem,
      _OrderProcessingGroup,
      _ProfitCenter,
      _RequestingCompanyCode,
      _RequestingCostCenter,
      _RequestingOrder,
      _ResultsAnalysisKey,
      _ResponsibleUser,
      _CreatedByUser,
      _LastChangedByUser,
      _CurRespCostCenterText,
      _CurRequestingCostCenterText,
      _CurCostCenterDataText,
      _SystemStatus,
      _WBSElementBasicData,
      _Currency,
      _OrderCategory,
      _Plant,
      _BusinessArea,
      _CurProfitCenterText,
      _CurActualPostedCostCenterText,
      _InternalOrderIsLocked,
      _IntOrdSettlementRuleIsCreated,
      _IntOrdDeletionFlagIsSet,
      _IntOrdIsMarkedForDeletion,
      _InternalOrderSystemStatusTP,
      _IntOrdUnnumberedUserStatusTP,
      _IntOrderNumberedUserStatusTP,
      _IntOrdOverallSystemStatusTP,
      _IntOrdLongDescriptionDraftTP,
      _TaxJurisdiction
}