P_GLACCT_IN_CC

CDS View

P_GLACCT_IN_CC is a CDS View in S/4HANA. It contains 16 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 16 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_GLAccount view from BASIC General Ledger Account
I_GlAccountTextInCompanycode view inner BASIC G/L Account in Company Code - Text
I_PubSecBudgetAccount view inner BASIC Budget Account
I_PubSecBudgetAccountText view inner BASIC Budget Account - Text

Fields (16)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY GLAccount GLAccount 1
AccountIsBlockedForPosting AccountIsBlockedForPosting 1
AccountIsMarkedForDeletion AccountIsMarkedForDeletion 1
AcctgDocItmDisplaySequenceRule AcctgDocItmDisplaySequenceRule 1
AlternativeGLAccount AlternativeGLAccount 1
AuthorizationGroup AuthorizationGroup 1
ChartOfAccounts ChartOfAccounts 1
CountryChartOfAccounts CountryChartOfAccounts 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
IsAutomaticallyPosted IsAutomaticallyPosted 1
IsOpenItemManaged IsOpenItemManaged 1
LineItemDisplayIsEnabled LineItemDisplayIsEnabled 1
ReconciliationAccountType ReconciliationAccountType 1
TaxCategory TaxCategory 1 
@AbapCatalog.sqlViewName: 'PFIGLACCTINCC'
@VDM.viewType: #BASIC
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey:true
define view P_Glacct_In_Cc 
as select from I_GLAccountInCompanyCode {
  key GLAccount,
  key 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,
      _CompanyCode.CountryChartOfAccounts,
      _GLAcctInCoCodeStatus,
      _User,
      _CompanyCode,
      _Text,
      _Reconciliationaccttype,
      _JointVentureRecovery,
      _MultiCurrencyAccounting,
      _TaxCategory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_GLACCOUNTINCOMPANYCODE"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_GLACCOUNTTEXTINCOMPANYCODE",
"I_GLACCTINCOCODEIMPLEMENTSTAT",
"I_JOINTVENTURERECOVERY",
"I_MULTICURRENCYACCOUNTING",
"I_RECONCILIATIONACCTTYPE",
"I_TAXCATEGORY",
"I_USER"
],
"BASE":
[
"I_GLACCOUNTINCOMPANYCODE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More