I_MatrixCnsldtnJrnlEntr

DDL: I_MATRIXCNSLDTNJRNLENTR SQL: IMXJRNLENTR Type: view COMPOSITE Package: FIN_CS_ANALYTICS_APPL_JEL
170 Fields 1 Data Sources 3 Associations

Matrix Cnsldtn: Journal Entry

I_MatrixCnsldtnJrnlEntr is a Composite CDS View that provides data about "Matrix Cnsldtn: Journal Entry" in SAP S/4HANA. It reads from 1 data source (P_MatrixCnsldtnFoundation) and exposes 170 fields with key fields ConsolidationLedger, ConsolidationDimension, FiscalYear, ConsolidationDocumentNumber, ConsolidationPostingItem. It has 3 associations to related views. Part of development package FIN_CS_ANALYTICS_APPL_JEL.

Data Sources (1)

SourceAliasJoin Type
P_MatrixCnsldtnFoundation P_MatrixCnsldtnFoundation from

Parameters (4)

NameTypeDefault
P_ConsolidationUnitHierarchy fincs_hryid
P_ConsolidationPrftCtrHier fincs_hryid
P_ConsolidationSegmentHier fincs_hryid
P_KeyDate sydate

Associations (3)

CardinalityTargetAliasCondition
[0..1] E_JournalEntryItem _Extension_acdoca $projection.Ledger = _Extension_acdoca.SourceLedger and $projection.CompanyCode = _Extension_acdoca.CompanyCode and $projection.FiscalYear = _Extension_acdoca.FiscalYear and $projection.ConsolidationDocumentNumber = _Extension_acdoca.AccountingDocument and $projection.ConsolidationPostingItem = _Extension_acdoca.LedgerGLLineItem
[0..1] E_CnsldtnGroupJrnlEntryItem _Extension_acdocu $projection.ConsolidationLedger = _Extension_acdocu.ConsolidationLedger and _Extension_acdocu.ConsolidationDimension = 'Y1' and $projection.FiscalYear = _Extension_acdocu.FiscalYear and $projection.ConsolidationDocumentNumber = _Extension_acdocu.CnsldtnGroupJrnlEntry and $projection.ConsolidationPostingItem = _Extension_acdocu.CnsldtnGroupJrnlEntryItem
[0..1] E_FinancialPlanningEntryItem _Extension_acdocp $projection.FinancialPlanningReqTransSqnc = _Extension_acdocp.FinancialPlanningReqTransSqnc and $projection.FinancialPlanningDataPacket = _Extension_acdocp.FinancialPlanningDataPacket and $projection.FinancialPlanningEntryItem = _Extension_acdocp.FinancialPlanningEntryItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMXJRNLENTR view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Matrix Cnsldtn: Journal Entry view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey ConsolidationPostingItem view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (170)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationLedger ConsolidationLedger Ledger
KEY ConsolidationDimension ConsolidationDimension Dimension
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY ConsolidationDocumentNumber ConsolidationDocumentNumber Document Number
KEY ConsolidationPostingItem ConsolidationPostingItem G/L Line Item
KEY ConsolidationGroup ConsolidationGroup Cons. Group
KEY FiscalPeriod FiscalPeriod Tax period
KEY PeriodMode PeriodMode
KEY ReferenceFiscalYear ReferenceFiscalYear Original FY
KEY CompanyCode CompanyCode Receiver Company Code
GLRecordType GLRecordType Record Type
ConsolidationVersion ConsolidationVersion Version
ConsolidationVersionElement ConsolidationVersionElement
TransactionCurrency TransactionCurrency Transaction Currency
LocalCurrency LocalCurrency Local Currency
GroupCurrency GroupCurrency Ledger curr.
BaseUnit BaseUnit Unit of Measure
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalYearVariant FiscalYearVariant FY Variant
PostingFiscalPeriod PostingFiscalPeriod Period
DocumentCategory DocumentCategory Document Category
ConsolidationDocumentType ConsolidationDocumentType Document Type
DebitCreditCode DebitCreditCode Single-Character Flag
Company Company Owner
ConsolidationUnit ConsolidationUnit Consolidation Unit
ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
FinancialStatementItem FinancialStatementItem FS Item
PartnerConsolidationUnit PartnerConsolidationUnit Partner Unit
SubItemCategory SubItemCategory Subitem Category
SubItem SubItem Subitem Number
PostingLevel PostingLevel Posting Level
ConsolidationApportionment ConsolidationApportionment Apportionment
CurrencyConversionsDiffType CurrencyConversionsDiffType CT Indicator
ConsolidationAcquisitionYear ConsolidationAcquisitionYear Acquis. Year
ConsolidationAcquisitionPeriod ConsolidationAcquisitionPeriod Period of Acq.
InvesteeConsolidationUnit InvesteeConsolidationUnit Investee Unit
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
AmountInLocalCurrency AmountInLocalCurrency Local Crcy Amt
AmountInGroupCurrency AmountInGroupCurrency Amnt in GrpCrcy
QuantityInBaseUnit QuantityInBaseUnit Quantity
DocumentItemText DocumentItemText Text
ConsolidationPostgItemAutoFlag ConsolidationPostgItemAutoFlag Auto. ID
BusinessTransactionType BusinessTransactionType Bus.transaction
PostingDate PostingDate Posting Date for GR
CurrencyTranslationDate CurrencyTranslationDate Value Date
RefConsolidationDocumentNumber RefConsolidationDocumentNumber Document Number
RefConsolidationPostingItem RefConsolidationPostingItem Item
RefConsolidationDocumentType RefConsolidationDocumentType Document Categ.
RefBusinessTransactionType RefBusinessTransactionType Bus.transaction
CreationDateTime CreationDateTime Timestamp
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
UserID UserID User Name
ReverseDocument ReverseDocument Reversed With
ReversedDocument ReversedDocument Reversed doc.
InvestmentActivityType InvestmentActivityType C/I Activity
InvestmentActivity InvestmentActivity Activity Number
ConsolidationDocReversalYear ConsolidationDocReversalYear Year of reversal doc
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
LogicalSystem LogicalSystem Logical System
ChartOfAccounts ChartOfAccounts Node Class
GLAccount GLAccount General Ledger
AssignmentReference AssignmentReference Assignment Reference
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
Segment Segment Segment number
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerProfitCenter PartnerProfitCenter Profit Center
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
PartnerCompany PartnerCompany Trading Partner
PartnerSegment PartnerSegment Partner Segment
OrderID OrderID Order ID
Customer Customer Sold-to Party
Supplier Supplier Supplier
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
FinancialTransactionType FinancialTransactionType Transact. Type
Project Project WBS Element
BillingDocumentType BillingDocumentType Billing Type
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SoldMaterial SoldMaterial Product Sold
SoldProduct SoldProduct Product Sold
SoldProductGroup SoldProductGroup Product Sold Group
CustomerGroup CustomerGroup Customer Group
CustomerSupplierCountry CustomerSupplierCountry Customer or Supplier Country/Region
CustomerSupplierIndustry CustomerSupplierIndustry Industry
SalesDistrict SalesDistrict Sales District
BillToParty BillToParty Inv. Recipient
ShipToParty ShipToParty Ship-To Party (obsolete)
CustomerSupplierCorporateGroup CustomerSupplierCorporateGroup Group
CnsldtnJrnlEntryItemOrigin CnsldtnJrnlEntryItemOrigin
FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc Request TSN
FinancialPlanningDataPacket FinancialPlanningDataPacket Data packet number
FinancialPlanningEntryItem FinancialPlanningEntryItem
Ledger Ledger Ledger
CnsldtnAdhocItem CnsldtnAdhocItem Ad Hoc Item
CnsldtnAdhocSet CnsldtnAdhocSet Ad Hoc Set
CnsldtnAdhocSetItem CnsldtnAdhocSetItem Ad Hoc Set Item
MatchingReasonCode MatchingReasonCode Result
OriginType OriginType Origin Type
OriginReference OriginReference Origin Ref.
_Ledger _Ledger
_Dimension _Dimension
_CnsldtnGroup _CnsldtnGroup
_CompanyCode _CompanyCode
_Version _Version
_Company _Company
_CnsldtnUnit _CnsldtnUnit
_ChartOfAccounts _ChartOfAccounts
_FinStmntItm _FinStmntItm
_PartnerUnit _PartnerUnit
_SubItemCategory _SubItemCategory
_SubItem _SubItem
_DebitCreditCode _DebitCreditCode
_DocumentType _DocumentType
_PostingLevel _PostingLevel
_InvesteeUnit _InvesteeUnit
_Apportionment _Apportionment
_CrcyCnvrsnDiffType _CrcyCnvrsnDiffType
_TransactionCurrency _TransactionCurrency
_LocalCurrency _LocalCurrency
_GroupCurrency _GroupCurrency
_BaseUnit _BaseUnit
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_GLChartOfAccounts _GLChartOfAccounts
_InternalOrder _InternalOrder
_Customer _Customer
_Supplier _Supplier
_Material _Material
_MaterialGroup _MaterialGroup
_Plant _Plant
_FinancialTransactionType _FinancialTransactionType
_Project _Project
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_FunctionalArea _FunctionalArea
_BusinessArea _BusinessArea
_ControllingArea _ControllingArea
_Segment _Segment
_PartnerCostCenter _PartnerCostCenter
_PartnerProfitCenter _PartnerProfitCenter
_PartnerFunctionalArea _PartnerFunctionalArea
_PartnerBusinessArea _PartnerBusinessArea
_PartnerCompany _PartnerCompany
_PartnerSegment _PartnerSegment
_BillingDocumentType _BillingDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SoldMaterial _SoldMaterial
_SoldProduct _SoldProduct
_SoldProductGroup _SoldProductGroup
_CustomerGroup _CustomerGroup
_Country _Country
_Industry _Industry
_SalesDistrict _SalesDistrict
_BillToParty _BillToParty
_ShipToParty _ShipToParty
_AdhocItem _AdhocItem
_AdhocSet _AdhocSet
_AdhocSetItem _AdhocSetItem
_VersionElement _VersionElement

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_MatrixCnsldtnJrnlEntr.
-- 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: IMXJRNLENTR
-- Parameters: P_ConsolidationUnitHierarchy : fincs_hryid, P_ConsolidationPrftCtrHier : fincs_hryid, P_ConsolidationSegmentHier : fincs_hryid, P_KeyDate : sydate

