C_TrdClassfctnProduct

DDL: C_TRDCLASSFCTNPRODUCT SQL: CTRDCLSPR Type: view CONSUMPTION Package: VDM_SLL_CLS
23 Fields 1 Data Sources 1 Associations 8 OData Services

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. It is exposed through 8 OData services (ASQL_F2151, ASQL_F2152, ASQL_F2155, ...). Part of development package VDM_SLL_CLS.

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

OData Services (8)

ServiceBindingVersionContractRelease
ASQL_F2151 ASQL_F2151 C2 NOT_RELEASED
ASQL_F2152 ASQL_F2152 C2 NOT_RELEASED
ASQL_F2155 ASQL_F2155 C2 NOT_RELEASED
ASQL_F2156 ASQL_F2156 C2 NOT_RELEASED
ASQL_F2390 ASQL_F2390 C2 NOT_RELEASED
ASQL_F2391 ASQL_F2391 C2 NOT_RELEASED
ASQL_F3146 ASQL_F3146 C2 NOT_RELEASED
ASQL_F3147 ASQL_F3147 C2 NOT_RELEASED

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