C_SameGLAcctAmtJrnlEntrItm

Same G/L Account and Amount JE Item | view: CGRCSAMEACCTAMT | Extraction: Not supported | Component: Information System
Tables used: ACDOCABKPFT001TKA02TKA01T000USR21ADCPADR2ADR3ADR6ADRPUSR21
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
JournalEntry Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
CreationDate Creation Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
NmbrOfDplJournalEntryItem null
AccountingDocumentHeaderText Document Header Text TEXT25
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
TransactionCode Transaction Code TCODE
ReverseDocument Reverse Document BELNR
DocumentReferenceID Document Reference ID XBLNR1
ControllingAreaName Controlling Area Name TEXT25
LastChangeDateTime Time Stamp of Last Change TZNTSTMPS
LedgerFiscalYear Ledger Fiscal Year GJAHR
CompanyCodeName Name of Company Code or Company TEXT25
FullName Full Name of Person TEXT80
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == T003.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == T004.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == T001.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == TCURC.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == TKA01.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == CSKS.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.COSTCENTER == CSKS.KOSTL
  • C_SAMEGLACCTAMTJRNLENTRITM.[column in domain "DATBI"] == CSKS.DATBI
  • C_SAMEGLACCTAMTJRNLENTRITM.CONTROLLINGAREA == CSKS.KOKRS
Customer Number
  • Client
  • Customer Number
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == KNA1.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.CUSTOMER == KNA1.KUNNR
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == T009.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.FISCALYEARVARIANT == T009.PERIV
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == SKB1.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.GLACCOUNT == SKB1.SAKNR
  • C_SAMEGLACCTAMTJRNLENTRITM.COMPANYCODE == SKB1.BUKRS
Ledger
  • Client
  • Ledger
Profit Center
  • Client
  • Profit Center
  • ?
  • Controlling Area
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == CEPC.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.PROFITCENTER == CEPC.PRCTR
  • C_SAMEGLACCTAMTJRNLENTRITM.[column in domain "DATBI"] == CEPC.DATBI
  • C_SAMEGLACCTAMTJRNLENTRITM.CONTROLLINGAREA == CEPC.KOKRS
Reference Document Type C_SAMEGLACCTAMTJRNLENTRITM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Supplier
  • Client
  • Supplier
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == LFA1.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • C_SAMEGLACCTAMTJRNLENTRITM.MANDT == TCURC.MANDT
  • C_SAMEGLACCTAMTJRNLENTRITM.TRANSACTIONCURRENCY == TCURC.WAERS