I_INTERNALORDER

CDS View

Internal Order

I_INTERNALORDER is a CDS View in S/4HANA. Internal Order. It contains 21 fields. 26 CDS views read from this table.

CDS Views using this table (26)

ViewTypeJoinVDMDescription
A_InternalOrder view from BASIC API Internal Order
C_InternalOrderQ0001 view from CONSUMPTION Internal Order
C_IntOrderOverallUserStatus view_entity inner CONSUMPTION Internal order overall user status
C_ReExAssignInternalOrder view from CONSUMPTION Internal Order
C_WhereUsdIntOrdVH view from CONSUMPTION WUIO Internal Orders
I_CnsldtnMasterData view union_all COMPOSITE Consolidation - Combined Master Data
I_InternalOrderSettlementRule view_entity inner COMPOSITE Internal Order Settlement Rule
I_InternalOrderStdVH view from COMPOSITE Internal Order
I_InternalOrderVH view from COMPOSITE Internal Order Value Help
I_IntOrderActiveSystemStatus view_entity inner COMPOSITE Internal Order Active System Status
I_IntOrderActiveUserStatus view_entity inner COMPOSITE Internal Order Active User Status
I_REControllingObject view union_all COMPOSITE Real Estate Accounting Object
P_EventBasedOverheadOrderVH view union COMPOSITE Order details
P_InternalOrderSystemStatus view_entity inner COMPOSITE Internal order system status
P_ProjectActualCostLineItem view inner COMPOSITE Project Cost Line Items with Actual Costs
P_ProjectObject_2 view union_all COMPOSITE Project Object
P_ProjectPlanCostLineItem view inner COMPOSITE Project Planned Cost Line Item
P_RunOverheadOrder view union COMPOSITE List of Orders for Actual Overhead Calculation Run
P_RunSettlementActualOrder view union COMPOSITE Run Settlement Actual List of Orders
P_SettlementSender view union_all CONSUMPTION Possible senders for settled object
P_WhereUsdIntOrdAlloc view_entity from COMPOSITE WUIO Allocations - Relation to the Order
P_WhereUsdIntOrdAlloc view_entity union_all COMPOSITE WUIO Allocations - Relation to the Order
R_InternalOrderTP view_entity from TRANSACTIONAL Internal Order
R_IntOrderNumberedUserStatusTP view_entity inner TRANSACTIONAL Internal order user status with number
R_IntOrdOverallSystemStatusTP view_entity inner TRANSACTIONAL Overall system status
R_IntOrdUnnumberedUserStatusTP view_entity inner TRANSACTIONAL Int. order user status without number

Fields (21)

KeyField CDS FieldsUsed in Views
KEY InternalOrder InternalOrder,ProjectObjectExternalID 10
_CompanyCode _CompanyCode 1
_InternalOrderTypeText _InternalOrderTypeText 1
_IntOrderActiveSystemStatus _IntOrderActiveSystemStatus 1
_IntOrderActiveUserStatus _IntOrderActiveUserStatus 1
_LastChangedByUser _IntOrderLastChangedByUser 1
_SystemStatus _SystemStatus 1
BusinessArea BusinessArea 1
CompanyCode CompanyCode 4
ControllingArea ControllingArea 6
ControllingObject ControllingObject,InternalOrderControllingObject,ProjectObjectNode 5
Currency Currency 1
FunctionalArea FunctionalArea 1
InternalOrderDescription InternalOrderDescription,ProjectObjectDescription 4
InternalOrderResponsibleUser InternalOrderResponsibleUser 1
IsStatisticalOrder IsStatisticalOrder 1
OrderCategory OrderCategory 1
OrderType OrderType 6
Plant Plant 1
ProfitCenter ProfitCenter,ProjectObjectProfitCenter 4
ResponsibleCostCenter ResponsibleCostCenter 3
@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'
@ObjectModel.sapObjectNodeType.name: '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';