LAW3_UI_MASTR_DATA_CONSRULES_C

DDL: LAW3_UI_MASTR_DATA_CONSRULES_C SQL: LAW3UIQMDCONRC Type: view

LAW3.0 Master Data:Individual Cons Rules

LAW3_UI_MASTR_DATA_CONSRULES_C is a CDS View that provides data about "LAW3.0 Master Data:Individual Cons Rules" in SAP S/4HANA. It reads from 3 data sources (law3d_cont, LAW3_UI_USER_TYPES_I, LAW3_UI_USER_TYPES_I) and exposes 6 fields.

Data Sources (3)

SourceAliasJoin Type
law3d_cont Cont from
LAW3_UI_USER_TYPES_I LAW3_UI_USER_TYPES_I left_outer
LAW3_UI_USER_TYPES_I LAW3_UI_USER_TYPES_I left_outer

Parameters (1)

NameTypeDefault
p_language sylangu

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName LAW3UIQMDCONRC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label LAW3.0 Master Data:Individual Cons Rules view

Fields (6)

KeyFieldSource TableSource FieldDescription
UserType law3d_cont usertyp User Type ID
Utyptext UserType utyptext Contr. User Type
Containsu law3d_cont containsu User Type ID
ContansUtext ContainsUType utyptext Contr. User Type
Crname law3d_cont crname Last Changed By
Crdate law3d_cont crdate Sizing Date

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 LAW3_UI_MASTR_DATA_CONSRULES_C.
-- 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: LAW3UIQMDCONRC
-- Parameters: p_language : sylangu

CREATE VIEW LAW3_UI_MASTR_DATA_CONSRULES_C AS
SELECT
  Cont.usertyp AS UserType,
  UserType.utyptext AS Utyptext,
  Cont.containsu AS Containsu,
  ContainsUType.utyptext AS ContansUtext,
  Cont.crname AS Crname,
  Cont.crdate AS Crdate
FROM law3d_cont AS Cont
LEFT OUTER JOIN LAW3_UI_USER_TYPES_I ON /* join condition not captured in parsed metadata */
;