I_ActiveGLAcctInCoCodeListItem

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_ActiveGLAcctInCoCodeListItem.
-- 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: IFIACOCDLI

CREATE VIEW I_ActiveGLAcctInCoCodeListItem AS
SELECT
  ActiveDocument.ChartOfAccounts AS ChartOfAccounts,
  ActiveDocument.GLAccount AS GLAccount,
  ActiveDocument.CompanyCode AS CompanyCode,
  ActiveDocument.AuthorizationGroup AS AuthorizationGroup,
  ActiveDocument.AccountingClerk AS AccountingClerk,
  ActiveDocument.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  ActiveDocument.CreationDate AS CreationDate,
  ActiveDocument.CreatedByUser AS CreatedByUser,
  ActiveDocument.PlanningLevel AS PlanningLevel,
  ActiveDocument.HouseBank AS HouseBank,
  ActiveDocument.HouseBankAccount AS HouseBankAccount,
  ActiveDocument.ExchRateDifferencesAccountDetn AS ExchRateDifferencesAccountDetn,
  ActiveDocument.ReconciliationAccountType AS ReconciliationAccountType,
  ActiveDocument.TaxCategory AS TaxCategory,
  ActiveDocument.InterestCalculationCode AS InterestCalculationCode,
  ActiveDocument.GLAccountCurrency AS GLAccountCurrency,
  ActiveDocument.IsManagedExternally AS IsManagedExternally,
  ActiveDocument.IsAutomaticallyPosted AS IsAutomaticallyPosted,
  ActiveDocument.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
  ActiveDocument.SupplementIsAllowed AS SupplementIsAllowed,
  ActiveDocument.IsOpenItemManaged AS IsOpenItemManaged,
  ActiveDocument.InterestCalculationDate AS InterestCalculationDate,
  ActiveDocument.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  ActiveDocument.AcctgDocItmDisplaySequenceRule AS AcctgDocItmDisplaySequenceRule,
  ActiveDocument.AlternativeGLAccount AS AlternativeGLAccount,
  _AlternativeGLAccountExternal.GLAccountExternal AS AlternativeGLAccountExternal,
  CountryChartOfAccounts,
  ActiveDocument.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  ActiveDocument.CommitmentItem AS CommitmentItem,
  ActiveDocument.TaxCodeIsRequired AS TaxCodeIsRequired,
  ActiveDocument.BalanceHasLocalCurrency AS BalanceHasLocalCurrency,
  ActiveDocument.ValuationGroup AS ValuationGroup,
  ActiveDocument.APARToleranceGroup AS APARToleranceGroup,
  ActiveDocument.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  ActiveDocument.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  ActiveDocument.ClearingIsLedgerGroupSpecific AS ClearingIsLedgerGroupSpecific,
  ActiveDocument.IsExtendedOpenItemManaged AS IsExtendedOpenItemManaged,
  ActiveDocument.IsCashFlowAccount AS IsCashFlowAccount,
  ActiveDocument.GLAcctInflationKey AS GLAcctInflationKey,
  ActiveDocument.FieldStatusGroup AS FieldStatusGroup,
  ActiveDocument.MultiCurrencyAccountingCode AS MultiCurrencyAccountingCode,
  ActiveDocument.ReconciliationAcctIsChangeable AS ReconciliationAcctIsChangeable,
  ActiveDocument.Country AS Country,
  ActiveDocument.ControllingArea AS ControllingArea,
  ActiveDocument.FieldStatusVariant AS FieldStatusVariant,
  cast( hextobin('00000000000000000000000000000000') as ska1_draft_uuid ) AS GLAcctInChartOfAcctsDraftUUID,
  DraftAdmin.InProcessByUser AS InProcessByUser,
  DraftAdmin.InProcessByUserDescription AS InProcessByUserDescription,
  DraftAdmin.DraftIsProcessedByMe AS DraftIsProcessedByMe,
  ActiveDocument.LastChangeDateTime AS LastChangeDateTime,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _GLAcctTxtInMaintLang.GLAccountName AS GLAccountName,
  _GLAcctTxtInMaintLang.GLAccountLongName AS GLAccountLongName,
  _GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  _CompanyCode._Country._Text[1:Language = $session.system_language].CountryName AS CountryName,
  _InflationKey._Text[1:Language = $session.system_language].GLAcctInflationKeyName AS GLAcctInflationKeyName,
  _PlanningLevel._Text[1:Language = $session.system_language].PlanningLevelName AS PlanningLevelName,
  _HouseBankAccount._Text[1:Language = $session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
  _Reconciliationaccttype._Text[1:Language = $session.system_language].ReconciliationAccountTypeName AS ReconciliationAccountTypeName,
  _InterestCalculationCode._Text[1:Language = $session.system_language].InterestCalculationCodeName AS InterestCalculationCodeName,
  _AcctgDocItmDspSqncRule._Text[1:Language = $session.system_language].AcctgDocItmDspSequenceRuleName AS AcctgDocItmDspSequenceRuleName,
  _GLAccountToleranceGroup._Text[1:Language = $session.system_language].APARToleranceGroupName AS APARToleranceGroupName,
  _JointVentureRecovery._Text[1:Language = $session.system_language].JointVentureRecoveryCodeName AS JointVentureRecoveryCodeName,
  _FieldStatusGroup._Text[1:Language = $session.system_language].FieldStatusGroupName AS FieldStatusGroupName,
  _MultiCurrencyAccounting._Text[1:Language = $session.system_language].MultiCurrencyAcctgCodeName AS MultiCurrencyAcctgCodeName,
  _GLAccountCurrency._Text[1:Language = $session.system_language].CurrencyShortName AS CurrencyShortName,
  _TaxCategory._Text[1:Language = $session.system_language].TaxCategoryName AS TaxCodeName
FROM I_GLAcctInCoCode AS ActiveDocument
LEFT OUTER JOIN I_DraftAdministrativeData AS DraftAdmin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [1..1]
LEFT OUTER JOIN I_InflationKey AS _InflationKey ON Country = _InflationKey.Country AND GLAcctInflationKey = _InflationKey.GLAcctInflationKey  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevel AS _PlanningLevel ON PlanningLevel = _PlanningLevel.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_Reconciliationaccttype AS _Reconciliationaccttype ON ReconciliationAccountType = _Reconciliationaccttype.ReconciliationAccountType  -- association [0..1]
LEFT OUTER JOIN I_InterestCalculationCode AS _InterestCalculationCode ON InterestCalculationCode = _InterestCalculationCode.InterestCalculationCode  -- association [0..1]
LEFT OUTER JOIN I_AcctgDocItmDspSqncRule AS _AcctgDocItmDspSqncRule ON AcctgDocItmDisplaySequenceRule = _AcctgDocItmDspSqncRule.AcctgDocItmDisplaySequenceRule  -- association [0..1]
LEFT OUTER JOIN I_GLAccountToleranceGroup AS _GLAccountToleranceGroup ON CompanyCode = _GLAccountToleranceGroup.CompanyCode AND APARToleranceGroup = _GLAccountToleranceGroup.APARToleranceGroup  -- association [0..1]
LEFT OUTER JOIN I_JointVentureRecovery AS _JointVentureRecovery ON JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode AND CompanyCode = _JointVentureRecovery.CompanyCode  -- 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_MultiCurrencyAccounting AS _MultiCurrencyAccounting ON MultiCurrencyAccountingCode = _MultiCurrencyAccounting.MultiCurrencyAccountingCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _GLAccountCurrency ON GLAccountCurrency = _GLAccountCurrency.Currency  -- 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_GLAcctTxtInMaintLang AS _GLAcctTxtInMaintLang ON ChartOfAccounts = _GLAcctTxtInMaintLang.ChartOfAccounts AND GLAccount = _GLAcctTxtInMaintLang.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _Text ON ChartOfAccounts = _Text.ChartOfAccounts AND GLAccount = _Text.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_FieldStatusVariant AS _FieldStatusVariant ON FieldStatusVariant = _FieldStatusVariant.FieldStatusVariant  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AlternativeGLAccountExternal ON CountryChartOfAccounts = _AlternativeGLAccountExternal.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccountExternal.GLAccount  -- association [0..1]
;