I_TW_RoundingDiffAccountingDoc

DDL: I_TW_ROUNDINGDIFFACCOUNTINGDOC Type: view_entity BASIC

TW rounding difference accounting document

I_TW_RoundingDiffAccountingDoc is a Basic CDS View that provides data about "TW rounding difference accounting document" in SAP S/4HANA. It reads from 1 data source (I_TW_EDocConsolidatedAcctgDoc) and exposes 9 fields with key fields ElectronicDocCompanyCode, AccountingDocument, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
I_TW_EDocConsolidatedAcctgDoc diff from

Annotations (6)

NameValueLevelField
EndUserText.label TW rounding difference accounting document view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocCompanyCode I_TW_EDocConsolidatedAcctgDoc ElectronicDocCompanyCode Value
KEY AccountingDocument I_TW_EDocConsolidatedAcctgDoc AccountingDocument Journal Entry
KEY FiscalYear I_TW_EDocConsolidatedAcctgDoc FiscalYear G/L Fiscal Year
ElectronicDocUUID I_TW_EDocConsolidatedAcctgDoc ElectronicDocUUID eDocument GUID
TW_EDocGvmntUniformInvcNumber I_TW_EDocConsolidatedAcctgDoc TW_EDocGvmntUniformInvcNumber GUI Number
ElectronicDocSourceKey I_TW_EDocConsolidatedAcctgDoc ElectronicDocSourceKey
ElectronicDocBillingSourceKey I_TW_EDocConsolidatedAcctgDoc ElectronicDocBillingSourceKey RefKey GJE
ODNDocumentClass I_TW_EDocConsolidatedAcctgDoc ODNDocumentClass Doc.class
PostingDate I_TW_EDocConsolidatedAcctgDoc PostingDate Posting Date for GR

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_TW_RoundingDiffAccountingDoc.
-- 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_TW_RoundingDiffAccountingDoc AS
SELECT
  diff.ElectronicDocCompanyCode AS ElectronicDocCompanyCode,
  diff.AccountingDocument AS AccountingDocument,
  diff.FiscalYear AS FiscalYear,
  diff.ElectronicDocUUID AS ElectronicDocUUID,
  diff.TW_EDocGvmntUniformInvcNumber AS TW_EDocGvmntUniformInvcNumber,
  diff.ElectronicDocSourceKey AS ElectronicDocSourceKey,
  diff.ElectronicDocBillingSourceKey AS ElectronicDocBillingSourceKey,
  diff.ODNDocumentClass AS ODNDocumentClass,
  diff.PostingDate AS PostingDate
FROM I_TW_EDocConsolidatedAcctgDoc AS diff
;