CREATE VIEW I_MatrixCnsldtnJrnlEntr AS
SELECT
  ConsolidationLedger,
  ConsolidationDimension,
  FiscalYear,
  ConsolidationDocumentNumber,
  ConsolidationPostingItem,
  ConsolidationGroup,
  FiscalPeriod,
  PeriodMode,
  ReferenceFiscalYear,
  CompanyCode,
  GLRecordType,
  ConsolidationVersion,
  ConsolidationVersionElement,
  TransactionCurrency,
  LocalCurrency,
  GroupCurrency,
  BaseUnit,
  FiscalYearPeriod,
  FiscalYearVariant,
  PostingFiscalPeriod,
  DocumentCategory,
  ConsolidationDocumentType,
  DebitCreditCode,
  Company,
  ConsolidationUnit,
  ConsolidationChartOfAccounts,
  FinancialStatementItem,
  PartnerConsolidationUnit,
  SubItemCategory,
  SubItem,
  PostingLevel,
  ConsolidationApportionment,
  CurrencyConversionsDiffType,
  ConsolidationAcquisitionYear,
  ConsolidationAcquisitionPeriod,
  InvesteeConsolidationUnit,
  AmountInTransactionCurrency,
  AmountInLocalCurrency,
  AmountInGroupCurrency,
  QuantityInBaseUnit,
  DocumentItemText,
  ConsolidationPostgItemAutoFlag,
  BusinessTransactionType,
  PostingDate,
  CurrencyTranslationDate,
  RefConsolidationDocumentNumber,
  RefConsolidationPostingItem,
  RefConsolidationDocumentType,
  RefBusinessTransactionType,
  CreationDateTime,
  CreationDate,
  CreationTime,
  UserID,
  ReverseDocument,
  ReversedDocument,
  InvestmentActivityType,
  InvestmentActivity,
  ConsolidationDocReversalYear,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  LogicalSystem,
  ChartOfAccounts,
  GLAccount,
  AssignmentReference,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  OrderID,
  Customer,
  Supplier,
  Material,
  MaterialGroup,
  Plant,
  FinancialTransactionType,
  Project,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SoldMaterial,
  SoldProduct,
  SoldProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  CnsldtnJrnlEntryItemOrigin,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  Ledger,
  CnsldtnAdhocItem,
  CnsldtnAdhocSet,
  CnsldtnAdhocSetItem,
  MatchingReasonCode,
  OriginType,
  OriginReference
