I_InternalOrder

DDL: I_INTERNALORDER SQL: IFIINTERNALORDER Type: view BASIC

Internal Order

I_InternalOrder is a Basic CDS View (Dimension) that provides data about "Internal Order" in SAP S/4HANA. It reads from 1 data source (aufk) and exposes 128 fields with key field InternalOrder. It has 52 associations to related views.

Data Sources (1)

SourceAliasJoin Type
aufk aufk from

Associations (52)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingAreaText $projection.ControllingArea = _ControllingAreaText.ControllingArea
[0..*] I_InternalOrderTypeText _InternalOrderTypeText $projection.OrderType = _InternalOrderTypeText.OrderType
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..*] I_ProfitCenter _ProfitCenter $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter
[0..1] I_FunctionalArea _FunctionalArea $projection.FunctionalArea = _FunctionalArea.FunctionalArea
[0..1] I_ControllingObjectClass _ControllingObjectClass $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass
[0..1] I_InternalOrderType _InternalOrderType $projection.OrderType = _InternalOrderType.OrderType
[0..*] I_CostCenter _CostCenter $projection.ControllingArea = _CostCenter.ControllingArea and $projection.ResponsibleCostCenter = _CostCenter.CostCenter
[0..*] I_InternalOrderSystemStatus _SystemStatus $projection.ControllingObject = _SystemStatus.ControllingObject
[1..1] E_LogisticsOrder _Extension $projection.InternalOrder = _Extension.OrderID
[0..*] I_ProfitCenterText _CurProfitCenterText $projection.ControllingArea = _CurProfitCenterText.ControllingArea and $projection.ProfitCenter = _CurProfitCenterText.ProfitCenter and _CurProfitCenterText.ValidityStartDate <= $session.system_date and _CurProfitCenterText.ValidityEndDate >= $session.system_date
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_User _User $projection.InternalOrderResponsibleUser = _User.UserID
[0..1] I_BusinessArea _BusinessArea $projection.BusinessArea = _BusinessArea.BusinessArea
[0..1] I_Currency _Currency $projection.Currency = _Currency.Currency
[0..1] I_OrderCategory _OrderCategory $projection.OrderCategory = _OrderCategory.OrderCategory
[0..*] I_CostCenterText _CurRespCostCenterText $projection.ControllingArea = _CurRespCostCenterText.ControllingArea and $projection.ResponsibleCostCenter = _CurRespCostCenterText.CostCenter and _CurRespCostCenterText.ValidityStartDate <= $session.system_date and _CurRespCostCenterText.ValidityEndDate >= $session.system_date
[0..1] I_WBSElementBasicData _WBSElementBasicData $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
[0..*] I_CostCenter _RequestingCostCenter $projection.RequestingCostCenter = _RequestingCostCenter.CostCenter and $projection.ControllingArea = _RequestingCostCenter.ControllingArea
[0..*] I_CostCenterText _CurRequestingCostCenterText $projection.ControllingArea = _CurRequestingCostCenterText.ControllingArea and $projection.RequestingCostCenter = _CurRequestingCostCenterText.CostCenter and _CurRequestingCostCenterText.ValidityStartDate <= $session.system_date and _CurRequestingCostCenterText.ValidityEndDate >= $session.system_date
[0..1] I_CompanyCode _RequestingCompanyCode $projection.RequestingCompanyCode = _RequestingCompanyCode.CompanyCode
[0..1] I_Order _RequestingOrder $projection.RequestingOrder = _RequestingOrder.OrderID
[0..1] I_Location _Location $projection.InternalOrderLocation = _Location.Location and $projection.LocationPlant = _Location.Plant
[0..1] I_Plant _LocationPlant $projection.LocationPlant = _LocationPlant.Plant
[0..*] I_CostCenter _ActualPostedCostCenter $projection.ControllingArea = _ActualPostedCostCenter.ControllingArea and $projection.ActualPostedCostCenter = _ActualPostedCostCenter.CostCenter
[0..*] I_CostCenterText _CurActualPostedCostCenterText $projection.ControllingArea = _CurActualPostedCostCenterText.ControllingArea and $projection.ActualPostedCostCenter = _CurActualPostedCostCenterText.CostCenter and _CurActualPostedCostCenterText.ValidityStartDate <= $session.system_date and _CurActualPostedCostCenterText.ValidityEndDate >= $session.system_date
[0..*] I_CostCenter _CostCenterData $projection.ControllingArea = _CostCenterData.ControllingArea and $projection.CostCenter = _CostCenterData.CostCenter
[0..*] I_CostCenterText _CurCostCenterDataText $projection.ControllingArea = _CurCostCenterDataText.ControllingArea and $projection.CostCenter = _CurCostCenterDataText.CostCenter and _CurCostCenterDataText.ValidityStartDate <= $session.system_date and _CurCostCenterDataText.ValidityEndDate >= $session.system_date
[0..1] I_LogicalSystem _LogicalSystem $projection.LogicalSystem = _LogicalSystem.LogicalSystem
[0..1] I_ConditionUsage _ConditionUsage $projection.ConditionUsage = _ConditionUsage.ConditionUsage
[0..1] I_ConditionApplication _ConditionApplication $projection.ConditionApplication = _ConditionApplication.ConditionApplication
[0..1] I_CostingSheetProcedure _CostingSheetProcedure $projection.ConditionUsage = _CostingSheetProcedure.ConditionUsage and $projection.ConditionApplication = _CostingSheetProcedure.ConditionApplication and $projection.CostingSheet = _CostingSheetProcedure.CostingSheetProcedure
[0..*] I_CostElementOnControllingArea _IntOrderSettlementCostElement $projection.ControllingArea = _IntOrderSettlementCostElement.ControllingArea and $projection.IntOrderSettlementCostElement = _IntOrderSettlementCostElement.CostElement
[0..1] I_GLAccountInCompanyCode _BasicSettlementGLAccount $projection.CompanyCode = _BasicSettlementGLAccount.CompanyCode and $projection.BasicSettlementGLAccount = _BasicSettlementGLAccount.GLAccount
[0..1] I_OrderProcessingGroup _OrderProcessingGroup $projection.ControllingArea = _OrderProcessingGroup.ControllingArea and $projection.OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup
[0..1] I_InvestmentProfile _InvestmentProfile $projection.InvestmentProfile = _InvestmentProfile.InvestmentProfile
[0..1] I_InvestmentReason _InvestmentReason $projection.InvestmentReason = _InvestmentReason.InvestmentReason
[0..1] I_EnvrnmtlInvestmentReason _EnvrnmtlInvestmentReason $projection.EnvironmentalInvestmentReason = _EnvrnmtlInvestmentReason.EnvrnmtlInvestmentReason
[0..1] I_JointVentureMaster _JointVentureMaster $projection.CompanyCode = _JointVentureMaster.CompanyCode and $projection.JointVenture = _JointVentureMaster.JointVenture
[0..1] I_JointVentureRecovery _JointVentureRecovery $projection.JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode and $projection.CompanyCode = _JointVentureRecovery.CompanyCode
[0..1] I_JntVntrEquityTypeMaster _JntVntrEquityTypeMaster $projection.JointVentureEquityType = _JntVntrEquityTypeMaster.JointVentureEquityType and $projection.CompanyCode = _JntVntrEquityTypeMaster.CompanyCode
[0..1] I_JntVntrCostCtrType _JntVntrCostCtrType $projection.JointVentureObjectType = _JntVntrCostCtrType.JntVntrCostCtrType and $projection.CompanyCode = _JntVntrCostCtrType.CompanyCode
[0..1] I_JntIntrstBillgClass _JntIntrstBillgClass $projection.JointVentureClass = _JntIntrstBillgClass.JntIntrstBillgClass and $projection.CompanyCode = _JntIntrstBillgClass.CompanyCode
[0..1] I_JntIntrstBillgSubclass _JntIntrstBillgSubclass $projection.CompanyCode = _JntIntrstBillgSubclass.CompanyCode and $projection.JointVentureClass = _JntIntrstBillgSubclass.JntIntrstBillgClass and $projection.JointVentureSubClass = _JntIntrstBillgSubclass.JntIntrstBillgSubClass
[0..1] I_UserContactCard _ResponsibleUser $projection.InternalOrderResponsibleUser = _ResponsibleUser.ContactCardID
[0..1] I_UserContactCard _CreatedByUser $projection.CreatedByUser = _CreatedByUser.ContactCardID
[0..1] I_UserContactCard _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.ContactCardID
[0..1] I_ResultsAnalysisKey _ResultsAnalysisKey $projection.ResultAnalysisInternalID = _ResultsAnalysisKey.ResultAnalysisInternalID
[0..1] I_InvestmentObjectScale _InvestmentObjectScale $projection.InvestmentScale = _InvestmentObjectScale.InvestmentScale
[0..*] I_IntOrderActiveSystemStatus _IntOrderActiveSystemStatus $projection.ControllingObject = _IntOrderActiveSystemStatus.StatusObject
[0..*] I_IntOrderActiveUserStatus _IntOrderActiveUserStatus $projection.ControllingObject = _IntOrderActiveUserStatus.StatusObject

