P_FINCORROMPRMDET_ACCDOC

DDL: P_FINCORROMPRMDET_ACCDOC SQL: PFINCORRACCDOC Type: view BASIC
8 Fields 2 Data Sources

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

Data Sources (2)

SourceAliasJoin Type
t048o _OMConf inner
P_FinCorrOMPrmDet _OMPrm from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFINCORRACCDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY event P_FinCorrOMPrmDet event Time
KEY company_code P_FinCorrOMPrmDet company_code Company Code
KEY account_type P_FinCorrOMPrmDet account_type SI Account type
KEY account P_FinCorrOMPrmDet account Std. Account
KEY document P_FinCorrOMPrmDet document Sales Document
KEY fis_year P_FinCorrOMPrmDet fis_year Fiscal Year
KEY req_mode P_FinCorrOMPrmDet req_mode Mode
KEY variant P_FinCorrOMPrmDet 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_ACCDOC.
-- 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: PFINCORRACCDOC

CREATE VIEW P_FINCORROMPRMDET_ACCDOC AS
SELECT
  _OMPrm.event AS event,
  _OMPrm.company_code AS company_code,
  _OMPrm.account_type AS account_type,
  _OMPrm.account AS account,
  _OMPrm.document AS document,
  _OMPrm.fis_year AS fis_year,
  _OMPrm.req_mode AS req_mode,
  _OMPrm.variant AS variant
FROM P_FinCorrOMPrmDet AS _OMPrm
INNER JOIN t048o AS _OMConf ON /* join condition not captured in parsed metadata */
;

Learn More