P_FSITEMMAPPINGHEADERALL

DDL: P_FSITEMMAPPINGHEADERALL SQL: PFSITEMMAPHDRALL Type: view COMPOSITE

P_FSITEMMAPPINGHEADERALL is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_FSItemMappingRevision, P_FSItemMappingHeaderDraft) and exposes 9 fields.

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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FSITEMMAPPINGREVISION",
"P_FSITEMMAPPINGHEADERDRAFT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More