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.

CREATE VIEW I_GLAcctInCoCodeTP AS
SELECT
  I_GLAcctInCoCode.ChartOfAccounts AS ChartOfAccounts,
  I_GLAcctInCoCode.GLAccount AS GLAccount,
  I_GLAcctInCoCode.CompanyCode AS CompanyCode,
  I_GLAcctInCoCode.CompanyCode AS CompanyCodeForEdit,
  I_GLAcctInCoCode.AuthorizationGroup AS AuthorizationGroup,
  I_GLAcctInCoCode.AccountingClerk AS AccountingClerk,
  I_GLAcctInCoCode.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  I_GLAcctInCoCode.CreationDate AS CreationDate,
  I_GLAcctInCoCode.CreatedByUser AS CreatedByUser,
  I_GLAcctInCoCode.PlanningLevel AS PlanningLevel,
  I_GLAcctInCoCode.HouseBank AS HouseBank,
  I_GLAcctInCoCode.HouseBankAccount AS HouseBankAccount,
  I_GLAcctInCoCode.ExchRateDifferencesAccountDetn AS ExchRateDifferencesAccountDetn,
  I_GLAcctInCoCode.ReconciliationAccountType AS ReconciliationAccountType,
  I_GLAcctInCoCode.TaxCategory AS TaxCategory,
  I_GLAcctInCoCode.InterestCalculationCode AS InterestCalculationCode,
  I_GLAcctInCoCode.GLAccountCurrency AS GLAccountCurrency,
  I_GLAcctInCoCode.IsManagedExternally AS IsManagedExternally,
  I_GLAcctInCoCode.IsAutomaticallyPosted AS IsAutomaticallyPosted,
  I_GLAcctInCoCode.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
  I_GLAcctInCoCode.SupplementIsAllowed AS SupplementIsAllowed,
  I_GLAcctInCoCode.IsOpenItemManaged AS IsOpenItemManaged,
  I_GLAcctInCoCode.InterestCalculationDate AS InterestCalculationDate,
  I_GLAcctInCoCode.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  I_GLAcctInCoCode.AcctgDocItmDisplaySequenceRule AS AcctgDocItmDisplaySequenceRule,
  I_GLAcctInCoCode.AlternativeGLAccount AS AlternativeGLAccount,
  case when I_GLAcctInCoCode.AlternativeGLAccount is not null and _GroupAccount.sakan is null then cast ( I_GLAcctInCoCode.AlternativeGLAccount as sakan ) else _GroupAccount.sakan end as AlternativeGLAccountExternal AS sakanendasAlternativeGLAccountExternal,
  I_GLAcctInCoCode.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_GLAcctInCoCode.CommitmentItem AS CommitmentItem,
  I_GLAcctInCoCode.TaxCodeIsRequired AS TaxCodeIsRequired,
  I_GLAcctInCoCode.BalanceHasLocalCurrency AS BalanceHasLocalCurrency,
  I_GLAcctInCoCode.ValuationGroup AS ValuationGroup,
  I_GLAcctInCoCode.APARToleranceGroup AS APARToleranceGroup,
  I_GLAcctInCoCode.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  I_GLAcctInCoCode.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  I_GLAcctInCoCode.ClearingIsLedgerGroupSpecific AS ClearingIsLedgerGroupSpecific,
  I_GLAcctInCoCode.IsCashFlowAccount AS IsCashFlowAccount,
  I_GLAcctInCoCode.GLAcctInflationKey AS GLAcctInflationKey,
  I_GLAcctInCoCode.FieldStatusGroup AS FieldStatusGroup,
  I_GLAcctInCoCode.MultiCurrencyAccountingCode AS MultiCurrencyAccountingCode,
  I_GLAcctInCoCode.ReconciliationAcctIsChangeable AS 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,
  I_GLAcctInCoCode.CountryChartOfAccounts AS 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]
;