P_ActualPlanGLAcctBalance2

Actual Plan G/L Account Balances | view: PFIACTPLNGLBAL2 | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, ACDOCA, ACDOCP, T004, T001, TKA02, T009, SKA1, 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
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
ActualPlanJournalEntryItem Actual Plan Journal Entry Item
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
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
Column Name Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation Quantity
Column Name Description
PostingDate Posting Date
CalendarDate Calendar Date
Column Name Description
ActualPlanCode Actual Plan Code Show values
AccountingDocumentCategory Journal Entry Category 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
DebitCreditCode Debit/Credit Code Show values
GLAccountType Type of a General Ledger Account Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
LedgerFiscalYear Ledger Fiscal Year GJAHR
PlanningCategory Plan Category FCOM_CATEGORY
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
GrantID Grant GM_GRANT_NBR
OrderType Order Type AUFART
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == T003.MANDT
Asset Class
  • Asset Class
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.ASSETCLASS == ANKA.ANLKL
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == ANKA.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == TCURC.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Budget Period
  • Fund
  • Financial Management Area
  • Budget Period
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.FUND == FMFUNDBPD.FINCODE
  • P_ACTUALPLANGLACCTBALANCE2.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • P_ACTUALPLANGLACCTBALANCE2.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == FMFUNDBPD.MANDT
Business Area
  • Client
  • Business Area
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == TGSB.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == T004.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.COMPANYCODE == T001.BUKRS
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == TCURC.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.CONTROLLINGAREA == TKA01.KOKRS
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • Cost Center
  • ?
  • P_ACTUALPLANGLACCTBALANCE2.CONTROLLINGAREA == CSKS.KOKRS
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == CSKS.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.COSTCENTER == CSKS.KOSTL
  • P_ACTUALPLANGLACCTBALANCE2.[column in domain "DATBI"] == CSKS.DATBI
Cost Source Unit
  • Client
  • Cost Source Unit
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == T006.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Client
  • Customer Number
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == KNA1.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Distribution Channel
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == TVTW.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == FM01.MANDT
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == T009.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.FISCALYEARVARIANT == T009.PERIV
Asset Subnumber
  • Asset Subnumber
  • ?
  • Fixed Asset
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.FIXEDASSET == ANLA.ANLN2
  • P_ACTUALPLANGLACCTBALANCE2.[column in domain "BUKRS"] == ANLA.BUKRS
  • P_ACTUALPLANGLACCTBALANCE2.MASTERFIXEDASSET == ANLA.ANLN1
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == ANLA.MANDT
Functional Area
  • Functional Area
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.FUNCTIONALAREA == TFKB.FKBER
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == TFKB.MANDT
Fund
  • Fund
  • Financial Management Area
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.FUND == FMFINCODE.FINCODE
  • P_ACTUALPLANGLACCTBALANCE2.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == FMFINCODE.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_ACTUALPLANGLACCTBALANCE2.COMPANYCODE == SKB1.BUKRS
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == SKB1.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == TCURC.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Order ID
  • Order ID
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.ORDERID == AUFK.AUFNR
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.ORGANIZATIONDIVISION == TSPA.SPART
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == TSPA.MANDT
Plant
  • Plant
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.PLANT == T001W.WERKS
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == T001W.MANDT
Product Number
  • Product Number
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.PRODUCT == MARA.MATNR
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == MARA.MANDT
Profit Center
  • Controlling Area
  • Profit Center
  • Client
  • ?
  • P_ACTUALPLANGLACCTBALANCE2.CONTROLLINGAREA == CEPC.KOKRS
  • P_ACTUALPLANGLACCTBALANCE2.PROFITCENTER == CEPC.PRCTR
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == CEPC.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.[column in domain "DATBI"] == CEPC.DATBI
Sales Organization
  • Sales Organization
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.SALESORGANIZATION == TVKO.VKORG
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.SEGMENT == FAGL_SEGM.SEGMENT
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == FAGL_SEGM.MANDT
Service Document ID
  • Service Document Item ID
  • Client
  • Service Document ID
  • Service Document Type
  • P_ACTUALPLANGLACCTBALANCE2.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == FCO_SRVDOC.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • P_ACTUALPLANGLACCTBALANCE2.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Item ID
  • Service Document Item ID
  • Client
  • Service Document ID
  • Service Document Type
  • P_ACTUALPLANGLACCTBALANCE2.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == FCO_SRVDOC.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • P_ACTUALPLANGLACCTBALANCE2.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Supplier
  • Client
  • Supplier
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == LFA1.MANDT
  • P_ACTUALPLANGLACCTBALANCE2.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Transaction Currency
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == TCURC.MANDT
Valuation area
  • Valuation area
  • Client
  • P_ACTUALPLANGLACCTBALANCE2.VALUATIONAREA == T001K.BWKEY
  • P_ACTUALPLANGLACCTBALANCE2.MANDT == T001K.MANDT