I_DoubtReceivablesAccount

DDL: I_DOUBTRECEIVABLESACCOUNT SQL: IDOUBTRCVACC Type: view BASIC
5 Fields 1 Data Sources

Account Determination

I_DoubtReceivablesAccount is a Basic CDS View that provides data about "Account Determination" in SAP S/4HANA. It reads from 1 data source (fagl_drprov_acc) and exposes 5 fields with key fields ChartOfAccounts, ValuationArea, ProvisionMethod.

Data Sources (1)

SourceAliasJoin Type
fagl_drprov_acc fagl_drprov_acc from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDOUBTRCVACC view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Account Determination view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ktopl G/L Chart of Accounts
KEY ValuationArea bwber Valuation Area
KEY ProvisionMethod rsmet Provision Meth.
DebitGLAccount konts Sales Reduction (Dr)
CreditGLAccount konth Provision Account

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_DoubtReceivablesAccount.
-- 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.
-- SQL view name: IDOUBTRCVACC

CREATE VIEW I_DoubtReceivablesAccount AS
SELECT
  ktopl AS ChartOfAccounts,
  bwber AS ValuationArea,
  rsmet AS ProvisionMethod,
  konts AS DebitGLAccount,
  konth AS CreditGLAccount
FROM fagl_drprov_acc
;

Learn More