I_GLAcctInCoCodeTP

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_GLAcctInCoCodeTP.
-- 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: IGLACOCDTP

CREATE VIEW I_GLAcctInCoCodeTP AS
SELECT
  I_GLAcctInCoCode.ChartOfAccounts AS ChartOfAccounts,
  GLAccount,
  CompanyCode,
  I_GLAcctInCoCode.CompanyCode AS CompanyCodeForEdit,
  AuthorizationGroup,
  AccountingClerk,
  LastInterestCalcRunDate,
  CreationDate,
  CreatedByUser,
  PlanningLevel,
  HouseBank,
  HouseBankAccount,
  ExchRateDifferencesAccountDetn,
  ReconciliationAccountType,
  TaxCategory,
  InterestCalculationCode,
  GLAccountCurrency,
  IsManagedExternally,
  IsAutomaticallyPosted,
  LineItemDisplayIsEnabled,
  SupplementIsAllowed,
  IsOpenItemManaged,
  InterestCalculationDate,
  IntrstCalcFrequencyInMonths,
  AcctgDocItmDisplaySequenceRule,
  AlternativeGLAccount,
  case when AlternativeGLAccount is not null and _GroupAccount.sakan is null then cast ( AlternativeGLAccount as sakan ) else _GroupAccount.sakan end as AlternativeGLAccountExternal AS sakanendasAlternativeGLAccountExternal,
  JointVentureRecoveryCode,
  CommitmentItem,
  TaxCodeIsRequired,
  BalanceHasLocalCurrency,
  ValuationGroup,
  APARToleranceGroup,
  AccountIsBlockedForPosting,
  AccountIsMarkedForDeletion,
  ClearingIsLedgerGroupSpecific,
  IsCashFlowAccount,
  GLAcctInflationKey,
  FieldStatusGroup,
  MultiCurrencyAccountingCode,
  ReconciliationAcctIsChangeable,
  I_GLAcctInCoCode.IsExtendedOpenItemManaged AS IsExtendedOpenItemManaged,
  chtaccts.MaintenanceLanguage AS MaintenanceLanguage,
  I_GLAcctInCoCode.GLAccount AS GLAccountForEdit,
  _GLAcctTxtInMaintLang.GLAccountName AS GLAccountName,
  _GLAcctTxtInMaintLang.GLAccountLongName AS GLAccountLongName,
  I_GLAcctInCoCode.ChartOfAccounts AS ChartOfAccountsForEdit,
  CountryChartOfAccounts,
  _CompanyCode.Country AS Country,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode.FieldStatusVariant AS FieldStatusVariant,
  _CompanyCode.CompanyCodeName AS CompanyCodeName
FROM I_GLAcctInCoCode
LEFT OUTER JOIN I_GLAcctInChtAcctsTP AS _GLAcctInChtAcctsTP ON ChartOfAccounts = _GLAcctInChtAcctsTP.ChartOfAccounts AND GLAccount = _GLAcctInChtAcctsTP.GLAccount  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCodeForEdit = _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 CompanyCodeForEdit = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCodeForEdit = _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 CompanyCodeForEdit = _GLAccountToleranceGroup.CompanyCode AND APARToleranceGroup = _GLAccountToleranceGroup.APARToleranceGroup  -- association [0..1]
LEFT OUTER JOIN I_JointVentureRecovery AS _JointVentureRecovery ON JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode AND CompanyCodeForEdit = _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 CompanyCodeForEdit = _TaxCategory.CompanyCode AND TaxCategory = _TaxCategory.TaxCategory  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AlternativeGLAccount ON CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAcctInDefaultLanguageText AS _GLAcctTxtInMaintLang ON ChartOfAccounts = _GLAcctTxtInMaintLang.ChartOfAccounts AND GLAccount = _GLAcctTxtInMaintLang.GLAccount AND MaintenanceLanguage = _GLAcctTxtInMaintLang.Language  -- 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 CountryChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON CompanyCode = _GLAccount.CompanyCode AND GLAccount = _GLAccount.GLAccount  -- association [0..1]
;