Annotations (17)

NameValueLevelField
EndUserText.label Internal Order view
AbapCatalog.sqlViewName IFIINTERNALORDER view
AbapCatalog.buffering.type #NONE view
AbapCatalog.buffering.numberOfKeyFields 0 view
AbapCatalog.buffering.status #NOT_ALLOWED view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey InternalOrder view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (128)

KeyFieldSource TableSource FieldDescription
KEY InternalOrder
InternalOrderDescription
OrderCategory autyp
BusinessArea
ControllingArea
Plant werks
Currency waers
IsStatisticalOrder
ReferenceOrder
SalesOrder kdauf
SalesOrderItem kdpos
WBSElement pspel
WBSElementInternalID
RequestingCostCenter akstl
RequestingCompanyCode abukr
RequestingOrder anfaufnr
InternalOrderLocation
LocationPlant sowrk
ExternalOrder aufex
ActualPostedCostCenter
PlanningWithLineItemsIsActive plgkz
CostCenter
LogicalSystem logsystem
OrdIsUsedInIntegratedPlanning
TaxJurisdiction
ResultAnalysisInternalID
ConditionUsage kvewe
ConditionApplication kappl
CostingSheet kalsm
OverheadCode
OrderInterestCalcProfile
IntOrderSettlementCostElement
BasicSettlementGLAccount saknr
IntOrderIndividualField1Value user0
IntOrderIndividualField2Value user1
IntOrderIndividualField3Value user2
IntOrderIndividualField4Value user3
IntOrderIndividualField5Amount user4
IntOrderIndividualField6Date user5
IntOrderIndividualField7Value user6
IntOrderIndividualField8Date user7
IntOrderIndividualField9Date user8
IntOrderIndividualField10Value user9
OrderProcessingGroup
InvestmentProfile
InvestmentScale
InvestmentReason izwek
EnvironmentalInvestmentReason umwkz
JointVenture vname
JointVentureRecoveryCode recid
JointVentureEquityType etype
JointVentureOriginalCostObject jv_oco
JointVentureObjectType otype
JointVentureClass jv_jibcl
JointVentureSubClass jv_jibsa
IsDeleted loekz
CreationDate erdat
CreationTime erfzeit
CreatedByUser
LastChangedByUser aenam
LastChangeDate aedat
LastChangeTime aezeit
ControllingObject objnr
CompanyCode
ProfitCenter
FunctionalArea
ControllingObjectClass
OrderType auart
ResponsibleCostCenter
InternalOrderResponsibleUser
IntOrderPlannedReleaseDate pdat1
IntOrderPlannedCompletionDate pdat2
IntOrderPlannedClosingDate pdat3
InternalOrderReleaseDate idat1
InternalOrderCompletionDate idat2
InternalOrderClosingDate idat3
CostCollector cckey
_ControllingArea _ControllingArea
_CompanyCode _CompanyCode
_ProfitCenter _ProfitCenter
_FunctionalArea _FunctionalArea
_ControllingObjectClass _ControllingObjectClass
_InternalOrderType _InternalOrderType
_CostCenter _CostCenter
_User _User
_WBSElementBasicData _WBSElementBasicData
_RequestingCostCenter _RequestingCostCenter
_RequestingCompanyCode _RequestingCompanyCode
_RequestingOrder _RequestingOrder
_Location _Location
_LocationPlant _LocationPlant
_ActualPostedCostCenter _ActualPostedCostCenter
_CostCenterData _CostCenterData
_LogicalSystem _LogicalSystem
_ConditionUsage _ConditionUsage
_ConditionApplication _ConditionApplication
_CostingSheetProcedure _CostingSheetProcedure
_IntOrderSettlementCostElement _IntOrderSettlementCostElement
_BasicSettlementGLAccount _BasicSettlementGLAccount
_OrderProcessingGroup _OrderProcessingGroup
_InvestmentProfile _InvestmentProfile
_InvestmentReason _InvestmentReason
_EnvrnmtlInvestmentReason _EnvrnmtlInvestmentReason
_JointVentureMaster _JointVentureMaster
_JointVentureRecovery _JointVentureRecovery
_JntVntrEquityTypeMaster _JntVntrEquityTypeMaster
_JntVntrCostCtrType _JntVntrCostCtrType
_JntIntrstBillgClass _JntIntrstBillgClass
_JntIntrstBillgSubclass _JntIntrstBillgSubclass
_ResponsibleUser _ResponsibleUser
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_CurRespCostCenterText _CurRespCostCenterText
_CurRequestingCostCenterText _CurRequestingCostCenterText
_CurCostCenterDataText _CurCostCenterDataText
_SystemStatus _SystemStatus
_ResultsAnalysisKey _ResultsAnalysisKey
_InvestmentObjectScale _InvestmentObjectScale
_Currency _Currency
_OrderCategory _OrderCategory
_BusinessArea _BusinessArea
_Plant _Plant
_CurProfitCenterText _CurProfitCenterText
_CurActualPostedCostCenterText _CurActualPostedCostCenterText
_IntOrderActiveSystemStatus _IntOrderActiveSystemStatus
_IntOrderActiveUserStatus _IntOrderActiveUserStatus
_ControllingAreaText _ControllingAreaText
_InternalOrderTypeText _InternalOrderTypeText
@EndUserText.label: 'Internal Order'

