I_CnsldtnJrnlEntryTP

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_CnsldtnJrnlEntryTP.
-- 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_CnsldtnJrnlEntryTP AS
SELECT
  acdocu.FiscalYear AS FiscalYear,
  acdocu.ConsolidationDocumentNumber AS ConsolidationDocumentNumber,
  acdocu.ConsolidationLedger AS ConsolidationLedger,
  acdocu.ConsolidationDimension AS ConsolidationDimension,
  acdocu.ConsolidationLedger AS ConsolidationLedgerForEdit,
  acdocu.FiscalYear AS FiscalYearForEdit,
  acdocu.ConsolidationVersion AS ConsolidationVersion,
  acdocu.ConsolidationUnit AS ConsolidationUnit,
  acdocu.FiscalPeriod AS FiscalPeriod,
  acdocu.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  acdocu.PostingLevel AS PostingLevel,
  acdocu.ConsolidationGroup AS ConsolidationGroup,
  acdocu.ConsolidationDocumentType AS ConsolidationDocumentType,
  acdocu.DocumentItemText AS DocumentItemText,
  acdocu.PostingDate AS PostingDate,
  acdocu.CreationDate AS CreationDate,
  acdocu.CreationTime AS CreationTime,
  acdocu.UserID AS UserID,
  acdocu.ConsolidationUnit1 AS ConsolidationUnit1,
  acdocu.ConsolidationUnit2 AS ConsolidationUnit2,
  acdocu.InvesteeConsolidationUnit AS InvesteeConsolidationUnit,
  acdocu.InvestmentActivityType AS InvestmentActivityType,
  acdocu.InvestmentActivity AS InvestmentActivity,
  acdocu.RefConsolidationDocumentNumber AS RefConsolidationDocumentNumber,
  acdocu.ReversedDocument AS ReversedDocument,
  acdocu.ReverseDocument AS ReverseDocument,
  acdocu.ConsolidationDocReversalYear AS ConsolidationDocReversalYear,
  acdocu.IsReversalDocument AS IsReversalDocument,
  cast('' as fc_testrun ) AS IsConsolidationTaskTestRun,
  cast('' as fincs_isworkflow ) AS IsInWorkFlow,
  cast('' as fc_cactt ) AS ConsolidationTaskCategory,
  cast('' as fc_cacti ) AS ConsolidationTask,
  cast('' as fincs_journalentry_source ) AS ConsolidationJrnlEntrSource,
  cast('00000000000000000000000000000000' as fincs_uuid ) AS ConsolidationJrnlEntrDraftUUID,
  acdocu.CnsldtnDocumentNumberForEdit AS CnsldtnDocumentNumberForEdit,
  cast ( _DocTypeFields[1: KeyFieldName1='RTCUR'].StatusIsHidden as fincs_ishidden ) AS AmountInTransCurrencyIsHidden,
  cast ( '' as fincs_ishidden ) AS AmountInLocalCurrencyIsHidden,
  cast ( '' as fincs_ishidden ) AS AmountInGroupCurrencyIsHidden,
  cast ( _DocTypeFields[1: KeyFieldName1='RUNIT'].StatusIsHidden as fincs_ishidden ) AS QuantityInBaseUnitIsHidden,
  cast ( 'X' as fincs_ishidden ) AS CnsldtnUnit1IsUsedIsHidden,
  cast ( _DocTypeFields[1: KeyFieldName1='RBUPTR'].StatusIsHidden as fincs_ishidden ) AS PartnerCnsldtnUnitIsHidden,
  cast ( '' as fincs_ishidden ) AS ConsolidationUnitIsHidden,
  cast ( 'X' as fincs_ishidden ) AS ConsolidationUnit3IsHidden,
  cast ( 'X' as fincs_ishidden ) AS PartnerCnsldtnUnit3IsHidden,
  cast ( _DocTypeFields[1: KeyFieldName1='SUBIT'].StatusIsHidden as fincs_ishidden ) AS SubItemIsHidden,
  cast ( _DocTypeFields[1: KeyFieldName1='SITYP'].StatusIsHidden as fincs_ishidden ) AS SubItemCategoryIsHidden,
  acdocu.CnsldtnGroupJrnlEntryBundle AS CnsldtnGroupJrnlEntryBundle
FROM I_CnsldtnJrnlEntryHeader AS acdocu
INNER JOIN I_CnsldtnGlobalParameter AS _GlobalParameter ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CnsldtnJrnlEntryItemTP AS _Item ON _Item.FiscalYear = FiscalYear AND _Item.ConsolidationDocumentNumber = ConsolidationDocumentNumber AND _Item.ConsolidationLedger = ConsolidationLedger  -- association [0..*]
LEFT OUTER JOIN I_CnsldtnLedger AS _Ledger ON ConsolidationLedgerForEdit = _Ledger.ConsolidationLedger  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnVersion AS _Version ON ConsolidationVersion = _Version.ConsolidationVersion  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnGroup AS _CnsldtnGroup ON ConsolidationGroup = _CnsldtnGroup.ConsolidationGroup AND _CnsldtnGroup.ConsolidationDimension = ConsolidationDimension  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _ChartOfAccounts ON ConsolidationChartOfAccounts = _ChartOfAccounts.ConsolidationChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnDocumentType_2 AS _DocumentType ON ConsolidationDocumentType = _DocumentType.ConsolidationDocumentType  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnJrnlEntrSource AS _JrnlEntrSource ON ConsolidationJrnlEntrSource = _JrnlEntrSource.ConsolidationJrnlEntrSource  -- association [0..1]
LEFT OUTER JOIN I_CnsldtnDocumentTypeField AS _DocTypeFields ON _DocTypeFields.ConsolidationDocumentType = ConsolidationDocumentType AND _DocTypeFields.ConsolidationDimension = ConsolidationDimension  -- association [0..*]
;