P_RecrrgSuplrInvcGLAccountVH

DDL: P_RECRRGSUPLRINVCGLACCOUNTVH SQL: PRSIGLACCOUNTVH Type: view BASIC

P_RecrrgSuplrInvcGLAccountVH is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_GLAccount) and exposes 8 fields with key fields GLAccount, CompanyCode. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccount _GLAccount from

Associations (2)

CardinalityTargetAliasCondition
[1..1] P_RecrrgSuplrInvcCoCodeVH _RecrrgSuplrInvcCoCodeVH _GLAccount.CompanyCode = _RecrrgSuplrInvcCoCodeVH.CompanyCode
[0..1] skat _GLAccountText _GLAccount.ChartOfAccounts = _GLAccountText.ktopl and _GLAccount.GLAccount = _GLAccountText.saknr and _GLAccountText.spras = $session.system_language

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRSIGLACCOUNTVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY GLAccount GLAccount
KEY CompanyCode _RecrrgSuplrInvcCoCodeVH CompanyCode
GLAccountExternal
GLAccountName _GLAccountText txt20
ChartOfAccounts ChartOfAccounts
GLAccountGroup GLAccountGroup
ReconciliationAccountType ReconciliationAccountType Reconcil. ID
AlternativeGLAccount AlternativeGLAccount 
@AbapCatalog.sqlViewName: 'PRSIGLACCOUNTVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@VDM.private:true
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
define view P_RecrrgSuplrInvcGLAccountVH as select from I_GLAccount as _GLAccount
  association [1..1] to P_RecrrgSuplrInvcCoCodeVH as _RecrrgSuplrInvcCoCodeVH on _GLAccount.CompanyCode = _RecrrgSuplrInvcCoCodeVH.CompanyCode
  association [0..1] to skat as _GLAccountText on _GLAccount.ChartOfAccounts = _GLAccountText.ktopl and _GLAccount.GLAccount = _GLAccountText.saknr
  and _GLAccountText.spras = $session.system_language
{
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.9
  @Search.ranking: #HIGH
  key GLAccount,
  key _RecrrgSuplrInvcCoCodeVH.CompanyCode as CompanyCode,
  @Search.fuzzinessThreshold: 0.9
  cast( GLAccountExternal as fac_sakan ) as GLAccountExternal,
  _GLAccountText.txt20 as GLAccountName,
  ChartOfAccounts,
  GLAccountGroup,
  @EndUserText.label: 'Reconcil. ID'
  ReconciliationAccountType,
  AlternativeGLAccount
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNT",
"P_RECRRGSUPLRINVCCOCODEVH",
"SKAT"
],
"ASSOCIATED":
[
"P_RECRRGSUPLRINVCCOCODEVH",
"SKAT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More