C_ReconAccountVHTemp

DDL: C_RECONACCOUNTVHTEMP SQL: CRECONACCTVH Type: view CONSUMPTION Package: VDM_MD_BP

Reconciliation Account

C_ReconAccountVHTemp is a Consumption CDS View that provides data about "Reconciliation Account" in SAP S/4HANA. It reads from 1 data source (I_GLAccountInChartOfAccounts) and exposes 5 fields with key field ReconciliationAccount. It has 2 associations to related views. Part of development package VDM_MD_BP.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_ReconAccountTextVHTemp _Text I_GLAccountInChartOfAccounts.GLAccount = _Text.GLAccount and I_GLAccountInChartOfAccounts.ChartOfAccounts = _Text.ChartOfAccounts
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRECONACCTVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey ReconciliationAccount view
Search.searchable true view
EndUserText.label Reconciliation Account view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ReconciliationAccount I_GLAccountInChartOfAccounts GLAccount
CompanyCodeasCompanyCode
ChartOfAccountsasChartOfAccounts
ChartofAccounts_Text
_CompanyCode _CompanyCode 
@AbapCatalog.sqlViewName: 'CRECONACCTVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ObjectModel.representativeKey: 'ReconciliationAccount'
@Search.searchable: true
@EndUserText.label: 'Reconciliation Account'

//THIS IS FOR SUPPLIERS ONLY

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER


define view C_ReconAccountVHTemp
as  

select
from I_GLAccountInChartOfAccounts -- G/L Account Master Record (Chart of Accounts)
join I_GLAccountInCompanyCode-- G/L Account Master Record (Company Code)
  on I_GLAccountInCompanyCode.GLAccount = I_GLAccountInChartOfAccounts.GLAccount
join I_CompanyCode -- Company Code
  on I_GLAccountInCompanyCode.CompanyCode = I_CompanyCode.CompanyCode and I_GLAccountInChartOfAccounts.ChartOfAccounts = I_CompanyCode.ChartOfAccounts -- Chart of Accounts

association [0..*] to C_ReconAccountTextVHTemp as _Text on I_GLAccountInChartOfAccounts.GLAccount = _Text.GLAccount
                                                             and I_GLAccountInChartOfAccounts.ChartOfAccounts = _Text.ChartOfAccounts
                                                             
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode

{
  @ObjectModel.text.association: '_Text'
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.75
  @Search.ranking: #HIGH
  key I_GLAccountInChartOfAccounts.GLAccount as ReconciliationAccount, -- Reconcialition Account key
      //--[ GENERATED:012:GlBfhyJl7kY4i6}7dD1KRG

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

  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.75
  @Search.ranking: #HIGH
  @ObjectModel.foreignKey.association: '_CompanyCode'
  key I_GLAccountInCompanyCode.CompanyCode as CompanyCode, -- Company Code
  @UI.hidden: true
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.75
  @Search.ranking: #HIGH
  I_GLAccountInChartOfAccounts.ChartOfAccounts as ChartOfAccounts, -- Chart of Accounts
  _Text,
  _CompanyCode

}
where I_GLAccountInCompanyCode.ReconciliationAccountType = 'K' -- Reconciliation indicator = 'K' (Suppliers)

Learn More