FINAC_SELECTION

@AbapCatalog : {
  compiler : {
    compareFilter: true
  },
  preserveKey: true,
  sqlViewName: 'FINACSELECTION'
}
@AccessControl : {
  authorizationCheck: #NOT_REQUIRED
}

@Metadata : {
  ignorePropagatedAnnotations: true
}
@ObjectModel : {
  usageType: {
    dataClass: #MIXED,
    serviceQuality: #D,
    sizeCategory: #XL
  }
}

define view FINAC_SELECTION
  as select from I_GLAccountLineItem as I_GLACCOUNTLINEITEM
  //hierarchy

  association [1..*] to FIN_SEL_HIER_LEAF_NODE        as _CostCtrHier                 on  $projection.ControllingArea = _CostCtrHier.HierarchyNodeClass
                                                                                      and $projection.CostCenter      = _CostCtrHier.UniversalHierarchyLeafValue
                                                                                      and _CostCtrHier.HierarchyType  = '0101'
  association [1..*] to FIN_SEL_HIER_LEAF_NODE        as _GLAccHier                   on  $projection.ChartOfAccounts = _GLAccHier.HierarchyNodeClass
                                                                                      and $projection.GLAccount       = _GLAccHier.UniversalHierarchyLeafValue
                                                                                      and _GLAccHier.HierarchyType    = 'FSVN'
  association [1..*] to FIN_SEL_HIER_LEAF_NODE        as _ProCtrHier                  on  $projection.ControllingArea = _ProCtrHier.HierarchyNodeClass
                                                                                      and $projection.ProfitCenter    = _ProCtrHier.UniversalHierarchyLeafValue
                                                                                      and _ProCtrHier.HierarchyType   = '0106'
  //basic

  association [1..1] to I_AccountAssignmentType       as _AccAssignType               on  $projection.AccountAssignmentType = _AccAssignType.AccountAssignmentType
  association [1..1] to I_AccountingDocumentCategory  as _AccDocCategory              on  $projection.AccountingDocumentCategory = _AccDocCategory.AccountingDocumentCategory
  association [1..1] to I_AccountingDocumentType      as _AccDocType                  on  $projection.AccountingDocumentType = _AccDocType.AccountingDocumentType
  association [1..1] to I_MovementCategory            as _MoveCategory                on  $projection.AssetAcctTransClassfctn = _MoveCategory.AssetAcctTransClassfctn
  association [1..1] to I_AssetClass                  as _AssetClass                  on  $projection.AssetClass = _AssetClass.AssetClass
  association [1..1] to FAA_DERP_AREA                 as _DerpArea                    on  $projection.AssetDepreciationArea = _DerpArea.depr_area
                                                                                      and $projection.CompanyCode           = _DerpArea.comp_code
  association [1..1] to I_AssetTransactionType        as _AssetTransType              on  $projection.AssetTransactionType = _AssetTransType.AssetTransactionType
  association [1..1] to I_BillingDocumentType         as _BillDocType                 on  $projection.BillingDocumentType = _BillDocType.BillingDocumentType
  association [1..1] to I_Customer                    as _Customer                    on  $projection.Customer = _Customer.Customer
  association [1..1] to I_BusinessArea                as _BusinessArea                on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [1..1] to I_BusinessProcess             as _BusinessProcess             on  $projection.BusinessProcess = _BusinessProcess.BusinessProcess
                                                                                      and $projection.ControllingArea = _BusinessProcess.ControllingArea
  association [1..*] to I_CostCenter                  as _CostCenter                  on  $projection.CostCenter      = _CostCenter.CostCenter
                                                                                      and $projection.ControllingArea = _CostCenter.ControllingArea
  association [1..1] to I_ControllingArea             as _ControllingArea             on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [1..1] to I_ChartOfAccounts             as _ChartOfAccounts             on  $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
  association [1..*] to I_ProfitCenter                as _ProfitCenter                on  $projection.ProfitCenter    = _ProfitCenter.ProfitCenter
                                                                                      and $projection.ControllingArea = _ProfitCenter.ControllingArea
  association [1..1] to I_GLAccountInChartOfAccounts  as _GLAccountInChartOfAccounts  on  $projection.GLAccount       = _GLAccountInChartOfAccounts.GLAccount
                                                                                      and $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
  association [1..*] to I_CostCenterActivityType      as _CostCenterActType           on  $projection.CostCtrActivityType = _CostCenterActType.CostCtrActivityType
                                                                                      and $projection.ControllingArea     = _CostCenterActType.ControllingArea
  association [1..1] to I_CustomerGroup               as _CustomerGroup               on  $projection.CustomerGroup = _CustomerGroup.CustomerGroup
  association [1..1] to I_Country                     as _CustomerSupplierCountry     on  $projection.CustomerSupplierCountry = _CustomerSupplierCountry.Country
  association [1..1] to I_Customer                    as _BillToParty                 on  $projection.BillToParty = _BillToParty.Customer
  association [1..1] to I_CustomerSupplierIndustry    as _CustomerSupplierIndustry    on  $projection.CustomerSupplierIndustry = _CustomerSupplierIndustry.Industry
  association [1..1] to I_DebitCreditCode             as _DebitCreditCode             on  $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode
  association [1..1] to I_DistributionChannel         as _DistributionChannel         on  $projection.DistributionChannel = _DistributionChannel.DistributionChannel
  association [1..1] to I_FinancialAccountType        as _FinancialAccountType        on  $projection.FinancialAccountType = _FinancialAccountType.FinancialAccountType
  association [1..1] to I_FixedAsset                  as _FixedAsset                  on  $projection.FixedAsset       = _FixedAsset.FixedAsset
                                                                                      and $projection.CompanyCode      = _FixedAsset.CompanyCode
                                                                                      and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
  association [1..1] to I_FunctionalArea              as _FunctionalArea              on  $projection.FunctionalArea = _FunctionalArea.FunctionalArea
  association [1..1] to I_GLAccountType               as _GLAccountType               on  $projection.GLAccountType = _GLAccountType.GLAccountType
  association [1..1] to I_Housebank                   as _HouseBank                   on  $projection.HouseBank   = _HouseBank.HouseBank
                                                                                      and $projection.CompanyCode = _HouseBank.CompanyCode
  association [1..1] to I_HouseBankAccount            as _HouseBankAccount            on  $projection.HouseBank        = _HouseBankAccount.HouseBank
                                                                                      and $projection.CompanyCode      = _HouseBankAccount.CompanyCode
                                                                                      and $projection.HouseBankAccount = _HouseBankAccount.HouseBankAccount
  association [1..1] to I_LogicalSystem               as _LogicalSystem               on  $projection.LogicalSystem = _LogicalSystem.LogicalSystem
  association [1..1] to I_MasterFixedAsset            as _MasterFixedAsset            on  $projection.CompanyCode      = _MasterFixedAsset.CompanyCode
                                                                                      and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
  association [1..1] to I_OperatingConcern            as _OperatingConcern            on  $projection.OperatingConcern = _OperatingConcern.OperatingConcern
  association [1..1] to I_OrderCategory               as _OrderCategory               on  $projection.OrderCategory = _OrderCategory.OrderCategory
  association [1..1] to I_Order                       as _Order                       on  $projection.OrderID = _Order.OrderID
  association [1..1] to I_Division                    as _OrgDivision                 on  $projection.OrganizationDivision = _OrgDivision.Division
  association [1..1] to I_BusinessArea                as _PartnerBusinessArea         on  $projection.BusinessArea = _PartnerBusinessArea.BusinessArea
  association [1..*] to I_CostCenter                  as _PartnerCostCenter           on  $projection.PartnerCostCenter = _PartnerCostCenter.CostCenter
                                                                                      and $projection.ControllingArea   = _PartnerCostCenter.ControllingArea
  association [1..1] to I_FunctionalArea              as _PartnerFunctionalArea       on  $projection.PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea
  association [1..*] to I_ProfitCenter                as _PartnerProfitCenter         on  $projection.PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter
                                                                                      and $projection.ControllingArea     = _PartnerProfitCenter.ControllingArea
  association [1..1] to I_Segment                     as _PartnerSegment              on  $projection.PartnerSegment = _PartnerSegment.Segment
  association [1..1] to I_Segment                     as _Segment                     on  $projection.Segment = _Segment.Segment
  association [1..1] to I_Plant                       as _Plant                       on  $projection.Plant = _Plant.Plant
  association [1..1] to I_PostingKey                  as _PostingKey                  on  $projection.PostingKey = _PostingKey.PostingKey
  association [1..1] to I_Product                     as _Product                     on  $projection.Product = _Product.Product
  association [1..1] to I_Product                     as _SoldProduct                 on  $projection.SoldProduct = _SoldProduct.Product
  association [1..1] to I_ProductGroup_2              as _SoldProductGroup            on  $projection.SoldProductGroup = _SoldProductGroup.ProductGroup
  association [1..1] to I_SpecialGLCode               as _SpecialGLCode               on  $projection.SpecialGLCode        = _SpecialGLCode.SpecialGLCode
                                                                                      and $projection.FinancialAccountType = _SpecialGLCode.FinancialAccountType
  association [1..1] to I_Supplier                    as _Supplier                    on  $projection.Supplier = _Supplier.Supplier
  association [1..*] to I_TaxCode                     as _TaxCode                     on  $projection.TaxCode = _TaxCode.TaxCode
  association [1..1] to I_WBSElementByExternalID      as _WBSElementByExternalID      on  $projection.wbselementexternalid = _WBSElementByExternalID.WBSElementExternalID
  association [1..1] to I_SalesOrganization           as _SalesOrganization           on  $projection.SalesOrganization = _SalesOrganization.SalesOrganization
  association [1..1] to I_SalesDistrict               as _SalesDistrict               on  $projection.SalesDistrict = _SalesDistrict.SalesDistrict
  association [1..1] to I_ProjectNetwork              as _ProjectNetwork              on  $projection.ProjectNetwork = _ProjectNetwork.ProjectNetwork
  association [1..1] to I_Customer                    as _ShipToParty                 on  $projection.ShipToParty = _ShipToParty.Customer
  association [1..1] to I_FinancialTransactionType    as _FinancialTransactionType    on  $projection.FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType
  association [1..1] to I_ControllingBusTransacType   as _ControllingBusTransacType   on  $projection.ControllingBusTransacType = _ControllingBusTransacType.BusinessTransactionType
  association [1..1] to I_BusinessTransactionCategory as _BusinessTransactionCategory on  $projection.BusinessTransactionCategory = _BusinessTransactionCategory.BusinessTransactionCategory
  association [1..1] to I_BusinessTransactionType     as _BusinessTransactionType     on  $projection.BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType
  association [1..1] to I_Partnercompany              as _PartnerCompany              on  $projection.PartnerCompany = _PartnerCompany.PartnerCompany
  association [1..1] to I_CnsldtnUnit_3               as _PartnerConsolidationUnit    on  $projection.PartnerConsolidationUnit = _PartnerConsolidationUnit.ConsolidationUnit

