_GLACCOUNTINCOMPANYCODE

27 Fields

_GLACCOUNTINCOMPANYCODE is an SAP database table in S/4HANA. It contains 27 fields.

Fields (27)

KeyField CDS FieldsUsed in Views
KEY AlternativeGLAccount AlternativeGLAccount,AlternativeGLAccountExternal 10
KEY CompanyCode CompanyCode 2
AccountingClerk AccountingClerk 2
AccountIsBlockedForPosting AccountIsBlockedForPosting 1
AccountIsMarkedForDeletion AccountIsMarkedForDeletion 4
APARToleranceGroup APARToleranceGroup 1
AuthorizationGroup AuthorizationGroup,GLAccountAuthorizationGroup 14
BalanceHasLocalCurrency BalanceHasLocalCurrency 1
CashPlanningGroup CashPlanningGroup 1
CommitmentItem CommitmentItem,CommitmentItemShortID 2
ExchRateDifferencesAccountDetn ExchRateDifferencesAccountDetn 1
FieldStatusGroup FieldStatusGroup 1
GLAccountCurrency GLAccountCurrency 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
InterestCalculationCode InterestCalculationCode 1
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths 1
IsAutomaticallyPosted IsAutomaticallyPosted 1
IsCashFlowAccount IsCashFlowAccount 1
IsManagedExternally IsManagedExternally 1
JointVentureRecoveryCode JointVentureRecoveryCode 1
PlanningLevel PlanningLevel 1
ReconciliationAccountType ReconciliationAccountType 2
SupplementIsAllowed SupplementIsAllowed 1
TaxCategory TaxCategory 1
TaxCodeIsRequired TaxCodeIsRequired 1
ValuationGroup ValuationGroup 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _GLACCOUNTINCOMPANYCODE (
    ALTERNATIVEGLACCOUNT,
    COMPANYCODE,
    ACCOUNTINGCLERK,
    ACCOUNTISBLOCKEDFORPOSTING,
    ACCOUNTISMARKEDFORDELETION,
    APARTOLERANCEGROUP,
    AUTHORIZATIONGROUP,
    BALANCEHASLOCALCURRENCY,
    CASHPLANNINGGROUP,
    COMMITMENTITEM,
    EXCHRATEDIFFERENCESACCOUNTDETN,
    FIELDSTATUSGROUP,
    GLACCOUNTCURRENCY,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERESTCALCULATIONCODE,
    INTRSTCALCFREQUENCYINMONTHS,
    ISAUTOMATICALLYPOSTED,
    ISCASHFLOWACCOUNT,
    ISMANAGEDEXTERNALLY,
    JOINTVENTURERECOVERYCODE,
    PLANNINGLEVEL,
    RECONCILIATIONACCOUNTTYPE,
    SUPPLEMENTISALLOWED,
    TAXCATEGORY,
    TAXCODEISREQUIRED,
    VALUATIONGROUP,
    PRIMARY KEY (ALTERNATIVEGLACCOUNT, COMPANYCODE)
);

Learn More