TRAC_ADTL_COMMON

@AbapCatalog.sqlViewName: 'TRACADTLCOMMON'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Common Data'

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S

@ClientHandling.algorithm: #SESSION_VARIABLE

// ********************************************************************************************

// This view is needed for Substitution Rule for Determination of Account Assignment Reference

// Do not use this view for any other purpose!!!!

// Only a dummy select is implemented here.

// ********************************************************************************************


/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
define view TRAC_ADTL_COMMON as select from I_Currency 

{      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_TreasuryGLAccountAssignRef',
                     element: 'TreasuryGLAccountAssignmentRef' }
        }]    
    key cast ('ABCDEFGHIJKL' as tpm_aa_ref preserving type ) as TreasuryGLAccountAssignmentRef,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]    
    cast( 'Z001' as fis_bukrs preserving type ) as CompanyCode,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_TreasuryValuationArea',
                     element: 'TreasuryValuationArea' }
        }] 
    cast( 'Z99' as tpm_val_area preserving type ) as TreasuryValuationArea,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_FinancialInstrProdCat',
                     element: 'FinancialInstrProductCategory' }
        }]    
    cast( '988' as ftr_gen_fin_instr_prod_categ  preserving type )   as FinancialInstrProductCategory,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_FinancialInstrProductType',
                     element: 'FinancialInstrumentProductType' }
        }]    
    cast( 'Z88' as vvsart preserving type ) as FinancialInstrumentProductType,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_TreasuryValuationClass',
                     element: 'TreasuryValuationClass' }
        }]     
    cast( '9001'as ftr_gen_valuation_class preserving type )  as TreasuryValuationClass,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_TreasuryPortfolio',
                     element: 'Portfolio' }
        }]    
    cast( 'PORTFOLIOZ' as rportb preserving type ) as Portfolio,
    
    //INFO: field fitting to data type of GFN WBSElementInternalID is available in TRACS_ADTL_COMMON, type of WBSElementExternalID is not

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_WBSElementBasicDataStdVH',
                     element: 'WBSElementInternalID' }
        }]    
    cast( '12345678' as ps_s4_pspnr  preserving type )                   as WBSElementInternalID,
    
    //INFO: keys ControllingArea and ValidityEndDate in I_CostCenterVH not considered in search help definition

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CostCenterVH',
                     element: 'CostCenter' }
        }]    
    cast( 'ABCDEFGHIJ' as fis_kostl preserving type )                    as CostCenter,
    
    //INFO: keys ControllingArea and ValidityEndDate in I_ProfitCenterVH not considered in search help definition

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ProfitCenterVH',
                     element: 'ProfitCenter' }
        }]    
    cast( 'ABCDEFGHIJ' as fis_prctr preserving type )                    as ProfitCenter,
    
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_FunctionalAreaVH',
                     element: 'FunctionalArea' }
        }]    
    cast( 'ABCDEFGHIJKLMNOP' as fm_farea preserving type )               as FunctionalArea,
    
    //INFO: key FinancialManagementArea in I_FundStdVH not considered in search help definition

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_FundStdVH',
                     element: 'Fund' }
        }]   
    cast( 'ABCDEFGHIJ' as bp_geber preserving type )                     as Fund,
    
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_GrantStdVH',
                     element: 'GrantID' }
        }]   
    cast( 'ABCDEFGHIJKLMNOPQRST' as gm_grant_nbr preserving type )       as GrantID,
    
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_TrsyPosCustomDiffntnTerm1',
                     element: 'TrsyPosCustomDiffntnTerm1' }
        }]   
    cast( 'ABCDEFGHIJKLMNOPQRST' as tpm_cust_diff_term_1_value preserving type ) as TrsyPosCustomDiffntnTerm1,
    
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_TrsyPosCustomDiffntnTerm2',
                     element: 'TrsyPosCustomDiffntnTerm2' }
        }]   
    cast( 'ABCDEFGHIJKLMNOPQRST' as tpm_cust_diff_term_2_value preserving type ) as TrsyPosCustomDiffntnTerm2,
    
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_TrsyPosCustomDiffntnTerm3',
                     element: 'TrsyPosCustomDiffntnTerm3' }
        }]   
    cast( 'ABCDEFGHIJKLMNOPQRST' as tpm_cust_diff_term_3_value preserving type ) as TrsyPosCustomDiffntnTerm3,
    
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_TrsyPosCustomDiffntnTerm4',
                     element: 'TrsyPosCustomDiffntnTerm4' }
        }]   
    cast( 'ABCDEFGHIJKLMNOPQRST' as tpm_cust_diff_term_4_value preserving type ) as TrsyPosCustomDiffntnTerm4,
    
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_TrsyPosCustomDiffntnTerm5',
                     element: 'TrsyPosCustomDiffntnTerm5' }
        }]   
    cast( 'ABCDEFGHIJKLMNOPQRST' as tpm_cust_diff_term_5_value preserving type ) as TrsyPosCustomDiffntnTerm5

// to be enabled in phase 2!!

//GROUPING_1  1 Type  TPM_AA_REF_PAR1 CHAR    8   0   0   1st Grouping Charact. for Acct Assignment Ref. Determination

//GROUPING_2  1 Type  TPM_AA_REF_PAR2 CHAR    8   0   0   2nd Grouping Charact. for Acct Assignment Ref. Determination

//GROUPING_3  1 Type  TPM_AA_REF_PAR3 CHAR    8   0   0   3rd Grouping Charact. for Acct Assignment Ref. Determination

//GROUPING_4  1 Type  TPM_AA_REF_PAR4 CHAR    8   0   0   4th Grouping Charact. for Acct Assignment Ref. Determination

//GROUPING_5  1 Type  TPM_AA_REF_PAR5 CHAR    8   0   0   5th Grouping Charact. for Acct Assignment Ref. Determination

//GROUPING_6  1 Type  TPM_AA_REF_PAR6 CHAR    8   0   0   6th Grouping Charact. for Acct Assignment Ref. Determination

//GROUPING_7  1 Type  TPM_AA_REF_PAR7 CHAR    8   0   0   7th Grouping Charact. for Acct Assignment Ref. Determination

//GROUPING_8  1 Type  TPM_AA_REF_PAR8 CHAR    8   0   0   8th Grouping Charact. for Acct Assignment Ref. Determination


} where 1 = 2;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CURRENCY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/