FINAC_SELECTION

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FINAC_SELECTION.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW FINAC_SELECTION AS
SELECT
  ControllingArea,
  CompanyCode,
  CostCenter,
  LogicalSystem,
  Plant,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  GLAccount,
  GLAccountType,
  ChartOfAccounts,
  FinancialAccountType,
  SpecialGLCode,
  PostingKey,
  DebitCreditCode,
  AccountingDocumentType,
  AccountingDocumentCategory,
  GLBusinessTransactionType,
  TransactionTypeDetermination,
  BusinessTransactionCategory,
  BusinessTransactionType,
  ControllingBusTransacType,
  Supplier,
  Customer,
  TaxCode,
  HouseBank,
  HouseBankAccount,
  AssetClass,
  MasterFixedAsset,
  FixedAsset,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  AssetDepreciationArea,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OperatingConcern,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS 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,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  CnsldtnSubitem
FROM I_GLAccountLineItem AS I_GLACCOUNTLINEITEM
LEFT OUTER JOIN FIN_SEL_HIER_LEAF_NODE AS _CostCtrHier ON ControllingArea = _CostCtrHier.HierarchyNodeClass AND CostCenter = _CostCtrHier.UniversalHierarchyLeafValue AND _CostCtrHier.HierarchyType = '0101'  -- association [1..*]
LEFT OUTER JOIN FIN_SEL_HIER_LEAF_NODE AS _GLAccHier ON ChartOfAccounts = _GLAccHier.HierarchyNodeClass AND GLAccount = _GLAccHier.UniversalHierarchyLeafValue AND _GLAccHier.HierarchyType = 'FSVN'  -- association [1..*]
LEFT OUTER JOIN FIN_SEL_HIER_LEAF_NODE AS _ProCtrHier ON ControllingArea = _ProCtrHier.HierarchyNodeClass AND ProfitCenter = _ProCtrHier.UniversalHierarchyLeafValue AND _ProCtrHier.HierarchyType = '0106'  -- association [1..*]
LEFT OUTER JOIN I_AccountAssignmentType AS _AccAssignType ON AccountAssignmentType = _AccAssignType.AccountAssignmentType  -- association [1..1]
LEFT OUTER JOIN I_AccountingDocumentCategory AS _AccDocCategory ON AccountingDocumentCategory = _AccDocCategory.AccountingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccDocType ON AccountingDocumentType = _AccDocType.AccountingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_MovementCategory AS _MoveCategory ON AssetAcctTransClassfctn = _MoveCategory.AssetAcctTransClassfctn  -- association [1..1]
LEFT OUTER JOIN I_AssetClass AS _AssetClass ON AssetClass = _AssetClass.AssetClass  -- association [1..1]
LEFT OUTER JOIN FAA_DERP_AREA AS _DerpArea ON AssetDepreciationArea = _DerpArea.depr_area AND CompanyCode = _DerpArea.comp_code  -- association [1..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransType ON AssetTransactionType = _AssetTransType.AssetTransactionType  -- association [1..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillDocType ON BillingDocumentType = _BillDocType.BillingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [1..1]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON BusinessProcess = _BusinessProcess.BusinessProcess AND ControllingArea = _BusinessProcess.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea  -- association [1..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [1..*]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON GLAccount = _GLAccountInChartOfAccounts.GLAccount AND ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCenterActType ON CostCtrActivityType = _CostCenterActType.CostCtrActivityType AND ControllingArea = _CostCenterActType.ControllingArea  -- association [1..*]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [1..1]
LEFT OUTER JOIN I_Country AS _CustomerSupplierCountry ON CustomerSupplierCountry = _CustomerSupplierCountry.Country  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [1..1]
LEFT OUTER JOIN I_CustomerSupplierIndustry AS _CustomerSupplierIndustry ON CustomerSupplierIndustry = _CustomerSupplierIndustry.Industry  -- association [1..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [1..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [1..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON FixedAsset = _FixedAsset.FixedAsset AND CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset  -- association [1..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [1..1]
LEFT OUTER JOIN I_GLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- association [1..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON HouseBank = _HouseBankAccount.HouseBank AND CompanyCode = _HouseBankAccount.CompanyCode AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON LogicalSystem = _LogicalSystem.LogicalSystem  -- association [1..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [1..1]
LEFT OUTER JOIN I_OperatingConcern AS _OperatingConcern ON OperatingConcern = _OperatingConcern.OperatingConcern  -- association [1..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [1..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [1..1]
LEFT OUTER JOIN I_Division AS _OrgDivision ON OrganizationDivision = _OrgDivision.Division  -- association [1..1]
LEFT OUTER JOIN I_BusinessArea AS _PartnerBusinessArea ON BusinessArea = _PartnerBusinessArea.BusinessArea  -- association [1..1]
LEFT OUTER JOIN I_CostCenter AS _PartnerCostCenter ON PartnerCostCenter = _PartnerCostCenter.CostCenter AND ControllingArea = _PartnerCostCenter.ControllingArea  -- association [1..*]
LEFT OUTER JOIN I_FunctionalArea AS _PartnerFunctionalArea ON PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea  -- association [1..1]
LEFT OUTER JOIN I_ProfitCenter AS _PartnerProfitCenter ON PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter AND ControllingArea = _PartnerProfitCenter.ControllingArea  -- association [1..*]
LEFT OUTER JOIN I_Segment AS _PartnerSegment ON PartnerSegment = _PartnerSegment.Segment  -- association [1..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_PostingKey AS _PostingKey ON PostingKey = _PostingKey.PostingKey  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Product AS _SoldProduct ON SoldProduct = _SoldProduct.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _SoldProductGroup ON SoldProductGroup = _SoldProductGroup.ProductGroup  -- association [1..1]
LEFT OUTER JOIN I_SpecialGLCode AS _SpecialGLCode ON SpecialGLCode = _SpecialGLCode.SpecialGLCode AND FinancialAccountType = _SpecialGLCode.FinancialAccountType  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_TaxCode AS _TaxCode ON TaxCode = _TaxCode.TaxCode  -- association [1..*]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementByExternalID ON wbselementexternalid = _WBSElementByExternalID.WBSElementExternalID  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [1..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [1..1]
LEFT OUTER JOIN I_FinancialTransactionType AS _FinancialTransactionType ON FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType  -- association [1..1]
LEFT OUTER JOIN I_ControllingBusTransacType AS _ControllingBusTransacType ON ControllingBusTransacType = _ControllingBusTransacType.BusinessTransactionType  -- association [1..1]
LEFT OUTER JOIN I_BusinessTransactionCategory AS _BusinessTransactionCategory ON BusinessTransactionCategory = _BusinessTransactionCategory.BusinessTransactionCategory  -- association [1..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [1..1]
LEFT OUTER JOIN I_Partnercompany AS _PartnerCompany ON PartnerCompany = _PartnerCompany.PartnerCompany  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnUnit_3 AS _PartnerConsolidationUnit ON PartnerConsolidationUnit = _PartnerConsolidationUnit.ConsolidationUnit  -- association [1..1]
;