I_OrderBasic

@AbapCatalog.sqlViewName: 'IORDERBASIC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_CreatedByUser', '_LastChangedByUser', '_LongText']
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.representativeKey: 'OrderID'
@ObjectModel.semanticKey: ['OrderID']
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Order Header Basic'
// Basic view selecting from order header table AUFK only - without restriction on any category

// Due to the high number of consumers, this CDS view is protected against incompatible changes


/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_OrderBasic
  as select from aufk as aufk

  association [1..1] to I_OrderCategory          as _OrderCategory          on  $projection.OrderCategory = _OrderCategory.OrderCategory
  association [1..1] to I_OrderType              as _OrderType              on  $projection.OrderType = _OrderType.OrderType
  association [0..1] to I_OrderLongText          as _LongText               on  $projection.OrderID = _LongText.OrderID
  association [1..1] to I_Order                  as _ReferenceOrder         on  $projection.ReferenceOrder= _ReferenceOrder.OrderID
  association [1..1] to I_LogisticsOrderBasic    as _LogisticsOrder         on  $projection.OrderID = _LogisticsOrder.OrderID
  association [0..*] to I_OrderHierarchyNode     as _OrderHierarchyNode     on  $projection.OrderID = _OrderHierarchyNode.OrderID
  association [1..1] to I_User                   as _CreatedByUser          on  $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                   as _LastChangedByUser      on  $projection.LastChangedByUser = _LastChangedByUser.UserID
  association [0..1] to I_Currency               as _Currency               on  $projection.Currency = _Currency.Currency
  association [0..1] to I_Language               as _LongTextLanguage       on  $projection.LongTextLanguage = _LongTextLanguage.Language
  association [1..1] to I_Plant                  as _Plant                  on  $projection.Plant = _Plant.Plant
  association [1..1] to I_StatusObject           as _StatusObject           on  $projection.ObjectInternalID = _StatusObject.StatusObject
  association [0..1] to I_CompanyCode            as _CompanyCode            on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_CompanyCode            as _RequestingCompanyCode  on  $projection.RequestingCompanyCode = _RequestingCompanyCode.CompanyCode
  association [0..1] to I_BusinessArea           as _BusinessArea           on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..*] to I_ProfitCenter           as _ProfitCenter           on  $projection.ControllingArea = _ProfitCenter.ControllingArea
                                                                            and $projection.ProfitCenter    = _ProfitCenter.ProfitCenter
  association [0..*] to I_CostCenter             as _CostCenter             on  $projection.ControllingArea = _CostCenter.ControllingArea
                                                                            and $projection.CostCenter      = _CostCenter.CostCenter
  association [0..*] to I_CostCenter             as _ResponsibleCostCenter  on  $projection.ControllingArea       = _ResponsibleCostCenter.ControllingArea
                                                                            and $projection.ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter
  association [0..*] to I_CostCenter             as _RequestingCostCenter   on  $projection.RequestingCostCenter = _RequestingCostCenter.CostCenter
                                                                            and $projection.ControllingArea      = _RequestingCostCenter.ControllingArea
  association [0..1] to I_ProductCostCtrlgOrder  as _ProductCostCtrlgOrder  on  $projection.ProductCostCollector = _ProductCostCtrlgOrder.OrderID
  association [0..1] to I_GLAccount              as _GLAccount              on  $projection.GLAccount   = _GLAccount.GLAccount
                                                                            and $projection.CompanyCode = _GLAccount.CompanyCode
  association [0..1] to I_CostElement            as _CostElement            on  $projection.ControllingArea = _CostElement.ControllingArea
                                                                            and $projection.CostElement     = _CostElement.CostElement
  association [0..1] to I_ControllingArea        as _ControllingArea        on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..1] to I_ControllingObjectClass as _ControllingObjectClass on  $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass
  association [0..1] to I_FunctionalArea         as _FunctionalArea         on  $projection.FunctionalArea = _FunctionalArea.FunctionalArea
  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..1] to I_OrderProcessingGroup   as _OrderProcessingGroup   on  $projection.ControllingArea = _OrderProcessingGroup.ControllingArea
                                                                            and $projection.OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup
{
      // Key

      @ObjectModel.text.element: ['OrderDescription']
  key aufk.aufnr                                        as OrderID,

      // Category and Type

      @ObjectModel.foreignKey.association: '_OrderCategory'
      cast(aufk.autyp as pph_autyp preserving type)     as OrderCategory,
      @ObjectModel.foreignKey.association: '_OrderType'
      cast(aufk.auart as aufart    preserving type)     as OrderType,

      // Text

      @Semantics.text: true
      cast(aufk.ktext as pph_auftext preserving type)   as OrderDescription,
      cast(case
             when aufk.ltext is not initial then 'X'
             else ''
           end as aufltext preserving type)             as OrderHasLongText,
      @ObjectModel.foreignKey.association: '_LongTextLanguage'
      cast(aufk.ltext as pph_longtextlang)              as LongTextLanguage,

      // Attributes

      aufk.loekz                                        as IsMarkedForDeletion,
      aufk.astkz                                        as IsStatisticalOrder,
      cast(aufk.plint as fco_plint preserving type )    as OrdIsUsedInIntegratedPlanning,

      // Admin

      @Semantics.systemDate.createdAt: true
      cast(aufk.erdat   as ordercreationdate preserving type) as CreationDate,
      @Semantics.systemTime.createdAt: true
      cast(aufk.erfzeit as ordercreationtime preserving type) as CreationTime,
      @Semantics.user.createdBy: true
      aufk.ernam                                        as CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      aufk.aedat                                        as LastChangeDate,
      @Semantics.systemTime.lastChangedAt: true
      aufk.aezeit                                       as LastChangeTime,
      @Semantics.user.lastChangedBy: true
      aufk.aenam                                        as LastChangedByUser,

      // Assignments

      @Semantics.currencyCode: true
      aufk.waers                                        as Currency,
      @ObjectModel.foreignKey.association: '_ReferenceOrder'
      cast(aufk.refnr as fis_aufrefnr preserving type)  as ReferenceOrder,
      @ObjectModel.foreignKey.association: '_Plant'
      aufk.werks                                        as Plant,
--    @ObjectModel.foreignKey.association: '_StatusObject'
      cast(aufk.objnr as pph_objnr preserving type)     as ObjectInternalID,
      @ObjectModel.foreignKey.association: '_BusinessArea'
      aufk.gsber                                        as BusinessArea,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      aufk.bukrs                                        as CompanyCode,
      @ObjectModel.foreignKey.association: '_RequestingCompanyCode'
      aufk.abukr                                        as RequestingCompanyCode,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      aufk.kokrs                                        as ControllingArea,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProfitCenterStdVH', element: 'ProfitCenter' } } ]
      aufk.prctr                                        as ProfitCenter,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CostCenterStdVH', element: 'CostCenter' } } ]
      aufk.kostl                                        as CostCenter,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CostCenterStdVH', element: 'CostCenter' } } ]
      aufk.akstl                                        as RequestingCostCenter,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_CostCenterStdVH', element: 'CostCenter' } } ]
      cast(aufk.kostv as pph_kostl preserving type)     as ResponsibleCostCenter,
      @ObjectModel.foreignKey.association: '_CostElement'
      cast(aufk.kstar as pph_kstar preserving type)     as CostElement,
      @ObjectModel.foreignKey.association: '_GLAccount'
      aufk.saknr                                        as GLAccount,
      @ObjectModel.foreignKey.association: '_ProductCostCtrlgOrder'
      aufk.pkosa                                        as ProductCostCollector,
      @ObjectModel.foreignKey.association: '_ConditionUsage'
      aufk.kvewe                                        as ConditionUsage,
      @ObjectModel.foreignKey.association: '_ConditionApplication'
      aufk.kappl                                        as ConditionApplication,
      @ObjectModel.foreignKey.association: '_CostingSheetProcedure'
      aufk.kalsm                                        as CostingSheet,
      @ObjectModel.foreignKey.association: '_ControllingObjectClass'
      cast(aufk.scope as pph_scope preserving type)     as ControllingObjectClass,
      @ObjectModel.foreignKey.association: '_FunctionalArea'
      aufk.func_area                                    as FunctionalArea,
      @ObjectModel.foreignKey.association: '_OrderProcessingGroup'
      cast(aufk.abkrs as fco_aufabkrs preserving type)  as OrderProcessingGroup,
      cast(aufk.zschl as fco_aufzschl preserving type)  as OverheadCode,
      cast(aufk.cycle as fins_st_kostl preserving type) as ActualPostedCostCenter,
      cast(aufk.txjcd as fis_txjcd preserving type)     as TaxJurisdiction,
      cast(aufk.abgsl as fco_abgr_schl preserving type) as ResultAnalysisInternalID,
      aufk.eb_post                                      as EventBasedPostingMethod,

      // Dates

      aufk.pdat2                                        as PlannedCompletionDate,
      aufk.idat2                                        as TechnicalCompletionDate,
      aufk.pdat1                                        as PlannedReleaseDate,
      aufk.idat1                                        as OrderActualReleaseDate,
      aufk.idat3                                        as OrderActualCloseDate,
      
      aufk.phas0                                        as OrderIsCreated,
      aufk.phas1                                        as OrderIsReleased,
      aufk.phas2                                        as OrderIsCompleted,
      aufk.phas3                                        as OrderIsClosed,
      // Associations

      _OrderCategory,
      _OrderType,
      _ReferenceOrder,
      _LogisticsOrder,
      _OrderHierarchyNode,
      _CreatedByUser,
      _LastChangedByUser,
      _LongText,
      _LongTextLanguage,
      _Currency,
      _Plant,
      _StatusObject,
      _CompanyCode,
      _RequestingCompanyCode,
      _BusinessArea,
      _ProfitCenter,
      _CostCenter,
      _RequestingCostCenter,
      _ResponsibleCostCenter,
      _ProductCostCtrlgOrder,
      _CostElement,
      _GLAccount,
      _ControllingArea,
      _ControllingObjectClass,
      _FunctionalArea,
      _ConditionUsage,
      _ConditionApplication,
      _CostingSheetProcedure,
      _OrderProcessingGroup
};