P_FSItemMappingGLAccountAll

DDL: P_FSITEMMAPPINGGLACCOUNTALL SQL: PFSMGLACCTALL Type: view COMPOSITE

P_FSItemMappingGLAccountAll is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_GLAccountInChartOfAccounts, I_FSItemMappingRevision) and exposes 7 fields with key fields FSItemMappingID, ConsolidationChartOfAccounts, ChartOfAccounts, FSItemMappingRevision, GLAccount. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_GLAccountInChartOfAccounts A2 left_outer
I_FSItemMappingRevision I_FSItemMappingRevision from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FSItemMappingItem _Item $projection.ConsolidationChartOfAccounts = _Item.ConsolidationChartOfAccounts and $projection.FSItemMappingRevision = _Item.FSItemMappingRevision and $projection.FSItemMappingID = _Item.FSItemMappingID and $projection.ChartOfAccounts = _Item.ChartOfAccounts and $projection.GLAccount = _Item.GLAccount

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFSMGLACCTALL view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FSItemMappingID A1 FSItemMappingID
KEY ConsolidationChartOfAccounts A1 ConsolidationChartOfAccounts
KEY ChartOfAccounts A1 ChartOfAccounts
KEY FSItemMappingRevision A1 FSItemMappingRevision
KEY GLAccount I_GLAccountInChartOfAccounts GLAccount
Counts 1
_Item _Item 
@AbapCatalog.sqlViewName: 'PFSMGLACCTALL'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #B,
  sizeCategory: #XL
}

define view P_FSItemMappingGLAccountAll
  as select from    I_FSItemMappingRevision A1
    left outer join I_GLAccountInChartOfAccounts as A2 on A1.ChartOfAccounts = A2.ChartOfAccounts

  association [0..1] to I_FSItemMappingItem      as _Item      on  $projection.ConsolidationChartOfAccounts = _Item.ConsolidationChartOfAccounts
                                                               and $projection.FSItemMappingRevision        = _Item.FSItemMappingRevision
                                                               and $projection.FSItemMappingID              = _Item.FSItemMappingID
                                                               and $projection.ChartOfAccounts              = _Item.ChartOfAccounts
                                                               and $projection.GLAccount                    = _Item.GLAccount
{

  key A1.FSItemMappingID,

  key A1.ConsolidationChartOfAccounts,

  key A1.ChartOfAccounts,

  key A1.FSItemMappingRevision,

  key A2.GLAccount,

      1 as Counts,

      _Item
}

Learn More