I_VN_TrialBalanceItemCube

DDL: I_VN_TRIALBALANCEITEMCUBE Type: view_entity COMPOSITE Package: GLO_FIN_IS_VN_TRIAL_BALANCE
55 Fields 1 Data Sources

VN Trial Balance Analytical - Cube

I_VN_TrialBalanceItemCube is a Composite CDS View (Cube) that provides data about "VN Trial Balance Analytical - Cube" in SAP S/4HANA. It reads from 1 data source (P_VN_TrialBalanceItem) and exposes 55 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument. Part of development package GLO_FIN_IS_VN_TRIAL_BALANCE.

Data Sources (1)

SourceAliasJoin Type
P_VN_TrialBalanceItem P_VN_TrialBalanceItem from

Parameters (4)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_FromPostingDate fis_budat_from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label VN Trial Balance Analytical - Cube view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY Ledger Ledger Ledger
FiscalPeriod FiscalPeriod Tax period
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
DebitCreditCode DebitCreditCode Single-Character Flag
AccountingDocumentType AccountingDocumentType Journal Entry Type
ChartOfAccounts ChartOfAccounts Node Class
GLAccount GLAccount General Ledger
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts
AlternativeGLAccount AlternativeGLAccount Group Account
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
Segment Segment Segment number
Supplier Supplier Supplier
Customer Customer Sold-to Party
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
CompanyCodeCurrency CompanyCodeCurrency Local Currency
DebitStartingBalAmtInCCCrcy DebitStartingBalAmtInCCCrcy
CreditStartingBalAmtInCCCrcy CreditStartingBalAmtInCCCrcy
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
DebitEndingBalAmtInCCCrcy DebitEndingBalAmtInCCCrcy
CreditEndingBalAmtInCCCrcy CreditEndingBalAmtInCCCrcy
TransactionCurrency TransactionCurrency Transaction Currency
DebitStartingBalAmtInTransCrcy DebitStartingBalAmtInTransCrcy
CrdtStartingBalAmtInTransCrcy CrdtStartingBalAmtInTransCrcy
DebitAmountInTransCrcy DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInTransCrcy CreditAmountInTransCrcy Credit Amt in DC
DebitEndingBalAmtInTransCrcy DebitEndingBalAmtInTransCrcy
CreditEndingBalAmtInTransCrcy CreditEndingBalAmtInTransCrcy
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
DebitStartingBalAmtInGlobCrcy DebitStartingBalAmtInGlobCrcy
CreditStartingBalAmtInGlobCrcy CreditStartingBalAmtInGlobCrcy
DebitAmountInGlobalCrcy DebitAmountInGlobalCrcy
CreditAmountInGlobalCrcy CreditAmountInGlobalCrcy
DebitEndingBalAmtInGlobalCrcy DebitEndingBalAmtInGlobalCrcy
CreditEndingBalAmtInGlobalCrcy CreditEndingBalAmtInGlobalCrcy
SupplierName _SupplierText SupplierName Supplier Name
CustomerName _CustomerText CustomerName Name of Customer
CompanyCodeName _CompanyCodeText CompanyCodeName Company Name
SegmentName
ProfitCenterName
AccountingDocumentTypeName
AlternativeGLAccountName
GLAccountName

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_VN_TrialBalanceItemCube.
-- 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.
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_FromPostingDate : fis_budat_from

CREATE VIEW I_VN_TrialBalanceItemCube AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  LedgerGLLineItem,
  Ledger,
  FiscalPeriod,
  PostingDate,
  DocumentDate,
  DebitCreditCode,
  AccountingDocumentType,
  ChartOfAccounts,
  GLAccount,
  CountryChartOfAccounts,
  AlternativeGLAccount,
  ProfitCenter,
  ControllingArea,
  Segment,
  Supplier,
  Customer,
  SalesDocument,
  SalesDocumentItem,
  PurchasingDocument,
  PurchasingDocumentItem,
  CompanyCodeCurrency,
  DebitStartingBalAmtInCCCrcy,
  CreditStartingBalAmtInCCCrcy,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  DebitEndingBalAmtInCCCrcy,
  CreditEndingBalAmtInCCCrcy,
  TransactionCurrency,
  DebitStartingBalAmtInTransCrcy,
  CrdtStartingBalAmtInTransCrcy,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  DebitEndingBalAmtInTransCrcy,
  CreditEndingBalAmtInTransCrcy,
  GlobalCurrency,
  DebitStartingBalAmtInGlobCrcy,
  CreditStartingBalAmtInGlobCrcy,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  DebitEndingBalAmtInGlobalCrcy,
  CreditEndingBalAmtInGlobalCrcy,
  _SupplierText.SupplierName AS SupplierName,
  _CustomerText.CustomerName AS CustomerName,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  _SegmentText[1:Language = $session.system_language].SegmentName AS SegmentName,
  _ProfitCenterText[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  _AccountingDocumentTypeText[1:Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  cast(_AlternativeGLAccountText[1:Language = $session.system_language].GLAccountName as fis_altkt_txt50) AS AlternativeGLAccountName,
  _GLAccountTxt[1:Language = $session.system_language].GLAccountName AS GLAccountName
FROM P_VN_TrialBalanceItem
;

Learn More