P_ARBSITMCLRSUGGEST

DDL: P_ARBSITMCLRSUGGEST SQL: PARBSITMFEBCL Type: view_entity BASIC Package: FINS_AR_MACHINE_LEARNING
4 Fields 1 Data Sources

Auto Clearing Suggestion

P_ARBSITMCLRSUGGEST is a Basic CDS View that provides data about "Auto Clearing Suggestion" in SAP S/4HANA. It reads from 1 data source (febcl) and exposes 4 fields. Part of development package FINS_AR_MACHINE_LEARNING.

Data Sources (1)

SourceAliasJoin Type
febcl febcl from

Annotations (6)

NameValueLevelField
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
BankStatementShortId kukey Statement Short Key
BankStatementItem esnum Memo Record No.
AccountingDocument
FiscalYear

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 P_ARBSITMCLRSUGGEST.
-- 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: PARBSITMFEBCL

CREATE VIEW P_ARBSITMCLRSUGGEST AS
SELECT
  kukey AS BankStatementShortId,
  esnum AS BankStatementItem,
  substring(selvon, 1, 10) AS AccountingDocument,
  substring(selvon, 11, 4) AS FiscalYear
FROM febcl
;

Learn More