P_OpenCorrespondence

DDL: P_OPENCORRESPONDENCE SQL: POpenCorrespnc Type: view BASIC
12 Fields 2 Data Sources

P_OpenCorrespondence is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (bkorm, bkorm) and exposes 12 fields.

Data Sources (2)

SourceAliasJoin Type
bkorm bkorm from
bkorm bkorm union_all

Annotations (6)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
Correspondence event Time
CompanyCode bukrs Source CoCode
AccountingDocument belnr SD Document
FiscalYear gjahr Settlement Year
CreationDate datum Valid to
CreationTime uzeit Time
CompanyCode bbukr Source CoCode
AccountingDocument belnr SD Document
FiscalYear gjahr Settlement Year
CreationDate datum Valid to
CreationTime uzeit Time
CreatedByUser usnam User Name

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_OpenCorrespondence.
-- 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: POpenCorrespnc

CREATE VIEW P_OpenCorrespondence AS
SELECT
  event AS Correspondence,
  bukrs AS CompanyCode,
  belnr AS AccountingDocument,
  gjahr AS FiscalYear,
  datum AS CreationDate,
  uzeit AS CreationTime,
  usnam AS CreatedByUser
FROM bkorm
-- UNION ALL with additional select branch(es): bkorm
;

Learn More