C_CnsldtnGrpJrnlEntrItmWrkflw

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 C_CnsldtnGrpJrnlEntrItmWrkflw.
-- 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: CCONSJRNLITMWF

CREATE VIEW C_CnsldtnGrpJrnlEntrItmWrkflw AS
SELECT
  MyObjectUUID,
  ItemUUID,
  DraftUUID,
  ParentDraftUUID,
  FiscalYear,
  ConsolidationDocumentNumber,
  ConsolidationLedger,
  ConsolidationPostingItem,
  ConsolidationDimension,
  GLRecordType,
  ConsolidationVersion,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalPeriod,
  Company,
  ConsolidationUnit,
  _ConsolidationUnitText.ConsolidationUnitText AS ConsolidationUnitMdmText,
  ConsolidationChartOfAccounts,
  _CnsldtnCoAText.ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
  FinancialStatementItem,
  _FSItemText.FinancialStatementItemMdmText AS FinancialStatementItemMdmText,
  PartnerConsolidationUnit,
  _PartnerConsolidationUnitText.ConsolidationUnitText AS PartnerCnsldtnUnitMediumText,
  ConsolidationUnit1IsUsed,
  ConsolidationGroup,
  CompanyCode,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationDocumentType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  _InvesteeConsolidationUnitText.ConsolidationUnitText AS InvesteeConsolidationUnitText,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  RefConsolidationDocumentNumber,
  ReferenceFiscalYear,
  RefConsolidationPostingItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  _InvestmentActivityTypeText.InvestmentActivityType AS InvestmentActivityTypeText,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  Plant,
  FinancialTransactionType,
  WBSElementInternalID,
  WBSElementExternalID,
  Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  MaterialGroup,
  ProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  ConsolidationUnit3,
  _ConsolidationUnit3Text.ConsolidationUnitText AS CnsldtnUnit3Text,
  PartnerConsolidationUnit3,
  _PartnerConsolidationUnit3Text.ConsolidationUnitText AS PartnerCnsldtnUnit3Text,
  FiscalYearPeriod,
  HasActiveEntity,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  IsActiveEntity,
  _FSItemAttribute.CnsldtnFSItemRole AS CnsldtnFSItemRole,
  _FSItemAttribute.CnsldtnFSItemDataCollection AS CnsldtnFSItemDataCollection,
  _FSItemAttribute.CnsldtnFSItemCrcyTranslation AS CnsldtnFSItemCrcyTranslation,
  _FSItemAttribute.CnsldtnFSItemElimination AS CnsldtnFSItemElimination,
  _FSItemAttribute.CnsldtnFSItemCashFlow AS CnsldtnFSItemCashFlow,
  _FSItemAttribute.CnsldtnFSItemScope AS CnsldtnFSItemScope,
  _FSItemAttribute.CnsldtnFSItemCustomerSpecific AS CnsldtnFSItemCustomerSpecific,
  _FSItemAttribute.CnsldtnEliminationTargetFSItem AS CnsldtnEliminationTargetFSItem,
  _FSItemAttribute.CnsldtnNCITargetFSItem AS CnsldtnNCITargetFSItem,
  _FSItemAttribute.CnsldtnPlanningTargetFSItem AS CnsldtnPlanningTargetFSItem
FROM I_CnsldtnGrpJrnlEntrItmWrkflw
LEFT OUTER JOIN C_CnsldtnGrpJrnlEntrWrkflw AS _Header ON _Header.MyObjectUUID = ItemUUID  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccountsT AS _CnsldtnCoAText ON _CnsldtnCoAText.ConsolidationChartOfAccounts = ConsolidationChartOfAccounts AND _CnsldtnCoAText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItemText AS _FSItemText ON _FSItemText.FinancialStatementItem = FinancialStatementItem AND _FSItemText.ConsolidationChartOfAccounts = ConsolidationChartOfAccounts AND _FSItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _ConsolidationUnitText ON ConsolidationUnit = _ConsolidationUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _PartnerConsolidationUnitText ON PartnerConsolidationUnit = _PartnerConsolidationUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _InvesteeConsolidationUnitText ON InvesteeConsolidationUnit = _InvesteeConsolidationUnitText.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnInvmtEquityActyVH AS _InvestmentActivityTypeText ON InvestmentActivityType = _InvestmentActivityTypeText.InvestmentActivityType  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _ConsolidationUnit3Text ON ConsolidationUnit = _ConsolidationUnit3Text.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN C_CnsldtnUnitValueHelp_2 AS _PartnerConsolidationUnit3Text ON PartnerConsolidationUnit = _PartnerConsolidationUnit3Text.ConsolidationUnit  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnFSItemByTimeVersion AS _FSItemAttribute ON FinancialStatementItem = _FSItemAttribute.CnsldtnFinancialStatementItem AND ConsolidationChartOfAccounts = _FSItemAttribute.ConsolidationChartOfAccounts AND ConsolidationVersion = _FSItemAttribute.ConsolidationVersion AND FiscalYearPeriod >= _FSItemAttribute.FromFiscalYearPeriod AND FiscalYearPeriod <= _FSItemAttribute.ToFiscalYearPeriod  -- association [0..1]
;