P_GLAcctFlowSemTagDateFunc

DDL: P_GLACCTFLOWSEMTAGDATEFUNC SQL: PFIACTPLNBFDF Type: view COMPOSITE

P_GLAcctFlowSemTagDateFunc is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_SemTagGLAccount, P_ActualPlanBalFlow) and exposes 39 fields with key fields GLAccountHierarchy, ActualPlanCode, PlanningCategory, Ledger, CompanyCode.

2 data source(s) 39 fields

Data Sources (2)

SourceAliasJoin Type
I_SemTagGLAccount I_SemTagGLAccount inner
P_ActualPlanBalFlow P_ActualPlanBalFlow from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFIACTPLNBFDF 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 (39)

KeyFieldSource TableSource FieldDescription
KEY GLAccountHierarchy GLAccountHierarchy
KEY ActualPlanCode ActualPlanCode
KEY PlanningCategory PlanningCategory
KEY Ledger Ledger
KEY CompanyCode CompanyCode
KEY DateFunction DateFunction
KEY FiscalYearPeriod FiscalYearPeriod
KEY GLAccountFlowType GLAccountFlowType
FiscalYearVariant FiscalYearVariant
LedgerFiscalYear LedgerFiscalYear
FiscalQuarter FiscalQuarter
FiscalYearQuarter FiscalYearQuarter
FiscalPeriod FiscalPeriod
ChartOfAccounts P_ActualPlanBalFlow ChartOfAccounts
GLAccount P_ActualPlanBalFlow GLAccount
IsBalanceSheetAccount IsBalanceSheetAccount
HierarchyNode HierarchyNode
SemanticTag SemanticTag
GLAccountTypeFlowType
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 Supplier
GlobalCurrency GlobalCurrency
AmountInGlobalCurrency AmountInGlobalCurrency
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy
InvertedAmountInGlobalCurrency
KslwoBCF KslwoBCF
KslonlyBCF KslonlyBCF
_GlobalCurrency _GlobalCurrency 
@AbapCatalog.sqlViewName: 'PFIACTPLNBFDF'
@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_GLAcctFlowSemTagDateFunc  as select from P_ActualPlanBalFlow
    inner join I_SemTagGLAccount   on  I_SemTagGLAccount.GLAccount         = P_ActualPlanBalFlow.GLAccount
                                   and I_SemTagGLAccount.ChartOfAccounts   = P_ActualPlanBalFlow.ChartOfAccounts
                                   and I_SemTagGLAccount.ValidityStartDate <= $session.system_date
                                   and I_SemTagGLAccount.ValidityEndDate   >= $session.system_date
{
key GLAccountHierarchy,
key ActualPlanCode,
key PlanningCategory,
key Ledger,
key CompanyCode,
key DateFunction,
key FiscalYearPeriod,  
key GLAccountFlowType,      

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

   
   FiscalYearVariant,
   LedgerFiscalYear,
   FiscalQuarter,
   FiscalYearQuarter,
   FiscalPeriod,                                                               
//   PostingDate, 

   
   P_ActualPlanBalFlow.ChartOfAccounts,
   P_ActualPlanBalFlow.GLAccount,
   IsBalanceSheetAccount,
   HierarchyNode,   
   SemanticTag,  
   cast( '            ' as fis_glacct_type_flow_type preserving type )             as GLAccountTypeFlowType,  
   
   ControllingArea,
   CostCenter,
   ProfitCenter,
   FunctionalArea,
   BusinessArea,
   Segment,
   
// use Sold...   

   Product,           // MATNR

   ProductGroup,      // MATKL_MM 

   
   SoldProduct,       // MATNR_COPA

   SoldProductGroup,  // MATKL

   
   Customer,
   CustomerGroup,      
   
   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'} }
   cast(( AmountInGlobalCurrency * -1 ) as fis_ksl_inverted  ) as InvertedAmountInGlobalCurrency,   
   
   @DefaultAggregation: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }     
   KslwoBCF,      
   @DefaultAggregation: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }        
   KslonlyBCF,         
   
   _GlobalCurrency  

}          
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SEMTAGGLACCOUNT",
"P_ACTUALPLANBALFLOW"
],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[
"P_ACTUALPLANBALFLOW"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More