P_ActualPlanGLAcctBalance

Actual Plan G/L Account Balances | view: PFIACTPLNGLBAL | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, ACDOCA, ACDOCP, T004, T001, TKA02, T009, SKA1, HRRP_FSV_DIR, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
HslwoBCF Amount in Company Code Currency
HslonlyBCF Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
KslwoBCF Amount in Global Currency
KslonlyBCF Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
Column Name Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation Quantity
Column Name Description
ValidityEndDate FK Valid To Date
ValidityStartDate Valid-From Date
PostingDate Posting Date
CalendarDate Calendar Date
Column Name Description
ActualPlanCode Actual Plan Code Show values
GLAccountFlowType G/L Account Flow Type Show values
GLAccountTypeFlowType G/L Account Flow Type For G/L Account Type Show values
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
GLAccountType Type of a General Ledger Account Show values
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentCategory Journal Entry Category Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
PlanningCategory Plan Category FCOM_CATEGORY
OrderType Order Type AUFART
HierarchyNode Hierarchy node
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarYearQuarter Year Quarter NUM5
CalendarMonth Calendar Month NUM2
CalendarYearMonth Year Month NUM6
CalendarWeek Calendar Week NUM2
CalendarYearWeek Year Week NUM6
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalWeek Fiscal Week FINS_FISCALWEEK
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_ACTUALPLANGLACCTBALANCE.MANDT == T003.MANDT
  • P_ACTUALPLANGLACCTBALANCE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Asset Class
  • Client
  • Asset Class
  • P_ACTUALPLANGLACCTBALANCE.MANDT == ANKA.MANDT
  • P_ACTUALPLANGLACCTBALANCE.ASSETCLASS == ANKA.ANLKL
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_ACTUALPLANGLACCTBALANCE.MANDT == TCURC.MANDT
  • P_ACTUALPLANGLACCTBALANCE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Business Area
  • Client
  • Business Area
  • P_ACTUALPLANGLACCTBALANCE.MANDT == TGSB.MANDT
  • P_ACTUALPLANGLACCTBALANCE.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_ACTUALPLANGLACCTBALANCE.MANDT == T004.MANDT
  • P_ACTUALPLANGLACCTBALANCE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_ACTUALPLANGLACCTBALANCE.COMPANYCODE == T001.BUKRS
  • P_ACTUALPLANGLACCTBALANCE.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_ACTUALPLANGLACCTBALANCE.MANDT == TCURC.MANDT
  • P_ACTUALPLANGLACCTBALANCE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_ACTUALPLANGLACCTBALANCE.CONTROLLINGAREA == TKA01.KOKRS
  • P_ACTUALPLANGLACCTBALANCE.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • ?
  • Cost Center
  • P_ACTUALPLANGLACCTBALANCE.CONTROLLINGAREA == CSKS.KOKRS
  • P_ACTUALPLANGLACCTBALANCE.MANDT == CSKS.MANDT
  • P_ACTUALPLANGLACCTBALANCE.[column in domain "DATBI"] == CSKS.DATBI
  • P_ACTUALPLANGLACCTBALANCE.COSTCENTER == CSKS.KOSTL
Cost Source Unit
  • Client
  • Cost Source Unit
  • P_ACTUALPLANGLACCTBALANCE.MANDT == T006.MANDT
  • P_ACTUALPLANGLACCTBALANCE.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Client
  • Customer Number
  • P_ACTUALPLANGLACCTBALANCE.MANDT == KNA1.MANDT
  • P_ACTUALPLANGLACCTBALANCE.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Client
  • Distribution Channel
  • P_ACTUALPLANGLACCTBALANCE.MANDT == TVTW.MANDT
  • P_ACTUALPLANGLACCTBALANCE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_ACTUALPLANGLACCTBALANCE.FISCALYEARVARIANT == T009.PERIV
  • P_ACTUALPLANGLACCTBALANCE.MANDT == T009.MANDT
Asset Subnumber
  • Client
  • Asset Subnumber
  • Fixed Asset
  • ?
  • P_ACTUALPLANGLACCTBALANCE.MANDT == ANLA.MANDT
  • P_ACTUALPLANGLACCTBALANCE.FIXEDASSET == ANLA.ANLN2
  • P_ACTUALPLANGLACCTBALANCE.MASTERFIXEDASSET == ANLA.ANLN1
  • P_ACTUALPLANGLACCTBALANCE.[column in domain "BUKRS"] == ANLA.BUKRS
Functional Area
  • Client
  • Functional Area
  • P_ACTUALPLANGLACCTBALANCE.MANDT == TFKB.MANDT
  • P_ACTUALPLANGLACCTBALANCE.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_ACTUALPLANGLACCTBALANCE.GLACCOUNT == SKB1.SAKNR
  • P_ACTUALPLANGLACCTBALANCE.COMPANYCODE == SKB1.BUKRS
  • P_ACTUALPLANGLACCTBALANCE.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • P_ACTUALPLANGLACCTBALANCE.MANDT == TCURC.MANDT
  • P_ACTUALPLANGLACCTBALANCE.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Order ID
  • Client
  • Order ID
  • P_ACTUALPLANGLACCTBALANCE.MANDT == AUFK.MANDT
  • P_ACTUALPLANGLACCTBALANCE.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • P_ACTUALPLANGLACCTBALANCE.MANDT == TSPA.MANDT
  • P_ACTUALPLANGLACCTBALANCE.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • P_ACTUALPLANGLACCTBALANCE.MANDT == T001W.MANDT
  • P_ACTUALPLANGLACCTBALANCE.PLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • P_ACTUALPLANGLACCTBALANCE.MANDT == MARA.MANDT
  • P_ACTUALPLANGLACCTBALANCE.PRODUCT == MARA.MATNR
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • P_ACTUALPLANGLACCTBALANCE.CONTROLLINGAREA == CEPC.KOKRS
  • P_ACTUALPLANGLACCTBALANCE.MANDT == CEPC.MANDT
  • P_ACTUALPLANGLACCTBALANCE.[column in domain "DATBI"] == CEPC.DATBI
  • P_ACTUALPLANGLACCTBALANCE.PROFITCENTER == CEPC.PRCTR
Sales Organization
  • Client
  • Sales Organization
  • P_ACTUALPLANGLACCTBALANCE.MANDT == TVKO.MANDT
  • P_ACTUALPLANGLACCTBALANCE.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_ACTUALPLANGLACCTBALANCE.MANDT == FAGL_SEGM.MANDT
  • P_ACTUALPLANGLACCTBALANCE.SEGMENT == FAGL_SEGM.SEGMENT
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
Service Document ID
  • Client
  • Service Document ID
  • ?
  • Service Document Type
  • P_ACTUALPLANGLACCTBALANCE.MANDT == FCO_SRVDOC.MANDT
  • P_ACTUALPLANGLACCTBALANCE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • P_ACTUALPLANGLACCTBALANCE.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • P_ACTUALPLANGLACCTBALANCE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Supplier
  • Supplier
  • Client
  • P_ACTUALPLANGLACCTBALANCE.SUPPLIER == LFA1.LIFNR
  • P_ACTUALPLANGLACCTBALANCE.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • P_ACTUALPLANGLACCTBALANCE.MANDT == TCURC.MANDT
  • P_ACTUALPLANGLACCTBALANCE.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Client
  • Valuation area
  • P_ACTUALPLANGLACCTBALANCE.MANDT == T001K.MANDT
  • P_ACTUALPLANGLACCTBALANCE.VALUATIONAREA == T001K.BWKEY