I_TrdClassfctnCntntNmbr

DDL: I_TRDCLASSFCTNCNTNTNMBR SQL: ITRDCLSCNT Type: view BASIC Package: VDM_SLL_CLS
10 Fields 1 Data Sources

Classification Content Number

I_TrdClassfctnCntntNmbr is a Basic CDS View that provides data about "Classification Content Number" in SAP S/4HANA. It reads from 1 data source (/sapsll/clsct) and exposes 10 fields with key field TrdClassfctnNmbrUUID. Part of development package VDM_SLL_CLS.

Data Sources (1)

SourceAliasJoin Type
/sapsll/clsct /sapsll/clsct from

Annotations (9)

NameValueLevelField
EndUserText.label Classification Content Number view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ITRDCLSCNT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey TrdClassfctnNmbrUUID view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrUUID db_key UUID
TrdClassfctnCntntVersUUID parent_key UUID
TrdClassfctnCntntUUID parent_key UUID
TrdClassfctnNmbrSchmCntnt nosct No. Scheme Content
TrdClassfctnCntntVersion ctver Version
TrdClassfctnNmbr ccngn Number
ValidityStartDate datab Validity period
ValidityEndDate datbi Validity period
CustomsUnitOfMeasure cuom1 1st Customs Unit
SecondCustomsUnitOfMeasure cuom2 2nd Customs Unit

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_TrdClassfctnCntntNmbr.
-- 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: ITRDCLSCNT

CREATE VIEW I_TrdClassfctnCntntNmbr AS
SELECT
  db_key AS TrdClassfctnNmbrUUID,
  parent_key AS TrdClassfctnCntntVersUUID,
  parent_key AS TrdClassfctnCntntUUID,
  nosct AS TrdClassfctnNmbrSchmCntnt,
  ctver AS TrdClassfctnCntntVersion,
  ccngn AS TrdClassfctnNmbr,
  datab AS ValidityStartDate,
  datbi AS ValidityEndDate,
  cuom1 AS CustomsUnitOfMeasure,
  cuom2 AS SecondCustomsUnitOfMeasure
FROM /sapsll/clsct
;

Learn More