P_FEBCL_BELNR_VALID

DDL: P_FEBCL_BELNR_VALID SQL: PFEBCLCLV Type: view BASIC Package: FCLM_CASHRECONCILIATION
6 Fields 1 Data Sources

Febcl without empty items

P_FEBCL_BELNR_VALID is a Basic CDS View that provides data about "Febcl without empty items" in SAP S/4HANA. It reads from 1 data source (febcl) and exposes 6 fields. Part of development package FCLM_CASHRECONCILIATION.

Data Sources (1)

SourceAliasJoin Type
febcl febcl from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFEBCLCLV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
ShortKey febcl kukey Statement Short Key
MemoRecordNumber febcl esnum Memo Record No.
ClearingRecordNumber febcl csnum Clearing Rec No
FieldName febcl selfd Field
selvon110asbelnr_dasDocumentNumber
CompanyCode febcl agbuk Company Code

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_FEBCL_BELNR_VALID.
-- 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: PFEBCLCLV

CREATE VIEW P_FEBCL_BELNR_VALID AS
SELECT
  febcl.kukey AS ShortKey,
  febcl.esnum AS MemoRecordNumber,
  febcl.csnum AS ClearingRecordNumber,
  febcl.selfd AS FieldName,
  cast ( substring( febcl.selvon, 1, 10 ) as belnr_d )as DocumentNumber AS selvon110asbelnr_dasDocumentNumber,
  febcl.agbuk AS CompanyCode
FROM febcl
;

Learn More