P_Glacct_In_Cc

DDL: P_GLACCT_IN_CC SQL: PFIGLACCTINCC Type: view BASIC
50 Fields 1 Data Sources

P_Glacct_In_Cc is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_GLAccountInCompanyCode) and exposes 50 fields with key fields GLAccount, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_GLAccountInCompanyCode I_GLAccountInCompanyCode from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFIGLACCTINCC view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY GLAccount GLAccount General Ledger
KEY CompanyCode CompanyCode Receiver Company Code
AuthorizationGroup AuthorizationGroup AuthorizGroup
AccountingClerk AccountingClerk Clerk Abbrev.
LastInterestCalcRunDate LastInterestCalcRunDate Last Int. Calc.
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
PlanningLevel PlanningLevel Planning Level
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
ExchRateDifferencesAccountDetn ExchRateDifferencesAccountDetn E/R Diff. Key
ReconciliationAccountType ReconciliationAccountType Reconcil. ID
TaxCategory TaxCategory Tax Code
InterestCalculationCode InterestCalculationCode Interest Indic.
GLAccountCurrency GLAccountCurrency Currency
ReconciliationAcctIsChangeable ReconciliationAcctIsChangeable Rec.Act Ready
IsManagedExternally IsManagedExternally Is Managed Ext.
IsAutomaticallyPosted IsAutomaticallyPosted Auto. Posting
LineItemDisplayIsEnabled LineItemDisplayIsEnabled Line Items
SupplementIsAllowed SupplementIsAllowed Supplement
IsOpenItemManaged IsOpenItemManaged Open Item Management
InterestCalculationDate InterestCalculationDate Last Key Date
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths Int.Calc.Freq.
AcctgDocItmDisplaySequenceRule AcctgDocItmDisplaySequenceRule Sort key
AlternativeGLAccount AlternativeGLAccount Group Account
JointVentureRecoveryCode JointVentureRecoveryCode Recovery Ind.
CommitmentItem CommitmentItem Commitment item
TaxCodeIsRequired TaxCodeIsRequired Pstg w/o tax allowed
BalanceHasLocalCurrency BalanceHasLocalCurrency Balances in LC
ValuationGroup ValuationGroup Valuation Group
APARToleranceGroup APARToleranceGroup Tolerance Group
AccountIsBlockedForPosting AccountIsBlockedForPosting Posting Block
AccountIsMarkedForDeletion AccountIsMarkedForDeletion Deletion Flag
ClearingIsLedgerGroupSpecific ClearingIsLedgerGroupSpecific OI Mgmt by LedgerGrp
CashPlanningGroup CashPlanningGroup Planning Group
IsCashFlowAccount IsCashFlowAccount Rel.Cash Flow
GLAcctInflationKey GLAcctInflationKey Inflation key
FieldStatusGroup FieldStatusGroup Field Status Grp
MultiCurrencyAccountingCode MultiCurrencyAccountingCode MCA Key
ChartOfAccounts _CompanyCode ChartOfAccounts Node Class
CountryChartOfAccounts _CompanyCode CountryChartOfAccounts Chart of Accts
_GLAcctInCoCodeStatus _GLAcctInCoCodeStatus
_User _User
_CompanyCode _CompanyCode
_Text _Text
_Reconciliationaccttype _Reconciliationaccttype
_JointVentureRecovery _JointVentureRecovery
_MultiCurrencyAccounting _MultiCurrencyAccounting
_TaxCategory _TaxCategory

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_Glacct_In_Cc.
-- 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: PFIGLACCTINCC

CREATE VIEW P_Glacct_In_Cc AS
SELECT
  GLAccount,
  CompanyCode,
  AuthorizationGroup,
  AccountingClerk,
  LastInterestCalcRunDate,
  CreationDate,
  CreatedByUser,
  LastChangeDateTime,
  PlanningLevel,
  HouseBank,
  HouseBankAccount,
  ExchRateDifferencesAccountDetn,
  ReconciliationAccountType,
  TaxCategory,
  InterestCalculationCode,
  GLAccountCurrency,
  ReconciliationAcctIsChangeable,
  IsManagedExternally,
  IsAutomaticallyPosted,
  LineItemDisplayIsEnabled,
  SupplementIsAllowed,
  IsOpenItemManaged,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  AcctgDocItmDisplaySequenceRule,
  AlternativeGLAccount,
  JointVentureRecoveryCode,
  CommitmentItem,
  TaxCodeIsRequired,
  BalanceHasLocalCurrency,
  ValuationGroup,
  APARToleranceGroup,
  AccountIsBlockedForPosting,
  AccountIsMarkedForDeletion,
  ClearingIsLedgerGroupSpecific,
  CashPlanningGroup,
  IsCashFlowAccount,
  GLAcctInflationKey,
  FieldStatusGroup,
  MultiCurrencyAccountingCode,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  _CompanyCode.CountryChartOfAccounts AS CountryChartOfAccounts
FROM I_GLAccountInCompanyCode
;

Learn More