I_GLACCOUNTINCOMPANYCODE

CDS View
44 Fields 79 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 44 fields. 79 CDS views read from this table.

CDS Views using this table (79)

ViewTypeJoinVDMDescription
C_AllocationSenderGLAcctVH view from CONSUMPTION Allocation Sender GL Account
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_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 union Greece GLAccount global hierarchy detail
FIISAL_GR_AltvGLAcctHierDetail view_entity from 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 from BASIC General Ledger Account in Company Code
I_LU_SAFTAdditionalZeroLine view inner COMPOSITE SAFT LU Additional VAT Zero Line
I_LU_SAFTJournalEntry view inner COMPOSITE SAFT LU General Ledger Documents
I_OpeningBalanceTransCrcy view left_outer COMPOSITE Opening Balance In Transaction Currency
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_SAFTBillingOneTimeCust view inner COMPOSITE SAF-T PT Billing One Time Custmer
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_SAFTGenLedgerCustomer view inner COMPOSITE SAF-T PT Gen Ledger 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
P_AR_GLCashFlowRlvtAcct view_entity from COMPOSITE
P_CN_CADEGLAccountFSVItem view left_outer CONSUMPTION
P_CN_CADEGLAccountFSVItem2 view left_outer COMPOSITE
P_CN_CADEGLLeafItemAccount view left_outer CONSUMPTION
P_CN_CADEGLLeafItemAccount2 view left_outer COMPOSITE
P_CN_GLAcctPerd view inner CONSUMPTION Cartesian Product of G/L Account and Fiscal Period
P_COAChangeListToCoCode view union COMPOSITE
P_FinClsgGLAccountInCoCode view_entity from COMPOSITE
P_FinStmtHierarchyWithCocd view left_outer BASIC
P_FSTMT_MAP_COA view from CONSUMPTION
P_FsvHierarchWithCOCD view left_outer BASIC
P_GLAccountTypeVH view from CONSUMPTION
P_GLAccountVH view from CONSUMPTION gl account vh
P_Glaccountwithaccountcurrency view from BASIC
P_Glacct_In_Cc view from BASIC
P_GLOverheadAccountVH view from CONSUMPTION gl account vh
P_GR_CustomerLedgerBasicItem view_entity from COMPOSITE
P_GR_CustomerLedgerBasicItem view_entity union_all COMPOSITE
P_GR_StRpTrialBalanceGLAcct view_entity from COMPOSITE Greece All G/L Account
P_LU_SAFTGENLDGRDPZRTAXADDLINE view inner COMPOSITE
P_LU_SAFTGENLDGRZEROTAXADDLINE view inner COMPOSITE
P_MX_FinancialStmntStructure view inner COMPOSITE
P_NL_SAFTJournalLineItem view inner COMPOSITE
P_Opening_Bal_Tran_Curr view left_outer BASIC
P_PH_GeneralLedgerAccount view from CONSUMPTION
P_PH_InputTaxAllocation view left_outer COMPOSITE
P_RU_FinancialStatementItem view left_outer CONSUMPTION Financial Statement for Russia
P_RU_PaymentDocument2 view inner CONSUMPTION
P_UnrealizedCrcyDiff view inner COMPOSITE

Fields (44)

KeyField CDS FieldsUsed in Views
KEY AuthorizationGroup AuthorizationGroup 5
KEY CompanyCode CompanyCode 12
KEY GLAccount COAChangeListTargetNumber,GLAccount,OperationalGLAccount,ReconciliationAccount 24
_CompanyCode _CompanyCode 1
_Reconciliationaccttype _Reconciliationaccttype 1
_TaxCategory _TaxCategory 1
AccountingClerk AccountingClerk 2
AccountIsBlockedForPosting AccountIsBlockedForPosting 2
AccountIsMarkedForDeletion AccountIsMarkedForDeletion 3
AcctgDocItmDisplaySequenceRule AcctgDocItmDisplaySequenceRule 2
AlternativeGLAccount AlternativeGLAccount 18
APARToleranceGroup APARToleranceGroup 2
BalanceHasLocalCurrency BalanceHasLocalCurrency 3
CashPlanningGroup CashPlanningGroup 2
ClearingIsLedgerGroupSpecific ClearingIsLedgerGroupSpecific 3
CommitmentItem CommitmentItem 1
CreatedByUser CreatedByUser 3
CreationDate CreationDate 3
ExchRateDifferencesAccountDetn ExchRateDifferencesAccountDetn 3
FieldStatusGroup FieldStatusGroup 2
GLAccountCurrency GLAccountCurrency 3
GLAcctInflationKey GLAcctInflationKey 2
HouseBank HouseBank 3
HouseBankAccount HouseBankAccount 3
InterestCalculationCode InterestCalculationCode 3
InterestCalculationDate InterestCalculationDate 3
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths 3
IsAutomaticallyPosted IsAutomaticallyPosted 2
IsCashFlowAccount IsCashFlowAccount 2
IsExtendedOpenItemManaged IsExtendedOpenItemManaged 2
IsManagedExternally IsManagedExternally 2
IsOpenItemManaged IsOpenItemManaged 3
JointVentureRecoveryCode JointVentureRecoveryCode 2
LastChangeDateTime LastChangeDateTime 1
LastInterestCalcRunDate LastInterestCalcRunDate 2
LineItemDisplayIsEnabled LineItemDisplayIsEnabled 2
MultiCurrencyAccountingCode MultiCurrencyAccountingCode 2
PlanningLevel PlanningLevel 3
ReconciliationAccountType ReconciliationAccountType 8
ReconciliationAcctIsChangeable ReconciliationAcctIsChangeable 2
SupplementIsAllowed SupplementIsAllowed 3
TaxCategory TaxCategory 4
TaxCodeIsRequired TaxCodeIsRequired 3
ValuationGroup ValuationGroup 2

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,
    _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)
);

Learn More