P_PlanBalFlowDateFunc2

DDL: P_PLANBALFLOWDATEFUNC2 SQL: PFIPLNBFDF2 Type: view COMPOSITE

P_PlanBalFlowDateFunc2 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_FinancialPlanningEntryItem, I_FiscalDateFunctionValue) and exposes 36 fields with key fields ActualPlanCode, PlanningCategory, Ledger, CompanyCode, DateFunction.

2 data source(s) 36 fields

Data Sources (2)

SourceAliasJoin Type
I_FinancialPlanningEntryItem I_FinancialPlanningEntryItem from
I_FiscalDateFunctionValue I_FiscalDateFunctionValue inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFIPLNBFDF2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ActualPlanCode
KEY PlanningCategory PlanningCategory
KEY Ledger Ledger
KEY CompanyCode CompanyCode
KEY DateFunction DateFunction
KEY FiscalYearPeriod FiscalYearPeriod
KEY GLAccountFlowType
FiscalYearVariant I_FinancialPlanningEntryItem FiscalYearVariant
LedgerFiscalYear LedgerFiscalYear
FiscalYear I_FinancialPlanningEntryItem FiscalYear
FiscalPeriod FiscalPeriod
PostingDate PostingDate
ChartOfAccounts ChartOfAccounts
GLAccount GLAccount
ControllingArea ControllingArea
CostCenter CostCenter
ProfitCenter ProfitCenter
FunctionalArea FunctionalArea
BusinessArea BusinessArea
Segment Segment
Product Product
ProductGroup ProductGroup
SoldProduct SoldProduct
SoldProductGroup SoldProductGroup
Customer Customer
CustomerGroup CustomerGroup
Supplier
GlobalCurrency GlobalCurrency
AmountInGlobalCurrency AmountInGlobalCurrency
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy
KslwoBCF AmountInGlobalCurrency
KslonlyBCF
_GlobalCurrency _GlobalCurrency
_FiscalCalendarDate _FiscalCalendarDate
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_FiscalYearVariant _FiscalYearVariant 
@AbapCatalog.sqlViewName: 'PFIPLNBFDF2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST, #UNION]
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view P_PlanBalFlowDateFunc2 as select from    I_FinancialPlanningEntryItem                                                              
              inner join   I_FiscalDateFunctionValue     on       I_FiscalDateFunctionValue.FiscalYearVariant        = I_FinancialPlanningEntryItem.FiscalYearVariant
                                                              and I_FiscalDateFunctionValue.DateFunctionValidityDate = $session.system_date
                                                              and I_FiscalDateFunctionValue.DateFunctionStartDate   <= I_FinancialPlanningEntryItem.PostingDate
                                                              and I_FiscalDateFunctionValue.DateFunctionEndDate     >= I_FinancialPlanningEntryItem.PostingDate                                                                
                                                         
{
key cast( 'P' as fis_actual_plan_code preserving type )   as ActualPlanCode,
key PlanningCategory,
key Ledger,
key CompanyCode,
key DateFunction,
key FiscalYearPeriod,  
key cast( '2         ' as fis_glaccount_flow_type preserving type )   as GLAccountFlowType,      

// *************    


   I_FinancialPlanningEntryItem.FiscalYearVariant,
   LedgerFiscalYear,
   I_FinancialPlanningEntryItem.FiscalYear,

   FiscalPeriod,                                                               
   PostingDate,
   
   ChartOfAccounts,
   GLAccount,
   
   ControllingArea,
   CostCenter,
   ProfitCenter,
   FunctionalArea,
   BusinessArea,
   Segment,
   
// use Sold...   

   Product,           // MATNR

   ProductGroup,      // MATKL_MM 

   
   SoldProduct,       // MATNR_COPA

   SoldProductGroup,  // MATKL

   
   Customer,
   CustomerGroup,   

   cast( '          ' as md_supplier preserving type ) as Supplier,         
   
   @ObjectModel.foreignKey.association: '_GlobalCurrency'
   @Semantics.currencyCode:true
   GlobalCurrency,
   @DefaultAggregation: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
   AmountInGlobalCurrency,
   @DefaultAggregation: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
   FixedAmountInGlobalCrcy,   
   
   @DefaultAggregation: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }         
   AmountInGlobalCurrency as KslwoBCF,
      
   @DefaultAggregation: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }        
   cast (0 as fis_ksl) as KslonlyBCF,    
   
   _GlobalCurrency,
   _FiscalCalendarDate,
   _GLAccountInChartOfAccounts,
   _FiscalYearVariant     
                                     
}

Learn More