I_CnsldtnJrnlEntrItem

Journal Entry (Database List) Items | view: IJRNLENTRITM | Extraction: Not supported | Component: Embedded Analytics

Tables used: SCAL_TT_YEAR, ACDOCU, ACDOCA, ACDOCP, ACDOCU, RTC_PULL_REQ, ACDOCA, TF500, FINCS_FSITEM, TF110, TF160, TF162, FINCS_BUNIT_ATD, FINCS_BUNIT_ATVD, FINCS_BUNIT, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, FINCS_FSITEM, T000, TF164, T881, TF165, TF200, TF110, T881, TF165, TF168, TF200, TF110, TF103A, TF001, TF040, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD, FINSC_LEDGER_REP, TFIN010, TFIN010, TFIN010, TFIN010, TF040

🔑 Keys (9)
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (8)
Other (50)
🔗 Relations (27)

Column Name	Description
ConsolidationLedger	Ledger
ConsolidationDimension	Dimension
FiscalYear	Fiscal Year
ReferenceFiscalYear	Fiscal Year
CompanyCode	Original company code
ConsolidationDocumentNumber	Document Number of an Accounting Document
ConsolidationPostingItem	Six-Character Posting Item for Ledger
ConsolidationRecordNumber	null
ConsolidationVersion	Version

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):
QuantityInBaseUnit	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
GLRecordType	Record Type	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
ConsolidationPostingItem1	Six-Character Posting Item for Ledger	DOCLN6
FiscalPeriod	Posting period	POPER
ConsolidationDocumentType	Document Type	FC_DOCTY
Company	Company	RCOMP
ConsolidationUnit	Consolidation Unit	FC_BUNIT
ConsolidationChartOfAccounts	Consolidation Chart of Accounts	FC_ITCLG
FinancialStatementItem	Financial Statement Item	FC_ITEM
PartnerConsolidationUnit	Partner Unit	FC_BUNIT
ConsolidationGroup	Consolidation Group	FC_CONGR
SubItemCategory	Subitem Category	FC_SITYP
SubItem	Subitem	FC_SITEM
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
GLAccount	Account Number	SAKNR
AssignmentReference	Assignment number	ZUONR
CostCenter	Cost Center	KOSTL
ProfitCenter	Profit Center	PRCTR
FunctionalArea	Functional Area	FKBER
BusinessArea	Business Area	GSBER
Segment	Segment for Segmental Reporting	FB_SEGMENT
FinancialTransactionType	Transaction type	RMVCT
Project	Project definition	PS_PSPID
CustomerSupplierCorporateGroup	Group key	KONZS
FinancialPlanningReqTransSqnc	Financial Planning Request Transaction Sequence Number	FIS_RSPM_TSN
FinancialPlanningDataPacket	Financial Planning Data Packet Number	NUM6
FinancialPlanningEntryItem	Financial Planning Entry Item	RSNUMRECORD
Ledger	Ledger in General Ledger Accounting	FINS_LEDGER
CnsldtnAdhocItem	Ad Hoc Item	FINCS_ADHOCITEM
CnsldtnAdhocSet	Ad Hoc Set	FINCS_ADHOCSET
CnsldtnAdhocSetItem	Ad Hoc Set Item	FINCS_ADHOCSETITEM
MatchingReasonCode	Reason Code	ICA_RCODE
OriginReference	Origin Reference	FINCS_ORIG_REF
OriginType	Origin Type	FINCS_ORIG_TYPE
CnsldtnGroupJrnlEntryBundle	Document Bundle Number	FINCS_BUNNR

