C_InventoryGLAcctBalQuery

DDL: C_INVENTORYGLACCTBALQUERY SQL: CINVTRGLACBALQ Type: view CONSUMPTION
36 Fields

Turkey Inventory CDS query

C_InventoryGLAcctBalQuery is a Consumption CDS View that provides data about "Turkey Inventory CDS query" in SAP S/4HANA.

Parameters (3)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_FinancialStatementVersion versn_011

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CINVTRGLACBALQ view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.query true view
EndUserText.label Turkey Inventory CDS query view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SourceLedger SourceLedger Source Ledger
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY Ledger Ledger Ledger
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptRunID StatryRptRunID Report Run ID
GLAccount GLAccount General Ledger
BusinessArea BusinessArea Business Area
ChartOfAccounts ChartOfAccounts Node Class
AlternativeGLAccount AlternativeGLAccount Group Account
Material Material Vehicle Model
Supplier Supplier Supplier
Customer Customer Sold-to Party
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
Cheque Cheque Cheque No
InventoryDescription InventoryDescription
ReconciliationAccountType ReconciliationAccountType Reconcil. ID
CorporateGroupChartOfAccounts CorporateGroupChartOfAccounts Group ChtAccts
GLAccountGroup GLAccountGroup Account Group
GLAccountLongName GLAccountLongName Long Text
ValuationArea ValuationArea Valuation Area
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
InvtrySpclStockWBSElmntIntID InvtrySpclStockWBSElmntIntID
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
AssetDepreciationArea AssetDepreciationArea Deprec. Area
InventoryQty InventoryQty
BaseUnit BaseUnit Unit of Measure
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts

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_InventoryGLAcctBalQuery.
-- 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: CINVTRGLACBALQ
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FinancialStatementVersion : versn_011

CREATE VIEW C_InventoryGLAcctBalQuery AS
SELECT
  CompanyCode,
  FiscalYear,
  SourceLedger,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  StatryRptCategory,
  StatryRptgEntity,
  StatryRptRunID,
  GLAccount,
  BusinessArea,
  ChartOfAccounts,
  AlternativeGLAccount,
  Material,
  Supplier,
  Customer,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  MasterFixedAsset,
  FixedAsset,
  Cheque,
  InventoryDescription,
  ReconciliationAccountType,
  CorporateGroupChartOfAccounts,
  GLAccountGroup,
  GLAccountLongName,
  ValuationArea,
  SalesDocument,
  SalesDocumentItem,
  InvtrySpclStockWBSElmntIntID,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  AssetDepreciationArea,
  InventoryQty,
  BaseUnit,
  CountryChartOfAccounts
;

Learn More