I_PRODUCTTCCCLASSIFICATION
Classify Product with Commodity Code
I_PRODUCTTCCCLASSIFICATION is a CDS View in S/4HANA. Classify Product with Commodity Code. It contains 28 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ProductTCCClassificationTP | view_entity | from | CONSUMPTION | Classify Product with Commodity Code |
Fields (28)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Product | Product | 1 |
| KEY | TrdClassfctnNmbrSchm | TrdClassfctnNmbrSchm | 1 |
| _Division | _Division | 1 | |
| _DivisionText | _DivisionText | 1 | |
| _ExternalProductGroup | _ExternalProductGroup | 1 | |
| _ExternalProductGroupText | _ExternalProductGroupText | 1 | |
| _IndustrySector | _IndustrySector | 1 | |
| _IndustrySectorText | _IndustrySectorText | 1 | |
| _Product | _Product | 1 | |
| _ProductCategory | _ProductCategory | 1 | |
| _ProductCategoryText | _ProductCategoryText | 1 | |
| _ProductGroup | _ProductGroup | 1 | |
| _ProductGroupText | _ProductGroupText | 1 | |
| _ProductHierarchy | _ProductHierarchy | 1 | |
| _ProductHierarchyText | _ProductHierarchyText | 1 | |
| _ProductType | _ProductType | 1 | |
| _ProductTypeText | _ProductTypeText | 1 | |
| _Text | _Text | 1 | |
| _TrdClassfctnNmbrSchmText | _TrdClassfctnNmbrSchmText | 1 | |
| CreationDate | CreationDate | 1 | |
| Division | Division | 1 | |
| ExternalProductGroup | ExternalProductGroup | 1 | |
| IndustrySector | IndustrySector | 1 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| ProductCategory | ProductCategory | 1 | |
| ProductGroup | ProductGroup | 1 | |
| ProductHierarchy | ProductHierarchy | 1 | |
| ProductType | ProductType | 1 |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Classify Product with Commodity Code'
@ObjectModel.semanticKey: ['Product', 'TrdClassfctnNmbrSchm']
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #L,
dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_ProductTCCClassification
as select from I_TrdClassfctnProduct as _Product
cross join I_TrdClassfctnNmbrSchm as _NumberingScheme
{
key _NumberingScheme.TrdClassfctnNmbrSchm as TrdClassfctnNmbrSchm,
key _Product.Product,
_NumberingScheme.TrdClassfctnNmbrSchmType,
_Product.AuthorizationGroup,
_Product.IsMarkedForDeletion,
_Product.ProductCategory,
_Product.ProductGroup,
_Product.Division,
_Product.ProductHierarchy,
_Product.ProductType,
_Product.ExternalProductGroup,
_Product.IndustrySector,
_Product.CreationDate,
//associations
_NumberingScheme._TrdClassfctnNmbrSchmText,
_NumberingScheme._TrdClassfctnNmbrSchmTypeText,
_Product._Product,
_Product._Text,
_Product._ProductCategory,
_Product._ProductCategoryText,
_Product._ProductGroup,
_Product._ProductGroupText,
_Product._Division,
_Product._DivisionText,
_Product._ProductHierarchy,
_Product._ProductHierarchyText,
_Product._ProductType,
_Product._ProductTypeText,
_Product._ExternalProductGroup,
_Product._ExternalProductGroupText,
_Product._IndustrySector,
_Product._IndustrySectorText
}
where
_NumberingScheme.TrdClassfctnNmbrSchmType = '11'
or _NumberingScheme.TrdClassfctnNmbrSchmType = '12'
or _NumberingScheme.TrdClassfctnNmbrSchmType = '13'
or _NumberingScheme.TrdClassfctnNmbrSchmType = '14'
or _NumberingScheme.TrdClassfctnNmbrSchmType = '15'
and
(
_Product.ProductCategory = ''
or _Product.ProductCategory = '00'
or _Product.ProductCategory = '02'
or _Product.ProductCategory = '10'
or _Product.ProductCategory = '11'
or _Product.ProductCategory = '12'
)
and
(
_Product.ProductTypeCode = ''
or
_Product.ProductTypeCode = '1'
or
_Product.ProductTypeCode = '2'
)