P_PlanBalFlowDateFunc

P_PlanBalFlowDateFunc | view: PFIPLNBFDF | Extraction: Not supported | Component: Information System

Tables used: ACDOCP, T001, TKA02, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (7)
💰 Amounts (4)
∑ Quantities
📅 Dates (1)
☰ Categorical (2)
Other (5)
🔗 Relations (17)

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 Business Area Client	`P_PLANBALFLOWDATEFUNC.BUSINESSAREA == TGSB.GSBER` `P_PLANBALFLOWDATEFUNC.MANDT == TGSB.MANDT`
Chart of Accounts Chart of Accounts Client	`P_PLANBALFLOWDATEFUNC.CHARTOFACCOUNTS == T004.KTOPL` `P_PLANBALFLOWDATEFUNC.MANDT == T004.MANDT`
Company Code Company Code Client	`P_PLANBALFLOWDATEFUNC.COMPANYCODE == T001.BUKRS` `P_PLANBALFLOWDATEFUNC.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`P_PLANBALFLOWDATEFUNC.CONTROLLINGAREA == TKA01.KOKRS` `P_PLANBALFLOWDATEFUNC.MANDT == TKA01.MANDT`
Cost Center Controlling Area Client Cost Center ?	`P_PLANBALFLOWDATEFUNC.CONTROLLINGAREA == CSKS.KOKRS` `P_PLANBALFLOWDATEFUNC.MANDT == CSKS.MANDT` `P_PLANBALFLOWDATEFUNC.COSTCENTER == CSKS.KOSTL` `P_PLANBALFLOWDATEFUNC.[column in domain "DATBI"] == CSKS.DATBI`
Customer Number Customer Number Client	`P_PLANBALFLOWDATEFUNC.CUSTOMER == KNA1.KUNNR` `P_PLANBALFLOWDATEFUNC.MANDT == KNA1.MANDT`
Customer Group Customer Group Client	`P_PLANBALFLOWDATEFUNC.CUSTOMERGROUP == T151.KDGRP` `P_PLANBALFLOWDATEFUNC.MANDT == T151.MANDT`
Functional Area Functional Area Client	`P_PLANBALFLOWDATEFUNC.FUNCTIONALAREA == TFKB.FKBER` `P_PLANBALFLOWDATEFUNC.MANDT == TFKB.MANDT`
G/L Account Chart of Accounts G/L Account Client	`P_PLANBALFLOWDATEFUNC.CHARTOFACCOUNTS == SKA1.KTOPL` `P_PLANBALFLOWDATEFUNC.GLACCOUNT == SKA1.SAKNR` `P_PLANBALFLOWDATEFUNC.MANDT == SKA1.MANDT`
Ledger Ledger Client	`P_PLANBALFLOWDATEFUNC.LEDGER == FINSC_LEDGER.RLDNR` `P_PLANBALFLOWDATEFUNC.MANDT == FINSC_LEDGER.MANDT`
Plan Category Plan Category Client	`P_PLANBALFLOWDATEFUNC.PLANNINGCATEGORY == FCOMC_CATEGORY.CATEGORY` `P_PLANBALFLOWDATEFUNC.MANDT == FCOMC_CATEGORY.MANDT`
Product Number Client Product Number	`P_PLANBALFLOWDATEFUNC.MANDT == MARA.MANDT` `P_PLANBALFLOWDATEFUNC.PRODUCT == MARA.MATNR`
Material Group Material Group Client	`P_PLANBALFLOWDATEFUNC.PRODUCTGROUP == T023.MATKL` `P_PLANBALFLOWDATEFUNC.MANDT == T023.MANDT`
Profit Center Profit Center Controlling Area Client ?	`P_PLANBALFLOWDATEFUNC.PROFITCENTER == CEPC.PRCTR` `P_PLANBALFLOWDATEFUNC.CONTROLLINGAREA == CEPC.KOKRS` `P_PLANBALFLOWDATEFUNC.MANDT == CEPC.MANDT` `P_PLANBALFLOWDATEFUNC.[column in domain "DATBI"] == CEPC.DATBI`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`P_PLANBALFLOWDATEFUNC.SEGMENT == FAGL_SEGM.SEGMENT` `P_PLANBALFLOWDATEFUNC.MANDT == FAGL_SEGM.MANDT`
Product Sold Client Product Sold	`P_PLANBALFLOWDATEFUNC.MANDT == MARA.MANDT` `P_PLANBALFLOWDATEFUNC.SOLDPRODUCT == MARA.MATNR`
Product Group Product Group Client	`P_PLANBALFLOWDATEFUNC.SOLDPRODUCTGROUP == T023.MATKL` `P_PLANBALFLOWDATEFUNC.MANDT == T023.MANDT`