I_GLAccountInOperatingCOA

DDL: I_GLACCOUNTINOPERATINGCOA SQL: IGLACCTCOAITM Type: view BASIC
14 Fields 1 Data Sources 1 Associations

GL Account Changes in Operating COA

I_GLAccountInOperatingCOA is a Basic CDS View that provides data about "GL Account Changes in Operating COA" in SAP S/4HANA. It reads from 1 data source (coachnglistactiv) and exposes 14 fields with key field COAChangeListItemUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
coachnglistactiv coachnglistactiv from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_COAChangeListActionStatus _actionstatus coachnglistactiv.action = _actionstatus.COAChangeListAction

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IGLACCTCOAITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label GL Account Changes in Operating COA view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY COAChangeListItemUUID itemnumber Item ID
ChartOfAccounts ktopl G/L Chart of Accounts
COAChangeListTargetNumber target_saknr Target G/L Acct No
COAChangeListTargetAccountDesc target_short_description Targt Acct Short Txt
GLAccountLongName target_long_description Target G/L Acct Txt
GLAccount saknr G/L Account
COAChangeListAction action User action
_ActionStatusText _actionstatus
COAChangeListItemStatus itemstatus Status Item
COAChangeListCheckResults check_result Result Code
COAChangeListImportUUID importuuid Import ID of File
COAChangeListCreatedByUser created_by Version Created By
COAChangeListCreationDateTime created_on Variant created on
WorkItemIDGroupText grouping Worklist Group

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_GLAccountInOperatingCOA.
-- 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: IGLACCTCOAITM

CREATE VIEW I_GLAccountInOperatingCOA AS
SELECT
  itemnumber AS COAChangeListItemUUID,
  ktopl AS ChartOfAccounts,
  target_saknr AS COAChangeListTargetNumber,
  target_short_description AS COAChangeListTargetAccountDesc,
  target_long_description AS GLAccountLongName,
  saknr AS GLAccount,
  action AS COAChangeListAction,
  itemstatus AS COAChangeListItemStatus,
  check_result AS COAChangeListCheckResults,
  importuuid AS COAChangeListImportUUID,
  created_by AS COAChangeListCreatedByUser,
  created_on AS COAChangeListCreationDateTime,
  grouping AS WorkItemIDGroupText
FROM coachnglistactiv
LEFT OUTER JOIN I_COAChangeListActionStatus AS _actionstatus ON coachnglistactiv.action = _actionstatus.COAChangeListAction  -- association [0..1]
;

Learn More