P_GLAcctFlowSemTagDateFunc2

DDL: P_GLACCTFLOWSEMTAGDATEFUNC2 Type: view_entity COMPOSITE Package: FINS_FIS_FICO

P_GLAcctFlowSemTagDateFunc2

P_GLAcctFlowSemTagDateFunc2 is a Composite CDS View that provides data about "P_GLAcctFlowSemTagDateFunc2" in SAP S/4HANA. It reads from 2 data sources (I_SemTagGLAccount, P_ActualPlanBalFlow2) and exposes 41 fields with key fields GLAccountHierarchy, ActualPlanCode, PlanningCategory, Ledger, CompanyCode. It has 2 associations to related views. Part of development package FINS_FIS_FICO.

2 data source(s) 41 fields

Data Sources (2)

SourceAliasJoin Type
I_SemTagGLAccount I_SemTagGLAccount inner
P_ActualPlanBalFlow2 P_ActualPlanBalFlow2 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (5)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY GLAccountHierarchy I_SemTagGLAccount GLAccountHierarchy
KEY ActualPlanCode P_ActualPlanBalFlow2 ActualPlanCode
KEY PlanningCategory P_ActualPlanBalFlow2 PlanningCategory
KEY Ledger P_ActualPlanBalFlow2 Ledger
KEY CompanyCode P_ActualPlanBalFlow2 CompanyCode
KEY DateFunction P_ActualPlanBalFlow2 DateFunction
KEY FiscalYearPeriod P_ActualPlanBalFlow2 FiscalYearPeriod
KEY GLAccountFlowType P_ActualPlanBalFlow2 GLAccountFlowType
FiscalYearVariant P_ActualPlanBalFlow2 FiscalYearVariant
LedgerFiscalYear P_ActualPlanBalFlow2 LedgerFiscalYear
FiscalQuarter P_ActualPlanBalFlow2 FiscalQuarter
FiscalYearQuarter P_ActualPlanBalFlow2 FiscalYearQuarter
FiscalPeriod P_ActualPlanBalFlow2 FiscalPeriod
ChartOfAccounts P_ActualPlanBalFlow2 ChartOfAccounts
GLAccount P_ActualPlanBalFlow2 GLAccount
IsBalanceSheetAccount P_ActualPlanBalFlow2 IsBalanceSheetAccount
HierarchyNode I_SemTagGLAccount HierarchyNode
SemanticTag I_SemTagGLAccount SemanticTag
GLAccountTypeFlowType
ControllingArea P_ActualPlanBalFlow2 ControllingArea
CostCenter P_ActualPlanBalFlow2 CostCenter
ProfitCenter P_ActualPlanBalFlow2 ProfitCenter
FunctionalArea P_ActualPlanBalFlow2 FunctionalArea
BusinessArea P_ActualPlanBalFlow2 BusinessArea
Segment P_ActualPlanBalFlow2 Segment
Product P_ActualPlanBalFlow2 Product
ProductGroup P_ActualPlanBalFlow2 ProductGroup
SoldProduct P_ActualPlanBalFlow2 SoldProduct
SoldProductGroup P_ActualPlanBalFlow2 SoldProductGroup
Customer P_ActualPlanBalFlow2 Customer
CustomerGroup P_ActualPlanBalFlow2 CustomerGroup
Supplier P_ActualPlanBalFlow2 Supplier
GlobalCurrency P_ActualPlanBalFlow2 GlobalCurrency
AmountInGlobalCurrency P_ActualPlanBalFlow2 AmountInGlobalCurrency
FixedAmountInGlobalCrcy P_ActualPlanBalFlow2 FixedAmountInGlobalCrcy
InvertedAmountInGlobalCurrency
KslwoBCF P_ActualPlanBalFlow2 KslwoBCF
KslonlyBCF P_ActualPlanBalFlow2 KslonlyBCF
_GlobalCurrency P_ActualPlanBalFlow2 _GlobalCurrency
_Customer _Customer
_Supplier _Supplier 
 @AbapCatalog.entityBuffer.definitionAllowed: false
 @AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST, #UNION]
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #COMPOSITE
@VDM.private:true
@Metadata.ignorePropagatedAnnotations: true
define view entity P_GLAcctFlowSemTagDateFunc2  as select from P_ActualPlanBalFlow2 as P_ActualPlanBalFlow2
    inner join I_SemTagGLAccount   on  I_SemTagGLAccount.GLAccount         = P_ActualPlanBalFlow2.GLAccount
                                   and I_SemTagGLAccount.ChartOfAccounts   = P_ActualPlanBalFlow2.ChartOfAccounts
                                   and I_SemTagGLAccount.ValidityStartDate <= $session.system_date
                                   and I_SemTagGLAccount.ValidityEndDate   >= $session.system_date
  association [0..1] to I_Customer                   as _Customer                   on  $projection.Customer = _Customer.Customer
  association [0..1] to I_Supplier                   as _Supplier                   on  $projection.Supplier = _Supplier.Supplier

