P_FSItemMappingFSItemAll

DDL: P_FSITEMMAPPINGFSITEMALL SQL: PFSMFSITEMALL Type: view COMPOSITE Package: FIN_CS_MD_FSITEMMAPPING

FSItem Mapping - FSItem All

P_FSItemMappingFSItemAll is a Composite CDS View that provides data about "FSItem Mapping - FSItem All" in SAP S/4HANA. It reads from 2 data sources (I_CnsldtnFinStmntItem, I_FSItemMappingRevision) and exposes 8 fields with key fields FSItemMappingID, ConsolidationChartOfAccounts, ChartOfAccounts, FSItemMappingRevision, FinancialStatementItem. It has 2 associations to related views. Part of development package FIN_CS_MD_FSITEMMAPPING.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_CnsldtnFinStmntItem A2 left_outer
I_FSItemMappingRevision I_FSItemMappingRevision from

Associations (2)

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.FinancialStatementItem = _Item.FinancialStatementItem
[0..1] P_FSitemMappingItemDraft _DraftItem $projection.ConsolidationChartOfAccounts = _DraftItem.ConsolidationChartOfAccounts and $projection.FSItemMappingRevision = _DraftItem.FSItemMappingRevision and $projection.FSItemMappingID = _DraftItem.FSItemMappingID and $projection.ChartOfAccounts = _DraftItem.ChartOfAccounts and $projection.FinancialStatementItem = _DraftItem.FinancialStatementItem

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFSMFSITEMALL view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY FSItemMappingID A1 FSItemMappingID
KEY ConsolidationChartOfAccounts I_CnsldtnFinStmntItem ConsolidationChartOfAccounts
KEY ChartOfAccounts A1 ChartOfAccounts
KEY FSItemMappingRevision A1 FSItemMappingRevision
KEY FinancialStatementItem I_CnsldtnFinStmntItem FinancialStatementItem
Counts 1
_Item _Item
_DraftItem _DraftItem 
@AbapCatalog.sqlViewName: 'PFSMFSITEMALL'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK

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

define view P_FSItemMappingFSItemAll
  as select from    I_FSItemMappingRevision A1
    left outer join I_CnsldtnFinStmntItem as A2 on  A1.ConsolidationChartOfAccounts = A2.ConsolidationChartOfAccounts

  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.FinancialStatementItem       = _Item.FinancialStatementItem
  association [0..1] to P_FSitemMappingItemDraft as _DraftItem on  $projection.ConsolidationChartOfAccounts = _DraftItem.ConsolidationChartOfAccounts
                                                               and $projection.FSItemMappingRevision        = _DraftItem.FSItemMappingRevision
                                                               and $projection.FSItemMappingID              = _DraftItem.FSItemMappingID
                                                               and $projection.ChartOfAccounts              = _DraftItem.ChartOfAccounts
                                                               and $projection.FinancialStatementItem       = _DraftItem.FinancialStatementItem
{

  key A1.FSItemMappingID,

  key A2.ConsolidationChartOfAccounts,

  key A1.ChartOfAccounts,

  key A1.FSItemMappingRevision,

  key A2.FinancialStatementItem,

      1 as Counts,

      _Item,

      _DraftItem
      //      A2._Text

}

Learn More