I_GVoAGrpJEItm

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_GVoAGrpJEItm.
-- 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 I_GVoAGrpJEItm AS
SELECT
  _Source.SourceLedger AS SourceLedger,
  _Source.CompanyCode AS CompanyCode,
  _Source.ReferenceFiscalYear AS ReferenceFiscalYear,
  _Source.AccountingDocument AS AccountingDocument,
  _Source.LedgerGLLineItem AS LedgerGLLineItem,
  _Source.Ledger AS Ledger,
  _Source.ConsolidationRecordNumber AS ConsolidationRecordNumber,
  cast( '' as fincs_group_jrnl_entry ) AS CnsldtnGroupJrnlEntry,
  cast( '' as fincs_group_jrnl_entry_item ) AS CnsldtnGroupJrnlEntryItem,
  _Source.ConsolidationLedger AS ConsolidationLedger,
  cast( 'M' as docct preserving type ) AS DocumentCategory,
  cast( '' as fc_ryacq ) AS ConsolidationAcquisitionYear,
  cast( '' as rpacq ) AS ConsolidationAcquisitionPeriod,
  cast( '' as fc_coicu ) AS InvesteeConsolidationUnit,
  cast( '' as autom preserving type ) AS ConsolidationPostgItemAutoFlag,
  cast( '' as fincs_coiac ) AS InvestmentActivityType,
  cast( '' as fincs_coinr ) AS InvestmentActivity,
  cast( '' as fc_rtflg ) AS CurrencyConversionsDiffType,
  cast( '' as docct preserving type ) AS RefConsolidationDocumentType,
  cast( 'Y1' as fc_dimen preserving type ) AS ConsolidationDimension,
  cast( '' as fc_docty ) AS ConsolidationDocumentType,
  cast( '' as fc_congr ) AS ConsolidationGroup,
  cast( 'PER' as fincs_period_mode ) AS PeriodMode,
  _Source.ConsolidationVersion AS ConsolidationVersion,
  cast( 'C' as fincs_rrcty preserving type ) AS GLRecordType,
  cast( '' as fc_plevl ) AS PostingLevel,
  _Source.CreationDateTime AS CreationDateTime,
  _PullRequest.CnsldtnPullRequestDateTime AS CnsldtnPullRequestDateTime,
  _Source.FiscalPeriod AS FiscalPeriod,
  _Source.FiscalYear AS FiscalYear,
  _Source.FiscalYearPeriod AS FiscalYearPeriod,
  cast( _Source.GroupCurrency as gcurr preserving type ) AS GroupCurrency,
  _Source.LocalCurrency AS LocalCurrency,
  _Source.AmountInLocalCurrency AS AmountInLocalCurrency,
  _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.Segment AS Segment,
  _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.ProductGroup AS MaterialGroup,
  _Source.Plant AS Plant,
  cast( _Source.WBSElementExternalID as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
  cast( _Source.Project as fis_project_no_conv preserving type ) 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.ConsolidationUnit AS ConsolidationUnit,
  cast( _Source.PartnerConsolidationUnit as fc_buptr preserving type ) AS PartnerConsolidationUnit,
  _Source.Company AS Company,
  _Source.FinancialStatementItem AS FinancialStatementItem,
  _Source.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  cast( _Source.SubItemCategory as fc_sityp preserving type ) AS SubItemCategory,
  cast( _Source.SubItem as fc_sitem preserving type ) 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,
  cast ( '' as fincs_adhocitem ) AS CnsldtnAdhocItem,
  cast ( '' as fincs_adhocset ) AS CnsldtnAdhocSet,
  cast ( '' as lcurr ) AS Currency,
  cast ( '' as fincs_finsrvcsproductgroup ) AS FinancialServicesProductGroup,
  cast ( '' as fincs_financialservicesbranch ) AS FinancialServicesBranch,
  cast ( '' as fincs_financialdatasource ) AS FinancialDataSource,
  cast ( '' as fincs_ghgcategory ) AS GHGCategory,
  cast ( '' as fincs_ghgscope preserving type ) AS GHGScope,
  cast ( '' as fincs_ghgscp2calculationmethod ) AS GHGScope2CalculationMethod,
  cast ( '' as fincs_ghgscp2cntrctlinstrument ) AS GHGScope2ContractualInstrument,
  cast ( '' as fincs_sustmodeoftransport ) AS SustainabilityModeOfTransport,
  cast ( '' as fincs_financialmanagementarea ) AS FinancialManagementArea,
  cast ( '' as fincs_fund ) AS Fund,
  cast ( '' as fincs_grant ) AS GrantID,
  cast ( '' as fincs_cashledgerchartofaccts ) AS CnsldtnCashLedgerChartOfAccts,
  cast ( '' as fincs_cashledgeraccount ) AS CashLedgerAccount
FROM P_GVoAGrpJEItm AS _Source
;