P_PlanBalFlowDateFunc2

P_PlanBalFlowDateFunc2 | view: PFIPLNBFDF2 | Extraction: Not supported | Component: Information System
Tables used: ACDOCP, T001, TKA02, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
ActualPlanCode Actual Plan Code Show values
PlanningCategory FK Plan Category
Ledger FK Ledger
CompanyCode FK Company Code
DateFunction Relative Date Function ID
FiscalYearPeriod Fiscal Year Period
GLAccountFlowType G/L Account Flow Type Show values
Column Name Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
KslwoBCF Amount in Global Currency
KslonlyBCF Amount in Global Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
ActualPlanCode Actual Plan Code Show values
GLAccountFlowType G/L Account Flow Type Show values
Column Name Description Domain name
FiscalYearVariant Fiscal Year Variant PERIV
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
Supplier Supplier LIFNR
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • P_PLANBALFLOWDATEFUNC2.MANDT == TGSB.MANDT
  • P_PLANBALFLOWDATEFUNC2.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_PLANBALFLOWDATEFUNC2.MANDT == T004.MANDT
  • P_PLANBALFLOWDATEFUNC2.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_PLANBALFLOWDATEFUNC2.COMPANYCODE == T001.BUKRS
  • P_PLANBALFLOWDATEFUNC2.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_PLANBALFLOWDATEFUNC2.MANDT == TKA01.MANDT
  • P_PLANBALFLOWDATEFUNC2.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • P_PLANBALFLOWDATEFUNC2.[column in domain "DATBI"] == CSKS.DATBI
  • P_PLANBALFLOWDATEFUNC2.MANDT == CSKS.MANDT
  • P_PLANBALFLOWDATEFUNC2.CONTROLLINGAREA == CSKS.KOKRS
  • P_PLANBALFLOWDATEFUNC2.COSTCENTER == CSKS.KOSTL
Customer Number
  • Client
  • Customer Number
  • P_PLANBALFLOWDATEFUNC2.MANDT == KNA1.MANDT
  • P_PLANBALFLOWDATEFUNC2.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • P_PLANBALFLOWDATEFUNC2.MANDT == T151.MANDT
  • P_PLANBALFLOWDATEFUNC2.CUSTOMERGROUP == T151.KDGRP
Functional Area
  • Client
  • Functional Area
  • P_PLANBALFLOWDATEFUNC2.MANDT == TFKB.MANDT
  • P_PLANBALFLOWDATEFUNC2.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • G/L Account
  • Client
  • Chart of Accounts
  • P_PLANBALFLOWDATEFUNC2.GLACCOUNT == SKA1.SAKNR
  • P_PLANBALFLOWDATEFUNC2.MANDT == SKA1.MANDT
  • P_PLANBALFLOWDATEFUNC2.CHARTOFACCOUNTS == SKA1.KTOPL
Ledger
  • Client
  • Ledger
Plan Category
  • Client
  • Plan Category
Product Number
  • Client
  • Product Number
  • P_PLANBALFLOWDATEFUNC2.MANDT == MARA.MANDT
  • P_PLANBALFLOWDATEFUNC2.PRODUCT == MARA.MATNR
Material Group
  • Material Group
  • Client
  • P_PLANBALFLOWDATEFUNC2.PRODUCTGROUP == T023.MATKL
  • P_PLANBALFLOWDATEFUNC2.MANDT == T023.MANDT
Profit Center
  • ?
  • Client
  • Controlling Area
  • Profit Center
  • P_PLANBALFLOWDATEFUNC2.[column in domain "DATBI"] == CEPC.DATBI
  • P_PLANBALFLOWDATEFUNC2.MANDT == CEPC.MANDT
  • P_PLANBALFLOWDATEFUNC2.CONTROLLINGAREA == CEPC.KOKRS
  • P_PLANBALFLOWDATEFUNC2.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_PLANBALFLOWDATEFUNC2.MANDT == FAGL_SEGM.MANDT
  • P_PLANBALFLOWDATEFUNC2.SEGMENT == FAGL_SEGM.SEGMENT
Product Sold
  • Client
  • Product Sold
  • P_PLANBALFLOWDATEFUNC2.MANDT == MARA.MANDT
  • P_PLANBALFLOWDATEFUNC2.SOLDPRODUCT == MARA.MATNR
Product Group
  • Client
  • Product Group
  • P_PLANBALFLOWDATEFUNC2.MANDT == T023.MANDT
  • P_PLANBALFLOWDATEFUNC2.SOLDPRODUCTGROUP == T023.MATKL