P_MX_FinancialStmntStructure

DDL: P_MX_FINANCIALSTMNTSTRUCTURE SQL: PMXFINSTMNTSTRUC Type: view COMPOSITE Package: GLO_FIN_IS_GL_MX_AUX_ACCT

MX Financial Statement Structure

P_MX_FinancialStmntStructure is a Composite CDS View that provides data about "MX Financial Statement Structure" in SAP S/4HANA. It reads from 6 data sources and exposes 36 fields with key fields FinancialStatementHierarchy, CompanyCode, HierarchyNode, ChartOfAccounts, ValidityEndDate. It has 4 associations to related views. Part of development package GLO_FIN_IS_GL_MX_AUX_ACCT.

6 data source(s) 36 fields

Data Sources (6)

SourceAliasJoin Type
I_GLAccountInCompanyCode AlternativeGLAccountDetails inner
I_GLAccountHierarchyNode FSV from
I_GLAccountHierarchyNode FSV union_all
I_CompanyCode I_CompanyCode inner
I_CompanyCode I_CompanyCode inner
I_GLAccountInCompanyCode I_GLAccountInCompanyCode inner

Associations (4)

CardinalityTargetAliasCondition
[0..*] R_HierRuntimeRprstnAttrib _Language $projection.FinancialStatementHierarchy = _Language.HierarchyID and $projection.ValidityEndDate = _Language.ValidityEndDate and _Language.HierarchyAttributeName = 'LANGUAGE'
[0..1] I_GLAccountTextRawData _GLAccountText $projection.OperationalChartOfAccounts = _GLAccountText.ChartOfAccounts and $projection.GLAccount = _GLAccountText.GLAccount and $projection.MaintenanceLanguage = _GLAccountText.Language
[0..1] I_GLAccountHierarchyNodeT _ParentNodeText $projection.FinancialStatementHierarchy = _ParentNodeText.GLAccountHierarchy and $projection.ParentNode = _ParentNodeText.HierarchyNode and $projection.ValidityEndDate = _ParentNodeText.ValidityEndDate and $projection.MaintenanceLanguage = _ParentNodeText.Language
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.OperationalChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMXFINSTMNTSTRUC view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementHierarchy I_GLAccountHierarchyNode GLAccountHierarchy
KEY CompanyCode I_CompanyCode CompanyCode
KEY HierarchyNode I_GLAccountHierarchyNode HierarchyNode
KEY ChartOfAccounts I_GLAccountHierarchyNode ChartOfAccounts
KEY ValidityEndDate I_GLAccountHierarchyNode ValidityEndDate
KEY HierarchyVersion I_GLAccountHierarchyNode HierarchyVersion
OperationalChartOfAccounts I_GLAccountHierarchyNode ChartOfAccounts
ValidityStartDate I_GLAccountHierarchyNode ValidityStartDate
FinancialStatementNodeType I_GLAccountHierarchyNode NodeType
ParentNode I_GLAccountHierarchyNode ParentNode
OperationalGLAccount I_GLAccountHierarchyNode GLAccount
GLAccount I_GLAccountHierarchyNode GLAccount
CountryChartOfAccounts I_CompanyCode CountryChartOfAccounts
MaintenanceLanguage _Language HierAttributeRangeFromVal
VATRegistration I_CompanyCode VATRegistration
AlternativeGLAccountIsUsed
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ParentNodeText _ParentNodeText
KEY CompanyCode I_CompanyCode CompanyCode
KEY HierarchyNode I_GLAccountHierarchyNode HierarchyNode
KEY ChartOfAccounts I_CompanyCode ChartOfAccounts
KEY ValidityEndDate I_GLAccountHierarchyNode ValidityEndDate
KEY HierarchyVersion I_GLAccountHierarchyNode HierarchyVersion
OperationalChartOfAccounts I_GLAccountHierarchyNode ChartOfAccounts
ValidityStartDate I_GLAccountHierarchyNode ValidityStartDate
FinancialStatementNodeType I_GLAccountHierarchyNode NodeType
ParentNode I_GLAccountHierarchyNode ParentNode
OperationalGLAccount I_GLAccountInCompanyCode GLAccount
GLAccount I_GLAccountHierarchyNode GLAccount
CountryChartOfAccounts I_CompanyCode CountryChartOfAccounts
MaintenanceLanguage _Language HierAttributeRangeFromVal
VATRegistration I_CompanyCode VATRegistration
AlternativeGLAccountIsUsed
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ParentNodeText _ParentNodeText
_GLAccountText _GLAccountText 
@AbapCatalog.sqlViewName: 'PMXFINSTMNTSTRUC'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_MX_FinancialStmntStructure

  as select from I_GLAccountHierarchyNode as FSV

    inner join   I_CompanyCode            on I_CompanyCode.ChartOfAccounts = FSV.ChartOfAccounts

    inner join   I_GLAccountInCompanyCode on  I_GLAccountInCompanyCode.CompanyCode = I_CompanyCode.CompanyCode
                                          and I_GLAccountInCompanyCode.GLAccount   = FSV.GLAccount

  association [0..*] to R_HierRuntimeRprstnAttrib    as _Language                   on  $projection.FinancialStatementHierarchy = _Language.HierarchyID
                                                                                    and $projection.ValidityEndDate             = _Language.ValidityEndDate
                                                                                    and _Language.HierarchyAttributeName        = 'LANGUAGE'
                                                                                    
  association [0..1] to I_GLAccountTextRawData       as _GLAccountText              on  $projection.OperationalChartOfAccounts  = _GLAccountText.ChartOfAccounts
                                                                                    and $projection.GLAccount                   = _GLAccountText.GLAccount
                                                                                    and $projection.MaintenanceLanguage         = _GLAccountText.Language
                                                                                    
  association [0..1] to I_GLAccountHierarchyNodeT    as _ParentNodeText             on  $projection.FinancialStatementHierarchy = _ParentNodeText.GLAccountHierarchy
                                                                                    and $projection.ParentNode                  = _ParentNodeText.HierarchyNode
                                                                                    and $projection.ValidityEndDate             = _ParentNodeText.ValidityEndDate
                                                                                    and $projection.MaintenanceLanguage         = _ParentNodeText.Language
                                                                                    
  association [0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on  $projection.OperationalChartOfAccounts  = _GLAccountInChartOfAccounts.ChartOfAccounts
                                                                                    and $projection.GLAccount                   = _GLAccountInChartOfAccounts.GLAccount

{
  key FSV.GLAccountHierarchy               as FinancialStatementHierarchy,
  key I_CompanyCode.CompanyCode            as CompanyCode,
  key FSV.HierarchyNode                    as HierarchyNode,
  key FSV.ChartOfAccounts                  as ChartOfAccounts,
  key FSV.ValidityEndDate                  as ValidityEndDate,
  key FSV.HierarchyVersion                 as HierarchyVersion,
      FSV.ChartOfAccounts                  as OperationalChartOfAccounts, //Chart of Accounts directly from the FSV, in case it is a Country CoA. Is used to get the correct text from each GL.

      FSV.ValidityStartDate                as ValidityStartDate,
      FSV.NodeType                         as FinancialStatementNodeType,
      FSV.ParentNode                       as ParentNode,
      FSV.GLAccount                        as OperationalGLAccount,
      FSV.GLAccount                        as GLAccount,
      I_CompanyCode.CountryChartOfAccounts as CountryChartOfAccounts,
      _Language.HierAttributeRangeFromVal  as MaintenanceLanguage,
      I_CompanyCode.VATRegistration        as VATRegistration,
      ''                                   as AlternativeGLAccountIsUsed,

      _GLAccountInChartOfAccounts,
      _ParentNodeText,
      _GLAccountText

}
where
      FSV.NodeType   =  'L'
  and FSV.ParentNode <> '00NOTASSGND'

union all select from I_GLAccountHierarchyNode as FSV

  inner join          I_CompanyCode                                           on I_CompanyCode.CountryChartOfAccounts = FSV.ChartOfAccounts

  inner join          I_GLAccountInCompanyCode as AlternativeGLAccountDetails on  AlternativeGLAccountDetails.CompanyCode          = I_CompanyCode.CompanyCode
                                                                              and AlternativeGLAccountDetails.AlternativeGLAccount = FSV.GLAccount

association [0..*] to R_HierRuntimeRprstnAttrib    as _Language                   on  $projection.FinancialStatementHierarchy = _Language.HierarchyID
                                                                                  and $projection.ValidityEndDate             = _Language.ValidityEndDate
                                                                                  and _Language.HierarchyAttributeName        = 'LANGUAGE'
                                                                                  
association [0..1] to I_GLAccountTextRawData       as _GLAccountText              on  $projection.OperationalChartOfAccounts  = _GLAccountText.ChartOfAccounts
                                                                                  and $projection.GLAccount                   = _GLAccountText.GLAccount
                                                                                  and $projection.MaintenanceLanguage         = _GLAccountText.Language
                                                                                  
association [0..1] to I_GLAccountHierarchyNodeT    as _ParentNodeText             on  $projection.FinancialStatementHierarchy = _ParentNodeText.GLAccountHierarchy
                                                                                  and $projection.ParentNode                  = _ParentNodeText.HierarchyNode
                                                                                  and $projection.ValidityEndDate             = _ParentNodeText.ValidityEndDate
                                                                                  and $projection.MaintenanceLanguage         = _ParentNodeText.Language
                                                                                  
association [0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on  $projection.OperationalChartOfAccounts  = _GLAccountInChartOfAccounts.ChartOfAccounts
                                                                                  and $projection.GLAccount                   = _GLAccountInChartOfAccounts.GLAccount
{
  key FSV.GLAccountHierarchy                as FinancialStatementHierarchy,
  key I_CompanyCode.CompanyCode             as CompanyCode,
  key FSV.HierarchyNode                     as HierarchyNode,
  key I_CompanyCode.ChartOfAccounts         as ChartOfAccounts,
  key FSV.ValidityEndDate                   as ValidityEndDate,
  key FSV.HierarchyVersion                  as HierarchyVersion,
      FSV.ChartOfAccounts                   as OperationalChartOfAccounts, //Chart of Accounts directly from the FSV, in case it is a Country CoA. Is used to get the correct text from each GL.

      FSV.ValidityStartDate                 as ValidityStartDate,
      FSV.NodeType                          as FinancialStatementNodeType,
      FSV.ParentNode                        as ParentNode,
      AlternativeGLAccountDetails.GLAccount as OperationalGLAccount,
      FSV.GLAccount                         as GLAccount,
      I_CompanyCode.CountryChartOfAccounts  as CountryChartOfAccounts,
      _Language.HierAttributeRangeFromVal   as MaintenanceLanguage,
      I_CompanyCode.VATRegistration         as VATRegistration,
      'X'                                   as AlternativeGLAccountIsUsed,

      _GLAccountInChartOfAccounts,
      _ParentNodeText,
      _GLAccountText

}
where
      FSV.NodeType   =  'L'
  and FSV.ParentNode <> '00NOTASSGND'

Learn More