@AbapCatalog:{
sqlViewName: 'ICSMASTERDATA',
compiler.compareFilter: true
}
@AccessControl:{
authorizationCheck: #PRIVILEGED_ONLY,
personalData.blocking: #NOT_REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
dataClass: #MASTER,
serviceQuality: #D,
sizeCategory: #L
}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Consolidation - Combined Master Data'
define view I_CnsldtnMasterData
as
select from I_CnsldtnAddlMD
{
key AdditionalCharcFieldName,
key AdditionalMasterDataCode,
key AdditionalMDSuprordFieldValue,
key cast ( 'CNSLDTN' as fincs_md_source ) as AdditionalMasterDataSource,
AdditionalMasterDataText
}
union all select from I_BillingDocumentType
{
key cast( 'FKART' as fieldname ) as AdditionalCharcFieldName,
key BillingDocumentType as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].BillingDocumentTypeName as AdditionalMasterDataText
}
union all select from I_BusinessArea
{
key cast( 'RBUSA' as fieldname ) as AdditionalCharcFieldName,
key BusinessArea as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].BusinessAreaName as AdditionalMasterDataText
}
union all select from I_ControllingArea
{
key cast( 'KOKRS' as fieldname ) as AdditionalCharcFieldName,
key ControllingArea as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
ControllingAreaName as AdditionalMasterDataText
}
// use the consolidation-specific private view to avoid duplicates originating from the time-dependency in accounting
// private view needs to be used to avoid the application of the aggregation function of the interface view
union all select distinct from P_CnsldtnCostCenter as _CostCenter
association [0..*] to P_CnsldtnCostCenterT as _Text on _CostCenter.ControllingArea = _Text.ControllingArea
and _CostCenter.CostCenter = _Text.CostCenter
and _CostCenter.AdditionalMasterDataSource = 'ACCTG'
{
key cast( 'RCNTR' as fieldname ) as AdditionalCharcFieldName,
key CostCenter as AdditionalMasterDataCode,
key ControllingArea as AdditionalMDSuprordFieldValue,
key AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].CostCenterName as AdditionalMasterDataText
}
where
AdditionalMasterDataSource = 'ACCTG'
union all select from I_Country
{
key cast( 'LAND1' as fieldname ) as AdditionalCharcFieldName,
key Country as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].CountryName as AdditionalMasterDataText
}
union all select from I_Customer
{
key cast( 'KUNNR' as fieldname ) as AdditionalCharcFieldName,
key Customer as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
CustomerName as AdditionalMasterDataText
}
union all select from I_CustomerGroup
{
key cast( 'KDGRP' as fieldname ) as AdditionalCharcFieldName,
key CustomerGroup as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].CustomerGroupName as AdditionalMasterDataText
}
union all select from I_DistributionChannel
{
key cast( 'VTWEG' as fieldname ) as AdditionalCharcFieldName,
key DistributionChannel as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].DistributionChannelName as AdditionalMasterDataText
}
union all select from I_Division
{
key cast( 'SPART' as fieldname ) as AdditionalCharcFieldName,
key Division as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].DivisionName as AdditionalMasterDataText
}
union all select from I_FinancialTransactionType
{
key cast( 'RMVCT' as fieldname ) as AdditionalCharcFieldName,
key FinancialTransactionType as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].FinancialTransactionTypeName as AdditionalMasterDataText
}
union all select from I_FunctionalArea
{
key cast( 'RFAREA' as fieldname ) as AdditionalCharcFieldName,
key FunctionalArea as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].FunctionalAreaName as AdditionalMasterDataText
}
union all select from I_GLAccountInChartOfAccounts
{
key cast( 'RACCT' as fieldname ) as AdditionalCharcFieldName,
key GLAccount as AdditionalMasterDataCode,
key ChartOfAccounts as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].GLAccountName as AdditionalMasterDataText
}
union all select from I_ChartOfAccounts
{
key cast( 'KTOPL' as fieldname ) as AdditionalCharcFieldName,
key ChartOfAccounts as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].ChartOfAccountsName as AdditionalMasterDataText
}
union all select from I_CustomerSupplierIndustry
{
key cast( 'BRSCH' as fieldname ) as AdditionalCharcFieldName,
key Industry as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].CustomerSupplierIndustryName as AdditionalMasterDataText
}
union all select from I_Material
{
key cast( 'MATNR' as fieldname ) as AdditionalCharcFieldName,
key Material as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].MaterialName as AdditionalMasterDataText
}
union all select from I_MaterialGroup
{
key cast( 'MATKL_MM' as fieldname ) as AdditionalCharcFieldName,
key MaterialGroup as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].MaterialGroupName as AdditionalMasterDataText
}
union all select from I_InternalOrder // I_OrdMstrData
{
key cast( 'AUFNR' as fieldname ) as AdditionalCharcFieldName,
key InternalOrder as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
InternalOrderDescription as AdditionalMasterDataText
}
union all select from I_Partnercompany
{
key cast( 'RASSC' as fieldname ) as AdditionalCharcFieldName,
key PartnerCompany as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
CompanyName as AdditionalMasterDataText
}
union all select from I_Plant
{
key cast( 'WERKS' as fieldname ) as AdditionalCharcFieldName,
key Plant as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
PlantName as AdditionalMasterDataText
}
union all select from I_Product
{
key cast( 'MATNR_COPA' as fieldname ) as AdditionalCharcFieldName,
key Product as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].ProductName as AdditionalMasterDataText
}
union all select from I_ProductGroup_2
{
key cast( 'MATKL' as fieldname ) as AdditionalCharcFieldName,
key ProductGroup as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_ProductGroupText[1: Language=$session.system_language].ProductGroupName as AdditionalMasterDataText
}
// use the consolidation-specific private view to avoid duplicates originating from the time-dependency in accounting
// private view needs to be used to avoid the application of the aggregation function of the interface view
union all select distinct from P_CnsldtnProfitCenter as _ProfitCenter
association [0..*] to P_CnsldtnProfitCenterT as _Text on _ProfitCenter.ControllingArea = _Text.ControllingArea
and _ProfitCenter.ProfitCenter = _Text.ProfitCenter
and _ProfitCenter.AdditionalMasterDataSource = 'ACCTG'
{
key cast( 'PRCTR' as fieldname ) as AdditionalCharcFieldName,
key ProfitCenter as AdditionalMasterDataCode,
key ControllingArea as AdditionalMDSuprordFieldValue,
key AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].ProfitCenterName as AdditionalMasterDataText
}
where
AdditionalMasterDataSource = 'ACCTG'
union all select from I_Project
{
key cast( 'PS_PSPID' as fieldname ) as AdditionalCharcFieldName,
key Project as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
ProjectDescription as AdditionalMasterDataText
}
union all select from I_SalesDistrict
{
key cast( 'BZIRK' as fieldname ) as AdditionalCharcFieldName,
key SalesDistrict as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].SalesDistrictName as AdditionalMasterDataText
}
union all select from I_SalesOrganization
{
key cast( 'VKORG' as fieldname ) as AdditionalCharcFieldName,
key SalesOrganization as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].SalesOrganizationName as AdditionalMasterDataText
}
union all select from I_Segment
{
key cast( 'SEGMENT' as fieldname ) as AdditionalCharcFieldName,
key Segment as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].SegmentName as AdditionalMasterDataText
}
union all select from I_Supplier
{
key cast( 'LIFNR' as fieldname ) as AdditionalCharcFieldName,
key Supplier as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
SupplierName as AdditionalMasterDataText
}
union all select from I_WBSElement
{
key cast( 'PS_POSID' as fieldname ) as AdditionalCharcFieldName,
key WBSElement as AdditionalMasterDataCode,
key Project as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
WBSDescription as AdditionalMasterDataText
}
/*
FINANCIAL SERVICES
*/
union all select from I_FinServicesProductGroup
{
key cast( 'FS_PRODUCT_GROUP' as fieldname ) as AdditionalCharcFieldName,
key FinancialServicesProductGroup as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].FinServicesProductGroupName as AdditionalMasterDataText
}
union all select from I_FinancialServicesBranch
{
key cast( 'BRANCH_ID' as fieldname ) as AdditionalCharcFieldName,
key FinancialServicesBranch as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].FinancialServicesBranchName as AdditionalMasterDataText
}
union all select from I_FinancialDataSource
{
key cast( 'DATASOURCE_ID' as fieldname ) as AdditionalCharcFieldName,
key FinancialDataSource as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].FinancialDataSourceName as AdditionalMasterDataText
}
/*
PUBLIC SECTOR
*/
union all select from I_FinancialManagementArea
{
key cast( 'FIKRS' as fieldname ) as AdditionalCharcFieldName,
key FinancialManagementArea as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].FinancialManagementAreaName as AdditionalMasterDataText
}
union all select from I_Fund
{
key cast( 'RFUND' as fieldname ) as AdditionalCharcFieldName,
key Fund as AdditionalMasterDataCode,
key FinancialManagementArea as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].FundName as AdditionalMasterDataText
}
union all select from I_Grant
{
key cast( 'RGRANT_NBR' as fieldname ) as AdditionalCharcFieldName,
key GrantID as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].GrantName as AdditionalMasterDataText
}
/*
GREENHOUSE GAS
*/
union all select from I_CnsldtnSustModeOfTransport // not possible to use source view due to missing client dependency
{
key cast( 'SUSMODEOFTRANSPORT' as fieldname ) as AdditionalCharcFieldName,
key SustainabilityModeOfTransport as AdditionalMasterDataCode,
key cast( '' as fincs_md_ref_value ) as AdditionalMDSuprordFieldValue,
key cast ( 'ACCTG' as fincs_md_source ) as AdditionalMasterDataSource,
_Text[1: Language=$session.system_language].SustModeOfTransportName as AdditionalMasterDataText
}
where
CnsldtnIsAdditionalMasterData is initial