VFCP_DDL_PAY_NOTE

DDL: FCLM_CP_PAYMENT_NOTES SQL: VFCP_PAY_NOTE Type: view
4 Fields 1 Data Sources

VFCP_DDL_PAY_NOTE is a CDS View in SAP S/4HANA. It reads from 1 data source (febre) and exposes 4 fields with key fields BANKSTATEMENT, ITEM, NOTENUM.

Data Sources (1)

SourceAliasJoin Type
febre pn from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VFCP_PAY_NOTE view
ClientDependent true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY BANKSTATEMENT febre kukey Statement Short Key
KEY ITEM febre esnum Memo Record No.
KEY NOTENUM febre rsnum Reservation
PAYMENT_NOTES febre vwezw Note to Payee

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 VFCP_DDL_PAY_NOTE.
-- 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: VFCP_PAY_NOTE

CREATE VIEW VFCP_DDL_PAY_NOTE AS
SELECT
  pn.kukey AS BANKSTATEMENT,
  pn.esnum AS ITEM,
  pn.rsnum AS NOTENUM,
  pn.vwezw AS PAYMENT_NOTES
FROM febre AS pn
;

Learn More