A_CnsldtnTransactionData

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_CnsldtnTransactionData.
-- 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: ACSTRANSDATA
-- Parameters: P_ConsolidationUnitHierId : fincs_hryid_consunit, P_ConsolidationPrftCtrHierId : fincs_hryid_profitcenter, P_ConsolidationSegmentHierId : fincs_hryid_segment, P_KeyDate : datbi

CREATE VIEW A_CnsldtnTransactionData AS
SELECT
  cast(ConsolidationLedger as fincs_rldnr preserving type ) AS ConsolidationLedger,
  ConsolidationDimension,
  FiscalYear,
  cast(ConsolidationDocumentNumber as fincs_docnr preserving type ) AS ConsolidationDocumentNumber,
  cast(ConsolidationPostingItem as fincs_docln preserving type ) AS ConsolidationPostingItem,
  cast(GLRecordType as fincs_glrcty preserving type ) AS GLRecordType,
  cast(ConsolidationVersion as fincs_vers preserving type ) AS ConsolidationVersion,
  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(FiscalPeriod as fincs_poper preserving type) AS FiscalPeriod,
  cast( cast(FiscalYearPeriod as abap.char(7)) as fis_jahrper_c preserving type ) AS FiscalYearPeriod,
  FiscalYearVariant,
  cast(PeriodMode as fincs_period_mode preserving type ) AS PeriodMode,
  cast(ConsolidationDocumentType as fincs_docty preserving type ) AS ConsolidationDocumentType,
  cast(DebitCreditCode as fincs_drcrk preserving type ) AS DebitCreditCode,
  Company,
  cast(ConsolidationUnit as fincs_rbunit preserving type ) AS ConsolidationUnit,
  cast(ConsolidationUnitForElim as fincs_rbunit_elim preserving type) AS ConsolidationUnitForElim,
  cast(ConsolidationChartOfAccounts as fincs_itcoa preserving type) AS ConsolidationChartOfAccounts,
  cast(FinancialStatementItem as fincs_item preserving type) AS FinancialStatementItem,
  cast(PartnerConsolidationUnit as fincs_rbuptr preserving type ) AS PartnerConsolidationUnit,
  cast(ConsolidationGroup as fc_congr preserving type ) AS ConsolidationGroup,
  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,
  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_coicu 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,
  QuantityInBaseUnit,
  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(RefBusinessTransactionType as fincs_refactiv preserving type) AS RefBusinessTransactionType,
  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(BusinessArea as fincs_rbusa preserving type) AS BusinessArea,
  cast(ControllingArea as fincs_kokrs preserving type) AS ControllingArea,
  cast(Segment as fincs_segment preserving type) AS Segment,
  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(Material as fincs_matnr preserving type) AS Material,
  cast(Plant as fincs_werks preserving type) AS Plant,
  cast(FinancialTransactionType as fincs_rmvct preserving type) AS FinancialTransactionType,
  WBSElementInternalID,
  cast(_CnsldtnWBSElementID.WBSDescription as fincs_ps_psp_pnr_t preserving type) AS WBSDescription,
  cast(WBSElementExternalID as fincs_ps_posid preserving type) AS WBSElementExternalID,
  cast(Project as fincs_ps_pspid preserving type) AS Project,
  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,
  CnsldtnAdhocItem,
  _AdhocItem._Text[1: Language=$session.system_language].CnsldtnAdhocItemText AS CnsldtnAdhocItemText,
  CnsldtnAdhocSet,
  _AdhocSet._Text[1: Language=$session.system_language].CnsldtnAdhocSetText AS CnsldtnAdhocSetText,
  CnsldtnAdhocSetItem,
  _AdhocSetItem.CnsldtnAdhocSetItemText AS CnsldtnAdhocSetItemText
