P_GLAcctFlowSemTagDateFunc

DDL: P_GLACCTFLOWSEMTAGDATEFUNC Type: view_entity COMPOSITE Package: FINS_FIS_FICO

P_GLAcctFlowSemTagDateFunc

P_GLAcctFlowSemTagDateFunc is a Composite CDS View that provides data about "P_GLAcctFlowSemTagDateFunc" in SAP S/4HANA. It reads from 2 data sources (I_SemTagGLAccount, P_ActualPlanBalFlow) and exposes 43 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) 43 fields

Data Sources (2)

SourceAliasJoin Type
I_SemTagGLAccount I_SemTagGLAccount inner
P_ActualPlanBalFlow P_ActualPlanBalFlow 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 (43)

KeyFieldSource TableSource FieldDescription
KEY GLAccountHierarchy I_SemTagGLAccount GLAccountHierarchy
KEY ActualPlanCode P_ActualPlanBalFlow ActualPlanCode
KEY PlanningCategory P_ActualPlanBalFlow PlanningCategory
KEY Ledger P_ActualPlanBalFlow Ledger
KEY CompanyCode P_ActualPlanBalFlow CompanyCode
KEY DateFunction P_ActualPlanBalFlow DateFunction
KEY FiscalYearPeriod P_ActualPlanBalFlow FiscalYearPeriod
KEY GLAccountFlowType P_ActualPlanBalFlow GLAccountFlowType
FiscalYearVariant P_ActualPlanBalFlow FiscalYearVariant
LedgerFiscalYear P_ActualPlanBalFlow LedgerFiscalYear
FiscalQuarter P_ActualPlanBalFlow FiscalQuarter
FiscalYearQuarter P_ActualPlanBalFlow FiscalYearQuarter
FiscalPeriod P_ActualPlanBalFlow FiscalPeriod
ChartOfAccounts P_ActualPlanBalFlow ChartOfAccounts
GLAccount P_ActualPlanBalFlow GLAccount
IsBalanceSheetAccount P_ActualPlanBalFlow IsBalanceSheetAccount
HierarchyNode I_SemTagGLAccount HierarchyNode
SemanticTag I_SemTagGLAccount SemanticTag
GLAccountTypeFlowType
ControllingArea P_ActualPlanBalFlow ControllingArea
CostCenter P_ActualPlanBalFlow CostCenter
ProfitCenter P_ActualPlanBalFlow ProfitCenter
FunctionalArea P_ActualPlanBalFlow FunctionalArea
BusinessArea P_ActualPlanBalFlow BusinessArea
Segment P_ActualPlanBalFlow Segment
Product P_ActualPlanBalFlow Product
ProductGroup P_ActualPlanBalFlow ProductGroup
SoldProduct P_ActualPlanBalFlow SoldProduct
SoldProductGroup P_ActualPlanBalFlow SoldProductGroup
Customer P_ActualPlanBalFlow Customer
CustomerGroup P_ActualPlanBalFlow CustomerGroup
Supplier P_ActualPlanBalFlow Supplier
OrderID P_ActualPlanBalFlow OrderID
SalesDocument P_ActualPlanBalFlow SalesDocument
GlobalCurrency P_ActualPlanBalFlow GlobalCurrency
AmountInGlobalCurrency P_ActualPlanBalFlow AmountInGlobalCurrency
FixedAmountInGlobalCrcy P_ActualPlanBalFlow FixedAmountInGlobalCrcy
InvertedAmountInGlobalCurrency
KslwoBCF P_ActualPlanBalFlow KslwoBCF
KslonlyBCF P_ActualPlanBalFlow KslonlyBCF
_GlobalCurrency P_ActualPlanBalFlow _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_GLAcctFlowSemTagDateFunc  as select from P_ActualPlanBalFlow  as 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
  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_ActualPlanBalFlow.ActualPlanCode,
key P_ActualPlanBalFlow.PlanningCategory,
key P_ActualPlanBalFlow.Ledger,
key P_ActualPlanBalFlow.CompanyCode,
key P_ActualPlanBalFlow.DateFunction,
key P_ActualPlanBalFlow.FiscalYearPeriod,  
key P_ActualPlanBalFlow.GLAccountFlowType,      

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

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

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

   P_ActualPlanBalFlow.Product,           // MATNR

   P_ActualPlanBalFlow.ProductGroup,      // MATKL_MM 

   
   P_ActualPlanBalFlow.SoldProduct,       // MATNR_COPA

   P_ActualPlanBalFlow.SoldProductGroup,  // MATKL

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

   _Customer,
   _Supplier
}

Learn More