P_FSItemMappingFSItemAllD

DDL: P_FSITEMMAPPINGFSITEMALLD SQL: PFSMFSITEMALLD Type: view COMPOSITE Package: FIN_CS_MD_FSITEMMAPPING

FSItem Mapping Draft - FSItem All

P_FSItemMappingFSItemAllD is a Composite CDS View that provides data about "FSItem Mapping Draft - FSItem All" in SAP S/4HANA. It reads from 2 data sources (I_CnsldtnFinStmntItem, P_FSItemMappingHeaderDraft) and exposes 5 fields. It has 1 association to related views. Part of development package FIN_CS_MD_FSITEMMAPPING.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_CnsldtnFinStmntItem A1 left_outer
P_FSItemMappingHeaderDraft P_FSItemMappingHeaderDraft from

Associations (1)

CardinalityTargetAliasCondition
[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 PFSMFSITEMALLD 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 #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (5)

KeyFieldSource TableSource FieldDescription
FSItemMappingUUID A0 draftuuid
FinancialStatementItem I_CnsldtnFinStmntItem FinancialStatementItem
access_type A0 access_type
Counts 1
_DraftItem _DraftItem 
@AbapCatalog.sqlViewName: 'PFSMFSITEMALLD'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

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

define view P_FSItemMappingFSItemAllD
  as select from    P_FSItemMappingHeaderDraft A0
    left outer join I_CnsldtnFinStmntItem as A1 on A0.consolidationchartofaccounts = A1.ConsolidationChartOfAccounts

  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
//                                                               and _DraftItem.haserror                      = ''


{
   A0.draftuuid as FSItemMappingUUID,

   A0.fsitemmappingid,

   A0.consolidationchartofaccounts,

   A0.chartofaccounts,

   A0.fsitemmappingrevision,

   A1.FinancialStatementItem,

   A0.access_type,

      1 as Counts,

      _DraftItem
}

Learn More