P_GlAccountByFinMgmtArea

DDL: P_GLACCOUNTBYFINMGMTAREA SQL: PCFIGLACCBYFMA Type: view CONSUMPTION
19 Fields 1 Data Sources 1 Associations

GL Account by Financial Management Area

P_GlAccountByFinMgmtArea is a Consumption CDS View that provides data about "GL Account by Financial Management Area" in SAP S/4HANA. It reads from 1 data source (I_GLAccount) and exposes 19 fields with key fields GLAccount, CompanyCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_GLAccount I_GLAccount from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FieldStatusGroup _FieldStatusGroup $projection.FieldStatusVariant = _FieldStatusGroup.FieldStatusVariant and $projection.FieldStatusGroup = _FieldStatusGroup.FieldStatusGroup

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.sqlViewName PCFIGLACCBYFMA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
EndUserText.label GL Account by Financial Management Area view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY GLAccount GLAccount General Ledger
KEY CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CompanyCodeExtendedName
FinancialManagementArea _CompanyCode FinancialManagementArea Financial Management Area
GLAccountName
GLAccountExtendedName
GLAccountLongName Description
AuthorizationGroup _GLAccountInCompanyCode AuthorizationGroup AuthorizGroup
AccountingClerk _GLAccountInCompanyCode AccountingClerk Clerk Abbrev.
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
CommitmentItemShortID _GLAccountInCompanyCode CommitmentItem Commitment item
FieldStatusVariant _CompanyCode FieldStatusVariant Fld stat.var.
FieldStatusGroup _GLAccountInCompanyCode FieldStatusGroup Field Status Grp
GLAccountType _GLAccountInChartOfAccounts GLAccountType Account Type
GLAccountTypeName
ChartOfAccounts ChartOfAccounts Node Class
_FieldStatusGroup _FieldStatusGroup

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_GlAccountByFinMgmtArea.
-- 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: PCFIGLACCBYFMA

CREATE VIEW P_GlAccountByFinMgmtArea AS
SELECT
  GLAccount,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast( concat_with_space(CompanyCode, _CompanyCode.CompanyCodeName, 1) as fmis_companycodeextendedname ) AS CompanyCodeExtendedName,
  _CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  _GLAccountInCompanyCode._Text[1:Language = $session.system_language].GLAccountName AS GLAccountName,
  cast( concat_with_space(GLAccount, _Text[1:Language = $session.system_language].GLAccountName, 1) as fmis_glaccountextendedname ) AS GLAccountExtendedName,
  _GLAccountInCompanyCode._Text[1:Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
  _GLAccountInCompanyCode.AuthorizationGroup AS AuthorizationGroup,
  _GLAccountInCompanyCode.AccountingClerk AS AccountingClerk,
  CreationDate,
  CreatedByUser,
  _GLAccountInCompanyCode.CommitmentItem AS CommitmentItemShortID,
  _CompanyCode.FieldStatusVariant AS FieldStatusVariant,
  _GLAccountInCompanyCode.FieldStatusGroup AS FieldStatusGroup,
  _GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  _GLAccountInChartOfAccounts._GLAccountType._GLAccountTypeText[1:Language=$session.system_language].GLAccountTypeName AS GLAccountTypeName,
  ChartOfAccounts
FROM I_GLAccount
LEFT OUTER JOIN I_FieldStatusGroup AS _FieldStatusGroup ON FieldStatusVariant = _FieldStatusGroup.FieldStatusVariant AND FieldStatusGroup = _FieldStatusGroup.FieldStatusGroup  -- association [0..1]
;

Learn More