FROM I_MatrixConsolidationReportC
LEFT OUTER JOIN A_CnsldtnLedgerT AS _CnsldtnLedgerT ON ConsolidationLedger = _CnsldtnLedgerT.ConsolidationLedger  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnDocumentTypeT AS _CnsldtnDocumentTypeT ON ConsolidationDocumentType = _CnsldtnDocumentTypeT.ConsolidationDocumentType  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnUnitForEliminationT AS _CnsldtnUnitForElimT ON ConsolidationUnit = _CnsldtnUnitForElimT.ConsolidationUnit  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnChartOfAccountsT AS _CnsldtnChartOfAccountsT ON ConsolidationChartOfAccounts = _CnsldtnChartOfAccountsT.ConsolidationChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnFSItemT AS _CnsldtnFSItemT ON FinancialStatementItem = _CnsldtnFSItemT.FinancialStatementItem AND ConsolidationChartOfAccounts = _CnsldtnFSItemT.ConsolidationChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSubitemCategoryT AS _CnsldtnSubitemCategoryT ON SubItemCategory = _CnsldtnSubitemCategoryT.SubItemCategory  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSubItemT AS _CnsldtnSubItemT ON SubItemCategory = _CnsldtnSubItemT.SubItemCategory AND SubItem = _CnsldtnSubItemT.SubItem  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnPostingLevelT AS _CnsldtnPostingLevelT ON PostingLevel = _CnsldtnPostingLevelT.PostingLevel  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnBaseUnitT AS _CnsldtnBaseUnit ON BaseUnit = _CnsldtnBaseUnit.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnGLAccountT AS _CnsldtnGLAccountT ON GLAccount = _CnsldtnGLAccountT.GLAccount AND ChartOfAccounts = _CnsldtnGLAccountT.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnCostCenterT AS _CnsldtnCostCenterT ON CostCenter = _CnsldtnCostCenterT.CostCenter AND ControllingArea = _CnsldtnCostCenterT.ControllingArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnPartnerUnitT AS _CnsldtnPartnerUnitT ON ConsolidationUnit = _CnsldtnPartnerUnitT.ConsolidationUnit  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnProfitCenterT AS _CnsldtnProfitCenterT ON ProfitCenter = _CnsldtnProfitCenterT.ProfitCenter AND ControllingArea = _CnsldtnProfitCenterT.ControllingArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnProfitCtrForElimT AS _CnsldtnProfitCtrForElimT ON ProfitCenter = _CnsldtnProfitCtrForElimT.ProfitCenter AND ControllingArea = _CnsldtnProfitCtrForElimT.ControllingArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnControllingAreaT AS _CnsldtnControllingAreaT ON ControllingArea = _CnsldtnControllingAreaT.ControllingArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnFunctionalAreaT AS _CnsldtnFunctionalAreaT ON FunctionalArea = _CnsldtnFunctionalAreaT.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnBusinessAreaT AS _CnsldtnBusinessAreaT ON BusinessArea = _CnsldtnBusinessAreaT.BusinessArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSegmentT AS _CnsldtnSegmentT ON Segment = _CnsldtnSegmentT.Segment  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSegmentForElimT AS _CnsldtnSegmentForElimT ON Segment = _CnsldtnSegmentForElimT.Segment  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnPartnerCostCtrT AS _CnsldtnPartnerCostCtrT ON CostCenter = _CnsldtnPartnerCostCtrT.CostCenter AND ControllingArea = _CnsldtnPartnerCostCtrT.ControllingArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnPartnerPrftCtrT AS _CnsldtnPartnerPrftCtrT ON ProfitCenter = _CnsldtnPartnerPrftCtrT.ProfitCenter AND ControllingArea = _CnsldtnPartnerPrftCtrT.ControllingArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnPartFuncnlAreaT AS _CnsldtnPartFuncnlAreaT ON FunctionalArea = _CnsldtnPartFuncnlAreaT.FunctionalArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnPartnerBusAreaT AS _CnsldtnPartnerBusAreaT ON BusinessArea = _CnsldtnPartnerBusAreaT.BusinessArea  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnPartnerSegmentT AS _CnsldtnPartnerSegmentT ON Segment = _CnsldtnPartnerSegmentT.Segment  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnGroupT AS _CnsldtnGroupT ON ConsolidationGroup = _CnsldtnGroupT.ConsolidationGroup  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnCustomerT AS _CnsldtnCustomerT ON Customer = _CnsldtnCustomerT.Customer  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSupplierT AS _CnsldtnSupplierT ON Supplier = _CnsldtnSupplierT.Supplier  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnMaterialT AS _CnsldtnMaterialT ON Material = _CnsldtnMaterialT.Material  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnPlantT AS _CnsldtnPlantT ON Plant = _CnsldtnPlantT.Plant  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnFinTransTypeT AS _CnsldtnFinTransTypeT ON FinancialTransactionType = _CnsldtnFinTransTypeT.FinancialTransactionType  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnVersionT AS _CnsldtnVersionT ON ConsolidationVersion = _CnsldtnVersionT.ConsolidationVersion  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnProjectT AS _CnsldtnProjectT ON Project = _CnsldtnProjectT.Project  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnBillingTypeT AS _CnsldtnBillingTypeT ON BillingDocumentType = _CnsldtnBillingTypeT.BillingDocumentType  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSalesOrgT AS _CnsldtnSalesOrgT ON SalesOrganization = _CnsldtnSalesOrgT.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnDistributionChnlT AS _CnsldtnDistributionChnlT ON DistributionChannel = _CnsldtnDistributionChnlT.DistributionChannel  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnDivisionT AS _CnsldtnDivisionT ON OrganizationDivision = _CnsldtnDivisionT.Division  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnMaterialGroupT AS _CnsldtnMaterialGroupT ON MaterialGroup = _CnsldtnMaterialGroupT.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnProductSoldT AS _CnsldtnProductSoldT ON SoldProduct = _CnsldtnProductSoldT.Material  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnProductSoldGroupT AS _CnsldtnProductSoldGroupT ON SoldProductGroup = _CnsldtnProductSoldGroupT.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnCustomerGroupT AS _CnsldtnCustomerGroupT ON CustomerGroup = _CnsldtnCustomerGroupT.CustomerGroup  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnSalesDistrictT AS _CnsldtnSalesDistrictT ON SalesDistrict = _CnsldtnSalesDistrictT.SalesDistrict  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnBillToPartyT AS _CnsldtnBillToPartyT ON BillToParty = _CnsldtnBillToPartyT.Customer  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnShipToPartyT AS _CnsldtnShipToPartyT ON ShipToParty = _CnsldtnShipToPartyT.Customer  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnUnitT AS _CnsldtnUnitT ON ConsolidationUnit = _CnsldtnUnitT.ConsolidationUnit  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnInvesteeUnitT AS _CnsldtnInvesteeUnitT ON InvesteeConsolidationUnit = _CnsldtnInvesteeUnitT.ConsolidationUnit  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnTransCurrencyT AS _CnsldtnTransCurrencyT ON TransactionCurrency = _CnsldtnTransCurrencyT.Currency  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnLocalCurrencyT AS _CnsldtnLocalCurrencyT ON LocalCurrency = _CnsldtnLocalCurrencyT.Currency  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnGroupCurrencyT AS _CnsldtnGroupCurrencyT ON GroupCurrency = _CnsldtnGroupCurrencyT.Currency  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnGlobalCompanyT AS _CnsldtnGlobalCompanyT ON PartnerCompany = _CnsldtnGlobalCompanyT.Company  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnIndustryT AS _CnsldtnIndustryT ON CustomerSupplierIndustry = _CnsldtnIndustryT.Industry  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnCountryT AS _CnsldtnCountryT ON CustomerSupplierCountry = _CnsldtnCountryT.Country  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnOfInvestmentsActyT AS _CnsldtnOfInvestmentsActyT ON InvestmentActivityType = _CnsldtnOfInvestmentsActyT.InvestmentActivityType  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnInternalOrderT AS _CnsldtnInternalOrderT ON OrderID = _CnsldtnInternalOrderT.InternalOrder  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnGLChartOfAccountsT AS _CnsldtnGLChartOfAccountsT ON ChartOfAccounts = _CnsldtnGLChartOfAccountsT.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnWBSElementT AS _CnsldtnWBSElementT ON WBSElementExternalID = _CnsldtnWBSElementT.WBSElement AND Project = _CnsldtnWBSElementT.Project  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnWBSElementID AS _CnsldtnWBSElementID ON WBSElementInternalID = _CnsldtnWBSElementID.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN A_CnsldtnDebitCreditCodeT AS _CnsldtnDebitCreditCodeT ON DebitCreditCode = _CnsldtnDebitCreditCodeT.DebitCreditCode  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnGLRecordTypeT AS _CnsldtnGLRecordTypeT ON GLRecordType = _CnsldtnGLRecordTypeT.GLRecordType  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnCrcyCnvrsnDiffTypeT AS _CnsldtnCrcyCnvrsnDiffTypeT ON CurrencyConversionsDiffType = _CnsldtnCrcyCnvrsnDiffTypeT.CurrencyConversionsDiffType  -- association [0..*]
LEFT OUTER JOIN A_CnsldtnCompanyCodeT AS _CnsldtnCompanyCodeT ON CompanyCode = _CnsldtnCompanyCodeT.CompanyCode  -- association [0..*]
LEFT OUTER JOIN E_CnsldtnGroupJrnlEntryItem AS _Extension ON ConsolidationLedger = _Extension.ConsolidationLedger AND ConsolidationDimension = _Extension.ConsolidationDimension AND FiscalYear = _Extension.FiscalYear AND ConsolidationDocumentNumber = _Extension.CnsldtnGroupJrnlEntry AND ConsolidationPostingItem = _Extension.CnsldtnGroupJrnlEntryItem  -- association [1..1]
;