P_IJE_LOG_DETAIL_PRE

Import Journal Entries Log Details | view: PIJELOGPRE | Extraction: Not supported | Component: S/4HANA Financial Consolidation, Core Processing
Tables used: ACDOCU
Column Name Description
cnsldtnledger FK Ledger
cnsldtndimension FK Dimension
fiscalyear Fiscal Year
cnsldtndocumentnumber Document Number of an Accounting Document
cnsldtnpostingitem Six-Character Posting Item for Ledger
Column Name Description
💲 Currency Key (transactioncurrency):
AmountInTransactionCurrency Value in Transaction Currency
💲 Currency key of the local currency (CnsldtnLocalCurrency):
AmountInCnsldtnLocalCrcy Value in Local Currency
💲 Currency key of the ledger currency (CnsldtnGroupCurrency):
AmountInCnsldtnGroupCrcy Value in Group Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
PostingDate Posting Date in the Document
CnsldtnCrcyTranslationDate 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
CnsldtnPostingLevel Posting Level Show values
CnsldtnApportionment Apportionment Show values
CnsldtnCrcyCnvrsnDiffType Currency Translation Show values
CnsldtnRefDocumentType Document Category Show values
CnsldtnInvmtActivityType Consolidation of Investments Activity Show values
Column Name Description Domain name
FiscalPeriod Posting period POPER
CnsldtnAcquisitionYear Year of Acquisition GJAHR
CnsldtnAcquisitionPeriod Period of Acquisition NUM03
DocumentItemText Item Text TEXT50
CnsldtnIsAutoPosting Indicator: Automatic posting lines TEXT1
CnsldtnBusinessTransactionType Business Transaction CHAR4
CnsldtnRefAcctgDocument Document Number of an Accounting Document BELNR
CnsldtnRefFiscalYear Original Fiscal Year GJAHR
CnsldtnRefAcctgDocItem Six-figure number of line item BUZEI6
CnsldtnRefBusTransType Business Transaction CHAR4
CnsldtnReverseDocument Reverse Document Number BELNR
CnsldtnReversedDocument Number of Reversed Document BELNR
CnsldtnInvmtActivity Consolidation of Investments Activity Number BELNR
CnsldtnDocReversalYear 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
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSNR
Project Project definition PS_PSPID
CustomerSupplierCorporateGroup Group key KONZS
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_IJE_LOG_DETAIL_PRE.MANDT == T006.MANDT
  • P_IJE_LOG_DETAIL_PRE.BASEUNIT == T006.MSEHI
Billing Type
  • Billing Type
  • Client
  • P_IJE_LOG_DETAIL_PRE.BILLINGDOCUMENTTYPE == TVFK.FKART
  • P_IJE_LOG_DETAIL_PRE.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_IJE_LOG_DETAIL_PRE.BILLTOPARTY == KNA1.KUNNR
  • P_IJE_LOG_DETAIL_PRE.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • P_IJE_LOG_DETAIL_PRE.BUSINESSAREA == TGSB.GSBER
  • P_IJE_LOG_DETAIL_PRE.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_IJE_LOG_DETAIL_PRE.CHARTOFACCOUNTS == T004.KTOPL
  • P_IJE_LOG_DETAIL_PRE.MANDT == T004.MANDT
