I_CustomerSupplierGLAccount

DDL: I_CUSTOMERSUPPLIERGLACCOUNT SQL: ICSGLACCT Type: view BASIC
17 Fields 3 Data Sources 1 Associations

Customer VH, Supplier VH, G/L Account VH

I_CustomerSupplierGLAccount is a Basic CDS View that provides data about "Customer VH, Supplier VH, G/L Account VH" in SAP S/4HANA. It reads from 3 data sources (gl_acct_cc, m_debid, m_kredk) and exposes 17 fields with key fields CustomerSupplierAccount, CompanyCode, FinancialAccountType, ChartOfAccounts, CompanyCode. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
gl_acct_cc gl_acct_cc union_all
m_debid m_debid from
m_kredk m_kredk union_all

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_FinancialAccountTypeText _Text $projection.FinancialAccountType = _Text.FinancialAccountType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICSGLACCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #BASIC view
EndUserText.label Customer VH, Supplier VH, G/L Account VH view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CustomerSupplierAccount kunnr Stock customer
KEY CompanyCode bukrs Value
KEY FinancialAccountType
KEY ChartOfAccounts G/L Chart of Accounts
AuthorizationGroup begru AuthorizGroup
IsMarkedForDeletion loevm End Contract
KEY CompanyCode bukrs Value
KEY FinancialAccountType
KEY ChartOfAccounts G/L Chart of Accounts
AuthorizationGroup begru AuthorizGroup
IsMarkedForDeletion loevm End Contract
KEY CompanyCode bukrs Value
KEY FinancialAccountType
KEY ChartOfAccounts ktopl G/L Chart of Accounts
AuthorizationGroup AuthorizGroup
IsMarkedForDeletion End Contract
_Text _Text

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_CustomerSupplierGLAccount.
-- 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: ICSGLACCT

CREATE VIEW I_CustomerSupplierGLAccount AS
SELECT
  kunnr AS CustomerSupplierAccount,
  bukrs AS CompanyCode,
  'D' AS FinancialAccountType,
  cast( '' as ktopl ) AS ChartOfAccounts,
  begru AS AuthorizationGroup,
  loevm AS IsMarkedForDeletion
FROM m_debid
LEFT OUTER JOIN I_FinancialAccountTypeText AS _Text ON FinancialAccountType = _Text.FinancialAccountType  -- association [0..*]
-- UNION ALL with additional select branch(es): m_kredk, gl_acct_cc
;

Learn More