C_Ssp_Glaccountvh

DDL: C_SSP_GLACCOUNTVH SQL: CSSPGLACCOUNTVH Type: view CONSUMPTION
28 Fields 1 Data Sources

Consumption view for GL Account

C_Ssp_Glaccountvh is a Consumption CDS View that provides data about "Consumption view for GL Account" in SAP S/4HANA. It reads from 1 data source (I_GLAccount) and exposes 28 fields with key fields GLAccount, CompanyCode, ChartOfAccounts.

Data Sources (1)

SourceAliasJoin Type
I_GLAccount Glaccount from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSSPGLACCOUNTVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey GLAccount view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Consumption view for GL Account view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY GLAccount I_GLAccount GLAccount General Ledger
KEY CompanyCode I_GLAccount CompanyCode Receiver Company Code
KEY ChartOfAccounts I_GLAccount ChartOfAccounts Node Class
GLAccountGroup I_GLAccount GLAccountGroup Account Group
CorporateGroupAccount I_GLAccount CorporateGroupAccount Group Account Number
AccountIsBlockedForPosting I_GLAccount AccountIsBlockedForPosting Posting Block
AccountIsBlockedForPlanning I_GLAccount AccountIsBlockedForPlanning Planning Block
AccountIsBlockedForCreation I_GLAccount AccountIsBlockedForCreation Creation Block
IsBalanceSheetAccount I_GLAccount IsBalanceSheetAccount Is Balance Sheet Account
AccountIsMarkedForDeletion I_GLAccount AccountIsMarkedForDeletion Deletion Flag
PartnerCompany I_GLAccount PartnerCompany Trading Partner
FunctionalArea I_GLAccount FunctionalArea Sendr Fctl Area
CreationDate I_GLAccount CreationDate Time Stamp
SampleGLAccount I_GLAccount SampleGLAccount Sample Account
IsProfitLossAccount I_GLAccount IsProfitLossAccount
CreatedByUser I_GLAccount CreatedByUser User Name
ProfitLossAccountType I_GLAccount ProfitLossAccountType Profit Loss Account Type
ReconciliationAccountType I_GLAccount ReconciliationAccountType Reconcil. ID
LineItemDisplayIsEnabled I_GLAccount LineItemDisplayIsEnabled Line Items
IsOpenItemManaged I_GLAccount IsOpenItemManaged Open Item Management
AlternativeGLAccount I_GLAccount AlternativeGLAccount Group Account
AcctgDocItmDisplaySequenceRule I_GLAccount AcctgDocItmDisplaySequenceRule Sort key
GLAccountExternal I_GLAccount GLAccountExternal G/L Acct External ID
_CompanyCode _CompanyCode
_Text _Text
_ChartOfAccounts _ChartOfAccounts
_GLAccountHierarchyNode _GLAccountHierarchyNode
_FunctionalArea _FunctionalArea

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 C_Ssp_Glaccountvh.
-- 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: CSSPGLACCOUNTVH

CREATE VIEW C_Ssp_Glaccountvh AS
SELECT
  Glaccount.GLAccount AS GLAccount,
  Glaccount.CompanyCode AS CompanyCode,
  Glaccount.ChartOfAccounts AS ChartOfAccounts,
  Glaccount.GLAccountGroup AS GLAccountGroup,
  Glaccount.CorporateGroupAccount AS CorporateGroupAccount,
  Glaccount.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  Glaccount.AccountIsBlockedForPlanning AS AccountIsBlockedForPlanning,
  Glaccount.AccountIsBlockedForCreation AS AccountIsBlockedForCreation,
  Glaccount.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  Glaccount.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  Glaccount.PartnerCompany AS PartnerCompany,
  Glaccount.FunctionalArea AS FunctionalArea,
  Glaccount.CreationDate AS CreationDate,
  Glaccount.SampleGLAccount AS SampleGLAccount,
  Glaccount.IsProfitLossAccount AS IsProfitLossAccount,
  Glaccount.CreatedByUser AS CreatedByUser,
  Glaccount.ProfitLossAccountType AS ProfitLossAccountType,
  Glaccount.ReconciliationAccountType AS ReconciliationAccountType,
  Glaccount.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
  Glaccount.IsOpenItemManaged AS IsOpenItemManaged,
  Glaccount.AlternativeGLAccount AS AlternativeGLAccount,
  Glaccount.AcctgDocItmDisplaySequenceRule AS AcctgDocItmDisplaySequenceRule,
  Glaccount.GLAccountExternal AS GLAccountExternal
FROM I_GLAccount AS Glaccount
;

Learn More