FROM P_MatrixCnsldtnFoundation
LEFT OUTER JOIN E_JournalEntryItem AS _Extension_acdoca ON Ledger = _Extension_acdoca.SourceLedger AND CompanyCode = _Extension_acdoca.CompanyCode AND FiscalYear = _Extension_acdoca.FiscalYear AND ConsolidationDocumentNumber = _Extension_acdoca.AccountingDocument AND ConsolidationPostingItem = _Extension_acdoca.LedgerGLLineItem  -- association [0..1]
LEFT OUTER JOIN E_CnsldtnGroupJrnlEntryItem AS _Extension_acdocu ON ConsolidationLedger = _Extension_acdocu.ConsolidationLedger AND _Extension_acdocu.ConsolidationDimension = 'Y1' AND FiscalYear = _Extension_acdocu.FiscalYear AND ConsolidationDocumentNumber = _Extension_acdocu.CnsldtnGroupJrnlEntry AND ConsolidationPostingItem = _Extension_acdocu.CnsldtnGroupJrnlEntryItem  -- association [0..1]
LEFT OUTER JOIN E_FinancialPlanningEntryItem AS _Extension_acdocp ON FinancialPlanningReqTransSqnc = _Extension_acdocp.FinancialPlanningReqTransSqnc AND FinancialPlanningDataPacket = _Extension_acdocp.FinancialPlanningDataPacket AND FinancialPlanningEntryItem = _Extension_acdocp.FinancialPlanningEntryItem  -- association [0..1]
;

Learn More