Which CDS Views use I_GLACCOUNTINCOMPANYCODE?

I_GLACCOUNTINCOMPANYCODE is used by 77 CDS view(s), including: C_AllocationSenderGLAcctVH, C_AR_StRpPurFrgnSrvcCube, C_CL_StRpGLAcctInCompanyCode, C_GLAcctInCoCodeChangeLog, C_GLAcctWthHouseBankAcctVH, C_NL_SAFTGeneralLedger, C_OverheadAllocationAccountVH, C_PE_GLAcctHierarchyInCoCode, C_PT_SAFTCustomerDocument, C_PT_SAFTGenLdgrCustVATReg.

How many fields does I_GLACCOUNTINCOMPANYCODE have?

I_GLACCOUNTINCOMPANYCODE has 45 fields. Key fields: AuthorizationGroup, CompanyCode, GLAccount.

I_GLACCOUNTINCOMPANYCODE

CDS View

45 Fields 77 CDS Views

General Ledger Account in Company Code

I_GLACCOUNTINCOMPANYCODE is a CDS View in S/4HANA. General Ledger Account in Company Code. It contains 45 fields. 77 CDS views read from this table.

CDS Views using this table (77)

View	Type	Join	VDM	Description
C_AllocationSenderGLAcctVH	view	from	CONSUMPTION	Account Number
C_AR_StRpPurFrgnSrvcCube	view	left_outer	CONSUMPTION	Cube View For Argentina Foreign Service
C_CL_StRpGLAcctInCompanyCode	view	from	CONSUMPTION	G/L Acct in Company Code for Chile Rptg
C_GLAcctInCoCodeChangeLog	view	inner	CONSUMPTION	GL account in company code change log
C_GLAcctWthHouseBankAcctVH	view	from	CONSUMPTION	GL/Account with HouseBank & HouseBankAcc
C_NL_SAFTGeneralLedger	view	inner	CONSUMPTION	SAF-T NL General Ledger
C_OverheadAllocationAccountVH	view	inner	CONSUMPTION	Overhead Allocation Account Value Help
C_PE_GLAcctHierarchyInCoCode	view	left_outer	CONSUMPTION	Acc. Ctrl. for Jrnl Entry Item Cube View
C_PT_SAFTCustomerDocument	view_entity	inner	CONSUMPTION	Customer to Doc Header Section - Cube
C_PT_SAFTGenLdgrCustVATReg	view_entity	inner	CONSUMPTION	SAFTPT Customer VAT Reg Master Data
C_PT_SAFTGenLdgrSuplrVATReg	view_entity	inner	CONSUMPTION	SAFTPT Supplier VAT Reg Master Data
C_RO_StRpCashJournalC	view_entity	from	CONSUMPTION	Romanian Cash Journal - Cube
C_UnivAllocOverheadAccountVH	view_entity	inner	CONSUMPTION	Overhead Allocation Account
FAC_DART_Z3_CHARTOFACCOUNTS	view	inner		Chart Of Accounts Master
FIISAL_GR_AltvGLAcctHierDetail	view_entity	from		Greece GLAccount global hierarchy detail
FIISAL_GR_AltvGLAcctHierDetail	view_entity	union		Greece GLAccount global hierarchy detail
FIISAL_GR_ALTVGLACCTHIERDETL2	view_entity	from		Greece GLAccount global hierarchy detail
FIISAL_GR_ALTVGLACCTHIERDETL2	view_entity	union		Greece GLAccount global hierarchy detail
FIISAL_GR_GLAcctHierDetail	view_entity	from		Greece GLAccount global hierarchy detail
FIISAL_GR_GLAcctHierDetail	view_entity	union		Greece GLAccount global hierarchy detail
FIISAL_GR_GLACCTHIERDETAIL2	view_entity	from		Greece GLAccount global hierarchy detail
FIISAL_GR_GLACCTHIERDETAIL2	view_entity	union		Greece GLAccount global hierarchy detail
I_GLAccountInCompanyCodeStdVH	view	from	COMPOSITE	General Ledger Account in Company Code
I_GLAcctInCoCode	view_entity	from	BASIC	General Ledger Account in Company Code
I_LU_SAFTJournalEntry	view	inner	COMPOSITE	SAFT LU General Ledger Documents
I_PT_DelDocCustAddrHist	view	left_outer	COMPOSITE	SAF-T PT Delivery Doc CustAddr History
I_PT_SAFTAccountingCustomer	view	inner	COMPOSITE	SAF-T PT Accounting Customer
I_PT_SAFTAcctgCustTaxRegnNmbr	view	inner	COMPOSITE	SAF-T Accounting Tax Registration Number
I_PT_SAFTAcctgDocCustAddrHist	view	left_outer	COMPOSITE	SAF-T PT AccountingDoc CustAddr History
I_PT_SAFTAcctgOneTimeCustomer	view	inner	COMPOSITE	SAF-T PT Accounting One Time Customer
I_PT_SAFTAcctgSupTaxRegnNmbr	view	inner	COMPOSITE	SAF-T PT Registration Number Suppliers
I_PT_SAFTBillAcctgOneTimeCust	view_entity	inner	COMPOSITE	One Time Customer from Accounting Doc
I_PT_SAFTBillgAcctgCustomer	view_entity	inner	COMPOSITE	Customer from Accounting Document
I_PT_SAFTBillgDocCustAddrHist	view	left_outer	COMPOSITE	SAF-T PT BillingDoc CustAddr History
I_PT_SAFTBillingCustomer	view	inner	COMPOSITE	SAF-T PT Billing Customer
I_PT_SAFTGenLdgrOneTmeSupplier	view	inner	COMPOSITE	SAFT PT GLEntries OTS
I_PT_SAFTGenLedCustTaxRegnNmbr	view	inner	COMPOSITE	SAF-T PT GL Registration Number Customer
I_PT_SAFTGenLedgerItem	view	inner	COMPOSITE	SAF-T PT Journal Ledger Entry Item
I_PT_SAFTGenLedgerSupplier	view	inner	COMPOSITE	SAFT PT GLEntries Supplier
I_PT_SAFTOneTimeCustBillg	view_entity	inner	COMPOSITE	One Time Customer from Billing Document
I_PT_SAFTPaymentCustomer	view	inner	COMPOSITE	SAF-T Payment Customer
I_PT_SAFTPaytCustTaxRegnNmbr	view	inner	COMPOSITE	SAF-T Payment Tax Registration Number
I_PT_SAFTSettlmtMgmtCustomer	view	inner	COMPOSITE	SAF-T PT Settlement Management Customer
I_PT_SAFTSettlmtMgmtTaxRegNmbr	view	inner	COMPOSITE	SAF-T PT Settlement Mgm Tax Reg Customer
I_PT_SAFTSlsInvcBillgCust	view_entity	inner	COMPOSITE	Customer from Billing Document
I_SAFTJournalLineItem	view	inner	COMPOSITE	SAF-T Journal Item
P_AR_CashJournalEntry	view_entity	from	COMPOSITE	Argentina Cash Journal Accounts Selection
P_AR_GLCashFlowRlvtAcct	view_entity	from	COMPOSITE	Argentina G/L Cash Flow Relevant Accounts
P_CN_CADEGLAccountFSVItem	view	left_outer	CONSUMPTION	CADE General Ledger Account with FSV Item
P_CN_CADEGLAccountFSVItem2	view	left_outer	COMPOSITE	CADE General Ledger Account with FSV Item (Copy)
P_CN_CADEGLLeafItemAccount	view	left_outer	CONSUMPTION	CADE General Ledger Account with Leaf Item Account
P_CN_CADEGLLeafItemAccount2	view	left_outer	COMPOSITE	CADE General Ledger Account with Leaf Item Account (Copy)
P_CN_GLAcctPerd	view	inner	CONSUMPTION	Cartesian Product of G/L Account and Fiscal Period
P_COAChangeListToCoCode	view_entity	union	COMPOSITE	Operating Chart of Accounts
P_CompanyCodeGLAccountInCOA	view_entity	from	COMPOSITE	Operating Chart of Accounts
P_FinClsgGLAccountInCoCode	view_entity	from	COMPOSITE	GL Account in company code
P_FinStmtHierarchyWithCocd	view	left_outer	BASIC	a
P_FSTMT_MAP_COA	view	from	CONSUMPTION	Map the various accounts of CoAs
P_FsvHierarchWithCOCD	view_entity	left_outer	BASIC	fsv hierarchy with company code assigned
P_GLAccountTypeVH	view	from	CONSUMPTION	gl account vh
P_GLAccountVH	view	from	CONSUMPTION	gl account vh
P_Glaccountwithaccountcurrency	view	from	BASIC	GL Account with Account Currency
P_Glacct_In_Cc	view	from	BASIC	G/L Account in Company Code
P_GLOverheadAccountVH	view	from	CONSUMPTION	gl account vh
P_GR_CustomerLedgerBasicItem	view_entity	from	COMPOSITE	Greece Customer Ledger Basic Item
P_GR_CustomerLedgerBasicItem	view_entity	union_all	COMPOSITE	Greece Customer Ledger Basic Item
P_GR_StRpTrialBalanceGLAcct	view_entity	from	COMPOSITE	Greece All G/L Account
P_LU_SAFTGENLDGRDPZRTAXADDLINE	view	inner	COMPOSITE	SAFT LU Add Zero Amount Tax Line
P_LU_SAFTGENLDGRZEROTAXADDLINE	view	inner	COMPOSITE	SAFT LU Add Zero Amount Tax Line
P_MX_FinancialStmntStructure	view	inner	COMPOSITE	MX Financial Statement Structure
P_NL_SAFTJournalLineItem	view	inner	COMPOSITE	Journal Line Items for NL Audit File
P_PH_GeneralLedgerAccount	view	from	CONSUMPTION	PH CAS General Ledger Account
P_PH_InputTaxAllocation	view	left_outer	COMPOSITE	Calculate Input Tax Allocation
P_RU_FinancialStatementItem	view	left_outer	CONSUMPTION	Financial Statement for Russia
P_RU_PaymentDocument2	view	inner	CONSUMPTION	Payment Document
P_UnrealizedCrcyDiff	view	inner	COMPOSITE	Unrealized Currency Difference
R_OperatingGLAcctInCoCodeTP	view_entity	from	TRANSACTIONAL	Operating G/L Account Company Code Data

