R_OperatingGLAccountTP

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 R_OperatingGLAccountTP.
-- 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 R_OperatingGLAccountTP AS
SELECT
  Acct.ChartOfAccounts AS ChartOfAccounts,
  Acct.GLAccount AS GLAccount,
  Acct._GLAcctInChartOfAcctsStatus.GLAcctCOAImplementStatus AS GLAcctCOAImplementStatus,
  _NotNeeded.GLAccountIsNotProdnRelevant AS GLAccountIsNotProdnRelevant,
  Acct.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  Acct.GLAccountGroup AS GLAccountGroup,
  Acct._ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  Acct.CorporateGroupAccount AS CorporateGroupAccount,
  Acct.ProfitLossAccountType AS ProfitLossAccountType,
  Acct._RetainedEarningsGLAccount.RetainedEarningsGLAccount AS RetainedEarningsGLAccount,
  Acct.SampleGLAccount AS SampleGLAccount,
  Acct.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  Acct.AccountIsBlockedForCreation AS AccountIsBlockedForCreation,
  Acct.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  Acct.AccountIsBlockedForPlanning AS AccountIsBlockedForPlanning,
  Acct.PartnerCompany AS PartnerCompany,
  Acct.FunctionalArea AS FunctionalArea,
  Acct.CreationDate AS CreationDate,
  Acct.CreatedByUser AS CreatedByUser,
  Acct.LastChangeDateTime AS LastChangeDateTime,
  Acct._Text[1: Language = $session.system_language].GLAccountName AS GLAccountLogonLangName,
  Acct._Text[1: Language = $session.system_language].GLAccountLongName AS GLAcctLogonLangLongName,
  _MaintTxt.GLAccountName AS GLAccountName,
  _MaintTxt.GLAccountLongName AS GLAccountLongName,
  $session.system_language AS Language,
  Acct.GLAccountType AS GLAccountType,
  Acct.GLAccountSubtype AS GLAccountSubtype,
  Acct.GLAccountExternal AS GLAccountExternal,
  Acct.BankReconciliationAccount AS BankReconciliationAccount,
  Acct.IsProfitLossAccount AS IsProfitLossAccount,
  Acct._ChartOfAccounts AS _ChartOfAccounts,
  _PublicSector.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
  _PublicSector.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  _PublicSector.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
  _PublicSector.PubSecBdgtAcctIsPostgAllowed AS PubSecBdgtAcctIsPostgAllowed,
  _PublicSector.PubSecBdgtAcctIsBdgtAllowed AS PubSecBdgtAcctIsBdgtAllowed,
  _PublicSector.PubSecBdgtAcctIsCarryFwd AS PubSecBdgtAcctIsCarryFwd,
  _PublicSector.PubSecBdgtAcctCarryFwdTo AS PubSecBdgtAcctCarryFwdTo,
  _PublicSector.CashLedgerAccount AS CashLedgerAccount,
  _PublicSector.SponsoredClass AS SponsoredClass,
  Acct._RetainedEarningsGLAccount AS _RetainedEarningsGLAccount,
  _CostElement.CostElementCategory AS CostElementCategory,
  _CostElement.UnitOfMeasure AS UnitOfMeasure,
  cast( _CostElement.ConsumptionQtyIsRecorded as xfeld ) AS ConsumptionQtyIsRecorded,
  Acct._GLAcctInChartOfAcctsStatus AS _GLAcctInChartOfAcctsStatus
FROM I_GLAccountInChartOfAccounts AS Acct
LEFT OUTER JOIN I_GLAcctInChartOfAcctsProdn AS _NotNeeded ON Acct.ChartOfAccounts = _NotNeeded.ChartOfAccounts AND Acct.GLAccount = _NotNeeded.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [1..*]
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_GLAccountHierarchyNode AS _GLAccountHierarchyNode ON GLAccount = _GLAccountHierarchyNode.GLAccount AND ChartOfAccounts = _GLAccountHierarchyNode.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_GLAccountForPublicSector AS _PublicSector ON ChartOfAccounts = _PublicSector.ChartOfAccounts AND GLAccount = _PublicSector.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountGroup AS _GLAccountGroup ON GLAccountGroup = _GLAccountGroup.GLAccountGroup AND ChartOfAccounts = _GLAccountGroup.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Globalcompany AS _GlobalCompany ON PartnerCompany = _GlobalCompany.Company  -- association [1..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CorporateGroupChartOfAccounts ON CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _CorporateGroupAccount ON CorporateGroupChartOfAccounts = _CorporateGroupAccount.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountGroupText AS _GLAccountGroupText ON GLAccountGroup = _GLAccountGroupText.GLAccountGroup AND ChartOfAccounts = _GLAccountGroupText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_GLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- association [0..1]
LEFT OUTER JOIN I_GLAccountSubtype AS _GLAccountSubtype ON GLAccountSubtype = _GLAccountSubtype.GLAccountSubtype  -- association [0..1]
LEFT OUTER JOIN I_GLAccountTypeText AS _GLAccountTypeText ON GLAccountType = _GLAccountTypeText.GLAccountType  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _MaintTxt ON Acct.ChartOfAccounts = _MaintTxt.ChartOfAccounts AND GLAccount = _MaintTxt.GLAccount AND _MaintTxt.Language = CoA.MaintenanceLanguage  -- association [1..1]
LEFT OUTER JOIN I_GLAcctInCOAImplementStatType AS _GLAcctImplementStatus ON glacctcoaimplementstatus = _GLAcctImplementStatus.GLAcctCOAImplementStatus  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _BankReconAcctTxt ON ChartOfAccounts = _BankReconAcctTxt.ChartOfAccounts AND BankReconciliationAccount = _BankReconAcctTxt.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_CostElement AS _CostElement ON ChartOfAccounts = _CostElement.ChartOfAccounts AND GLAccount = _CostElement.CostElement AND _CostElement.ControllingArea = 'A000'  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedBy ON CreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_OperatingGLAcctInCoCodeTP AS _CompanyCode ON /* condition not available in parsed metadata */  -- association [0..*]
;