{
  ControllingArea,
  CompanyCode,
  @ObjectModel.hierarchy.association: '_CostCtrHier'
  CostCenter,
  LogicalSystem,
  Plant,
  @ObjectModel.hierarchy.association: '_ProCtrHier'
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  @ObjectModel.hierarchy.association: '_GLAccHier'
  GLAccount,
  GLAccountType,
  ChartOfAccounts,
  FinancialAccountType,
  SpecialGLCode,
  PostingKey,
  DebitCreditCode,
  AccountingDocumentType,
  AccountingDocumentCategory,
  GLBusinessTransactionType,
  TransactionTypeDetermination,
  BusinessTransactionCategory,
  BusinessTransactionType,
  @EndUserText.label: 'Controlling Business Transaction Type'
  ControllingBusTransacType,
  Supplier,
  Customer,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  AssetClass,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  @EndUserText.label: 'Asset Movement Category'
  AssetAcctTransClassfctn,
  AssetDepreciationArea,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OperatingConcern,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  Product,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  BaseUnit,
  AssignmentReference,
  FinancialTransactionType,
  
  ConsolidationUnit,
  PartnerConsolidationUnit,
  Company,
  ConsolidationChartOfAccounts,
  @EndUserText.label: 'Consolidation FS Item'
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  CnsldtnSubitem,

  //hierarchy

  _ProCtrHier,
  _CostCtrHier,
  _GLAccHier,

  //basic

  _AccAssignType,
  _AccDocCategory,
  _AccDocType,
  _MoveCategory,
  _AssetClass,
  _DerpArea,
  _AssetTransType,
  _BillDocType,
  _Customer,
  _BusinessArea,
  _BusinessProcess,
  _CostCenter,
  _ControllingArea,
  _ChartOfAccounts,
  _ProfitCenter,
  _GLAccountInChartOfAccounts,
  _CostCenterActType,
  _CustomerGroup,
  _BillToParty,
  _CustomerSupplierCountry,
  _CustomerSupplierIndustry,
  _DebitCreditCode,
  _DistributionChannel,
  _FinancialAccountType,
  _FixedAsset,
  _FunctionalArea,
  _GLAccountType,
  _HouseBank,
  _HouseBankAccount,
  _LogicalSystem,
  _MasterFixedAsset,
  _OperatingConcern,
  _OrderCategory,
  _Order,
  _OrgDivision,
  _PartnerBusinessArea,
  _PartnerFunctionalArea,
  _PartnerProfitCenter,
  _PartnerCostCenter,
  _PartnerSegment,
  _Segment,
  _Plant,
  _PostingKey,
  _Product,
  _SoldProduct,
  _SoldProductGroup,
  _SpecialGLCode,
  _Supplier,
  _TaxCode,
  _WBSElementByExternalID,
  _SalesOrganization,
  _SalesDistrict,
  _ProjectNetwork,
  _ShipToParty,
  _FinancialTransactionType,
  _ControllingBusTransacType,
  _BusinessTransactionCategory,
  _BusinessTransactionType,
  _PartnerCompany, 
  _ConsolidationUnit,
  _PartnerConsolidationUnit,
  _Company,
  _ConsolidationChartOfAccounts,
  _CnsldtnFinancialStatementItem,
  _CnsldtnSubitemCategory,
  _CnsldtnSubitem
}

where
      CompanyCode =  ''
  and CompanyCode <> ''