I_FinSGLErrorItem

DDL: I_FINSGLERRORITEM Type: view_entity BASIC
34 Fields 1 Data Sources

Financial Services GL Error Item

I_FinSGLErrorItem is a Basic CDS View that provides data about "Financial Services GL Error Item" in SAP S/4HANA. It reads from 1 data source (gle_ecs_item) and exposes 34 fields with key field FinSGLErrorItemUUID.

Data Sources (1)

SourceAliasJoin Type
gle_ecs_item gle_ecs_item from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Financial Services GL Error Item view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey FinSGLErrorItemUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name FinSGLErrorItem view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY FinSGLErrorItemUUID item_id Simulation Item ID
FinSGLCompoundErrorCategory compound_error Compound Error Cat.
FinSGLErrorItemStatus Workflow Status
FinSGLErrorItemSeverity Thresh.Val. Severity
FinSGLPostedCompanyCode company_code Company Code
FinSGLPostedDocument doc_no Posted Doc. No.
FinSGLPostedFiscalYear fiscal_year Tax Item Fiscal Year
LedgerGLLineItem Tax doc. item number
FinSGLErrorDocument int_doc_ref_id ECS Document Number
FinSGLErrorFiscalYear int_doc_year ECS Entered in Year
AccountType account_type SI Account type
FinSGLOriginalPostingDate post_date_o Orig. Posting Date
FinSGLOriginalAccount account_o Original GL Acct
FinSGLOriginalProfitCenter profit_center_o Orig. Profit Ctr
FinSGLOriginalCostCenter cost_center_o Orig. Cost Center
AmountInTransactionCurrency amount_tcur Amount
TransactionCurrency tcur Currency
FinSGLPostedPostingDate post_date Sett. Post Date
FinSGLPostedAccount account Std. Account
FinSGLPostedCostCenter cost_center Posted Cost Center
FinSGLPostedProfitCenter profit_center Profit Center
FinSGLCorrectionCompanyCode new_company_code CoCode of Corr.Doc.
FinSGLCorrectionDocument new_doc_no Corr. Doc. No.
FinSGLCorrectionFiscalYear new_year Corr. Doc. FY
FinSGLCrrtnRvslCompanyCode corr_rev_ccode CC of Rev.Correction
FinSGLCrrtnReversalDocument corr_rev_doc_no Correction Doc. No.
FinSGLCrrtnRvslFiscalYear corr_rev_year Correction Doc. FY
FinSGLErrCrrtnEnvrmt if_type Interface type
FinSGLRunID Run Adm Run ID
FinSGLErrorItemCreatedBy create_user User Name
FinSGLErrorItemChangedBy change_user User Name
FinSGLErrorItemProcessor owner Vehicle Owner
FinSGLErrorItemTeamName owner_grp Team
Note wf_comment Comment

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_FinSGLErrorItem.
-- 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_FinSGLErrorItem AS
SELECT
  item_id AS FinSGLErrorItemUUID,
  compound_error AS FinSGLCompoundErrorCategory,
  cast( status as gle_dte_ecs_status_no_conv ) AS FinSGLErrorItemStatus,
  cast( severity as gle_dte_ecs_severity_no_conv ) AS FinSGLErrorItemSeverity,
  company_code AS FinSGLPostedCompanyCode,
  doc_no AS FinSGLPostedDocument,
  fiscal_year AS FinSGLPostedFiscalYear,
  lpad( cast(pos_no as fis_docln ), 6, '0' ) AS LedgerGLLineItem,
  int_doc_ref_id AS FinSGLErrorDocument,
  int_doc_year AS FinSGLErrorFiscalYear,
  account_type AS AccountType,
  post_date_o AS FinSGLOriginalPostingDate,
  account_o AS FinSGLOriginalAccount,
  profit_center_o AS FinSGLOriginalProfitCenter,
  cost_center_o AS FinSGLOriginalCostCenter,
  amount_tcur AS AmountInTransactionCurrency,
  tcur AS TransactionCurrency,
  post_date AS FinSGLPostedPostingDate,
  account AS FinSGLPostedAccount,
  cost_center AS FinSGLPostedCostCenter,
  profit_center AS FinSGLPostedProfitCenter,
  new_company_code AS FinSGLCorrectionCompanyCode,
  new_doc_no AS FinSGLCorrectionDocument,
  new_year AS FinSGLCorrectionFiscalYear,
  corr_rev_ccode AS FinSGLCrrtnRvslCompanyCode,
  corr_rev_doc_no AS FinSGLCrrtnReversalDocument,
  corr_rev_year AS FinSGLCrrtnRvslFiscalYear,
  if_type AS FinSGLErrCrrtnEnvrmt,
  cast( runid_ext as gle_dte_ecs_runid_conv ) AS FinSGLRunID,
  create_user AS FinSGLErrorItemCreatedBy,
  change_user AS FinSGLErrorItemChangedBy,
  owner AS FinSGLErrorItemProcessor,
  owner_grp AS FinSGLErrorItemTeamName,
  wf_comment AS Note
FROM gle_ecs_item
;

Learn More