@AbapCatalog.sqlViewName: 'IFIINTERNALORDER'
@AbapCatalog.buffering: {type: #NONE, numberOfKeyFields: 0, status: #NOT_ALLOWED}

@VDM.viewType: #BASIC

@Analytics: { dataCategory: #DIMENSION, 
              dataExtraction:{ enabled: true } 
            }

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'InternalOrder'

@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true

//--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0

@AccessControl.privilegedAssociations: ['_ControllingAreaText','_InternalOrderTypeText', '_ResponsibleUser', '_LastChangedByUser','_CreatedByUser']
// ]--GENERATED

@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE ]

define view I_InternalOrder
  as select from aufk

  //--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0

  association [0..1] to I_ControllingArea              as _ControllingAreaText           on  $projection.ControllingArea = _ControllingAreaText.ControllingArea
  association [0..*] to I_InternalOrderTypeText        as _InternalOrderTypeText         on  $projection.OrderType = _InternalOrderTypeText.OrderType
  // ]--GENERATED

  association [0..1] to I_ControllingArea              as _ControllingArea               on  $projection.ControllingArea = _ControllingArea.ControllingArea

  association [0..1] to I_CompanyCode                  as _CompanyCode                   on  $projection.CompanyCode = _CompanyCode.CompanyCode

  association [0..*] to I_ProfitCenter                 as _ProfitCenter                  on  $projection.ControllingArea = _ProfitCenter.ControllingArea
                                                                                         and $projection.ProfitCenter    = _ProfitCenter.ProfitCenter

  association [0..1] to I_FunctionalArea               as _FunctionalArea                on  $projection.FunctionalArea = _FunctionalArea.FunctionalArea

  association [0..1] to I_ControllingObjectClass       as _ControllingObjectClass        on  $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass

  association [0..1] to I_InternalOrderType            as _InternalOrderType             on  $projection.OrderType = _InternalOrderType.OrderType

  association [0..*] to I_CostCenter                   as _CostCenter                    on  $projection.ControllingArea       = _CostCenter.ControllingArea
                                                                                         and $projection.ResponsibleCostCenter = _CostCenter.CostCenter

  association [0..*] to I_InternalOrderSystemStatus    as _SystemStatus                  on  $projection.ControllingObject = _SystemStatus.ControllingObject

  association [1..1] to E_LogisticsOrder               as _Extension                     on  $projection.InternalOrder = _Extension.OrderID

  association [0..*] to I_ProfitCenterText             as _CurProfitCenterText           on  $projection.ControllingArea            = _CurProfitCenterText.ControllingArea
                                                                                         and $projection.ProfitCenter               = _CurProfitCenterText.ProfitCenter
                                                                                         and _CurProfitCenterText.ValidityStartDate <= $session.system_date
                                                                                         and _CurProfitCenterText.ValidityEndDate   >= $session.system_date

  association [0..1] to I_Plant                        as _Plant                         on  $projection.Plant = _Plant.Plant

  association [0..1] to I_User                         as _User                          on  $projection.InternalOrderResponsibleUser = _User.UserID

  association [0..1] to I_BusinessArea                 as _BusinessArea                  on  $projection.BusinessArea = _BusinessArea.BusinessArea

  association [0..1] to I_Currency                     as _Currency                      on  $projection.Currency = _Currency.Currency

  association [0..1] to I_OrderCategory                as _OrderCategory                 on  $projection.OrderCategory = _OrderCategory.OrderCategory

  association [0..*] to I_CostCenterText               as _CurRespCostCenterText         on  $projection.ControllingArea              = _CurRespCostCenterText.ControllingArea
                                                                                         and $projection.ResponsibleCostCenter        = _CurRespCostCenterText.CostCenter
                                                                                         and _CurRespCostCenterText.ValidityStartDate <= $session.system_date
                                                                                         and _CurRespCostCenterText.ValidityEndDate   >= $session.system_date

  association [0..1] to I_WBSElementBasicData          as _WBSElementBasicData           on  $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID

  association [0..*] to I_CostCenter                   as _RequestingCostCenter          on  $projection.RequestingCostCenter = _RequestingCostCenter.CostCenter
                                                                                         and $projection.ControllingArea      = _RequestingCostCenter.ControllingArea

  association [0..*] to I_CostCenterText               as _CurRequestingCostCenterText   on  $projection.ControllingArea                    = _CurRequestingCostCenterText.ControllingArea
                                                                                         and $projection.RequestingCostCenter               = _CurRequestingCostCenterText.CostCenter
                                                                                         and _CurRequestingCostCenterText.ValidityStartDate <= $session.system_date
                                                                                         and _CurRequestingCostCenterText.ValidityEndDate   >= $session.system_date

  association [0..1] to I_CompanyCode                  as _RequestingCompanyCode         on  $projection.RequestingCompanyCode = _RequestingCompanyCode.CompanyCode

  association [0..1] to I_Order                        as _RequestingOrder               on  $projection.RequestingOrder = _RequestingOrder.OrderID

  association [0..1] to I_Location                     as _Location                      on  $projection.InternalOrderLocation = _Location.Location
                                                                                         and $projection.LocationPlant         = _Location.Plant

  association [0..1] to I_Plant                        as _LocationPlant                 on  $projection.LocationPlant = _LocationPlant.Plant

  association [0..*] to I_CostCenter                   as _ActualPostedCostCenter        on  $projection.ControllingArea        = _ActualPostedCostCenter.ControllingArea
                                                                                         and $projection.ActualPostedCostCenter = _ActualPostedCostCenter.CostCenter

  association [0..*] to I_CostCenterText               as _CurActualPostedCostCenterText on  $projection.ControllingArea                      = _CurActualPostedCostCenterText.ControllingArea
                                                                                         and $projection.ActualPostedCostCenter               = _CurActualPostedCostCenterText.CostCenter
                                                                                         and _CurActualPostedCostCenterText.ValidityStartDate <= $session.system_date
                                                                                         and _CurActualPostedCostCenterText.ValidityEndDate   >= $session.system_date

  association [0..*] to I_CostCenter                   as _CostCenterData                on  $projection.ControllingArea = _CostCenterData.ControllingArea
                                                                                         and $projection.CostCenter      = _CostCenterData.CostCenter

  association [0..*] to I_CostCenterText               as _CurCostCenterDataText         on  $projection.ControllingArea              = _CurCostCenterDataText.ControllingArea
                                                                                         and $projection.CostCenter                   = _CurCostCenterDataText.CostCenter
                                                                                         and _CurCostCenterDataText.ValidityStartDate <= $session.system_date
                                                                                         and _CurCostCenterDataText.ValidityEndDate   >= $session.system_date

  association [0..1] to I_LogicalSystem                as _LogicalSystem                 on  $projection.LogicalSystem = _LogicalSystem.LogicalSystem

  association [0..1] to I_ConditionUsage               as _ConditionUsage                on  $projection.ConditionUsage = _ConditionUsage.ConditionUsage

  association [0..1] to I_ConditionApplication         as _ConditionApplication          on  $projection.ConditionApplication = _ConditionApplication.ConditionApplication

  association [0..1] to I_CostingSheetProcedure        as _CostingSheetProcedure         on  $projection.ConditionUsage       = _CostingSheetProcedure.ConditionUsage
                                                                                         and $projection.ConditionApplication = _CostingSheetProcedure.ConditionApplication
                                                                                         and $projection.CostingSheet         = _CostingSheetProcedure.CostingSheetProcedure

  association [0..*] to I_CostElementOnControllingArea as _IntOrderSettlementCostElement on  $projection.ControllingArea               = _IntOrderSettlementCostElement.ControllingArea
                                                                                         and $projection.IntOrderSettlementCostElement = _IntOrderSettlementCostElement.CostElement

  association [0..1] to I_GLAccountInCompanyCode       as _BasicSettlementGLAccount      on  $projection.CompanyCode              = _BasicSettlementGLAccount.CompanyCode
                                                                                         and $projection.BasicSettlementGLAccount = _BasicSettlementGLAccount.GLAccount

  association [0..1] to I_OrderProcessingGroup         as _OrderProcessingGroup          on  $projection.ControllingArea      = _OrderProcessingGroup.ControllingArea
                                                                                         and $projection.OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup

  association [0..1] to I_InvestmentProfile            as _InvestmentProfile             on  $projection.InvestmentProfile = _InvestmentProfile.InvestmentProfile

  association [0..1] to I_InvestmentReason             as _InvestmentReason              on  $projection.InvestmentReason = _InvestmentReason.InvestmentReason

  association [0..1] to I_EnvrnmtlInvestmentReason     as _EnvrnmtlInvestmentReason      on  $projection.EnvironmentalInvestmentReason = _EnvrnmtlInvestmentReason.EnvrnmtlInvestmentReason

  association [0..1] to I_JointVentureMaster           as _JointVentureMaster            on  $projection.CompanyCode  = _JointVentureMaster.CompanyCode
                                                                                         and $projection.JointVenture = _JointVentureMaster.JointVenture

  association [0..1] to I_JointVentureRecovery         as _JointVentureRecovery          on  $projection.JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode
                                                                                         and $projection.CompanyCode              = _JointVentureRecovery.CompanyCode

  association [0..1] to I_JntVntrEquityTypeMaster      as _JntVntrEquityTypeMaster       on  $projection.JointVentureEquityType = _JntVntrEquityTypeMaster.JointVentureEquityType
                                                                                         and $projection.CompanyCode            = _JntVntrEquityTypeMaster.CompanyCode

  association [0..1] to I_JntVntrCostCtrType           as _JntVntrCostCtrType            on  $projection.JointVentureObjectType = _JntVntrCostCtrType.JntVntrCostCtrType
                                                                                         and $projection.CompanyCode            = _JntVntrCostCtrType.CompanyCode

  association [0..1] to I_JntIntrstBillgClass          as _JntIntrstBillgClass           on  $projection.JointVentureClass = _JntIntrstBillgClass.JntIntrstBillgClass
                                                                                         and $projection.CompanyCode       = _JntIntrstBillgClass.CompanyCode

  association [0..1] to I_JntIntrstBillgSubclass       as _JntIntrstBillgSubclass        on  $projection.CompanyCode          = _JntIntrstBillgSubclass.CompanyCode
                                                                                         and $projection.JointVentureClass    = _JntIntrstBillgSubclass.JntIntrstBillgClass
                                                                                         and $projection.JointVentureSubClass = _JntIntrstBillgSubclass.JntIntrstBillgSubClass

  association [0..1] to I_UserContactCard              as _ResponsibleUser               on  $projection.InternalOrderResponsibleUser = _ResponsibleUser.ContactCardID

  association [0..1] to I_UserContactCard              as _CreatedByUser                 on  $projection.CreatedByUser = _CreatedByUser.ContactCardID

  association [0..1] to I_UserContactCard              as _LastChangedByUser             on  $projection.LastChangedByUser = _LastChangedByUser.ContactCardID


  association [0..1] to I_ResultsAnalysisKey           as _ResultsAnalysisKey            on  $projection.ResultAnalysisInternalID = _ResultsAnalysisKey.ResultAnalysisInternalID
  association [0..1] to I_InvestmentObjectScale        as _InvestmentObjectScale         on  $projection.InvestmentScale = _InvestmentObjectScale.InvestmentScale

  association [0..*] to I_IntOrderActiveSystemStatus   as _IntOrderActiveSystemStatus    on  $projection.ControllingObject = _IntOrderActiveSystemStatus.StatusObject

  association [0..*] to I_IntOrderActiveUserStatus     as _IntOrderActiveUserStatus      on  $projection.ControllingObject = _IntOrderActiveUserStatus.StatusObject