Fields (45)

Key	Field	CDS Fields	Used in Views
KEY	AuthorizationGroup	AuthorizationGroup	5
KEY	CompanyCode	CompanyCode	14
KEY	GLAccount	COAChangeListTargetNumber,GLAccount,OperationalGLAccount,ReconciliationAccount	26
	_CompanyCode	_CompanyCode	1
	_GLAcctInCoCodeStatus	_GLAcctInCoCodeStatus	1
	_Reconciliationaccttype	_Reconciliationaccttype	1
	_TaxCategory	_TaxCategory	1
	AccountingClerk	AccountingClerk	3
	AccountIsBlockedForPosting	AccountIsBlockedForPosting	3
	AccountIsMarkedForDeletion	AccountIsMarkedForDeletion	4
	AcctgDocItmDisplaySequenceRule	AcctgDocItmDisplaySequenceRule	3
	AlternativeGLAccount	AlternativeGLAccount	19
	APARToleranceGroup	APARToleranceGroup	3
	BalanceHasLocalCurrency	BalanceHasLocalCurrency	4
	CashPlanningGroup	CashPlanningGroup	3
	ClearingIsLedgerGroupSpecific	ClearingIsLedgerGroupSpecific	4
	CommitmentItem	CommitmentItem	1
	CreatedByUser	CreatedByUser	4
	CreationDate	CreationDate	4
	ExchRateDifferencesAccountDetn	ExchRateDifferencesAccountDetn	4
	FieldStatusGroup	FieldStatusGroup	3
	GLAccountCurrency	GLAccountCurrency	4
	GLAcctInflationKey	GLAcctInflationKey	3
	HouseBank	HouseBank	4
	HouseBankAccount	HouseBankAccount	4
	InterestCalculationCode	InterestCalculationCode	4
	InterestCalculationDate	InterestCalculationDate	4
	IntrstCalcFrequencyInMonths	IntrstCalcFrequencyInMonths	4
	IsAutomaticallyPosted	IsAutomaticallyPosted	3
	IsCashFlowAccount	IsCashFlowAccount	3
	IsExtendedOpenItemManaged	IsExtendedOpenItemManaged	3
	IsManagedExternally	IsManagedExternally	3
	IsOpenItemManaged	IsOpenItemManaged	4
	JointVentureRecoveryCode	JointVentureRecoveryCode	3
	LastChangeDateTime	LastChangeDateTime	1
	LastInterestCalcRunDate	LastInterestCalcRunDate	3
	LineItemDisplayIsEnabled	LineItemDisplayIsEnabled	3
	MultiCurrencyAccountingCode	MultiCurrencyAccountingCode	3
	PlanningLevel	PlanningLevel	4
	ReconciliationAccountType	ReconciliationAccountType	9
	ReconciliationAcctIsChangeable	ReconciliationAcctIsChangeable	3
	SupplementIsAllowed	SupplementIsAllowed	4
	TaxCategory	TaxCategory	5
	TaxCodeIsRequired	TaxCodeIsRequired	4
	ValuationGroup	ValuationGroup	3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- General Ledger Account in Company Code
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCOUNTINCOMPANYCODE (
    AUTHORIZATIONGROUP,
    COMPANYCODE,
    GLACCOUNT,
    _COMPANYCODE,
    _GLACCTINCOCODESTATUS,
    _RECONCILIATIONACCTTYPE,
    _TAXCATEGORY,
    ACCOUNTINGCLERK,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACCOUNTISMARKEDFORDELETION,
    ACCTGDOCITMDISPLAYSEQUENCERULE,
    ALTERNATIVEGLACCOUNT,
    APARTOLERANCEGROUP,
    BALANCEHASLOCALCURRENCY,
    CASHPLANNINGGROUP,
    CLEARINGISLEDGERGROUPSPECIFIC,
    COMMITMENTITEM,
    CREATEDBYUSER,
    CREATIONDATE,
    EXCHRATEDIFFERENCESACCOUNTDETN,
    FIELDSTATUSGROUP,
    GLACCOUNTCURRENCY,
    GLACCTINFLATIONKEY,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERESTCALCULATIONCODE,
    INTERESTCALCULATIONDATE,
    INTRSTCALCFREQUENCYINMONTHS,
    ISAUTOMATICALLYPOSTED,
    ISCASHFLOWACCOUNT,
    ISEXTENDEDOPENITEMMANAGED,
    ISMANAGEDEXTERNALLY,
    ISOPENITEMMANAGED,
    JOINTVENTURERECOVERYCODE,
    LASTCHANGEDATETIME,
    LASTINTERESTCALCRUNDATE,
    LINEITEMDISPLAYISENABLED,
    MULTICURRENCYACCOUNTINGCODE,
    PLANNINGLEVEL,
    RECONCILIATIONACCOUNTTYPE,
    RECONCILIATIONACCTISCHANGEABLE,
    SUPPLEMENTISALLOWED,
    TAXCATEGORY,
    TAXCODEISREQUIRED,
    VALUATIONGROUP,
    PRIMARY KEY (AUTHORIZATIONGROUP, COMPANYCODE, GLACCOUNT)
);

Depth:

I_GLACCOUNTINCOMPANYCODE

CDS Views using this table (77)

Fields (45)

Learn More