P_GLAcctBalance01

CDS Views for GL Account Line Items in a specific Peirod | view: PGLACCTBAL01 | Extraction: Not supported | Component: Localization Financials Statements
Tables used: SCAL_TT_DATE, ACDOCA, FINSC_LD_CMP, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmtInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmtInCoCodeCrcy Credit Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
DebitAmtInGlobalCrcy Debit Amount in Global Currency
CreditAmtInGlobalCrcy Credit Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
DebitAmtInFreeDefinedCrcy1 Debit Amount in Free Defined Currency 1
CreditAmtInFreeDefinedCrcy1 Credit Amount in Free Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
DebitAmtInFreeDefinedCrcy2 Debit Amount in Free Defined Currency 2
CreditAmtInFreeDefinedCrcy2 Credit Amount in Free Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
DebitAmtInFreeDefinedCrcy3 Debit Amount in Free Defined Currency 3
CreditAmtInFreeDefinedCrcy3 Credit Amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
DebitAmtInFreeDefinedCrcy4 Debit Amount in Free Defined Currency 4
CreditAmtInFreeDefinedCrcy4 Credit Amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
DebitAmtInFreeDefinedCrcy5 Debit Amount in Free Defined Currency 5
CreditAmtInFreeDefinedCrcy5 Credit Amount in Free Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
DebitAmtInFreeDefinedCrcy6 Debit Amount in Free Defined Currency 6
CreditAmtInFreeDefinedCrcy6 Credit Amount in Free Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
DebitAmtInFreeDefinedCrcy7 Debit Amount in Free Defined Currency 7
CreditAmtInFreeDefinedCrcy7 Credit Amount in Free Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
DebitAmtInFreeDefinedCrcy8 Debit Amount in Free Defined Currency 8
CreditAmtInFreeDefinedCrcy8 Credit Amount in Free Defined Currency 8
💲 Functional Currency (FunctionalCurrency):
DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
GLAccountType Type of a General Ledger Account Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
WBSElement WBS Element FIS_WBS
FunctionalCurrencyRole Functional Currency Role (Currency Type) FINS_CURTYPE
PeriodFlag null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_GLACCTBALANCE01.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_GLACCTBALANCE01.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Client
  • Alternative Chart of Accounts for Country/Region
  • P_GLACCTBALANCE01.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • P_GLACCTBALANCE01.MANDT == SKA1.MANDT
  • P_GLACCTBALANCE01.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
Business Area
  • Client
  • Business Area
  • P_GLACCTBALANCE01.MANDT == TGSB.MANDT
  • P_GLACCTBALANCE01.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_GLACCTBALANCE01.CHARTOFACCOUNTS == T004.KTOPL
  • P_GLACCTBALANCE01.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_GLACCTBALANCE01.COMPANYCODE == T001.BUKRS
  • P_GLACCTBALANCE01.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
  • P_GLACCTBALANCE01.COMPANYCODECURRENCY == TCURC.WAERS
Company Code Currency Role
  • Company Code Currency Role
  • Client
Controlling Area
  • Client
  • Controlling Area
  • P_GLACCTBALANCE01.MANDT == TKA01.MANDT
  • P_GLACCTBALANCE01.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Cost Center
  • Client
  • Controlling Area
  • ?
  • P_GLACCTBALANCE01.COSTCENTER == CSKS.KOSTL
  • P_GLACCTBALANCE01.MANDT == CSKS.MANDT
  • P_GLACCTBALANCE01.CONTROLLINGAREA == CSKS.KOKRS
  • P_GLACCTBALANCE01.[column in domain "DATBI"] == CSKS.DATBI
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • P_GLACCTBALANCE01.MANDT == T004.MANDT
  • P_GLACCTBALANCE01.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
  • P_GLACCTBALANCE01.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 1 Role (Currency Type)
  • Freely Defined Currency 1 Role (Currency Type)
  • Client
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
  • P_GLACCTBALANCE01.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 2 Role (Currency Type)
  • Freely Defined Currency 2 Role (Currency Type)
  • Client
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_GLACCTBALANCE01.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
Freely Defined Currency 3 Role (Currency Type)
  • Client
  • Freely Defined Currency 3 Role (Currency Type)
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_GLACCTBALANCE01.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
Freely Defined Currency 4 Role (Currency Type)
  • Client
  • Freely Defined Currency 4 Role (Currency Type)
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
  • P_GLACCTBALANCE01.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 5 Role (Currency Type)
  • Freely Defined Currency 5 Role (Currency Type)
  • Client
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
  • P_GLACCTBALANCE01.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 6 Role (Currency Type)
  • Freely Defined Currency 6 Role (Currency Type)
  • Client
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
  • P_GLACCTBALANCE01.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 7 Role (Currency Type)
  • Freely Defined Currency 7 Role (Currency Type)
  • Client
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
  • P_GLACCTBALANCE01.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Freely Defined Currency 8 Role (Currency Type)
  • Freely Defined Currency 8 Role (Currency Type)
  • Client
Functional Area
  • Client
  • Functional Area
  • P_GLACCTBALANCE01.MANDT == TFKB.MANDT
  • P_GLACCTBALANCE01.FUNCTIONALAREA == TFKB.FKBER
Functional Currency
  • Client
  • Functional Currency
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
  • P_GLACCTBALANCE01.FUNCTIONALCURRENCY == TCURC.WAERS
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_GLACCTBALANCE01.GLACCOUNT == SKB1.SAKNR
  • P_GLACCTBALANCE01.COMPANYCODE == SKB1.BUKRS
  • P_GLACCTBALANCE01.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • P_GLACCTBALANCE01.GLOBALCURRENCY == TCURC.WAERS
  • P_GLACCTBALANCE01.MANDT == TCURC.MANDT
Global Currency Role
  • Global Currency Role
  • Client
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_GLACCTBALANCE01.MANDT == T880.MANDT
  • P_GLACCTBALANCE01.PARTNERCOMPANY == T880.RCOMP
Profit Center
  • Profit Center
  • Client
  • Controlling Area
  • ?
  • P_GLACCTBALANCE01.PROFITCENTER == CEPC.PRCTR
  • P_GLACCTBALANCE01.MANDT == CEPC.MANDT
  • P_GLACCTBALANCE01.CONTROLLINGAREA == CEPC.KOKRS
  • P_GLACCTBALANCE01.[column in domain "DATBI"] == CEPC.DATBI
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_GLACCTBALANCE01.MANDT == FAGL_SEGM.MANDT
  • P_GLACCTBALANCE01.SEGMENT == FAGL_SEGM.SEGMENT