I_TRDCLASSFCTNPRODUCT

CDS View
28 Fields 15 CDS Views

Product

I_TRDCLASSFCTNPRODUCT is a CDS View in S/4HANA. Product. It contains 28 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_ProdCmmdtyCodeObjPage view from CONSUMPTION Product Classification - Commodity Code
C_ProdCstmsTNEndUseObjPage view from CONSUMPTION Product Classification - Customs Tariff Number With End Use
C_ProdCstmsTrifNmbrObjPage view from CONSUMPTION Product Classification - Customs Tariff Number
C_ProdIntrastatSCObjPage view from CONSUMPTION Product Classification - Intrastat Service Code
C_ProdLglCtrlObjPage view from CONSUMPTION Product Classification - Legal Control
C_TrdClassfctnProdObjPage view from CONSUMPTION Product
C_TrdClassfctnProduct view from CONSUMPTION Product
I_ClassifyProductLglCtrl view from COMPOSITE Classify Product Legal Control
I_ProductTCCClassification view_entity from COMPOSITE Classify Product with Commodity Code
I_ReclassifyProductLglCtrl view inner COMPOSITE Reclassify Product Legal Control
I_TrdClassfctnProductVH view from COMPOSITE Product Value Help
P_ClassifyProdEndUseForKeyDate view from COMPOSITE
P_ClassifyProductForKeyDate view from COMPOSITE
P_ReclassifyProductForKeyDate view inner COMPOSITE
P_ReclsfyProdEndUseForKeyDate view inner COMPOSITE

Fields (28)

KeyField CDS FieldsUsed in Views
KEY Product Product 12
_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 5
_ProductGroupText _ProductGroupText 1
_ProductHierarchy _ProductHierarchy 1
_ProductHierarchyText _ProductHierarchyText 1
_ProductType _ProductType 5
_ProductTypeText _ProductTypeText 1
_Text _Text 2
AuthorizationGroup AuthorizationGroup 6
CreationDate CreationDate 1
Division Division 3
ExternalProductGroup ExternalProductGroup 3
IndustrySector IndustrySector 3
IsMarkedForDeletion IsMarkedForDeletion 3
ProductCategory ProductCategory 3
ProductGroup ProductGroup 7
ProductHierarchy ProductHierarchy 3
ProductType ProductType 7
ProductTypeCode ProductTypeCode 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Product
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_TRDCLASSFCTNPRODUCT (
    PRODUCT,
    _DIVISION,
    _DIVISIONTEXT,
    _EXTERNALPRODUCTGROUP,
    _EXTERNALPRODUCTGROUPTEXT,
    _INDUSTRYSECTOR,
    _INDUSTRYSECTORTEXT,
    _PRODUCT,
    _PRODUCTCATEGORY,
    _PRODUCTCATEGORYTEXT,
    _PRODUCTGROUP,
    _PRODUCTGROUPTEXT,
    _PRODUCTHIERARCHY,
    _PRODUCTHIERARCHYTEXT,
    _PRODUCTTYPE,
    _PRODUCTTYPETEXT,
    _TEXT,
    AUTHORIZATIONGROUP,
    CREATIONDATE,
    DIVISION,
    EXTERNALPRODUCTGROUP,
    INDUSTRYSECTOR,
    ISMARKEDFORDELETION,
    PRODUCTCATEGORY,
    PRODUCTGROUP,
    PRODUCTHIERARCHY,
    PRODUCTTYPE,
    PRODUCTTYPECODE,
    PRIMARY KEY (PRODUCT)
);

Learn More