C_MatrixCnsldtnJrnlEntr

Matrix Cnsldtn: JE Consumption View | view: CMXJRNLENTR | Extraction: Not supported | Component: Embedded Analytics
Tables used: SCAL_TT_YEAR, ACDOCU, FINCS_REF_VERS_R, ACDOCA, ACDOCP, RTC_PULL_REQ, ACDOCU, ACDOCA, TGSB, TGSBT, FINCS_ADDLCHARC, FINCS_ADDLMD, FINCS_ADDLMDT, FINCS_ADHITMT, FINCS_ADHSETT, TF121, TF500, TF501, FINCS_FSITEM, FINCS_FSITEMT, T000, FINCS_GRPSTR, TF181, TF110, TF160, TF162, FINCS_BUNIT_ATD, FINCS_BUNIT_ATVD, TF161, FINCS_BUNITT, FINCS_BUNIT, TF200, TF201, T001, TKA02, TKA01, CSKS, CSKT, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, TFKBT, FINCS_FSITEM, CEPC, CEPCT, T000, FAGL_SEGMT, TF164, HRRP_NODE, T881, TF165, TF200, TF110, T881, TF165, TF168, TF200, TF110, TF103A, TF004, TF001, TF040, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD, FINSC_LEDGER_REP, TFIN010, TFIN010, TFIN010, TFIN010, TF040
Column Name Description
ConsolidationLedger Ledger
ConsolidationDimension Dimension
FiscalYear Fiscal Year
ConsolidationDocumentNumber Document Number of an Accounting Document
ConsolidationPostingItem Six-Character Posting Item for Ledger
ConsolidationGroup Consolidation Group
FiscalPeriod Reporting Period
PeriodMode Period Mode Show values
ReferenceFiscalYear Fiscal Year
CompanyCode Original company code
Column Name Description
💲 Currency Key (TransactionCurrency):
AmountInTransactionCurrency Value in Transaction Currency
💲 Currency key of the local currency (LocalCurrency):
AmountInLocalCurrency Value in Local Currency
💲 Currency key of the ledger currency (GroupCurrency):
AmountInGroupCurrency Value in Group Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
CnsldtnQuantityInBaseUnit Quantity
Column Name Description
PostingDate Posting Date in the Document
CurrencyTranslationDate Value Date for Currency Translation
CreationDate Day On Which Accounting Document Was Entered
CreationTime Time of Entry
Column Name Description
PeriodMode Period Mode Show values
GLRecordType Record Type Show values
DocumentCategory Document Category Show values
DebitCreditCode Debit/Credit Indicator Show values
PostingLevel Posting Level Show values
ConsolidationApportionment Apportionment Show values
CurrencyConversionsDiffType Currency Translation Show values
RefConsolidationDocumentType Document Category Show values
InvestmentActivityType Consolidation of Investments Activity Show values
CnsldtnJrnlEntryItemOrigin Consolidation Journal Entry Item Origin Show values
Column Name Description Domain name
ConsolidationGroupMediumText Medium Text TEXT30
PeriodModeText Short Text for Fixed Values DDTEXT
ConsolidationVersion Consolidation Version FC_RVERS
ConsolidationVersionText Description TEXT30
ConsolidationVersionElement Version RVERS
CnsldtnVersionElementDesc Description TEXT30
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
FiscalYearVariant Fiscal Year Variant PERIV
PostingFiscalPeriod Posting period POPER
ConsolidationDocumentType Document Type FC_DOCTY
ConsolidationDocumentTypeText Description TEXT30
Company Company RCOMP
ConsolidationUnit Consolidation Unit FC_BUNIT
ConsolidationUnitMdmText Short description TEXT20
ConsolidationUnitForElim Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
ConsolidationChartOfAccounts Consolidation Chart of Accounts FC_ITCLG
ConsolidationChartOfAcctsText Description TEXT30
FinancialStatementItem Financial Statement Item FC_ITEM
FinancialStatementItemMdmText Description TEXT50
PartnerConsolidationUnit Partner Unit FC_BUNIT
PartnerCnsldtnUnitMediumText Short description TEXT20
SubItemCategory Subitem Category FC_SITYP
SubItem Subitem FC_SITEM
PostingLevelText Short Text for Fixed Values DDTEXT
ConsolidationAcquisitionYear Year of Acquisition GJAHR
ConsolidationAcquisitionPeriod Period of Acquisition NUM03
InvesteeConsolidationUnit Investee Unit FC_BUNIT
DocumentItemText Item Text TEXT50
ConsolidationPostgItemAutoFlag Indicator: Automatic posting lines TEXT1
BusinessTransactionType Business Transaction CHAR4
RefConsolidationDocumentNumber Document Number of an Accounting Document BELNR
RefConsolidationPostingItem Six-figure number of line item BUZEI6
RefBusinessTransactionType Business Transaction CHAR4
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
UserID User Name XUBNAME
ReverseDocument Reverse Document Number BELNR
ReversedDocument Number of Reversed Document BELNR
InvestmentActivity Consolidation of Investments Activity Number BELNR
ConsolidationDocReversalYear Year of reversal document or reversed document GJAHR
ReferenceDocumentType Reference procedure AWTYP
ReferenceDocumentContext Reference Organizational Units AWORG
LogicalSystem Logical system LOGSYS
ChartOfAccounts Chart of Accounts KTOPL
GLAccount Account Number SAKNR
AssignmentReference Assignment number ZUONR
CostCenter Cost Center KOSTL
CostCenterName Cost Center Name TEXT20
ProfitCenter Profit Center PRCTR
ProfitCenterName Description of Profit Center TEXT20
ConsolidationPrftCtrForElim Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
FunctionalArea Functional Area FKBER
FunctionalAreaName Name of the Functional Area TEXT25
BusinessArea Business Area GSBER
BusinessAreaName Business Area Description TEXT30
ControllingArea Controlling Area CACCD
ControllingAreaName Controlling Area Name TEXT25
Segment Segment for Segmental Reporting FB_SEGMENT
SegmentName Segment Name TEXT50
ConsolidationSegmentForElim Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
PartnerCostCenter Sender cost center KOSTL
PartnerCostCenterName Cost Center Name TEXT20
PartnerProfitCenter Partner Profit Center PRCTR
PartnerProfitCenterName Description of Profit Center TEXT20
PartnerFunctionalArea Partner Functional Area FKBER
PartnerFunctionalAreaName Name of the Functional Area TEXT25
PartnerBusinessArea Trading partner's business area GSBER
PartnerBusinessAreaName Business Area Description TEXT30
PartnerCompany Company ID of Trading Partner RCOMP
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
PartnerSegmentName Segment Name TEXT50
OrderID Order Number AUFNR
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
Material Material Number MATNR
MaterialGroup Material Group MATKL
Plant Plant WERKS
FinancialTransactionType Transaction type RMVCT
Project Project definition PS_PSPID
BillingDocumentType Billing Type FKART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
SoldMaterial Product Sold MATNR
SoldProduct Product Sold MATNR
SoldProductGroup Product Sold Group MATKL
CustomerGroup Customer Group KDGRP
CustomerSupplierCountry Country/Region Key LAND1
CustomerSupplierIndustry Industry key BRSCH
SalesDistrict Sales District BZIRK
BillToParty Bill-to Party KUNNR
ShipToParty Ship-to Party KUNNR
CustomerSupplierCorporateGroup Group key KONZS
CnsldtnAdhocItem Ad Hoc Item FINCS_ADHOCITEM
CnsldtnAdhocSet Ad Hoc Set FINCS_ADHOCSET
CnsldtnAdhocSetItem Ad Hoc Set Item FINCS_ADHOCSETITEM
MatchingReasonCode Reason Code ICA_RCODE
OriginType Origin Type FINCS_ORIG_TYPE
OriginReference Origin Reference FINCS_ORIG_REF
CnsldtnAdhocItemText Ad Hoc Item Description FINCS_ADHOCITEMTEXT
CnsldtnAdhocSetText Ad Hoc Set Description FINCS_ADHOCSETTEXT