I_FinSGLCnsldtnADBMap01

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 I_FinSGLCnsldtnADBMap01.
-- 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.
-- Parameters: P_ConsolidationDimension : fc_dimen, P_ConsolidationUnit : fc_bunit, P_ConsolidationVersion : fc_rvers, P_FiscalYearPeriod : fincs_fiscalyearper

CREATE VIEW I_FinSGLCnsldtnADBMap01 AS
SELECT
  Source.FinSGLRunUUID AS FinSGLRunUUID,
  Source.FinSGLItemID AS FinSGLItemID,
  Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  Source.ConsolidationDimension AS ConsolidationDimension,
  Source.Ledger AS Ledger,
  Source.CompanyCode AS CompanyCode,
  Source.ConsolidationUnit AS ConsolidationUnit,
  Source.FinancialStatementItem AS FinancialStatementItem,
  Source.SubItem AS SubItem,
  Source.SubItemCategory AS SubItemCategory,
  Source.CnsldtnSubitemSource AS CnsldtnSubitemSource,
  Source.GLAccount AS GLAccount,
  Source.ChartOfAccounts AS ChartOfAccounts,
  Source.ConsolidationLedger AS ConsolidationLedger,
  Source.FiscalPeriod AS FiscalPeriod,
  Source.FiscalYear AS FiscalYear,
  Source.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  Source.GroupCurrency AS GroupCurrency,
  Source.LocalCurrency AS LocalCurrency,
  Source.TransactionCurrency AS TransactionCurrency,
  MTDAvgDailyBalInBalTransCrcy,
  QTDAvgDailyBalInBalTransCrcy,
  YTDAvgDailyBalInBalTransCrcy,
  Source.MTDAvgDailyBalInCCCrcy AS MTDAvgDailyBalInCCCrcy,
  Source.QTDAvgDailyBalInCCCrcy AS QTDAvgDailyBalInCCCrcy,
  Source.YTDAvgDailyBalInCCCrcy AS YTDAvgDailyBalInCCCrcy,
  Source.MTDAvgDailyBalInGlobCrcy AS MTDAvgDailyBalInGlobCrcy,
  Source.QTDAvgDailyBalInGlobCrcy AS QTDAvgDailyBalInGlobCrcy,
  Source.YTDAvgDailyBalInGlobCrcy AS YTDAvgDailyBalInGlobCrcy,
  Source.BusinessArea AS BusinessArea,
  Source.PartnerCostCenter AS PartnerCostCenter,
  Source.PartnerBusinessArea AS PartnerBusinessArea,
  Source.PartnerCompany AS PartnerCompany,
  Source.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  Source.ProfitCenter AS ProfitCenter,
  Source.Segment AS Segment,
  Source.CostCenter AS CostCenter,
  Source.FunctionalArea AS FunctionalArea,
  Source.FinancialTransactionType AS FinancialTransactionType,
  Source.OrderID AS OrderID,
  Source.BillingDocumentType AS BillingDocumentType,
  Source.ControllingArea AS ControllingArea,
  Source.Customer AS Customer,
  Source.Supplier AS Supplier,
  Source.MaterialGroup AS MaterialGroup,
  Source.Material AS Material,
  Source.PartnerProfitCenter AS PartnerProfitCenter,
  Source.WBSElementExternalID AS WBSElementExternalID,
  Source.Project AS Project,
  Source.PartnerSegment AS PartnerSegment,
  Source.PartnerFunctionalArea AS PartnerFunctionalArea,
  Source.Plant AS Plant,
  Source.AssignmentReference AS AssignmentReference,
  Source.SalesOrganization AS SalesOrganization,
  Source.DistributionChannel AS DistributionChannel,
  Source.OrganizationDivision AS OrganizationDivision,
  Source.SoldProduct AS SoldProduct,
  Source.SoldProductGroup AS SoldProductGroup,
  Source.CustomerGroup AS CustomerGroup,
  Source.CustomerSupplierCountry AS CustomerSupplierCountry,
  Source.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  Source.SalesDistrict AS SalesDistrict,
  Source.BillToParty AS BillToParty,
  Source.ShipToParty AS ShipToParty,
  Source.WBSElementInternalID AS WBSElementInternalID
FROM P_GLE_ADB_GR_FT_06
LEFT OUTER JOIN E_FinSGLCnsldtnADB AS _Extension ON Source.FinSGLRunUUID = _Extension.FinSGLRunUUID AND Source.FinSGLItemID = _Extension.FinSGLItemID AND Source.Ledger = _Extension.Ledger AND Source.CompanyCode = _Extension.CompanyCode  -- association [1..1]
;