P_CNSLDTNINTEGRPTDFINDATA_01

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 P_CNSLDTNINTEGRPTDFINDATA_01.
-- 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.
-- SQL view name: PINTFINDATA_01
-- Parameters: P_CreationDateTimeRgFr : timestamp, P_CreationDateTimeRgTo : timestamp

CREATE VIEW P_CNSLDTNINTEGRPTDFINDATA_01 AS
SELECT
  _UnitByTimeVersion.ConsolidationDimension AS ConsolidationDimension,
  _UnitByTimeVersion.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  cast( _UnitByTime.ConsolidationUnitLocalCurrency as lcurr preserving type ) AS LocalCurrency,
  _Version.ConsolidationVersion AS ConsolidationVersion,
  _Version.FSItemMappingVersion AS FSItemMappingVersion,
  _Version.ConsolidationLedger AS ConsolidationLedger,
  _Version.GroupCurrency AS GroupCurrency,
  _Version.CnsldtnVersionGroupCrcySource AS CnsldtnVersionGroupCrcySource,
  _CnsldtnFSItem.ConsolidationBreakdownCategory AS BreakdownCategory,
  _Source.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  _Source.FinancialTransactionType AS FinancialTransactionType,
  _Source.FunctionalArea AS FunctionalArea,
  _Source.BusinessArea AS BusinessArea,
  _Source.CostCenter AS CostCenter,
  _Source.GLAccount AS GLAccount,
  _Source.ProfitCenter AS ProfitCenter,
  _Source.AmountInBalanceTransacCrcy AS AmountInTransactionCurrency,
  _Source.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _Source.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _Source.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _Source.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _Source.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _Source.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _Source.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _Source.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _Source.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _Source.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  _Source.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  _Source.Segment AS Segment,
  _Source.CompanyCode AS CompanyCode,
  _Source.ChartOfAccounts AS ChartOfAccounts,
  _Source.AssignmentReference AS AssignmentReference,
  _Source.ControllingArea AS ControllingArea,
  _Source.PartnerCostCenter AS PartnerCostCenter,
  _Source.PartnerProfitCenter AS PartnerProfitCenter,
  _Source.PartnerFunctionalArea AS PartnerFunctionalArea,
  _Source.PartnerBusinessArea AS PartnerBusinessArea,
  _Source.PartnerCompany AS PartnerCompany,
  _Source.PartnerSegment AS PartnerSegment,
  _Source.OrderID AS OrderID,
  _Source.Customer AS Customer,
  _Source.Supplier AS Supplier,
  _Source.Material AS Material,
  _Source.MaterialGroup AS MaterialGroup,
  _Source.ProductGroup AS ProductGroup,
  _Source.Plant AS Plant,
  _Source.WBSElement AS WBSElementExternalID,
  _Source.Project AS Project,
  _Source.BillingDocumentType AS BillingDocumentType,
  _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.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
  _Source.WBSElementInternalID AS WBSElementInternalID,
  _Source.CreationDateTime AS CreationDateTime,
  _Source.ConsolidationUnit AS ConsolidationUnit,
  _Source.PartnerConsolidationUnit AS PartnerConsolidationUnit,
  _Source.Company AS Company,
  _Source.CnsldtnFinancialStatementItem AS FinancialStatementItem,
  _Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  _Source.CnsldtnSubitemCategory AS SubItemCategory,
  _Source.CnsldtnSubitem AS SubItem,
  _Source.AssetClass AS AssetClass,
  _Source.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  _Source.AccountingDocumentType AS AccountingDocumentType,
  _Source.BusinessTransactionType AS BusinessTransactionType,
  _Source.FinancialClosingStep AS FinancialClosingStep,
  _Source.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  _Source.CostAnalysisResource AS CostAnalysisResource,
  _Source.FinancialServicesProductGroup AS FinancialServicesProductGroup,
  _Source.FinancialServicesBranch AS FinancialServicesBranch,
  _Source.FinancialDataSource AS FinancialDataSource,
  _Source.FinancialManagementArea AS FinancialManagementArea,
  _Source.GrantID AS GrantID,
  _Source.Fund AS Fund,
  _Source.PartnerFund AS PartnerFund,
  _Source.CashLedgerAccount AS CashLedgerAccount,
  _CashLedgerCompanyCode.ChartOfAccounts AS CnsldtnCashLedgerChartOfAccts,
  _Source.Ledger AS Ledger,
  _Source.SourceLedger AS SourceLedger,
  _Source.LedgerGLLineItem AS LedgerGLLineItem,
  _Source.AccountingDocument AS AccountingDocument,
  _Source.FiscalPeriod AS FiscalPeriod,
  _Source.LedgerFiscalYear AS FiscalYear,
  _Source.FiscalYearPeriod AS FiscalYearPeriod,
  _Source.FiscalYear AS ReferenceFiscalYear
FROM I_GLAccountLineItem AS _Source
INNER JOIN I_CnsldtnUnitByTimeVersion AS _UnitByTimeVersion ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnVersion AS _Version ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnFSItem_2 AS _CnsldtnFSItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnUnitByTime AS _UnitByTime ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CashLedgerCompanyCode ON _CashLedgerCompanyCode.CompanyCode = _Source.CashLedgerCompanyCode  -- association [0..1]
;