{
key I_SemTagGLAccount.GLAccountHierarchy,
key P_ActualPlanBalFlow2.ActualPlanCode,
key P_ActualPlanBalFlow2.PlanningCategory,
key P_ActualPlanBalFlow2.Ledger,
key P_ActualPlanBalFlow2.CompanyCode,
key P_ActualPlanBalFlow2.DateFunction,
key P_ActualPlanBalFlow2.FiscalYearPeriod,  
key P_ActualPlanBalFlow2.GLAccountFlowType,      

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

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

   
   P_ActualPlanBalFlow2.ChartOfAccounts,
   P_ActualPlanBalFlow2.GLAccount,
   P_ActualPlanBalFlow2.IsBalanceSheetAccount,
   I_SemTagGLAccount.HierarchyNode,   
   I_SemTagGLAccount.SemanticTag,  
   cast( '            ' as fis_glacct_type_flow_type preserving type )             as GLAccountTypeFlowType,  
   
   P_ActualPlanBalFlow2.ControllingArea,
   P_ActualPlanBalFlow2.CostCenter,
   P_ActualPlanBalFlow2.ProfitCenter,
   P_ActualPlanBalFlow2.FunctionalArea,
   P_ActualPlanBalFlow2.BusinessArea,
   P_ActualPlanBalFlow2.Segment,

// use Sold...   

   P_ActualPlanBalFlow2.Product,           // MATNR

   P_ActualPlanBalFlow2.ProductGroup,      // MATKL_MM 

   
   P_ActualPlanBalFlow2.SoldProduct,       // MATNR_COPA

   P_ActualPlanBalFlow2.SoldProductGroup,  // MATKL

   
   P_ActualPlanBalFlow2.Customer,
   P_ActualPlanBalFlow2.CustomerGroup,   
   
   P_ActualPlanBalFlow2.Supplier,        
   
   @ObjectModel.foreignKey.association: '_GlobalCurrency'
   P_ActualPlanBalFlow2.GlobalCurrency,
   @Aggregation.default: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
   P_ActualPlanBalFlow2.AmountInGlobalCurrency,
   @Aggregation.default: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
   P_ActualPlanBalFlow2.FixedAmountInGlobalCrcy, 
   
  @Aggregation.default: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
   cast(( P_ActualPlanBalFlow2.AmountInGlobalCurrency * -1 ) as fis_ksl_inverted  ) as InvertedAmountInGlobalCurrency,   
   
   @Aggregation.default: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }     
   P_ActualPlanBalFlow2.KslwoBCF,      
   @Aggregation.default: #SUM
   @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }        
   P_ActualPlanBalFlow2.KslonlyBCF,         
   
   P_ActualPlanBalFlow2._GlobalCurrency ,
    
   _Customer,
   _Supplier
}

Learn More