C_GLAcctInCoCdListItem

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 C_GLAcctInCoCdListItem.
-- 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.
-- Parameters: P_Language : spras, P_GLAcctOriginalRecordIsUsed : fac_is_show_old_value

CREATE VIEW C_GLAcctInCoCdListItem AS
SELECT
  PublicUnion.ChartOfAccounts AS ChartOfAccounts,
  PublicUnion.GLAccount AS GLAccount,
  PublicUnion.CompanyCode AS CompanyCode,
  cast ( '' as fac_is_show_old_value ) AS GLAcctOriginalRecordIsUsed,
  _GLAccountInChartOfAccounts.GLAccountExternal AS GLAccountExternal,
  PublicUnion.AuthorizationGroup AS AuthorizationGroup,
  PublicUnion.AccountingClerk AS AccountingClerk,
  PublicUnion.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  PublicUnion.CreationDate AS CreationDate,
  PublicUnion.CreatedByUser AS CreatedByUser,
  _User.UserDescription AS CreatedByUserName,
  PublicUnion.PlanningLevel AS PlanningLevel,
  PublicUnion.HouseBank AS HouseBank,
  PublicUnion.HouseBankAccount AS HouseBankAccount,
  PublicUnion.ExchRateDifferencesAccountDetn AS ExchRateDifferencesAccountDetn,
  PublicUnion.ReconciliationAccountType AS ReconciliationAccountType,
  PublicUnion.TaxCategory AS TaxCategory,
  PublicUnion.InterestCalculationCode AS InterestCalculationCode,
  PublicUnion.GLAccountCurrency AS GLAccountCurrency,
  PublicUnion.IsManagedExternally AS IsManagedExternally,
  PublicUnion.IsAutomaticallyPosted AS IsAutomaticallyPosted,
  PublicUnion.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
  PublicUnion.SupplementIsAllowed AS SupplementIsAllowed,
  PublicUnion.IsOpenItemManaged AS IsOpenItemManaged,
  PublicUnion.InterestCalculationDate AS InterestCalculationDate,
  PublicUnion.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  PublicUnion.AcctgDocItmDisplaySequenceRule AS AcctgDocItmDisplaySequenceRule,
  cast ( PublicUnion.AlternativeGLAccount as fis_alternativeglaccount ) AS AlternativeGLAccount,
  CountryChartOfAccounts,
  PublicUnion.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  PublicUnion.CommitmentItem AS CommitmentItem,
  PublicUnion.TaxCodeIsRequired AS TaxCodeIsRequired,
  PublicUnion.BalanceHasLocalCurrency AS BalanceHasLocalCurrency,
  PublicUnion.ValuationGroup AS ValuationGroup,
  PublicUnion.APARToleranceGroup AS APARToleranceGroup,
  PublicUnion.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  PublicUnion.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  PublicUnion.GLAccountIsNotProdnRelevant AS GLAccountIsNotProdnRelevant,
  PublicUnion.GLAcctCoCodeImplementStatus AS GLAcctCoCodeImplementStatus,
  PublicUnion.GLAccountCoCodIsDeliveredBySAP AS GLAccountCoCodIsDeliveredBySAP,
  PublicUnion.ClearingIsLedgerGroupSpecific AS ClearingIsLedgerGroupSpecific,
  PublicUnion.IsExtendedOpenItemManaged AS IsExtendedOpenItemManaged,
  PublicUnion.IsCashFlowAccount AS IsCashFlowAccount,
  PublicUnion.GLAcctInflationKey AS GLAcctInflationKey,
  PublicUnion.FieldStatusGroup AS FieldStatusGroup,
  PublicUnion.MultiCurrencyAccountingCode AS MultiCurrencyAccountingCode,
  PublicUnion.ReconciliationAcctIsChangeable AS ReconciliationAcctIsChangeable,
  PublicUnion.Country AS Country,
  PublicUnion.ControllingArea AS ControllingArea,
  PublicUnion.FieldStatusVariant AS FieldStatusVariant,
  PublicUnion.CompanyCodeName AS CompanyCodeName,
  PublicUnion.CountryName AS CountryName,
  PublicUnion.GLAcctInflationKeyName AS GLAcctInflationKeyName,
  PublicUnion.PlanningLevelName AS PlanningLevelName,
  PublicUnion.HouseBankAccountDescription AS HouseBankAccountDescription,
  PublicUnion.ReconciliationAccountTypeName AS ReconciliationAccountTypeName,
  PublicUnion.InterestCalculationCodeName AS InterestCalculationCodeName,
  PublicUnion.AcctgDocItmDspSequenceRuleName AS AcctgDocItmDspSequenceRuleName,
  PublicUnion.APARToleranceGroupName AS APARToleranceGroupName,
  PublicUnion.JointVentureRecoveryCodeName AS JointVentureRecoveryCodeName,
  PublicUnion.FieldStatusGroupName AS FieldStatusGroupName,
  PublicUnion.MultiCurrencyAcctgCodeName AS MultiCurrencyAcctgCodeName,
  PublicUnion.CurrencyShortName AS CurrencyShortName,
  PublicUnion.TaxCodeName AS TaxCodeName,
  coalesce( _Text[1:Language = $parameters.P_Language].GLAccountName, _GLAcctTxtInMaintLang.GLAccountName ) as GLAccountName AS GLAccountNameasGLAccountName,
  coalesce( _Text[1:Language = $parameters.P_Language].GLAccountLongName, _GLAcctTxtInMaintLang.GLAccountLongName ) as GLAccountLongName AS GLAccountLongNameasGLAccountLongName,
  _GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  _GLAccountInChartOfAccounts._GLAccountType._GLAccountTypeText[1:Language = $session.system_language].GLAccountTypeName AS GLAccountTypeName,
  $parameters.P_Language AS Language,
  cast ( '' as char32 ) AS ActiveDocumentETag,
  PublicUnion.LastChangeDateTime AS LastChangeDateTime,
  PublicUnion.InProcessByUser AS InProcessByUser,
  PublicUnion.InProcessByUserDescription AS InProcessByUserDescription,
  PublicUnion.DraftIsProcessedByMe AS DraftIsProcessedByMe,
  PublicUnion.HasDraftEntity AS HasDraftEntity,
  PublicUnion.GLAcctInChartOfAcctsDraftUUID AS GLAcctInChartOfAcctsDraftUUID
FROM I_ActiveGLAcctInCoCodeListItem AS PublicUnion
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
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]
;