P_CN_GLAcctItems

G/L Account Items | view: PVCNGLAITEMS | Extraction: Not supported | Component: Financials China
Column Name Description
CompanyCode FK Company Code
FiscalYear Ledger Fiscal Year
Ledger FK Ledger in General Ledger Accounting
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy null
AmountInDisplayCurrency Amount in Company Code Currency
DebitAmountInDisplayCrcy Debit Amount in Company Code Currency
CreditAmountInDisplayCrcy null
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
ValueDate Accounting Document Entry Date
DocumentDate Journal Entry Date
Column Name Description
AccountIsMarkedForDeletion Indicator: Account Marked for Deletion? Show values
Directon Debit/Credit Code Show values
AccountingDocumentCategory Document Status Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
AuthorizationGroup Authorization Group BRGRU
DisplayGLAccount G/L Account SAKNR
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
AssignmentReference Assignment Reference ZUONR
DocumentHeaderText Document Header Text TEXT25
ReferenceDocument Reference document number AWREF
ExchangeRate Character Field of Length 12 CHAR12
DocumentItemText Item Text TEXT50
AlternativeReferenceDocument Alternative Reference Number XBLNR_ALT
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_CN_GLACCTITEMS.MANDT == T003.MANDT
  • P_CN_GLACCTITEMS.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Business Area
  • Business Area
  • Client
  • P_CN_GLACCTITEMS.BUSINESSAREA == TGSB.GSBER
  • P_CN_GLACCTITEMS.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_CN_GLACCTITEMS.MANDT == T004.MANDT
  • P_CN_GLACCTITEMS.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_CN_GLACCTITEMS.COMPANYCODE == T001.BUKRS
  • P_CN_GLACCTITEMS.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_CN_GLACCTITEMS.MANDT == TKA01.MANDT
  • P_CN_GLACCTITEMS.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Cost Center
  • Controlling Area
  • P_CN_GLACCTITEMS.[column in domain "DATBI"] == CSKS.DATBI
  • P_CN_GLACCTITEMS.MANDT == CSKS.MANDT
  • P_CN_GLACCTITEMS.COSTCENTER == CSKS.KOSTL
  • P_CN_GLACCTITEMS.CONTROLLINGAREA == CSKS.KOKRS
Functional Area
  • Client
  • Functional Area
  • P_CN_GLACCTITEMS.MANDT == TFKB.MANDT
  • P_CN_GLACCTITEMS.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_CN_GLACCTITEMS.GLACCOUNT == SKB1.SAKNR
  • P_CN_GLACCTITEMS.COMPANYCODE == SKB1.BUKRS
  • P_CN_GLACCTITEMS.MANDT == SKB1.MANDT
G/L Account Group
  • G/L Account Group
  • Chart of Accounts
  • Client
  • P_CN_GLACCTITEMS.GLACCOUNTGROUP == T077S.KTOKS
  • P_CN_GLACCTITEMS.CHARTOFACCOUNTS == T077S.KTOPL
  • P_CN_GLACCTITEMS.MANDT == T077S.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Profit Center
  • Profit Center
  • ?
  • Client
  • Controlling Area
  • P_CN_GLACCTITEMS.PROFITCENTER == CEPC.PRCTR
  • P_CN_GLACCTITEMS.[column in domain "DATBI"] == CEPC.DATBI
  • P_CN_GLACCTITEMS.MANDT == CEPC.MANDT
  • P_CN_GLACCTITEMS.CONTROLLINGAREA == CEPC.KOKRS
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
Transaction Currency
  • Client
  • Transaction Currency
  • P_CN_GLACCTITEMS.MANDT == TCURC.MANDT
  • P_CN_GLACCTITEMS.TRANSACTIONCURRENCY == TCURC.WAERS