P_RecrrgSuplrInvcGLAccountVH

DDL: P_RECRRGSUPLRINVCGLACCOUNTVH SQL: PRSIGLACCOUNTVH Type: view BASIC
8 Fields 1 Data Sources 2 Associations

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.

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 General Ledger
KEY CompanyCode _RecrrgSuplrInvcCoCodeVH CompanyCode Receiver Company Code
GLAccountExternal G/L Acct External ID
GLAccountName _GLAccountText txt20 Text 20
ChartOfAccounts ChartOfAccounts Node Class
GLAccountGroup GLAccountGroup Account Group
ReconciliationAccountType ReconciliationAccountType Reconcil. ID
AlternativeGLAccount AlternativeGLAccount Group Account

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RecrrgSuplrInvcGLAccountVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PRSIGLACCOUNTVH

CREATE VIEW P_RecrrgSuplrInvcGLAccountVH AS
SELECT
  GLAccount,
  _RecrrgSuplrInvcCoCodeVH.CompanyCode AS CompanyCode,
  cast( GLAccountExternal as fac_sakan ) AS GLAccountExternal,
  _GLAccountText.txt20 AS GLAccountName,
  ChartOfAccounts,
  GLAccountGroup,
  ReconciliationAccountType,
  AlternativeGLAccount
FROM I_GLAccount AS _GLAccount
LEFT OUTER JOIN P_RecrrgSuplrInvcCoCodeVH AS _RecrrgSuplrInvcCoCodeVH ON _GLAccount.CompanyCode = _RecrrgSuplrInvcCoCodeVH.CompanyCode  -- association [1..1]
LEFT OUTER JOIN skat AS _GLAccountText ON _GLAccount.ChartOfAccounts = _GLAccountText.ktopl AND _GLAccount.GLAccount = _GLAccountText.saknr AND _GLAccountText.spras = $session.system_language  -- association [0..1]
;

Learn More