P_FSITEMMAPPINGHEADERALL

DDL: P_FSITEMMAPPINGHEADERALL SQL: PFSITEMMAPHDRALL Type: view COMPOSITE Package: FIN_CS_MD_FSITEMMAPPING

Financial Statement Item Mapping Item

P_FSITEMMAPPINGHEADERALL is a Composite CDS View that provides data about "Financial Statement Item Mapping Item" in SAP S/4HANA. It reads from 2 data sources (I_FSItemMappingRevision, P_FSItemMappingHeaderDraft) and exposes 9 fields. Part of development package FIN_CS_MD_FSITEMMAPPING.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_FSItemMappingRevision I_FSItemMappingRevision from
P_FSItemMappingHeaderDraft P_FSItemMappingHeaderDraft union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFSITEMMAPHDRALL 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
ConsolidationChartOfAccounts ConsolidationChartOfAccounts
ChartOfAccounts ChartOfAccounts
FSItemMappingID FSItemMappingID
FSItemMappingRevision FSItemMappingRevision
ConsolidationChartOfAccounts ConsolidationChartOfAccounts
ChartOfAccounts ChartOfAccounts
FSItemMappingID FSItemMappingID
FSItemMappingRevision FSItemMappingRevision
IsActiveEntity 
@AbapCatalog.sqlViewName: 'PFSITEMMAPHDRALL'
@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_FSITEMMAPPINGHEADERALL
  //with parameters

  //@Consumption.hidden: true

  //@Environment.systemField: #SYSTEM_LANGUAGE

  //P_Language : sylangu


  as select from I_FSItemMappingRevision

{
  key cast(concat(
    concat(
     concat('~', ConsolidationChartOfAccounts),
     concat('~', ChartOfAccounts)),
    concat(
     concat('~', FSItemMappingID),
     concat('~', FSItemMappingRevision))) as char32) as FSItemMappingUUID,

      ConsolidationChartOfAccounts,

      ChartOfAccounts,

      FSItemMappingID,

      FSItemMappingRevision,
      
      'X' as IsActiveEntity

}
union all select from P_FSItemMappingHeaderDraft
{

  key DraftUUID                   as FSItemMappingUUID,

      ConsolidationChartOfAccounts,

      ChartOfAccounts,

      FSItemMappingID,

      FSItemMappingRevision,
      
      '' as IsActiveEntity

}

Learn More