C_TrdClassfctnProduct

DDL: C_TRDCLASSFCTNPRODUCT SQL: CTRDCLSPR Type: view CONSUMPTION
23 Fields 1 Data Sources 1 Associations

Product

C_TrdClassfctnProduct is a Consumption CDS View that provides data about "Product" in SAP S/4HANA. It reads from 1 data source (I_TrdClassfctnProduct) and exposes 23 fields with key field Product. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_TrdClassfctnProduct I_TrdClassfctnProduct from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_Product _Extension $projection.Product = _Extension.Product

Annotations (15)

NameValueLevelField
EndUserText.label Product view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CTRDCLSPR view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Product Master view
UI.headerInfo.typeNamePlural Product Master view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value Product view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value Product_Text view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
ProductGroup ProductGroup Product Sold Group
Division Division Internal Division ID
ProductHierarchy ProductHierarchy Prod.hierarchy
ProductType ProductType Product Type Group
ExternalProductGroup ExternalProductGroup Ext. prod group
CreationDate CreationDate Time Stamp
GrossWeight GrossWeight Total Weight
NetWeight NetWeight Net weight
WeightUnit WeightUnit Weight unit
BaseUnit BaseUnit Unit of Measure
AuthorizationGroup AuthorizationGroup AuthorizGroup
_Product _Product
_ProductGroup _ProductGroup
_ProductType _ProductType
_Text _Text
_ProductGroupText _ProductGroupText
_DivisionText _DivisionText
_ProductHierarchyText _ProductHierarchyText
_ProductTypeText _ProductTypeText
_ExternalProductGroupText _ExternalProductGroupText
_WeightUnitText _WeightUnitText
_BaseUnitText _BaseUnitText

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_TrdClassfctnProduct.
-- 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: CTRDCLSPR

CREATE VIEW C_TrdClassfctnProduct AS
SELECT
  Product,
  ProductGroup,
  Division,
  ProductHierarchy,
  ProductType,
  ExternalProductGroup,
  CreationDate,
  GrossWeight,
  NetWeight,
  WeightUnit,
  BaseUnit,
  AuthorizationGroup
FROM I_TrdClassfctnProduct
LEFT OUTER JOIN E_Product AS _Extension ON Product = _Extension.Product  -- association [0..1]
;

Learn More