I_TreasuryPositionAccount

DDL: I_TREASURYPOSITIONACCOUNT SQL: ITRPOSACC Type: view BASIC

Treasury Position Account

I_TreasuryPositionAccount is a Basic CDS View (Dimension) that provides data about "Treasury Position Account" in SAP S/4HANA. It reads from 1 data source (trft_pos_account) and exposes 5 fields with key fields CompanyCode, TreasuryPositionAccount.

Data Sources (1)

SourceAliasJoin Type
trft_pos_account TreasuryPositionAccount from

Annotations (19)

NameValueLevelField
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ITRPOSACC view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Treasury Position Account view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey TreasuryPositionAccount view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode trft_pos_account company_code
KEY TreasuryPositionAccount
TreasuryPositionAccountName
DepositoryBank
_CompanyCode _CompanyCode
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true // only if required by ATC check 

@AbapCatalog.sqlViewName: 'ITRPOSACC'
@AccessControl.authorizationCheck: #CHECK
// Assumption: Depository Bank is organization but  N O T  any private person!!

@AccessControl.personalData.blocking:  #NOT_REQUIRED 
@Analytics.dataCategory: #DIMENSION 
@Analytics.dataExtraction.enabled : true
@Analytics.internalName: #LOCAL 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@EndUserText.label: 'Treasury Position Account'
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE]
@ObjectModel.representativeKey: 'TreasuryPositionAccount'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B 
@ObjectModel.usageType.sizeCategory: #S
@Metadata.allowExtensions:true   
@Metadata.ignorePropagatedAnnotations: true // For C1-Release 

@VDM.viewType: #BASIC

define view I_TreasuryPositionAccount
  as select from trft_pos_account as TreasuryPositionAccount
  association to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
{
      //--[ GENERATED:012:GlBfhyJl7kY4pGd}um{aL0

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_CompanyCode'
  key TreasuryPositionAccount.company_code      as CompanyCode,
      @ObjectModel.text.element: 'TreasuryPositionAccountName'
  key cast(TreasuryPositionAccount.pos_account  as ftr_gen_pos_account_future preserving type)
                                                as TreasuryPositionAccount,
      @Semantics.text: true
      cast(TreasuryPositionAccount.pos_acc_text as ftr_gen_pos_accnt_future_name preserving type)
                                                as TreasuryPositionAccountName,

      //      TreasuryPositionAccount.settlement_acc,

      //      TreasuryPositionAccount.pos_acc_number,

      
      cast(TreasuryPositionAccount.pos_acc_bank as ftr_gen_partnr_depository_bank preserving type)
                                                as DepositoryBank,
      
      //      TreasuryPositionAccount.house_bank        as HouseBank,

      //      TreasuryPositionAccount.house_bank_acc    as HouseBankAccount,

      //      TreasuryPositionAccount.rgsber,

      //      TreasuryPositionAccount.rportb            as Portfolio,

      //      TreasuryPositionAccount.rerf,

      //      TreasuryPositionAccount.derf,

      //      TreasuryPositionAccount.terf,

      //      TreasuryPositionAccount.reher,

      //      TreasuryPositionAccount.rbear,

      //      TreasuryPositionAccount.dbear,

      //      TreasuryPositionAccount.tbear,

      //      TreasuryPositionAccount.rbher,

      //      TreasuryPositionAccount.blabla,

      //      TreasuryPositionAccount.attribute_sa01,

      //      TreasuryPositionAccount.attribute_sa02,

      //      TreasuryPositionAccount.attribute_sc03,

      //      TreasuryPositionAccount.attribute_sc04,

      //      TreasuryPositionAccount.attribute_ma01,

      //      TreasuryPositionAccount.attribute_ma02,

      //      TreasuryPositionAccount.attribute_mc03,

      //      TreasuryPositionAccount.attribute_mc04,

      //      TreasuryPositionAccount.attribute_la01,

      //      TreasuryPositionAccount.attribute_la02,

      //      TreasuryPositionAccount.attribute_lc03,

      //      TreasuryPositionAccount.attribute_lc04


      // Associations

      _CompanyCode

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TRFT_POS_ACCOUNT"
],
"ASSOCIATED":
[
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/