I_GLAcctInCoCode

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 I_GLAcctInCoCode.
-- 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: IGLACOCD

CREATE VIEW I_GLAcctInCoCode AS
SELECT
  skb1.GLAccount AS GLAccount,
  skb1.CompanyCode AS CompanyCode,
  skb1.AuthorizationGroup AS AuthorizationGroup,
  skb1.AccountingClerk AS AccountingClerk,
  skb1.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  skb1.CreationDate AS CreationDate,
  skb1.CreatedByUser AS CreatedByUser,
  skb1.LastChangeDateTime AS LastChangeDateTime,
  skb1.PlanningLevel AS PlanningLevel,
  skb1.HouseBank AS HouseBank,
  skb1.HouseBankAccount AS HouseBankAccount,
  skb1.ExchRateDifferencesAccountDetn AS ExchRateDifferencesAccountDetn,
  skb1.ReconciliationAccountType AS ReconciliationAccountType,
  skb1.TaxCategory AS TaxCategory,
  skb1.InterestCalculationCode AS InterestCalculationCode,
  skb1.GLAccountCurrency AS GLAccountCurrency,
  skb1.ReconciliationAcctIsChangeable AS ReconciliationAcctIsChangeable,
  skb1.IsManagedExternally AS IsManagedExternally,
  skb1.IsAutomaticallyPosted AS IsAutomaticallyPosted,
  skb1.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
  skb1.SupplementIsAllowed AS SupplementIsAllowed,
  skb1.IsOpenItemManaged AS IsOpenItemManaged,
  skb1.InterestCalculationDate AS InterestCalculationDate,
  skb1.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  skb1.AcctgDocItmDisplaySequenceRule AS AcctgDocItmDisplaySequenceRule,
  skb1.AlternativeGLAccount AS AlternativeGLAccount,
  skb1.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  skb1.CommitmentItem AS CommitmentItem,
  skb1.TaxCodeIsRequired AS TaxCodeIsRequired,
  skb1.BalanceHasLocalCurrency AS BalanceHasLocalCurrency,
  skb1.ValuationGroup AS ValuationGroup,
  skb1.APARToleranceGroup AS APARToleranceGroup,
  skb1.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  skb1.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  skb1.ClearingIsLedgerGroupSpecific AS ClearingIsLedgerGroupSpecific,
  skb1.IsCashFlowAccount AS IsCashFlowAccount,
  skb1.GLAcctInflationKey AS GLAcctInflationKey,
  skb1.FieldStatusGroup AS FieldStatusGroup,
  skb1.MultiCurrencyAccountingCode AS MultiCurrencyAccountingCode,
  skb1.IsExtendedOpenItemManaged AS IsExtendedOpenItemManaged,
  t001.Country AS Country,
  t001.ChartOfAccounts AS ChartOfAccounts,
  t001.ControllingArea AS ControllingArea,
  t001.FieldStatusVariant AS FieldStatusVariant,
  t001.CountryChartOfAccounts AS CountryChartOfAccounts
FROM I_GLAccountInCompanyCode AS skb1
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _Text ON CompanyCode = _Text.CompanyCode AND GLAccount = _Text.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [1..1]
LEFT OUTER JOIN I_Reconciliationaccttype AS _Reconciliationaccttype ON ReconciliationAccountType = _Reconciliationaccttype.ReconciliationAccountType  -- association [0..1]
LEFT OUTER JOIN I_InflationKey AS _InflationKey ON Country = _InflationKey.Country AND GLAcctInflationKey = _InflationKey.GLAcctInflationKey  -- association [0..1]
LEFT OUTER JOIN I_JointVentureRecovery AS _JointVentureRecovery ON CompanyCode = _JointVentureRecovery.CompanyCode AND JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode  -- association [0..1]
LEFT OUTER JOIN I_MultiCurrencyAccounting AS _MultiCurrencyAccounting ON MultiCurrencyAccountingCode = _MultiCurrencyAccounting.MultiCurrencyAccountingCode  -- association [0..1]
LEFT OUTER JOIN I_FieldStatusGroup AS _FieldStatusGroup ON FieldStatusVariant = _FieldStatusGroup.FieldStatusVariant AND FieldStatusGroup = _FieldStatusGroup.FieldStatusGroup  -- association [0..1]
LEFT OUTER JOIN I_FieldStatusVariant AS _FieldStatusVariant ON FieldStatusVariant = _FieldStatusVariant.FieldStatusVariant  -- association [0..1]
LEFT OUTER JOIN I_TaxCategory AS _TaxCategory ON CompanyCode = _TaxCategory.CompanyCode AND TaxCategory = _TaxCategory.TaxCategory  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAcctInCoCodeImplementStat AS _GLAcctInCoCodeStatus ON CompanyCode = _GLAcctInCoCodeStatus.CompanyCode AND GLAccount = _GLAcctInCoCodeStatus.GLAccount  -- association [0..1]
;