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 A_CnsldtnGrpJrnlItem.
-- 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 A_CnsldtnGrpJrnlItem AS
SELECT
FiscalYear,
CnsldtnGroupJrnlEntry,
CnsldtnGroupJrnlEntryItem,
cast(ConsolidationGroup as fincs_consolidationgroup preserving type ) AS ConsolidationGroup,
cast(FiscalPeriod as fincs_poper preserving type) AS FiscalPeriod,
cast(PeriodMode as fincs_period_mode preserving type ) AS PeriodMode,
cast(_CnsldtnGroup_3._Text[1: Language=$session.system_language].ConsolidationGroupText as fincs_consolidationgrouptext preserving type ) AS ConsolidationGroupText,
cast(GLRecordType as fincs_glrcty preserving type ) AS GLRecordType,
cast(ConsolidationVersion as fincs_vers preserving type ) AS ConsolidationVersion,
cast(_Version._Text[1: Language=$session.system_language].ConsolidationVersionText as fincs_consolidationversiontext preserving type) AS ConsolidationVersionText,
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,
cast(_DocumentType_2._Text[1: Language=$session.system_language].ConsolidationDocumentTypeText as fincs_docty_t preserving type) AS ConsolidationDocumentTypeText,
cast(DebitCreditCode as fincs_drcrk preserving type ) AS DebitCreditCode,
Company,
cast(ConsolidationUnit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
cast(_CnsldtnUnit_4._Text[1: Language=$session.system_language].ConsolidationUnitText as fincs_consolidationunittext preserving type) AS ConsolidationUnitText,
cast(ConsolidationUnitForElim as fincs_rbunit_elim preserving type ) AS ConsolidationUnitForElim,
cast(ConsolidationChartOfAccounts as fincs_itcoa preserving type ) AS ConsolidationChartOfAccounts,
cast(FinancialStatementItem as fincs_consolidationfsitem preserving type ) AS FinancialStatementItem,
cast(_FinStmntItm_2._Text[1: Language=$session.system_language].CnsldtnFSItemText as fincs_consolidationfsitemtext preserving type ) AS CnsldtnFSItemText,
cast(PartnerConsolidationUnit as fincs_partnerconsolidationunit preserving type ) AS PartnerConsolidationUnit,
cast(_PartnerUnit_4._Text[1: Language=$session.system_language].ConsolidationUnitText as fincs_partnerconsunittext preserving type ) AS PartnerConsolidationUnitText,
cast(CompanyCode as fincs_bukrs preserving type) AS CompanyCode,
cast(SubItemCategory as fincs_sityp preserving type) AS SubItemCategory,
cast(_SubItemCategory._Text[1: Language=$session.system_language].SubItemCategoryText as fincs_sityp_t preserving type ) AS CnsldtnSubitemCategoryText,
cast(SubItem as fincs_subit preserving type) AS SubItem,
cast(PostingLevel as fincs_plevl preserving type) AS PostingLevel,
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(RefConsolidationDocumentNumber as fincs_refdocnr preserving type) AS RefConsolidationDocumentNumber,
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(FinancialServicesProductGroup as fincs_finsrvcsproductgroup preserving type ) AS FinancialServicesProductGroup,
cast(FinancialServicesBranch as fincs_financialservicesbranch preserving type ) AS FinancialServicesBranch,
cast(FinancialDataSource as fincs_financialdatasource preserving type ) AS FinancialDataSource,
cast(GHGScope as fincs_ghgscope preserving type ) AS GHGScope,
cast(GHGCategory as fincs_ghgcategory preserving type ) AS GHGCategory,
cast(GHGScope2CalculationMethod as fincs_ghgscp2calculationmethod preserving type ) AS GHGScope2CalculationMethod,
cast(GHGScope2ContractualInstrument as fincs_ghgscp2cntrctlinstrument preserving type ) AS GHGScope2ContractualInstrument,
cast(GHGDataQualityCharacteristic as fincs_ghgdtaqltycharc preserving type ) AS GHGDataQualityCharacteristic,
cast(GHGEnergyClassification as fincs_ghgenergyclassification preserving type ) AS GHGEnergyClassification,
cast(GHGEnergyMix as fincs_ghgenergymix preserving type ) AS GHGEnergyMix,
cast(GHGEnergySourcingType as fincs_ghgenergysourcingtype preserving type ) AS GHGEnergySourcingType,
cast(SustainabilityModeOfTransport as fincs_sustmodeoftransport preserving type ) AS SustainabilityModeOfTransport,
cast ( FinancialManagementArea as fincs_financialmanagementarea preserving type ) AS FinancialManagementArea,
cast ( Fund as fincs_fund preserving type ) AS Fund,
cast ( GrantID as fincs_grant preserving type ) AS GrantID,
cast ( CnsldtnCashLedgerChartOfAccts as fincs_cashledgerchartofaccts preserving type ) AS CnsldtnCashLedgerChartOfAccts,
cast ( CashLedgerAccount as fincs_cashledgeraccount preserving type ) AS CashLedgerAccount,
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,
cast(ProfitCenter as fincs_prctr preserving type) AS ProfitCenter,
cast(ConsolidationPrftCtrForElim as fincs_prctr_elim preserving type) AS ConsolidationPrftCtrForElim,
cast(FunctionalArea as fincs_rfarea preserving type) AS FunctionalArea,
cast(_FunctionalArea._Text[1: Language=$session.system_language].FunctionalAreaName as fincs_rfarea_t preserving type ) AS FunctionalAreaName,
cast(BusinessArea as fincs_rbusa preserving type) AS BusinessArea,
cast(ControllingArea as fincs_kokrs preserving type) AS ControllingArea,
cast(_ControllingArea._Text[1: Language=$session.system_language].ControllingAreaName as fincs_kokrs_t preserving type ) AS ControllingAreaName,
cast(Segment as fincs_segment preserving type) AS Segment,
cast(Project as ps_pspid_edit preserving type) AS Project,
cast(WBSElement as ps_posid_edit preserving type ) AS WBSElement,
cast(_Segment._Text[1: Language=$session.system_language].SegmentName as fincs_segmentname preserving type ) AS SegmentName,
cast(ConsolidationSegmentForElim as fincs_segment_elim preserving type) AS ConsolidationSegmentForElim,
cast(PartnerCostCenter as fincs_scntr preserving type) AS PartnerCostCenter,
cast(PartnerProfitCenter as fincs_pprctr preserving type) AS PartnerProfitCenter,
cast(PartnerFunctionalArea as fincs_sfarea preserving type) AS PartnerFunctionalArea,
cast(PartnerBusinessArea as fincs_sbusa preserving type) AS PartnerBusinessArea,
cast(PartnerCompany as fincs_rassc preserving type) AS PartnerCompany,
cast(PartnerSegment as fincs_psegment preserving type) AS PartnerSegment,
cast(OrderID as fincs_aufnr preserving type) AS OrderID,
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(Material as fincs_material preserving type) AS Material,
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,
_AdhocSetItem.CnsldtnAdhocSetItemText AS CnsldtnAdhocSetItemText,
CnsldtnAdhocItem,
CnsldtnAdhocSet,
CnsldtnAdhocSetItem
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]
;