Consolidation Chart of Accounts
  • Consolidation Chart of Accounts
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNCHARTOFACCOUNTS == TF120.ITCLG
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF120.MANDT
Dimension
  • Dimension
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNDIMENSION == TF150.DIMEN
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF150.MANDT
Document Type
  • Document Type
  • Dimension
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNDOCUMENTTYPE == TF500.DOCTY
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNDIMENSION == TF500.DIMEN
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF500.MANDT
Financial Statement Item
  • Financial Statement Item
  • Consolidation Chart of Accounts
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNFINSTMNTITM == TF100.ITEM
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNCHARTOFACCOUNTS == TF100.ITCLG
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF100.MANDT
Subitem
  • Subitem Category
  • Subitem
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNFINSTMNTSUBITMCAT == TF115.SITYP
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNFINSTMNTSUBITM == TF115.SITEM
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF115.MANDT
Subitem Category
  • Subitem Category
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNFINSTMNTSUBITMCAT == TF110.SITYP
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF110.MANDT
Consolidation Group
  • Dimension
  • Consolidation Group
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNDIMENSION == TF180.DIMEN
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNGROUP == TF180.CONGR
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF180.MANDT
Investee Unit
  • Dimension
  • Investee Unit
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNDIMENSION == TF160.DIMEN
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNINVESTEEUNIT == TF160.BUNIT
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF160.MANDT
Ledger
  • Client
  • Ledger
  • P_IJE_LOG_DETAIL_PRE.MANDT == T881.MANDT
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNLEDGER == T881.RLDNR
Partner Unit
  • Dimension
  • Partner Unit
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNDIMENSION == TF160.DIMEN
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNPARTNERUNIT == TF160.BUNIT
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF160.MANDT
Consolidation Unit
  • Dimension
  • Consolidation Unit
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNDIMENSION == TF160.DIMEN
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNUNIT == TF160.BUNIT
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF160.MANDT
Consolidation Version
  • Consolidation Version
  • Client
  • P_IJE_LOG_DETAIL_PRE.CNSLDTNVERSION == TF200.RVERS
  • P_IJE_LOG_DETAIL_PRE.MANDT == TF200.MANDT
Company
  • Company
  • Client
  • P_IJE_LOG_DETAIL_PRE.COMPANY == T880.RCOMP
  • P_IJE_LOG_DETAIL_PRE.MANDT == T880.MANDT
Original company code
  • Client
  • Original company code
  • P_IJE_LOG_DETAIL_PRE.MANDT == T001.MANDT
  • P_IJE_LOG_DETAIL_PRE.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • P_IJE_LOG_DETAIL_PRE.CONTROLLINGAREA == TKA01.KOKRS
  • P_IJE_LOG_DETAIL_PRE.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • ?
  • Client
  • P_IJE_LOG_DETAIL_PRE.CONTROLLINGAREA == CSKS.KOKRS
  • P_IJE_LOG_DETAIL_PRE.COSTCENTER == CSKS.KOSTL
  • P_IJE_LOG_DETAIL_PRE.[column in domain "DATBI"] == CSKS.DATBI
  • P_IJE_LOG_DETAIL_PRE.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • P_IJE_LOG_DETAIL_PRE.CUSTOMER == KNA1.KUNNR
  • P_IJE_LOG_DETAIL_PRE.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • P_IJE_LOG_DETAIL_PRE.CUSTOMERGROUP == T151.KDGRP
  • P_IJE_LOG_DETAIL_PRE.MANDT == T151.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_IJE_LOG_DETAIL_PRE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_IJE_LOG_DETAIL_PRE.MANDT == T005.MANDT
Industry key
  • Industry key
  • Client
  • P_IJE_LOG_DETAIL_PRE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • P_IJE_LOG_DETAIL_PRE.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • P_IJE_LOG_DETAIL_PRE.MANDT == TVTW.MANDT
  • P_IJE_LOG_DETAIL_PRE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Plant
  • Client
  • Plant
  • P_IJE_LOG_DETAIL_PRE.MANDT == T001W.MANDT
  • P_IJE_LOG_DETAIL_PRE.FINANCIALTRANSACTIONTYPE == T001W.WERKS
Functional Area
  • Client
  • Functional Area
  • P_IJE_LOG_DETAIL_PRE.MANDT == TFKB.MANDT
  • P_IJE_LOG_DETAIL_PRE.FUNCTIONALAREA == TFKB.FKBER
Account Number
  • Account Number
  • Client
  • Original company code
  • P_IJE_LOG_DETAIL_PRE.GLACCOUNT == SKB1.SAKNR
  • P_IJE_LOG_DETAIL_PRE.MANDT == SKB1.MANDT
  • P_IJE_LOG_DETAIL_PRE.COMPANYCODE == SKB1.BUKRS
Material Number
  • Material Number
  • Client
  • P_IJE_LOG_DETAIL_PRE.MATERIAL == MARA.MATNR
  • P_IJE_LOG_DETAIL_PRE.MANDT == MARA.MANDT
Order Number
  • Order Number
  • Client
  • P_IJE_LOG_DETAIL_PRE.ORDERID == AUFK.AUFNR
  • P_IJE_LOG_DETAIL_PRE.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • P_IJE_LOG_DETAIL_PRE.ORGANIZATIONDIVISION == TSPA.SPART
  • P_IJE_LOG_DETAIL_PRE.MANDT == TSPA.MANDT