{
      @ObjectModel.text.element: ['InternalOrderDescription']
  key cast( aufnr as fins_int_aufnr preserving type )      as InternalOrder,

      @Semantics.text: true
      cast(ktext as fis_internalorder_text)                as InternalOrderDescription,
      @ObjectModel.foreignKey.association: '_OrderCategory'
      autyp                                                as OrderCategory,
      @ObjectModel.foreignKey.association: '_BusinessArea'
      cast(gsber as fis_rbusa)                             as BusinessArea,
      //--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ControllingArea',
                     element: 'ControllingArea' }
        }]
      @ObjectModel.text.association: '_ControllingAreaText'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_ControllingArea'
      cast(kokrs as fis_kokrs preserving type )            as ControllingArea,
      @ObjectModel.foreignKey.association: '_Plant'
      werks                                                as Plant,
      @ObjectModel.foreignKey.association: '_Currency'
      waers                                                as Currency,
      cast (astkz as fins_co_xaufnr_stat preserving type ) as IsStatisticalOrder,
      cast(refnr as fis_aufrefnr preserving type )         as ReferenceOrder,
      kdauf                                                as SalesOrder,
      kdpos                                                as SalesOrderItem,
      pspel                                                as WBSElement,
      @ObjectModel.foreignKey.association: '_WBSElementBasicData'
      cast ( pspel as ps_s4_pspnr preserving type )        as WBSElementInternalID,
      akstl                                                as RequestingCostCenter,
      @ObjectModel.foreignKey.association: '_RequestingCompanyCode'
      abukr                                                as RequestingCompanyCode,
      @ObjectModel.foreignKey.association: '_RequestingOrder'
      anfaufnr                                             as RequestingOrder,
      @ObjectModel.foreignKey.association: '_Location'
      cast( stort as fco_io_aufstort preserving type )     as InternalOrderLocation,
      @ObjectModel.foreignKey.association: '_LocationPlant'
      sowrk                                                as LocationPlant,
      aufex                                                as ExternalOrder,
      cast( cycle as fins_st_kostl preserving type )       as ActualPostedCostCenter,
      plgkz                                                as PlanningWithLineItemsIsActive,
      cast(kostl as fis_kostl preserving type )            as CostCenter,
      @ObjectModel.foreignKey.association: '_LogicalSystem'
      logsystem                                            as LogicalSystem,
      cast(plint as fco_plint preserving type )            as OrdIsUsedInIntegratedPlanning,
      cast ( txjcd as fis_txjcd preserving type )          as TaxJurisdiction,
      cast(abgsl as fco_abgr_schl preserving type )        as ResultAnalysisInternalID,
      @ObjectModel.foreignKey.association: '_ConditionUsage'
      kvewe                                                as ConditionUsage,
      @ObjectModel.foreignKey.association: '_ConditionApplication'
      kappl                                                as ConditionApplication,
      @ObjectModel.foreignKey.association: '_CostingSheetProcedure'
      kalsm                                                as CostingSheet,
      cast(zschl as fco_aufzschl preserving type )         as OverheadCode,
      // TODO - Define basic view for TPI01

      cast(zschm as fco_io_ps_zschm preserving type )      as OrderInterestCalcProfile,
      cast(kstar as fco_aufkstar preserving type )         as IntOrderSettlementCostElement,
      @ObjectModel.foreignKey.association: '_BasicSettlementGLAccount'
      saknr                                                as BasicSettlementGLAccount,

      user0                                                as IntOrderIndividualField1Value,
      user1                                                as IntOrderIndividualField2Value,
      user2                                                as IntOrderIndividualField3Value,
      user3                                                as IntOrderIndividualField4Value,
      @Semantics.amount.currencyCode: 'Currency'
      user4                                                as IntOrderIndividualField5Amount,
      user5                                                as IntOrderIndividualField6Date,
      user6                                                as IntOrderIndividualField7Value,
      user7                                                as IntOrderIndividualField8Date,
      user8                                                as IntOrderIndividualField9Date,
      user9                                                as IntOrderIndividualField10Value,

      @ObjectModel.foreignKey.association: '_OrderProcessingGroup'
      cast(abkrs as fco_aufabkrs preserving type )         as OrderProcessingGroup,
      cast(ivpro as fco_im_profil preserving type )        as InvestmentProfile,
      cast(sizecl as fco_im_sizecl preserving type )       as InvestmentScale,
      izwek                                                as InvestmentReason,
      @ObjectModel.foreignKey.association: '_EnvrnmtlInvestmentReason'
      umwkz                                                as EnvironmentalInvestmentReason,
      vname                                                as JointVenture,
      @ObjectModel.foreignKey.association: '_JointVentureRecovery'
      recid                                                as JointVentureRecoveryCode,
      @ObjectModel.foreignKey.association: '_JntVntrEquityTypeMaster'
      etype                                                as JointVentureEquityType,
      //TODO - Domain Fixed values

      jv_oco                                               as JointVentureOriginalCostObject,
      otype                                                as JointVentureObjectType,
      @ObjectModel.foreignKey.association: '_JntIntrstBillgClass'
      jv_jibcl                                             as JointVentureClass,
      @ObjectModel.foreignKey.association: '_JntIntrstBillgSubclass'
      jv_jibsa                                             as JointVentureSubClass,

      //  abkrs as ProcessingGroup,

      loekz                                                as IsDeleted,
      erdat                                                as CreationDate,
      erfzeit                                              as CreationTime,
      @ObjectModel.foreignKey.association: '_CreatedByUser'
      cast(ernam as fin_usnam preserving type )            as CreatedByUser,
      @ObjectModel.foreignKey.association: '_LastChangedByUser'
      aenam                                                as LastChangedByUser,
      aedat                                                as LastChangeDate,
      aezeit                                               as LastChangeTime,
      objnr                                                as ControllingObject,
      //--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_CompanyCode' //Inserted by VDM CDS Suite Plugin

      cast(bukrs as fis_bukrs preserving type )            as CompanyCode,
      //--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ProfitCenterStdVH',
                     element: 'ProfitCenter' },
          additionalBinding: [{ localElement: 'ControllingArea',
                                element: 'ControllingArea' }]
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_ProfitCenter' //Inserted by VDM CDS Suite Plugin

      cast(prctr as fis_prctr)                             as ProfitCenter,
      @ObjectModel.foreignKey.association: '_FunctionalArea' //Inserted by VDM CDS Suite Plugin

      cast(func_area as fm_farea)                          as FunctionalArea,
      @ObjectModel.foreignKey.association: '_ControllingObjectClass' //Inserted by VDM CDS Suite Plugin

      cast(scope as fis_scope_cv_conv)                     as ControllingObjectClass,
      //--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_InternalOrderTypeStdVH',
                     element: 'OrderType' }
        }]
      @ObjectModel.text.association: '_InternalOrderTypeText'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_InternalOrderType'
      auart                                                as OrderType,
      //--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CostCenterStdVH',
                     element: 'CostCenter' },
          additionalBinding: [{ localElement: 'ControllingArea',
                                element: 'ControllingArea' }]
        }]
      // ]--GENERATED

      cast( kostv as fin_io_aufkostv preserving type )     as ResponsibleCostCenter,
      @ObjectModel.foreignKey.association: '_ResponsibleUser'
      cast( veraa_user as fco_veraa_user preserving type ) as InternalOrderResponsibleUser,

      pdat1                                                as IntOrderPlannedReleaseDate,
      pdat2                                                as IntOrderPlannedCompletionDate,
      pdat3                                                as IntOrderPlannedClosingDate,
      idat1                                                as InternalOrderReleaseDate,
      idat2                                                as InternalOrderCompletionDate,
      idat3                                                as InternalOrderClosingDate,
      cckey                                                as CostCollector,

      _ControllingArea,
      _CompanyCode,
      _ProfitCenter,
      _FunctionalArea,
      _ControllingObjectClass,
      _InternalOrderType,
      _CostCenter,
      _User,
      _WBSElementBasicData,
      _RequestingCostCenter,
      _RequestingCompanyCode,
      _RequestingOrder,
      _Location,
      _LocationPlant,
      _ActualPostedCostCenter,
      _CostCenterData,
      _LogicalSystem,
      _ConditionUsage,
      _ConditionApplication,
      _CostingSheetProcedure,
      _IntOrderSettlementCostElement,
      _BasicSettlementGLAccount,
      _OrderProcessingGroup,
      _InvestmentProfile,
      _InvestmentReason,
      _EnvrnmtlInvestmentReason,
      _JointVentureMaster,
      _JointVentureRecovery,
      _JntVntrEquityTypeMaster,
      _JntVntrCostCtrType,
      _JntIntrstBillgClass,
      _JntIntrstBillgSubclass,
      _ResponsibleUser,
      _CreatedByUser,
      _LastChangedByUser,
      _CurRespCostCenterText,
      _CurRequestingCostCenterText,
      _CurCostCenterDataText,
      _SystemStatus,
      _ResultsAnalysisKey,
      _InvestmentObjectScale,
      _Currency,
      _OrderCategory,
      _BusinessArea,
      _Plant,
      _CurProfitCenterText,
      _CurActualPostedCostCenterText,
      _IntOrderActiveSystemStatus,
      _IntOrderActiveUserStatus,
      //--[ GENERATED:012:GFBfhxvv7jY4pHq{eVxSQ0

      @Consumption.hidden: true
      _ControllingAreaText,
      @Consumption.hidden: true
      _InternalOrderTypeText
      // ]--GENERATED

}
where
     autyp = '01'
  or autyp = '02'
  or autyp = '03';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUFK"
],
"ASSOCIATED":
[
"E_LOGISTICSORDER",
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONDITIONAPPLICATION",
"I_CONDITIONUSAGE",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECTCLASS",
"I_COSTCENTER",
"I_COSTCENTERTEXT",
"I_COSTELEMENTONCONTROLLINGAREA",
"I_COSTINGSHEETPROCEDURE",
"I_CURRENCY",
"I_ENVRNMTLINVESTMENTREASON",
"I_FUNCTIONALAREA",
"I_GLACCOUNTINCOMPANYCODE",
"I_INTERNALORDERSYSTEMSTATUS",
"I_INTERNALORDERTYPE",
"I_INTERNALORDERTYPETEXT",
"I_INTORDERACTIVESYSTEMSTATUS",
"I_INTORDERACTIVEUSERSTATUS",
"I_INVESTMENTOBJECTSCALE",
"I_INVESTMENTPROFILE",
"I_INVESTMENTREASON",
"I_JNTINTRSTBILLGCLASS",
"I_JNTINTRSTBILLGSUBCLASS",
"I_JNTVNTRCOSTCTRTYPE",
"I_JNTVNTREQUITYTYPEMASTER",
"I_JOINTVENTUREMASTER",
"I_JOINTVENTURERECOVERY",
"I_LOCATION",
"I_LOGICALSYSTEM",
"I_ORDER",
"I_ORDERCATEGORY",
"I_ORDERPROCESSINGGROUP",
"I_PLANT",
"I_PROFITCENTER",
"I_PROFITCENTERTEXT",
"I_RESULTSANALYSISKEY",
"I_USER",
"I_USERCONTACTCARD",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/