P_CONTRACTTYPESIDE

DDL: P_CONTRACTTYPESIDE SQL: PCNTRTYPESIDE Type: view BASIC
3 Fields 2 Data Sources

P_CONTRACTTYPESIDE is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (tb2be, /accgo/t_cak_typ) and exposes 3 fields.

Data Sources (2)

SourceAliasJoin Type
tb2be a from
/accgo/t_cak_typ b inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PCNTRTYPESIDE view
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view

Fields (3)

KeyFieldSource TableSource FieldDescription
tctyp tb2be tctyp Contract Type
tdtpv tb2be tdtpv Control Grp Pur
tdtpc tb2be tdtpc Cntrl Grp Sales

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_CONTRACTTYPESIDE.
-- 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: PCNTRTYPESIDE

CREATE VIEW P_CONTRACTTYPESIDE AS
SELECT
  a.tctyp AS tctyp,
  a.tdtpv AS tdtpv,
  a.tdtpc AS tdtpc
FROM tb2be AS a
INNER JOIN /accgo/t_cak_typ AS b ON /* join condition not captured in parsed metadata */
;

Learn More