FAC_OPP_CDS_OKP2

DDL: FAC_OPP_CDS_OKP2 SQL: FACOPPV_KAPS Type: view
22 Fields 2 Data Sources

CDS View for KAPS display

FAC_OPP_CDS_OKP2 is a CDS View that provides data about "CDS View for KAPS display" in SAP S/4HANA. It reads from 2 data sources (kaps, tj01t) and exposes 22 fields with key fields kokrs, gjahr, versn, vrgng, perbl.

Data Sources (2)

SourceAliasJoin Type
kaps kaps from
tj01t tj01t left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACOPPV_KAPS view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View for KAPS display view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY kokrs kaps kokrs Org. Value
KEY gjahr kaps gjahr Settlement Year
KEY versn kaps versn Version
KEY vrgng kaps vrgng Bus.Transaction
KEY perbl kaps perbl Period Block
co_biz_txt tj01t txt Version Dscrptn
psp001 kaps psp001 Period Lock
psp002 kaps psp002 Period Lock
psp003 kaps psp003 Period Lock
psp004 kaps psp004 Period Lock
psp005 kaps psp005 Period Lock
psp006 kaps psp006 Period Lock
psp007 kaps psp007 Period Lock
psp008 kaps psp008 Period Lock
psp009 kaps psp009 Period Lock
psp010 kaps psp010 Period Lock
psp011 kaps psp011 Period Lock
psp012 kaps psp012 Period Lock
psp013 kaps psp013 Period Lock
psp014 kaps psp014 Period Lock
psp015 kaps psp015 Period Lock
psp016 kaps psp016 Period Lock

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 FAC_OPP_CDS_OKP2.
-- 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: FACOPPV_KAPS

CREATE VIEW FAC_OPP_CDS_OKP2 AS
SELECT
  kaps.kokrs AS kokrs,
  kaps.gjahr AS gjahr,
  kaps.versn AS versn,
  kaps.vrgng AS vrgng,
  kaps.perbl AS perbl,
  tj01t.txt AS co_biz_txt,
  kaps.psp001 AS psp001,
  kaps.psp002 AS psp002,
  kaps.psp003 AS psp003,
  kaps.psp004 AS psp004,
  kaps.psp005 AS psp005,
  kaps.psp006 AS psp006,
  kaps.psp007 AS psp007,
  kaps.psp008 AS psp008,
  kaps.psp009 AS psp009,
  kaps.psp010 AS psp010,
  kaps.psp011 AS psp011,
  kaps.psp012 AS psp012,
  kaps.psp013 AS psp013,
  kaps.psp014 AS psp014,
  kaps.psp015 AS psp015,
  kaps.psp016 AS psp016
FROM kaps
LEFT OUTER JOIN tj01t ON /* join condition not captured in parsed metadata */
;

Learn More