FINCS_CNSLDTNBALVALDTNUNITLVL

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_CNSLDTNBALVALDTNUNITLVL.
-- 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_CNSLDTNBALVALDTNUNITLVL AS
SELECT
  Item.ConsolidationLedger AS ConsolidationLedger,
  Item.ConsolidationDimension AS ConsolidationDimension,
  Item.FiscalYear AS FiscalYear,
  Item.CnsldtnGroupJrnlEntry AS ConsolidationDocumentNumber,
  Item.CnsldtnGroupJrnlEntryItem AS ConsolidationPostingItem,
  Relation.ConsolidationVersion AS ConsolidationVersion,
  Item.LocalCurrency AS Currency,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.LocalCurrency AS LocalCurrency,
  Item.GroupCurrency AS GroupCurrency,
  Item.DocumentCategory AS DocumentCategory,
  Item.Company AS Company,
  Item.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  Item.CnsldtnFinancialStatementItem AS FinancialStatementItem,
  Item.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  Item.SubItemCategory AS SubItemCategory,
  Item.SubItem AS SubItem,
  Item.FiscalPeriod AS PostingFiscalPeriod,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.AmountInLocalCurrency AS AmountInLocalCurrency,
  Item.AmountInGroupCurrency AS AmountInGroupCurrency,
  Item.CnsldtnCstmSignAmtInTransCrcy AS CnsldtnCstmSignAmtInTransCrcy,
  Item.CnsldtnCstmSignAmtInLoclCrcy AS CnsldtnCstmSignAmtInLoclCrcy,
  Item.CnsldtnCstmSignAmtInGrpCrcy AS CnsldtnCstmSignAmtInGrpCrcy,
  Item.ConsolidationUnit AS ConsolidationUnit,
  Item.ConsolidationGroup AS ConsolidationGroup,
  Item.PostingLevel AS PostingLevel,
  Item.ConsolidationDocumentType AS ConsolidationDocumentType,
  Item.ConsolidationAcquisitionYear AS ConsolidationAcquisitionYear,
  Item.ConsolidationAcquisitionPeriod AS ConsolidationAcquisitionPeriod,
  Item.InvesteeConsolidationUnit AS InvesteeConsolidationUnit,
  Item.ConsolidationPostgItemAutoFlag AS ConsolidationPostgItemAutoFlag,
  Item.RefConsolidationDocumentType AS RefConsolidationDocumentType,
  Item.InvestmentActivityType AS InvestmentActivityType,
  Item.InvestmentActivity AS InvestmentActivity,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.GLAccount AS GLAccount,
  Item.BaseUnit AS BaseUnit,
  Item.CnsldtnQuantityInBaseUnit AS CnsldtnQuantityInBaseUnit,
  Item.CnsldtnCstmSignLongQtyInBsUnit AS CnsldtnCstmSignLongQtyInBsUnit,
  Item.CostCenter AS CostCenter,
  Item.ProfitCenter AS ProfitCenter,
  Item.FunctionalArea AS FunctionalArea,
  Item.BusinessArea AS BusinessArea,
  Item.ControllingArea AS ControllingArea,
  Item.Segment AS Segment,
  Item.PartnerCostCenter AS PartnerCostCenter,
  Item.PartnerProfitCenter AS PartnerProfitCenter,
  Item.PartnerFunctionalArea AS PartnerFunctionalArea,
  Item.PartnerBusinessArea AS PartnerBusinessArea,
  Item.PartnerCompany AS PartnerCompany,
  Item.PartnerSegment AS PartnerSegment,
  Item.MaterialGroup AS MaterialGroup,
  Item.Plant AS Plant,
  Item.FinancialTransactionType AS FinancialTransactionType,
  Item.WBSElementExternalID AS WBSElementExternalID,
  Item.Project AS Project,
  Item.BillingDocumentType AS BillingDocumentType,
  Item.SalesOrganization AS SalesOrganization,
  Item.DistributionChannel AS DistributionChannel,
  Item.OrganizationDivision AS OrganizationDivision,
  Item.SoldProductGroup AS SoldProductGroup,
  Item.CustomerGroup AS CustomerGroup,
  Item.CustomerSupplierCountry AS CustomerSupplierCountry,
  Item.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  Item.SalesDistrict AS SalesDistrict,
  Item.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  Item.CreationDateTime AS CreationDateTime,
  Item.CompanyCode AS CompanyCode,
  Item.ShipToParty AS ShipToParty,
  Item.BillToParty AS BillToParty,
  Item.Material AS Material,
  Item.SoldProduct AS SoldProduct,
  Item.CurrencyConversionsDiffType AS CurrencyConversionsDiffType,
  Item.OrderID AS InternalOrder,
  Item.Customer AS Customer,
  Item.Supplier AS Supplier,
  Item.GLRecordType AS GLRecordType,
  Item.CnsldtnAdhocItem AS CnsldtnAdhocItem,
  Item.CnsldtnAdhocSet AS CnsldtnAdhocSet,
  Item.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  Item.FinancialServicesBranch AS FinancialServicesBranch,
  Item.FinancialDataSource AS FinancialDataSource,
  Item.FinancialManagementArea AS FinancialManagementArea,
  Item.Fund AS Fund,
  Item.GrantID AS GrantID,
  Item.CnsldtnCashLedgerChartOfAccts AS CnsldtnCashLedgerChartOfAccts,
  Item.CashLedgerAccount AS CashLedgerAccount,
  Item.GHGScope AS GHGScope,
  Item.GHGCategory AS GHGCategory,
  Item.GHGScope2CalculationMethod AS GHGScope2CalculationMethod,
  Item.GHGScope2ContractualInstrument AS GHGScope2ContractualInstrument,
  Item.SustainabilityModeOfTransport AS SustainabilityModeOfTransport,
  Item.GHGDataQualityCharacteristic AS GHGDataQualityCharacteristic,
  Item.GHGEnergyClassification AS GHGEnergyClassification,
  Item.GHGEnergyMix AS GHGEnergyMix,
  Item.GHGEnergySourcingType AS GHGEnergySourcingType
FROM I_CnsldtnVersionRelation AS Relation
LEFT OUTER JOIN E_CnsldtnGroupJrnlEntryItem AS _Extension ON ConsolidationLedger = _Extension.ConsolidationLedger AND ConsolidationDimension = _Extension.ConsolidationDimension AND FiscalYear = _Extension.FiscalYear AND ConsolidationDocumentNumber = _Extension.CnsldtnGroupJrnlEntry AND ConsolidationPostingItem = _Extension.CnsldtnGroupJrnlEntryItem  -- association [1..1]
;