I_ImprmtProfitAndLossAccounts

DDL: I_IMPRMTPROFITANDLOSSACCOUNTS Type: view BASIC

Impairment process P&L GL Accts

I_ImprmtProfitAndLossAccounts is a Basic CDS View (Dimension) that provides data about "Impairment process P&L GL Accts" in SAP S/4HANA. It reads from 1 data source (finsc_imp_pl_gl) and exposes 7 fields with key fields AccountingPrinciple, ChartOfAccounts. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
finsc_imp_pl_gl finsc_imp_pl_gl from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_AccountingPrinciple _AccountingPrinciple $projection.AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts

Annotations (17)

NameValueLevelField
EndUserText.label Impairment process P&L GL Accts view
AbapCatalog.sqlViewName IIMPPLGLACC view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 2 view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.representativeKey AccountingPrinciple view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY AccountingPrinciple acc_principle Evaluation area EBRR
KEY ChartOfAccounts chrt_accts Chart of Accts
LossAllowanceChangeGLAccount imp_chg_pl_account New/Change PL CLA GL
LossAllowanceReleaseGLAccount imp_release_pl_account Release P&L CLA GL
LossAllowanceWriteOffGLAccount imp_writeoff_pl_account Write-Off P&L GL
_AccountingPrinciple _AccountingPrinciple
_ChartOfAccounts _ChartOfAccounts

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_ImprmtProfitAndLossAccounts.
-- 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_ImprmtProfitAndLossAccounts AS
SELECT
  acc_principle AS AccountingPrinciple,
  chrt_accts AS ChartOfAccounts,
  imp_chg_pl_account AS LossAllowanceChangeGLAccount,
  imp_release_pl_account AS LossAllowanceReleaseGLAccount,
  imp_writeoff_pl_account AS LossAllowanceWriteOffGLAccount
FROM finsc_imp_pl_gl
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
;