Trading partner's business area
  • Trading partner's business area
  • Client
  • P_IJE_LOG_DETAIL_PRE.PARTNERBUSINESSAREA == TGSB.GSBER
  • P_IJE_LOG_DETAIL_PRE.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_IJE_LOG_DETAIL_PRE.PARTNERCOMPANY == T880.RCOMP
  • P_IJE_LOG_DETAIL_PRE.MANDT == T880.MANDT
Sender cost center
  • Controlling Area
  • Sender cost center
  • ?
  • Client
  • P_IJE_LOG_DETAIL_PRE.CONTROLLINGAREA == CSKS.KOKRS
  • P_IJE_LOG_DETAIL_PRE.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_IJE_LOG_DETAIL_PRE.[column in domain "DATBI"] == CSKS.DATBI
  • P_IJE_LOG_DETAIL_PRE.MANDT == CSKS.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_IJE_LOG_DETAIL_PRE.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • P_IJE_LOG_DETAIL_PRE.MANDT == TFKB.MANDT
Partner Profit Center
  • Partner Profit Center
  • Controlling Area
  • ?
  • Client
  • P_IJE_LOG_DETAIL_PRE.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_IJE_LOG_DETAIL_PRE.CONTROLLINGAREA == CEPC.KOKRS
  • P_IJE_LOG_DETAIL_PRE.[column in domain "DATBI"] == CEPC.DATBI
  • P_IJE_LOG_DETAIL_PRE.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_IJE_LOG_DETAIL_PRE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • P_IJE_LOG_DETAIL_PRE.MANDT == FAGL_SEGM.MANDT
Material Group
  • Material Group
  • Client
  • P_IJE_LOG_DETAIL_PRE.PLANT == T023.MATKL
  • P_IJE_LOG_DETAIL_PRE.MANDT == T023.MANDT
Profit Center
  • Profit Center
  • Controlling Area
  • ?
  • Client
  • P_IJE_LOG_DETAIL_PRE.PROFITCENTER == CEPC.PRCTR
  • P_IJE_LOG_DETAIL_PRE.CONTROLLINGAREA == CEPC.KOKRS
  • P_IJE_LOG_DETAIL_PRE.[column in domain "DATBI"] == CEPC.DATBI
  • P_IJE_LOG_DETAIL_PRE.MANDT == CEPC.MANDT
Sales District
  • Sales District
  • Client
  • P_IJE_LOG_DETAIL_PRE.SALESDISTRICT == T171.BZIRK
  • P_IJE_LOG_DETAIL_PRE.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • P_IJE_LOG_DETAIL_PRE.SALESORGANIZATION == TVKO.VKORG
  • P_IJE_LOG_DETAIL_PRE.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_IJE_LOG_DETAIL_PRE.SEGMENT == FAGL_SEGM.SEGMENT
  • P_IJE_LOG_DETAIL_PRE.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • P_IJE_LOG_DETAIL_PRE.SHIPTOPARTY == KNA1.KUNNR
  • P_IJE_LOG_DETAIL_PRE.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • P_IJE_LOG_DETAIL_PRE.SOLDPRODUCT == MARA.MATNR
  • P_IJE_LOG_DETAIL_PRE.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • P_IJE_LOG_DETAIL_PRE.SOLDPRODUCTGROUP == T023.MATKL
  • P_IJE_LOG_DETAIL_PRE.MANDT == T023.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_IJE_LOG_DETAIL_PRE.SUPPLIER == LFA1.LIFNR
  • P_IJE_LOG_DETAIL_PRE.MANDT == LFA1.MANDT
Currency Key
  • Currency Key
  • Client
  • P_IJE_LOG_DETAIL_PRE.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_IJE_LOG_DETAIL_PRE.MANDT == TCURC.MANDT
User Name
  • User Name
  • Client
  • P_IJE_LOG_DETAIL_PRE.USERID == USR02.BNAME
  • P_IJE_LOG_DETAIL_PRE.MANDT == USR02.MANDT
Transaction type
  • Transaction type
  • Client
  • P_IJE_LOG_DETAIL_PRE.WBSELEMENTINTERNALID == T856.TRTYP
  • P_IJE_LOG_DETAIL_PRE.MANDT == T856.MANDT