I_OffsettingAccount

DDL: I_OFFSETTINGACCOUNT Type: view COMPOSITE
11 Fields 1 Data Sources 6 Associations

Offsetting Account

I_OffsettingAccount (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_OffsettingAccount is a Composite CDS View (Dimension) that provides data about "Offsetting Account" in SAP S/4HANA. It reads from 1 data source (P_OffsettingAccount) and exposes 11 fields with key fields ChartOfAccounts, OffsettingAccountType, OffsettingAccount. It has 6 associations to related views.

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL-IS
CapabilitiesAnalytical Dimension, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
P_OffsettingAccount P_OffsettingAccount from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[0..1] I_GLAccountInChartOfAccounts _GLAccount $projection.OffsettingAccount = _GLAccount.ChartOfAccounts and $projection.OffsettingAccount = _GLAccount.GLAccount and ( $projection.OffsettingAccountType = 'S' or $projection.OffsettingAccountType = 'M' or $projection.OffsettingAccountType = 'A' )
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.OffsettingAccount = _GLAccountInChartOfAccounts.GLAccount and ( $projection.OffsettingAccountType = 'S' or $projection.OffsettingAccountType = 'M' or $projection.OffsettingAccountType = 'A' )
[0..1] I_FinancialAccountType _OffsettingAccountType $projection.OffsettingAccountType = _OffsettingAccountType.FinancialAccountType
[0..1] I_Customer _Customer $projection.OffsettingAccount = _Customer.Customer and $projection.OffsettingAccountType = 'D'
[0..1] I_Supplier _Supplier $projection.OffsettingAccount = _Supplier.Supplier and $projection.OffsettingAccountType = 'K'

Annotations (16)

NameValueLevelField
EndUserText.label Offsetting Account view
Analytics.dataCategory #DIMENSION view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IFIOFFSETACCT view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
ObjectModel.representativeKey OffsettingAccount view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.allowExtensions true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts P_OffsettingAccount ChartOfAccounts Chart of Accounts
KEY OffsettingAccountType P_OffsettingAccount OffsettingAccountType Offsetting Account Type
KEY OffsettingAccount P_OffsettingAccount OffsettingAccount Offsetting Account
OffsettingAccountName P_OffsettingAccount OffsettingAccountName Name of Offsetting Account
OffsettingAccountShortName P_OffsettingAccount OffsettingAccountShortName Short Name of Offsetting Account
_ChartOfAccounts _ChartOfAccounts
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_GLAccount _GLAccount
_Customer _Customer
_Supplier _Supplier
_OffsettingAccountType _OffsettingAccountType

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_OffsettingAccount.
-- 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_OffsettingAccount AS
SELECT
  P_OffsettingAccount.ChartOfAccounts AS ChartOfAccounts,
  P_OffsettingAccount.OffsettingAccountType AS OffsettingAccountType,
  P_OffsettingAccount.OffsettingAccount AS OffsettingAccount,
  P_OffsettingAccount.OffsettingAccountName AS OffsettingAccountName,
  P_OffsettingAccount.OffsettingAccountShortName AS OffsettingAccountShortName
FROM P_OffsettingAccount
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccount ON OffsettingAccount = _GLAccount.ChartOfAccounts AND OffsettingAccount = _GLAccount.GLAccount AND ( OffsettingAccountType = 'S' OR OffsettingAccountType = 'M' OR OffsettingAccountType = 'A' )  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND OffsettingAccount = _GLAccountInChartOfAccounts.GLAccount AND ( OffsettingAccountType = 'S' OR OffsettingAccountType = 'M' OR OffsettingAccountType = 'A' )  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _OffsettingAccountType ON OffsettingAccountType = _OffsettingAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON OffsettingAccount = _Customer.Customer AND OffsettingAccountType = 'D'  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON OffsettingAccount = _Supplier.Supplier AND OffsettingAccountType = 'K'  -- association [0..1]
;

Learn More