I_TrdClassfctnLglRgln

DDL: I_TRDCLASSFCTNLGLRGLN SQL: ITRDCLSLGREG Type: view BASIC Package: VDM_SLL_CLS

Trade Classification Legal Regulation

I_TrdClassfctnLglRgln is a Basic CDS View that provides data about "Trade Classification Legal Regulation" in SAP S/4HANA. It reads from 1 data source (I_LegalRegulation) and exposes 8 fields with key field LegalRegulation. It is exposed through 2 OData services (ASQL_F2390, ASQL_F2391). Part of development package VDM_SLL_CLS.

Data Sources (1)

SourceAliasJoin Type
I_LegalRegulation I_LegalRegulation from

Annotations (12)

NameValueLevelField
EndUserText.label Trade Classification Legal Regulation view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ITRDCLSLGREG view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey LegalRegulation view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable false view
ObjectModel.usageType.sizeCategory M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
AbapCatalog.compiler.compareFilter true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F2390 ASQL_F2390 C2 NOT_RELEASED
ASQL_F2391 ASQL_F2391 C2 NOT_RELEASED

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY LegalRegulation LegalRegulation Legal Regulation
CtrlClNmbrSchm CtrlClNmbrSchm Numbering Scheme
IntlTrdLglRglnArea IntlTrdLglRglnArea Trd. Regulation Area
OriginCountry OriginCountry Ctry/Reg of Origin
TrdCmplncCtrlIsRlvtForAllProd TrdCmplncCtrlIsRlvtForAllProd
CmmdtyCodeNmbrSchm CmmdtyCodeNmbrSchm Numbering Scheme
_CountryText _CountryText
_LegalRegulationText _LegalRegulationText

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 I_TrdClassfctnLglRgln.
-- 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: ITRDCLSLGREG

CREATE VIEW I_TrdClassfctnLglRgln AS
SELECT
  LegalRegulation,
  CtrlClNmbrSchm,
  IntlTrdLglRglnArea,
  OriginCountry,
  TrdCmplncCtrlIsRlvtForAllProd,
  CmmdtyCodeNmbrSchm
FROM I_LegalRegulation
;