P_GLAcctLineItemEnrcd

GLAccount Line Items Enriched | view: PGLACCTLINEITEME | Extraction: Not supported | Component: Financials China
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
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 Credit 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
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
DebitAmountInGlobalCrcy Debit Amount in Global Currency
CreditAmountInGlobalCrcy Credit Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
DebitAmountInFreeDefinedCrcy1 Debit Amount in Free Defined Currency 1
CreditAmountInFreeDefinedCrcy1 Credit Amount in Free Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
DebitAmountInFreeDefinedCrcy2 Debit Amount in Free Defined Currency 2
CreditAmountInFreeDefinedCrcy2 Credit Amount in Free Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
DebitAmountInFreeDefinedCrcy3 Debit Amount in Free Defined Currency 3
CreditAmountInFreeDefinedCrcy3 Credit Amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
DebitAmountInFreeDefinedCrcy4 Debit Amount in Free Defined Currency 4
CreditAmountInFreeDefinedCrcy4 Credit Amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
DebitAmountInFreeDefinedCrcy5 Debit Amount in Free Defined Currency 5
CreditAmountInFreeDefinedCrcy5 Credit Amount in Free Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
DebitAmountInFreeDefinedCrcy6 Debit Amount in Free Defined Currency 6
CreditAmountInFreeDefinedCrcy6 Credit Amount in Free Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
DebitAmountInFreeDefinedCrcy7 Debit Amount in Free Defined Currency 7
CreditAmountInFreeDefinedCrcy7 Credit Amount in Free Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
DebitAmountInFreeDefinedCrcy8 Debit Amount in Free Defined Currency 8
CreditAmountInFreeDefinedCrcy8 Credit Amount in Free Defined Currency 8
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ClearingDate Clearing Date
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
AssignmentReference Assignment Reference ZUONR
IsCleared null
DocumentItemText Item Text TEXT50
ClearingAccountingDocument Clearing Journal Entry BELNR
AlternativeReferenceDocument Alternative Reference Number XBLNR_ALT
AccountingDocumentHeaderText Document Header Text TEXT25
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_GLACCTLINEITEMENRCD.MANDT == T003.MANDT
  • P_GLACCTLINEITEMENRCD.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Business Area
  • Business Area
  • Client
  • P_GLACCTLINEITEMENRCD.BUSINESSAREA == TGSB.GSBER
  • P_GLACCTLINEITEMENRCD.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • P_GLACCTLINEITEMENRCD.MANDT == T001.MANDT
  • P_GLACCTLINEITEMENRCD.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
  • P_GLACCTLINEITEMENRCD.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • P_GLACCTLINEITEMENRCD.CUSTOMER == KNA1.KUNNR
  • P_GLACCTLINEITEMENRCD.MANDT == KNA1.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
  • P_GLACCTLINEITEMENRCD.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
  • P_GLACCTLINEITEMENRCD.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_GLACCTLINEITEMENRCD.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
  • P_GLACCTLINEITEMENRCD.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
  • P_GLACCTLINEITEMENRCD.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
  • P_GLACCTLINEITEMENRCD.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
  • P_GLACCTLINEITEMENRCD.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
  • P_GLACCTLINEITEMENRCD.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_GLACCTLINEITEMENRCD.MANDT == SKB1.MANDT
  • P_GLACCTLINEITEMENRCD.GLACCOUNT == SKB1.SAKNR
  • P_GLACCTLINEITEMENRCD.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
  • P_GLACCTLINEITEMENRCD.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Profit Center
  • Profit Center
  • ?
  • ?
  • Client
  • P_GLACCTLINEITEMENRCD.PROFITCENTER == CEPC.PRCTR
  • P_GLACCTLINEITEMENRCD.[column in domain "DATBI"] == CEPC.DATBI
  • P_GLACCTLINEITEMENRCD.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_GLACCTLINEITEMENRCD.MANDT == CEPC.MANDT
Special G/L Indicator
  • Special G/L Indicator
  • Client
  • Account Type
  • P_GLACCTLINEITEMENRCD.SPECIALGLCODE == T074U.UMSKZ
  • P_GLACCTLINEITEMENRCD.MANDT == T074U.MANDT
  • P_GLACCTLINEITEMENRCD.FINANCIALACCOUNTTYPE == T074U.KOART
Supplier
  • Supplier
  • Client
  • P_GLACCTLINEITEMENRCD.SUPPLIER == LFA1.LIFNR
  • P_GLACCTLINEITEMENRCD.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • P_GLACCTLINEITEMENRCD.MANDT == TCURC.MANDT
  • P_GLACCTLINEITEMENRCD.TRANSACTIONCURRENCY == TCURC.WAERS