I_GlAccountTextInCompanycode

DDL: I_GLACCOUNTTEXTINCOMPANYCODE SQL: IFIGLACCINCOCDT Type: view BASIC
9 Fields 2 Data Sources

G/L Account in Company Code - Text

I_GlAccountTextInCompanycode (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_GlAccountTextInCompanycode is a Basic CDS View that provides data about "G/L Account in Company Code - Text" in SAP S/4HANA. It reads from 2 data sources (P_Glacct_In_Cc, I_GLAccountText) and exposes 9 fields with key fields GLAccount, CompanyCode, Language.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-GL-N
CapabilitiesData Source for Defining CDS Entities, Language-Dependent Text, Data Source for Search
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description This CDS view provides the data to answer, for example, the following business questions:<ul> <li><p>Which company codes is a G/L account assigned to?</p></li> <li><p>Is this account relevant for open item management? If yes, which kind of open item management: standard, by ledger group, or extended open item management?</p></li> <li><p>What is the alternative account number for this G/L account in a particular company code?</p></li> <li><p>What is the account currency for a G/L account?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (2)

SourceAliasJoin Type
P_Glacct_In_Cc I_GLAccountInCompanyCode inner
I_GLAccountText I_GLAccountText from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IFIGLACCINCOCDT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label G/L Account in Company Code - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey GLAccount view
AbapCatalog.buffering.status #NOT_ALLOWED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
AbapCatalog.preserveKey true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY GLAccount I_GLAccountText GLAccount G/L Account Number
KEY CompanyCode P_Glacct_In_Cc CompanyCode Receiver Company Code
KEY Language I_GLAccountText Language Report Text Language
ChartOfAccounts I_GLAccountText ChartOfAccounts Chart of Accounts
GLAccountName G/L Account Name
GLAccountLongName G/L Account Long Name
_Language _Language
_CompanyCode _CompanyCode
_ChartOfAccounts _ChartOfAccounts

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_GlAccountTextInCompanycode.
-- 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: IFIGLACCINCOCDT

CREATE VIEW I_GlAccountTextInCompanycode AS
SELECT
  I_GLAccountText.GLAccount AS GLAccount,
  I_GLAccountInCompanyCode.CompanyCode AS CompanyCode,
  I_GLAccountText.Language AS Language,
  I_GLAccountText.ChartOfAccounts AS ChartOfAccounts,
  cast(I_GLAccountText.GLAccountName as fin_glaccount_name preserving type ) AS GLAccountName,
  cast(I_GLAccountText.GLAccountLongName as fis_txt50_skat preserving type ) AS GLAccountLongName
FROM I_GLAccountText
INNER JOIN P_Glacct_In_Cc AS I_GLAccountInCompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More