Master Data Relations	Join Conditions
Billing Type Client Billing Type	`I_CNSLDTNJRNLENTRITEM.MANDT == TVFK.MANDT` `I_CNSLDTNJRNLENTRITEM.BILLINGDOCUMENTTYPE == TVFK.FKART`
Bill-to Party Bill-to Party Client	`I_CNSLDTNJRNLENTRITEM.BILLTOPARTY == KNA1.KUNNR` `I_CNSLDTNJRNLENTRITEM.MANDT == KNA1.MANDT`
Chart of Accounts Chart of Accounts Client	`I_CNSLDTNJRNLENTRITEM.CHARTOFACCOUNTS == T004.KTOPL` `I_CNSLDTNJRNLENTRITEM.MANDT == T004.MANDT`
Controlling Area Client Controlling Area	`I_CNSLDTNJRNLENTRITEM.MANDT == TKA01.MANDT` `I_CNSLDTNJRNLENTRITEM.CONTROLLINGAREA == TKA01.KOKRS`
Customer Number Client Customer Number	`I_CNSLDTNJRNLENTRITEM.MANDT == KNA1.MANDT` `I_CNSLDTNJRNLENTRITEM.CUSTOMER == KNA1.KUNNR`
Customer Group Customer Group Client	`I_CNSLDTNJRNLENTRITEM.CUSTOMERGROUP == T151.KDGRP` `I_CNSLDTNJRNLENTRITEM.MANDT == T151.MANDT`
Country/Region Key Country/Region Key Client	`I_CNSLDTNJRNLENTRITEM.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `I_CNSLDTNJRNLENTRITEM.MANDT == T005.MANDT`
Industry key Industry key Client	`I_CNSLDTNJRNLENTRITEM.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH` `I_CNSLDTNJRNLENTRITEM.MANDT == T016.MANDT`
Distribution Channel Client Distribution Channel	`I_CNSLDTNJRNLENTRITEM.MANDT == TVTW.MANDT` `I_CNSLDTNJRNLENTRITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Material Number Material Number Client	`I_CNSLDTNJRNLENTRITEM.MATERIAL == MARA.MATNR` `I_CNSLDTNJRNLENTRITEM.MANDT == MARA.MANDT`
Material Group Material Group Client	`I_CNSLDTNJRNLENTRITEM.MATERIALGROUP == T023.MATKL` `I_CNSLDTNJRNLENTRITEM.MANDT == T023.MANDT`
Order Number Order Number Client	`I_CNSLDTNJRNLENTRITEM.ORDERID == AUFK.AUFNR` `I_CNSLDTNJRNLENTRITEM.MANDT == AUFK.MANDT`
Division Client Division	`I_CNSLDTNJRNLENTRITEM.MANDT == TSPA.MANDT` `I_CNSLDTNJRNLENTRITEM.ORGANIZATIONDIVISION == TSPA.SPART`
Trading partner's business area Client Trading partner's business area	`I_CNSLDTNJRNLENTRITEM.MANDT == TGSB.MANDT` `I_CNSLDTNJRNLENTRITEM.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Client Company ID of Trading Partner	`I_CNSLDTNJRNLENTRITEM.MANDT == T880.MANDT` `I_CNSLDTNJRNLENTRITEM.PARTNERCOMPANY == T880.RCOMP`
Sender cost center Client ? Controlling Area Sender cost center	`I_CNSLDTNJRNLENTRITEM.MANDT == CSKS.MANDT` `I_CNSLDTNJRNLENTRITEM.[column in domain "DATBI"] == CSKS.DATBI` `I_CNSLDTNJRNLENTRITEM.CONTROLLINGAREA == CSKS.KOKRS` `I_CNSLDTNJRNLENTRITEM.PARTNERCOSTCENTER == CSKS.KOSTL`
Partner Functional Area Client Partner Functional Area	`I_CNSLDTNJRNLENTRITEM.MANDT == TFKB.MANDT` `I_CNSLDTNJRNLENTRITEM.PARTNERFUNCTIONALAREA == TFKB.FKBER`
Partner Profit Center Partner Profit Center Client ? Controlling Area	`I_CNSLDTNJRNLENTRITEM.PARTNERPROFITCENTER == CEPC.PRCTR` `I_CNSLDTNJRNLENTRITEM.MANDT == CEPC.MANDT` `I_CNSLDTNJRNLENTRITEM.[column in domain "DATBI"] == CEPC.DATBI` `I_CNSLDTNJRNLENTRITEM.CONTROLLINGAREA == CEPC.KOKRS`
Partner Segment for Segmental Reporting Client Partner Segment for Segmental Reporting	`I_CNSLDTNJRNLENTRITEM.MANDT == FAGL_SEGM.MANDT` `I_CNSLDTNJRNLENTRITEM.PARTNERSEGMENT == FAGL_SEGM.SEGMENT`
Plant Client Plant	`I_CNSLDTNJRNLENTRITEM.MANDT == T001W.MANDT` `I_CNSLDTNJRNLENTRITEM.PLANT == T001W.WERKS`
Sales District Client Sales District	`I_CNSLDTNJRNLENTRITEM.MANDT == T171.MANDT` `I_CNSLDTNJRNLENTRITEM.SALESDISTRICT == T171.BZIRK`
Sales Organization Client Sales Organization	`I_CNSLDTNJRNLENTRITEM.MANDT == TVKO.MANDT` `I_CNSLDTNJRNLENTRITEM.SALESORGANIZATION == TVKO.VKORG`
Ship-to Party Client Ship-to Party	`I_CNSLDTNJRNLENTRITEM.MANDT == KNA1.MANDT` `I_CNSLDTNJRNLENTRITEM.SHIPTOPARTY == KNA1.KUNNR`
Product Sold Product Sold Product Sold Client	`I_CNSLDTNJRNLENTRITEM.SOLDPRODUCT == MARA.MATNR` `I_CNSLDTNJRNLENTRITEM.SOLDMATERIAL == MARA.MATNR` `I_CNSLDTNJRNLENTRITEM.MANDT == MARA.MANDT`
Product Sold Product Sold Product Sold Client	`I_CNSLDTNJRNLENTRITEM.SOLDPRODUCT == MARA.MATNR` `I_CNSLDTNJRNLENTRITEM.SOLDMATERIAL == MARA.MATNR` `I_CNSLDTNJRNLENTRITEM.MANDT == MARA.MANDT`
Product Sold Group Client Product Sold Group	`I_CNSLDTNJRNLENTRITEM.MANDT == T023.MANDT` `I_CNSLDTNJRNLENTRITEM.SOLDPRODUCTGROUP == T023.MATKL`
Account Number of Supplier Client Account Number of Supplier	`I_CNSLDTNJRNLENTRITEM.MANDT == LFA1.MANDT` `I_CNSLDTNJRNLENTRITEM.SUPPLIER == LFA1.LIFNR`