I_FinSGLErrorItemReversal

DDL: I_FINSGLERRORITEMREVERSAL Type: view_entity COMPOSITE
52 Fields 2 Data Sources

Error Items details for reversal

I_FinSGLErrorItemReversal is a Composite CDS View that provides data about "Error Items details for reversal" in SAP S/4HANA. It reads from 2 data sources (I_FinSGLDocumentReference, I_FinSGLErrorItem) and exposes 52 fields with key fields FinSGLErrorItemUUID, FinSGLRunID, FinSGLRunID.

Data Sources (2)

SourceAliasJoin Type
I_FinSGLDocumentReference a from
I_FinSGLErrorItem I_FinSGLErrorItem union

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Error Items details for reversal view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY FinSGLErrorItemUUID b FinSGLErrorItemUUID Simulation Item ID
KEY FinSGLRunID I_FinSGLDocumentReference FinSGLRunID UUID
FinSGLErrorDocument b FinSGLErrorDocument ECS Document Number
FinSGLErrorFiscalYear b FinSGLErrorFiscalYear ECS Entered in Year
FinSGLPostedDocument I_FinSGLDocumentReference AccountingDocument Posted Doc. No.
FinSGLPostedCompanyCode I_FinSGLDocumentReference CompanyCode Receiver Company Code
FinSGLPostedFiscalYear I_FinSGLDocumentReference FiscalYear G/L Fiscal Year
ReverseDocument I_FinSGLDocumentReference ReverseDocument Reversed With
ReferenceDocumentType I_FinSGLDocumentReference ReferenceDocumentType Reference Document Type
OriginalReferenceDocument I_FinSGLDocumentReference OriginalReferenceDocument Reference Key
PostingDate I_FinSGLDocumentReference PostingDate Posting Date for GR
FiscalPeriod I_FinSGLDocumentReference FiscalPeriod Tax period
IntercompanyTransaction I_FinSGLDocumentReference IntercompanyTransaction Intercompany Transaction
LedgerGroup I_FinSGLDocumentReference LedgerGroup Ledger Group
AccountingDocumentType I_FinSGLDocumentReference AccountingDocumentType Journal Entry Type
ReversalReason I_FinSGLDocumentReference ReversalReason Reversal Reason
PlannedReversalDate I_FinSGLDocumentReference PlannedReversalDate Reversal Date
FinSGLCorrectionDocument b FinSGLCorrectionDocument Corr. Doc. No.
FinSGLCorrectionCompanyCode b FinSGLCorrectionCompanyCode CoCode of Corr.Doc.
FinSGLCorrectionFiscalYear b FinSGLCorrectionFiscalYear Corr. Doc. FY
FinSGLCrrtnReversalDocument b FinSGLCrrtnReversalDocument Correction Doc. No.
FinSGLCrrtnRvslCompanyCode b FinSGLCrrtnRvslCompanyCode CC of Rev.Correction
FinSGLCrrtnRvslFiscalYear b FinSGLCrrtnRvslFiscalYear Correction Doc. FY
FinSGLErrorItemStatus b FinSGLErrorItemStatus
FinSGLErrorItemSeverity b FinSGLErrorItemSeverity
LedgerGLLineItem b LedgerGLLineItem Journal Entry Item
KEY FinSGLRunID FinSGLRunID UUID
FinSGLErrorDocument FinSGLErrorDocument ECS Document Number
FinSGLErrorFiscalYear FinSGLErrorFiscalYear ECS Entered in Year
FinSGLPostedDocument FinSGLPostedDocument Posted Doc. No.
FinSGLPostedCompanyCode Receiver Company Code
FinSGLPostedFiscalYear G/L Fiscal Year
ReverseDocument Reversed With
ReferenceDocumentType Reference Document Type
OriginalReferenceDocument Reference Key
PostingDate Posting Date for GR
FiscalPeriod Tax period
IntercompanyTransaction Intercompany Transaction
LedgerGroup Ledger Group
AccountingDocumentType Journal Entry Type
ReversalReason Reversal Reason
PlannedReversalDate Reversal Date
FinSGLCorrectionDocument FinSGLCorrectionDocument Corr. Doc. No.
FinSGLCorrectionCompanyCode FinSGLCorrectionCompanyCode CoCode of Corr.Doc.
FinSGLCorrectionFiscalYear FinSGLCorrectionFiscalYear Corr. Doc. FY
FinSGLCrrtnReversalDocument FinSGLCrrtnReversalDocument Correction Doc. No.
FinSGLCrrtnRvslCompanyCode FinSGLCrrtnRvslCompanyCode CC of Rev.Correction
FinSGLCrrtnRvslFiscalYear FinSGLCrrtnRvslFiscalYear Correction Doc. FY
FinSGLErrorItemStatus FinSGLErrorItemStatus
FinSGLErrorItemSeverity FinSGLErrorItemSeverity
LedgerGLLineItem LedgerGLLineItem Journal Entry Item
StatusFlagValue

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_FinSGLErrorItemReversal.
-- 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_FinSGLErrorItemReversal AS
SELECT
  b.FinSGLErrorItemUUID AS FinSGLErrorItemUUID,
  a.FinSGLRunID AS FinSGLRunID,
  b.FinSGLErrorDocument AS FinSGLErrorDocument,
  b.FinSGLErrorFiscalYear AS FinSGLErrorFiscalYear,
  a.AccountingDocument AS FinSGLPostedDocument,
  a.CompanyCode AS FinSGLPostedCompanyCode,
  a.FiscalYear AS FinSGLPostedFiscalYear,
  a.ReverseDocument AS ReverseDocument,
  a.ReferenceDocumentType AS ReferenceDocumentType,
  a.OriginalReferenceDocument AS OriginalReferenceDocument,
  a.PostingDate AS PostingDate,
  a.FiscalPeriod AS FiscalPeriod,
  a.IntercompanyTransaction AS IntercompanyTransaction,
  a.LedgerGroup AS LedgerGroup,
  a.AccountingDocumentType AS AccountingDocumentType,
  a.ReversalReason AS ReversalReason,
  a.PlannedReversalDate AS PlannedReversalDate,
  b.FinSGLCorrectionDocument AS FinSGLCorrectionDocument,
  b.FinSGLCorrectionCompanyCode AS FinSGLCorrectionCompanyCode,
  b.FinSGLCorrectionFiscalYear AS FinSGLCorrectionFiscalYear,
  b.FinSGLCrrtnReversalDocument AS FinSGLCrrtnReversalDocument,
  b.FinSGLCrrtnRvslCompanyCode AS FinSGLCrrtnRvslCompanyCode,
  b.FinSGLCrrtnRvslFiscalYear AS FinSGLCrrtnRvslFiscalYear,
  b.FinSGLErrorItemStatus AS FinSGLErrorItemStatus,
  b.FinSGLErrorItemSeverity AS FinSGLErrorItemSeverity,
  b.LedgerGLLineItem AS LedgerGLLineItem,
  '' AS StatusFlagValue
FROM I_FinSGLDocumentReference AS a
-- UNION with additional select branch(es): I_FinSGLErrorItem
;

Learn More