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_CnsldtnLogicBasedGrpJEItm.
-- 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_ConsolidationUnitHierarchy : fincs_hryid_consunit, P_ConsolidationPrftCtrHier : fincs_hryid_profitcenter, P_ConsolidationSegmentHier : fincs_hryid_segment, P_KeyDate : vdm_v_key_date
CREATE VIEW C_CnsldtnLogicBasedGrpJEItm AS
SELECT
FiscalYear,
CnsldtnGroupJrnlEntry,
CnsldtnGroupJrnlEntryItem,
cast(FiscalPeriod as fincs_poper preserving type) AS FiscalPeriod,
cast(PeriodMode as fincs_period_mode preserving type ) AS PeriodMode,
cast(ConsolidationGroup as fincs_consolidationgroup preserving type ) AS ConsolidationGroup,
_CnsldtnGroup_3._Text[1: Language =$session.system_language].ConsolidationGroupMediumText AS ConsolidationGroupMediumText,
cast(GLRecordType as fincs_glrcty preserving type ) AS GLRecordType,
cast(ConsolidationVersion as fincs_vers preserving type ) AS ConsolidationVersion,
_Version._Text[1: Language =$session.system_language].ConsolidationVersionText AS ConsolidationVersionText,
cast(ConsolidationVersionElement as fincs_vers_elem preserving type ) AS ConsolidationVersionElement,
_VersionElement._Text[1: Language =$session.system_language].ConsolidationVersionText AS CnsldtnVersionElementDesc,
cast(TransactionCurrency as fincs_rtcur preserving type ) AS TransactionCurrency,
cast(LocalCurrency as fincs_rhcur preserving type ) AS LocalCurrency,
cast(GroupCurrency as fincs_rkcur preserving type ) AS GroupCurrency,
cast(BaseUnit as fincs_runit preserving type ) AS BaseUnit,
cast( FiscalYearPeriod as fincs_fromfiscalyearperiod preserving type ) AS FiscalYearPeriod,
FiscalYearVariant,
cast(ConsolidationDocumentType as fincs_docty preserving type ) AS ConsolidationDocumentType,
_DocumentType_2._Text[1: Language =$session.system_language].ConsolidationDocumentTypeText AS ConsolidationDocumentTypeText,
cast(DebitCreditCode as fincs_drcrk preserving type ) AS DebitCreditCode,
cast(Company as fincs_company preserving type ) AS Company,
cast(ConsolidationUnit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
_CnsldtnUnit_4._Text[1: Language =$session.system_language].ConsolidationUnitMdmText AS ConsolidationUnitMdmText,
cast(ConsolidationUnitForElim as fincs_rbunit_elim preserving type ) AS ConsolidationUnitForElim,
cast(ConsolidationChartOfAccounts as fincs_itcoa preserving type ) AS ConsolidationChartOfAccounts,
_ChartOfAccounts._Text[1: Language =$session.system_language].ConsolidationChartOfAcctsText AS ConsolidationChartOfAcctsText,
cast(FinancialStatementItem as fincs_md_finstatementitem preserving type ) AS FinancialStatementItem,
_FinStmntItm_2._Text[1: Language =$session.system_language].CnsldtnFSItemMediumText AS FinancialStatementItemMdmText,
cast(PartnerConsolidationUnit as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
_PartnerUnit_4._Text[1: Language =$session.system_language].ConsolidationUnitMdmText AS PartnerCnsldtnUnitMediumText,
cast(CompanyCode as fincs_bukrs preserving type) AS CompanyCode,
cast(SubItemCategory as fincs_sityp preserving type) AS SubItemCategory,
cast(SubItem as fincs_subit preserving type) AS SubItem,
cast(PostingLevel as fincs_plevl preserving type) AS PostingLevel,
_PostingLevel._Text[1: Language =$session.system_language].PostingLevelText AS PostingLevelText,
cast(ConsolidationApportionment as fincs_rpflg preserving type) AS ConsolidationApportionment,
cast(CurrencyConversionsDiffType as fincs_rtflg preserving type) AS CurrencyConversionsDiffType,
cast(ConsolidationAcquisitionYear as fincs_yracq preserving type) AS ConsolidationAcquisitionYear,
cast(ConsolidationAcquisitionPeriod as fincs_pracq preserving type) AS ConsolidationAcquisitionPeriod,
cast(InvesteeConsolidationUnit as fincs_investeeconsunit preserving type) AS InvesteeConsolidationUnit,
cast(AmountInTransactionCurrency as fincs_tsl preserving type) AS AmountInTransactionCurrency,
cast(AmountInLocalCurrency as fincs_hsl preserving type) AS AmountInLocalCurrency,
cast(AmountInGroupCurrency as fincs_ksl preserving type) AS AmountInGroupCurrency,
CnsldtnQuantityInBaseUnit,
cast(DocumentItemText as fincs_sgtxt preserving type) AS DocumentItemText,
cast(ConsolidationPostgItemAutoFlag as fincs_autom preserving type) AS ConsolidationPostgItemAutoFlag,
cast(BusinessTransactionType as fincs_glvor preserving type) AS BusinessTransactionType,
PostingDate,
cast(CurrencyTranslationDate as fincs_wsdat preserving type) AS CurrencyTranslationDate,
cast(ReferenceFiscalYear as fincs_refryear preserving type) AS ReferenceFiscalYear,
cast(RefConsolidationPostingItem as fincs_refdocln preserving type) AS RefConsolidationPostingItem,
cast(RefConsolidationDocumentType as fincs_refdocct preserving type) AS RefConsolidationDocumentType,
cast(RefBusinessTransactionType as fincs_refactiv preserving type) AS RefBusinessTransactionType,
cast(CreationDateTime as fincs_timestamp preserving type) AS CreationDateTime,
cast(CreationDate as fincs_cpudt preserving type) AS CreationDate,
cast(CreationTime as fincs_cputm preserving type) AS CreationTime,
cast(UserID as fincs_usnam preserving type) AS UserID,
cast(ReverseDocument as fincs_rvsdocnr preserving type) AS ReverseDocument,
cast(ReversedDocument as fincs_orndocnr preserving type) AS ReversedDocument,
cast(InvestmentActivityType as fincs_coiac preserving type) AS InvestmentActivityType,
cast(InvestmentActivity as fincs_coinr preserving type) AS InvestmentActivity,
cast(ConsolidationDocReversalYear as fincs_revyear preserving type) AS ConsolidationDocReversalYear,
cast(ReferenceDocumentType as fincs_awtyp preserving type) AS ReferenceDocumentType,
cast(ReferenceDocumentContext as fincs_aworg preserving type) AS ReferenceDocumentContext,
LogicalSystem,
cast(ChartOfAccounts as fincs_ktopl preserving type) AS ChartOfAccounts,
cast(GLAccount as fincs_racct preserving type) AS GLAccount,
cast(AssignmentReference as fincs_zuonr preserving type) AS AssignmentReference,
cast(CostCenter as fincs_rcntr preserving type) AS CostCenter,
_CostCenter._Text[1: Language =$session.system_language].AdditionalMasterDataText AS CostCenterName,
cast(ProfitCenter as fincs_prctr preserving type) AS ProfitCenter,
_ProfitCenter._Text[1: Language =$session.system_language].AdditionalMasterDataText AS ProfitCenterName,
cast(ConsolidationPrftCtrForElim as fincs_prctr_elim preserving type) AS ConsolidationPrftCtrForElim,
cast(FunctionalArea as fincs_rfarea preserving type) AS FunctionalArea,
_FunctionalArea._Text[1: Language =$session.system_language].AdditionalMasterDataText AS FunctionalAreaName,
cast(BusinessArea as fincs_rbusa preserving type) AS BusinessArea,
_BusinessArea._Text[1: Language =$session.system_language].AdditionalMasterDataText AS BusinessAreaName,
cast(ControllingArea as fincs_kokrs preserving type) AS ControllingArea,
_ControllingArea._Text[1: Language =$session.system_language].AdditionalMasterDataText AS ControllingAreaName,
cast(Segment as fincs_segment preserving type) AS Segment,
_Segment._Text[1: Language =$session.system_language].AdditionalMasterDataText AS SegmentName,
cast(ConsolidationSegmentForElim as fincs_segment_elim preserving type) AS ConsolidationSegmentForElim,
cast(PartnerCostCenter as fincs_scntr preserving type) AS PartnerCostCenter,
_PartnerCostCenter._Text[1: Language =$session.system_language].AdditionalMasterDataText AS PartnerCostCenterName,
cast(PartnerProfitCenter as fincs_pprctr preserving type) AS PartnerProfitCenter,
_PartnerProfitCenter._Text[1: Language =$session.system_language].AdditionalMasterDataText AS PartnerProfitCenterName,
cast(PartnerFunctionalArea as fincs_sfarea preserving type) AS PartnerFunctionalArea,
_PartnerFunctionalArea._Text[1: Language =$session.system_language].AdditionalMasterDataText AS PartnerFunctionalAreaName,
cast(PartnerBusinessArea as fincs_sbusa preserving type) AS PartnerBusinessArea,
_PartnerBusinessArea._Text[1: Language =$session.system_language].AdditionalMasterDataText AS PartnerBusinessAreaName,
cast(PartnerCompany as fincs_rassc preserving type) AS PartnerCompany,
cast(PartnerSegment as fincs_psegment preserving type) AS PartnerSegment,
_PartnerSegment._Text[1: Language =$session.system_language].AdditionalMasterDataText AS PartnerSegmentName,
cast(OrderID as fincs_aufnr preserving type) AS OrderID,
cast(Customer as fincs_customer preserving type) AS Customer,
cast(Supplier as fincs_lifnr preserving type) AS Supplier,
cast(Plant as fincs_werks preserving type) AS Plant,
cast(FinancialTransactionType as fincs_rmvct preserving type) AS FinancialTransactionType,
cast(BillingDocumentType as fincs_fkart preserving type) AS BillingDocumentType,
cast(SalesOrganization as fincs_vkorg preserving type) AS SalesOrganization,
cast(DistributionChannel as fincs_vtweg preserving type) AS DistributionChannel,
cast(OrganizationDivision as fincs_spart preserving type) AS OrganizationDivision,
cast(MaterialGroup as fincs_maktl_mm preserving type) AS MaterialGroup,
cast(SoldProduct as fincs_matnr_copa preserving type) AS SoldProduct,
cast(SoldProductGroup as fincs_matkl preserving type) AS SoldProductGroup,
cast(CustomerGroup as fincs_kdgrp preserving type) AS CustomerGroup,
cast(CustomerSupplierCountry as fincs_land1 preserving type) AS CustomerSupplierCountry,
cast(CustomerSupplierIndustry as fincs_brsch preserving type) AS CustomerSupplierIndustry,
cast(SalesDistrict as fincs_bzirk preserving type) AS SalesDistrict,
cast(BillToParty as fincs_kunre preserving type) AS BillToParty,
cast(ShipToParty as fincs_kunwe preserving type) AS ShipToParty,
cast(CustomerSupplierCorporateGroup as fincs_konzs preserving type) AS CustomerSupplierCorporateGroup,
cast(CnsldtnAdhocItem as fincs_adhocitem preserving type) AS CnsldtnAdhocItem,
_AdhocItem._Text[1: Language = $session.system_language].CnsldtnAdhocItemText AS CnsldtnAdhocItemText,
cast(CnsldtnAdhocSet as fincs_adhocset preserving type) AS CnsldtnAdhocSet,
_AdhocSet._Text[1: Language = $session.system_language].CnsldtnAdhocSetText AS CnsldtnAdhocSetText,
cast(CnsldtnAdhocSetItem as fincs_adhocsetitem preserving type) AS CnsldtnAdhocSetItem,
MatchingReasonCode,
OriginType,
OriginReference,
CnsldtnJrnlEntryItemOrigin,
_PeriodModeText.PeriodModeText AS PeriodModeText
FROM I_CnsldtnGrpJrnlItemC
LEFT OUTER JOIN E_CnsldtnGroupJrnlEntryItem_3 AS _Extension ON FiscalYear = _Extension.FiscalYear AND CnsldtnGroupJrnlEntry = _Extension.CnsldtnGroupJrnlEntry AND CnsldtnGroupJrnlEntryItem = _Extension.CnsldtnGroupJrnlEntryItem -- association [1..1]
;