P_FinCorrOMPrmDet

DDL: P_FINCORROMPRMDET SQL: PFIN_V_CORR Type: view BASIC
13 Fields 2 Data Sources

P_FinCorrOMPrmDet is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (fin_d_corr_reqs, v_fin_corr_req_t) and exposes 13 fields with key fields event, company_code, account_type, account, document.

Data Sources (2)

SourceAliasJoin Type
fin_d_corr_reqs fin_d_corr_reqs from
v_fin_corr_req_t v_fin_corr_req_t union

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PFIN_V_CORR view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY event fin_d_corr_reqs event Time
KEY company_code fin_d_corr_reqs company_code Company Code
KEY account_type fin_d_corr_reqs account_type SI Account type
KEY account fin_d_corr_reqs account Std. Account
KEY document fin_d_corr_reqs document Sales Document
KEY fis_year fin_d_corr_reqs fis_year Fiscal Year
KEY event Time
KEY company_code v_fin_corr_req_t company_code Company Code
KEY account_type v_fin_corr_req_t account_type SI Account type
KEY account v_fin_corr_req_t account Std. Account
KEY document v_fin_corr_req_t document Sales Document
KEY fis_year v_fin_corr_req_t fis_year Fiscal Year
KEY variant v_fin_corr_req_t variant Variant Saved

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_FinCorrOMPrmDet.
-- 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: PFIN_V_CORR

CREATE VIEW P_FinCorrOMPrmDet AS
SELECT
  fin_d_corr_reqs.event AS event,
  fin_d_corr_reqs.company_code AS company_code,
  fin_d_corr_reqs.account_type AS account_type,
  fin_d_corr_reqs.account AS account,
  fin_d_corr_reqs.document AS document,
  fin_d_corr_reqs.fis_year AS fis_year,
  v_fin_corr_req_t.variant AS variant
FROM fin_d_corr_reqs
-- UNION with additional select branch(es): v_fin_corr_req_t
;

Learn More