P_FSItemMappingGLAccountAllD

DDL: P_FSITEMMAPPINGGLACCOUNTALLD SQL: PFSMGLACCTALLD Type: view COMPOSITE Package: FIN_CS_MD_FSITEMMAPPING

FSItem Mapping Draft - GLAccount All

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

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_GLAccountInChartOfAccounts A1 left_outer
P_FSItemMappingHeaderDraft P_FSItemMappingHeaderDraft from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_FSitemMappingItemDraft _DraftItem $projection.FSItemMappingUUID = _DraftItem.parentuuid and $projection.GLAccount = _DraftItem.glaccount

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFSMGLACCTALLD 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 (9)

KeyFieldSource TableSource FieldDescription
FSItemMappingUUID A0 draftuuid
FSItemMappingID A0 fsitemmappingid
ConsolidationChartOfAccounts A0 consolidationchartofaccounts
ChartOfAccounts A0 chartofaccounts
FSItemMappingRevision A0 fsitemmappingrevision
GLAccount I_GLAccountInChartOfAccounts GLAccount
access_type A0 access_type
Counts 1
_DraftItem _DraftItem 
@AbapCatalog.sqlViewName: 'PFSMGLACCTALLD'
@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_FSItemMappingGLAccountAllD
  as select from    P_FSItemMappingHeaderDraft A0
    left outer join I_GLAccountInChartOfAccounts as A1 on A0.chartofaccounts = A1.ChartOfAccounts

  association [0..1] to P_FSitemMappingItemDraft as _DraftItem on  $projection.FSItemMappingUUID = _DraftItem.parentuuid
                                                               and $projection.GLAccount = _DraftItem.glaccount
//                                                               and _DraftItem.haserror                      = ''


{
   A0.draftuuid as FSItemMappingUUID,
//   A0.draftuuid,

   A0.fsitemmappingid as FSItemMappingID,

   A0.consolidationchartofaccounts as ConsolidationChartOfAccounts,

   A0.chartofaccounts as ChartOfAccounts,

   A0.fsitemmappingrevision as FSItemMappingRevision,

   A1.GLAccount,
   
   A0.access_type,

      1 as Counts,

      _DraftItem
}

Learn More