P_RECONCILIATION_STATUS

DDL: P_RECONCILIATION_STATUS SQL: PCASHRES Type: view BASIC
3 Fields 2 Data Sources

P_RECONCILIATION_STATUS is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (fclm_crh, fclm_crl) and exposes 3 fields with key fields mandt, flow_id, valid_from.

Data Sources (2)

SourceAliasJoin Type
fclm_crh header inner
fclm_crl line from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCASHRES view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY mandt fclm_crl mandt Editing Client
KEY flow_id fclm_crl flow_id Flow ID
KEY valid_from fclm_crl valid_from Validity Start Time

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_RECONCILIATION_STATUS.
-- 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: PCASHRES

CREATE VIEW P_RECONCILIATION_STATUS AS
SELECT
  line.mandt AS mandt,
  line.flow_id AS flow_id,
  line.valid_from AS valid_from
FROM fclm_crl AS line
INNER JOIN fclm_crh AS header ON /* join condition not captured in parsed metadata */
;

Learn More