C_CnsldtnJrnlEntryItemTP

Journal Entry Item | view: CCSJRNLENTRITP | TRAN | Extraction: Not supported | Component: S4HANA Financial Consolidation[Cloud]
Tables used: ACDOCU, ACDOCU, ACDOCU, TF121, FINCS_FSITEMT, T000, TF160, TF162, FINCS_BUNIT_ATVD, TF161, FINCS_BUNITT, FINCS_BUNIT, TF200, TF506, TF004, TF001
Column Name Description
FiscalYear Fiscal Year
ConsolidationLedger FK Ledger
ConsolidationDocumentNumber Document Number of an Accounting Document
ConsolidationPostingItem Six-Character Posting Item for Ledger
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
CurrencyTranslationDate Value Date for Currency Translation
CreationDate Day On Which Accounting Document Was Entered
CreationTime Time of Entry
PostingDate Posting Date in the Document
Column Name Description
ConsolidationUnit1IsUsed Consolidation unit 1 chosen Show values
GLRecordType Record Type 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
InvestmentActivityTypeText Consolidation of Investments Activity Show values
Column Name Description Domain name
FiscalYearForEdit Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ConsolidationUnitMdmText Short description TEXT20
ConsolidationChartOfAcctsText Description TEXT30
FinancialStatementItemMdmText Description TEXT50
PartnerCnsldtnUnitMediumText Short description TEXT20
ConsolidationAcquisitionYear Year of Acquisition GJAHR
ConsolidationAcquisitionPeriod Period of Acquisition NUM03
InvesteeConsolidationUnitText Short description TEXT20
DocumentItemText Item Text TEXT50
ConsolidationPostgItemAutoFlag Indicator: Automatic posting lines TEXT1
BusinessTransactionType Business Transaction CHAR4
ReferenceFiscalYear Original Fiscal Year GJAHR
RefConsolidationDocumentNumber Document Number of an Accounting Document BELNR
RefConsolidationPostingItem Six-figure number of line item BUZEI6
RefBusinessTransactionType Business Transaction CHAR4
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
AssignmentReference Assignment number ZUONR
WBSElementInternalID Work Breakdown Structure Element (WBS Element)
WBSElementExternalID Work Breakdown Structure Element (WBS Element)
Project Project definition PS_PSPID
CustomerSupplierCorporateGroup Group key KONZS
CnsldtnUnit3Text Short description TEXT20
PartnerCnsldtnUnit3Text Short description TEXT20
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T006.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.BASEUNIT == T006.MSEHI
Billing Type
  • Billing Type
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.BILLINGDOCUMENTTYPE == TVFK.FKART
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.BILLTOPARTY == KNA1.KUNNR
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.BUSINESSAREA == TGSB.GSBER
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.CHARTOFACCOUNTS == T004.KTOPL
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T004.MANDT
Company
  • Company
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.COMPANY == T880.RCOMP
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T880.MANDT
Original company code
  • Client
  • Original company code
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T001.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.COMPANYCODE == T001.BUKRS
Consolidation Chart of Accounts
  • Consolidation Chart of Accounts
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF120.MANDT
Dimension
  • Client
  • Dimension
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF150.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONDIMENSION == TF150.DIMEN
Document Type
  • Client
  • Dimension
  • Document Type
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF500.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONDIMENSION == TF500.DIMEN
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY
Consolidation Group
  • Consolidation Group
  • Client
  • Dimension
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONGROUP == TF180.CONGR
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF180.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONDIMENSION == TF180.DIMEN
Ledger
  • Client
  • Ledger
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T881.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONLEDGER == T881.RLDNR
Consolidation Unit
  • Consolidation Unit
  • Consolidation Unit
  • Client
  • Dimension
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONUNIT3 == TF160.BUNIT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONUNIT == TF160.BUNIT
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF160.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONDIMENSION == TF160.DIMEN
Consolidation Unit
  • Consolidation Unit
  • Consolidation Unit
  • Client
  • Dimension
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONUNIT3 == TF160.BUNIT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONUNIT == TF160.BUNIT
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF160.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONDIMENSION == TF160.DIMEN
Consolidation Version
  • Client
  • Consolidation Version
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF200.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONVERSION == TF200.RVERS
Controlling Area
  • Controlling Area
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.CONTROLLINGAREA == TKA01.KOKRS
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Client
  • Cost Center
  • C_CNSLDTNJRNLENTRYITEMTP.CONTROLLINGAREA == CSKS.KOKRS
  • C_CNSLDTNJRNLENTRYITEMTP.[column in domain "DATBI"] == CSKS.DATBI
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == CSKS.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.CUSTOMER == KNA1.KUNNR
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.CUSTOMERGROUP == T151.KDGRP
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T151.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T005.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
Industry key
  • Industry key
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TVTW.MANDT
Financial Statement Item
  • Consolidation Chart of Accounts
  • Client
  • Financial Statement Item
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONCHARTOFACCOUNTS == TF100.ITCLG
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF100.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.FINANCIALSTATEMENTITEM == TF100.ITEM
Transaction type
  • Transaction type
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T856.MANDT
Functional Area
  • Functional Area
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.FUNCTIONALAREA == TFKB.FKBER
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TFKB.MANDT
Account Number
  • Account Number
  • Client
  • Original company code
  • C_CNSLDTNJRNLENTRYITEMTP.GLACCOUNT == SKB1.SAKNR
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == SKB1.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.COMPANYCODE == SKB1.BUKRS
Investee Unit
  • Investee Unit
  • Client
  • Dimension
  • C_CNSLDTNJRNLENTRYITEMTP.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF160.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONDIMENSION == TF160.DIMEN
