FINCS_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 FINCS_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 FINCS_SELECTION AS
SELECT
  ConsolidationLedger,
  ConsolidationDimension,
  cast( FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  CnsldtnGroupJrnlEntry,
  CnsldtnGroupJrnlEntryItem,
  BaseUnit,
  TransactionCurrency,
  BusinessArea,
  ChartOfAccounts,
  Company,
  cast( CompanyCode as fincs_bukrs preserving type ) AS CompanyCode,
  cast( ConsolidationAcquisitionPeriod as fincs_rpacq preserving type ) AS ConsolidationAcquisitionPeriod,
  cast( ConsolidationAcquisitionYear as fincs_ryacq preserving type ) AS ConsolidationAcquisitionYear,
  ConsolidationChartOfAccounts,
  ConsolidationDocumentType,
  ConsolidationGroup,
  ConsolidationPostgItemAutoFlag,
  ConsolidationUnit,
  ControllingArea,
  cast( FinancialStatementItem as fincs_fsi_item preserving type ) AS FinancialStatementItem,
  CostCenter,
  cast (CurrencyConversionsDiffType as fincs_rtflg preserving type ) AS CurrencyConversionsDiffType,
  Customer,
  CustomerGroup,
  CustomerSupplierCorporateGroup,
  cast( CustomerSupplierCountry as fc_cntry preserving type ) AS CustomerSupplierCountry,
  CustomerSupplierIndustry,
  DistributionChannel,
  FinancialTransactionType,
  FunctionalArea,
  cast( GLAccount as fincs_saknr preserving type ) AS GLAccount,
  GLRecordType,
  InvesteeConsolidationUnit,
  InvestmentActivity,
  InvestmentActivityType,
  MaterialGroup,
  cast ( OrderID as fincs_internal_order preserving type ) AS InternalOrder,
  OrganizationDivision,
  cast( PartnerBusinessArea as fincs_pargb preserving type ) AS PartnerBusinessArea,
  cast( PartnerCompany as fincs_rassc preserving type ) AS PartnerCompany,
  PartnerConsolidationUnit,
  cast( PartnerCostCenter as fincs_skost preserving type ) AS PartnerCostCenter,
  cast( PartnerFunctionalArea as fincs_sfkber preserving type ) AS PartnerFunctionalArea,
  cast( PartnerProfitCenter as fincs_pprctr preserving type ) AS PartnerProfitCenter,
  PartnerSegment,
  Plant,
  PostingLevel,
  ProfitCenter,
  cast( Project as fincs_ps_pspid preserving type ) AS Project,
  SalesDistrict,
  SalesOrganization,
  Segment,
  SoldProductGroup,
  SubItem,
  SubItemCategory,
  Supplier,
  WBSElementExternalID,
  SoldProduct,
  Material,
  BillingDocumentType,
  BillToParty,
  ShipToParty,
  CnsldtnAdhocSet,
  CnsldtnAdhocItem,
  FinancialServicesProductGroup,
  FinancialServicesBranch,
  FinancialDataSource,
  FinancialManagementArea,
  Fund,
  PartnerFund,
  GrantID,
  CnsldtnCashLedgerChartOfAccts,
  CashLedgerAccount,
  GHGScope,
  GHGCategory,
  GHGScope2CalculationMethod,
  GHGScope2ContractualInstrument,
  SustainabilityModeOfTransport,
  GHGDataQualityCharacteristic,
  GHGEnergyClassification,
  GHGEnergyMix,
  GHGEnergySourcingType
FROM I_CnsldtnGroupJrnlEntryItem
LEFT OUTER JOIN FINCS_SEL_CONGR AS _CnsldtnGroup ON ConsolidationGroup = _CnsldtnGroup.ConsolidationGroup  -- association [1..1]
LEFT OUTER JOIN FINCS_SEL_DOCTY AS _DocumentType ON ConsolidationDocumentType = _DocumentType.ConsolidationDocumentType  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnGLRecordType AS _GLRecordType ON GLRecordType = _GLRecordType.GLRecordType  -- association [1..1]
LEFT OUTER JOIN FINCS_SEL_BUNIT AS _CnsldtnUnit ON ConsolidationUnit = _CnsldtnUnit.ConsolidationUnit  -- association [1..1]
LEFT OUTER JOIN FINCS_SEL_BUNIT AS _PartnerUnit ON PartnerConsolidationUnit = _PartnerUnit.ConsolidationUnit  -- association [1..1]
LEFT OUTER JOIN FINCS_SEL_BUNIT AS _InvesteeUnit ON InvesteeConsolidationUnit = _InvesteeUnit.ConsolidationUnit  -- association [1..1]
LEFT OUTER JOIN FINCS_SEL_FSITEM AS _FinStmntItm ON ConsolidationChartOfAccounts = _FinStmntItm.ConsolidationChartOfAccounts AND FinancialStatementItem = _FinStmntItm.FinancialStatementItem  -- association [1..1]
;