I_ProcmtHubGLAccountText

DDL: I_PROCMTHUBGLACCOUNTTEXT SQL: IHUBGLACCTSTXT Type: view BASIC
7 Fields 1 Data Sources 2 Associations

Basic View for G/L Account Description from Back-End System

I_ProcmtHubGLAccountText is a Basic CDS View that provides data about "Basic View for G/L Account Description from Back-End System" in SAP S/4HANA. It reads from 1 data source (mmpur_ext_skat) and exposes 7 fields with key fields ProcurementHubSourceSystem, ChartOfAccounts, GLAccount, Language. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mmpur_ext_skat mmpur_ext_skat from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProcmtHubGLAcctInChtOfAccts _ProcmtHubGLAcctInChtOfAccts $projection.GLAccount = _ProcmtHubGLAcctInChtOfAccts.GLAccount and $projection.ChartOfAccounts = _ProcmtHubGLAcctInChtOfAccts.ChartOfAccounts and $projection.ProcurementHubSourceSystem = _ProcmtHubGLAcctInChtOfAccts.ProcurementHubSourceSystem
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IHUBGLACCTSTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Basic View for G/L Account Description from Back-End System view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ProcurementHubSourceSystem extsourcesystem Connected System ID
KEY ChartOfAccounts chartofaccounts Node Class
KEY GLAccount glaccount General Ledger
KEY Language language Report Text Language
GLAccountLongName glaccountlongname Long Text
_ProcmtHubGLAcctInChtOfAccts _ProcmtHubGLAcctInChtOfAccts
_Language _Language

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 I_ProcmtHubGLAccountText.
-- 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: IHUBGLACCTSTXT

CREATE VIEW I_ProcmtHubGLAccountText AS
SELECT
  extsourcesystem AS ProcurementHubSourceSystem,
  ChartOfAccounts,
  GLAccount,
  Language,
  GLAccountLongName
FROM mmpur_ext_skat
LEFT OUTER JOIN I_ProcmtHubGLAcctInChtOfAccts AS _ProcmtHubGLAcctInChtOfAccts ON GLAccount = _ProcmtHubGLAcctInChtOfAccts.GLAccount AND ChartOfAccounts = _ProcmtHubGLAcctInChtOfAccts.ChartOfAccounts AND ProcurementHubSourceSystem = _ProcmtHubGLAcctInChtOfAccts.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More