Material Number
  • Client
  • Material Number
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == MARA.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.MATERIALGROUP == T023.MATKL
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T023.MANDT
Order Number
  • Order Number
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.ORDERID == AUFK.AUFNR
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.ORGANIZATIONDIVISION == TSPA.SPART
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TSPA.MANDT
Trading partner's business area
  • Client
  • Trading partner's business area
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TGSB.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.PARTNERCOMPANY == T880.RCOMP
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T880.MANDT
Partner Unit
  • Partner Unit
  • Partner Unit
  • Client
  • Dimension
  • C_CNSLDTNJRNLENTRYITEMTP.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT
  • C_CNSLDTNJRNLENTRYITEMTP.PARTNERCONSOLIDATIONUNIT3 == TF160.BUNIT
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF160.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONDIMENSION == TF160.DIMEN
Partner Unit
  • Partner Unit
  • Partner Unit
  • Client
  • Dimension
  • C_CNSLDTNJRNLENTRYITEMTP.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT
  • C_CNSLDTNJRNLENTRYITEMTP.PARTNERCONSOLIDATIONUNIT3 == TF160.BUNIT
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF160.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.CONSOLIDATIONDIMENSION == TF160.DIMEN
Sender cost center
  • Controlling Area
  • ?
  • Sender cost center
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.CONTROLLINGAREA == CSKS.KOKRS
  • C_CNSLDTNJRNLENTRYITEMTP.[column in domain "DATBI"] == CSKS.DATBI
  • C_CNSLDTNJRNLENTRYITEMTP.PARTNERCOSTCENTER == CSKS.KOSTL
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == CSKS.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TFKB.MANDT
Partner Profit Center
  • Controlling Area
  • ?
  • Partner Profit Center
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.CONTROLLINGAREA == CEPC.KOKRS
  • C_CNSLDTNJRNLENTRYITEMTP.[column in domain "DATBI"] == CEPC.DATBI
  • C_CNSLDTNJRNLENTRYITEMTP.PARTNERPROFITCENTER == CEPC.PRCTR
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == FAGL_SEGM.MANDT
Plant
  • Plant
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.PLANT == T001W.WERKS
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T001W.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.PRODUCTGROUP == T023.MATKL
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T023.MANDT
Profit Center
  • Controlling Area
  • Profit Center
  • ?
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.CONTROLLINGAREA == CEPC.KOKRS
  • C_CNSLDTNJRNLENTRYITEMTP.PROFITCENTER == CEPC.PRCTR
  • C_CNSLDTNJRNLENTRYITEMTP.[column in domain "DATBI"] == CEPC.DATBI
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == CEPC.MANDT
Sales District
  • Sales District
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.SALESDISTRICT == T171.BZIRK
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == T171.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TVKO.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.SEGMENT == FAGL_SEGM.SEGMENT
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.SHIPTOPARTY == KNA1.KUNNR
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.SOLDMATERIAL == MARA.MATNR
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == MARA.MANDT
Subitem
  • Subitem
  • Client
  • Subitem Category
  • C_CNSLDTNJRNLENTRYITEMTP.SUBITEM == TF115.SITEM
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF115.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.SUBITEMCATEGORY == TF115.SITYP
Subitem Category
  • Client
  • Subitem Category
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TF110.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.SUBITEMCATEGORY == TF110.SITYP
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == LFA1.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.SUPPLIER == LFA1.LIFNR
Currency Key
  • Currency Key
  • Client
  • C_CNSLDTNJRNLENTRYITEMTP.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == TCURC.MANDT
User Name
  • Client
  • User Name
  • C_CNSLDTNJRNLENTRYITEMTP.MANDT == USR02.MANDT
  • C_CNSLDTNJRNLENTRYITEMTP.USERID == USR02.BNAME