FARMLVD_BSITMCLRINFO

DDL: FARMLVD_BSITMCLRINFO Type: view_entity Package: FINS_AR_MACHINE_LEARNING
4 Fields 1 Data Sources

Payment Advice

FARMLVD_BSITMCLRINFO is a CDS View that provides data about "Payment Advice" in SAP S/4HANA. It reads from 1 data source (farvd_febcl_with_ext) and exposes 4 fields. Part of development package FINS_AR_MACHINE_LEARNING.

Data Sources (1)

SourceAliasJoin Type
farvd_febcl_with_ext farvd_febcl_with_ext from

Parameters (1)

NameTypeDefault
P_FieldType feldn_f05a

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Payment Advice view

Fields (4)

KeyFieldSource TableSource FieldDescription
kukey kukey Statement Short Key
esnum 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 FARMLVD_BSITMCLRINFO.
-- 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.
-- Parameters: P_FieldType : feldn_f05a

CREATE VIEW FARMLVD_BSITMCLRINFO AS
SELECT
  kukey,
  esnum,
  substring(selvon, 1, 10) AS AccountingDocument,
  substring(selvon, 11, 4) AS FiscalYear
FROM farvd_febcl_with_ext
;

Learn More