P_GLAccountBalanceInCCCrcy2

DDL: P_GLACCOUNTBALANCEINCCCRCY2 SQL: PGLBALANCE2 Type: view CONSUMPTION
12 Fields 1 Data Sources

P_GLAccountBalanceInCCCrcy2 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemSemTag) and exposes 12 fields.

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItemSemTag I_GLAccountLineItemSemTag from

Parameters (2)

NameTypeDefault
P_FiscalPeriod fins_fiscalperiod
P_FiscalYear gjahr

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PGLBALANCE2 view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
Ledger Ledger Ledger
CompanyCode CompanyCode Receiver Company Code
GLAccountHierarchy GLAccountHierarchy
SemanticTag SemanticTag Semantic Tag
FiscalYear FiscalYear G/L Fiscal Year
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
PostingDate PostingDate Posting Date for GR
SemanticTagName
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
GLAccount GLAccount General Ledger

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_GLAccountBalanceInCCCrcy2.
-- 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: PGLBALANCE2
-- Parameters: P_FiscalPeriod : fins_fiscalperiod, P_FiscalYear : gjahr

CREATE VIEW P_GLAccountBalanceInCCCrcy2 AS
SELECT
  Ledger,
  CompanyCode,
  GLAccountHierarchy,
  SemanticTag,
  FiscalYear,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  PostingDate,
  _SemanticTag._Text[1:Language = $session.system_language].SemanticTagName AS SemanticTagName,
  ProfitCenter,
  ControllingArea,
  GLAccount
FROM I_GLAccountLineItemSemTag
;

Learn More