C_ProdLglCtrlObjPage

DDL: C_PRODLGLCTRLOBJPAGE SQL: CPRLGLCLSOP Type: view CONSUMPTION Package: VDM_SLL_CLS
19 Fields 2 Data Sources 2 Associations 1 OData Services

Product Classification - Legal Control

C_ProdLglCtrlObjPage is a Consumption CDS View that provides data about "Product Classification - Legal Control" in SAP S/4HANA. It reads from 2 data sources (I_TrdClassfctnLglRgln, I_TrdClassfctnProduct) and exposes 19 fields with key fields Product, LegalRegulation. It has 2 associations to related views. It is exposed through 1 OData service (ASQL_F3935). Part of development package VDM_SLL_CLS.

Data Sources (2)

SourceAliasJoin Type
I_TrdClassfctnLglRgln _TrdClassfctnLglRgln cross
I_TrdClassfctnProduct _TrdClassfctnProduct from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProdLglCtrlForKeyDate _ProdLglCtrlForKeyDate _TrdClassfctnLglRgln.LegalRegulation = _ProdLglCtrlForKeyDate.LegalRegulation and _TrdClassfctnProduct.Product = _ProdLglCtrlForKeyDate.Product
[0..1] I_Product _Product _Product.Product = $projection.Product

Annotations (14)

NameValueLevelField
EndUserText.label Product Classification - Legal Control view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPRLGLCLSOP view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.draftEnabled false view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3935 ASQL_F3935 C2 NOT_RELEASED

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Product I_TrdClassfctnProduct Product Product Sold
KEY LegalRegulation I_TrdClassfctnLglRgln LegalRegulation
LegalRegulationName Legal Regulation Description
ControlClass
ControlGrouping
ValidityStartDate
ValidityEndDate
TrdClassfctnRemark
TrdClassfctnNmbrForOfclDesc
TrdClassfctnNmbrForCnctntdDesc
TrdClassfctnNmbrStartDate
TrdClassfctnNmbr
TrdClassfctnNmbrSchmCntnt
FirstLegalRegulation
_OfficialDesc
_CnctntdDesc
_ControlGroupingText
_LegalRegulationText I_TrdClassfctnLglRgln _LegalRegulationText
_Product _Product

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 C_ProdLglCtrlObjPage.
-- 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: CPRLGLCLSOP

CREATE VIEW C_ProdLglCtrlObjPage AS
SELECT
  _TrdClassfctnProduct.Product AS Product,
  _TrdClassfctnLglRgln.LegalRegulation AS LegalRegulation,
  _TrdClassfctnLglRgln._LegalRegulationText[ 1: Language = $session.system_language ].LegalRegulationName AS LegalRegulationName,
  _ProdLglCtrlForKeyDate(P_KeyDate: $session.system_date).ControlClass AS ControlClass,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date).ControlGrouping AS ControlGrouping,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date).ValidityStartDate AS ValidityStartDate,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date).ValidityEndDate AS ValidityEndDate,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date).TrdClassfctnRemark AS TrdClassfctnRemark,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date).TrdClassfctnNmbrForOfclDesc AS TrdClassfctnNmbrForOfclDesc,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date).TrdClassfctnNmbrForCnctntdDesc AS TrdClassfctnNmbrForCnctntdDesc,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date).TrdClassfctnNmbrStartDate AS TrdClassfctnNmbrStartDate,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date).TrdClassfctnNmbr AS TrdClassfctnNmbr,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date).TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date).LegalRegulation AS FirstLegalRegulation,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date)._OfficialDesc AS _OfficialDesc,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date)._CnctntdDesc AS _CnctntdDesc,
  _ProdLglCtrlForKeyDate(P_Keydate: $session.system_date)._ControlGroupingText AS _ControlGroupingText,
  _TrdClassfctnLglRgln._LegalRegulationText AS _LegalRegulationText
FROM I_TrdClassfctnProduct AS _TrdClassfctnProduct
CROSS JOIN I_TrdClassfctnLglRgln AS _TrdClassfctnLglRgln
LEFT OUTER JOIN I_ProdLglCtrlForKeyDate AS _ProdLglCtrlForKeyDate ON _TrdClassfctnLglRgln.LegalRegulation = _ProdLglCtrlForKeyDate.LegalRegulation AND _TrdClassfctnProduct.Product = _ProdLglCtrlForKeyDate.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = Product  -- association [0..1]
;

Learn More