C_ProdCommodityCodeForKeyDate

Product Commodity Code for Country/Region | view: CPRCMDTYCDFKDATE | Extraction: Not supported | Component: International Trade Classification
Tables used: /SAPSLL/MARITC, /SAPSLL/CLSNR, /SAPSLL/TDNOS, /SAPSLL/DNOSCT, /SAPSLL/NOSCA, /SAPSLL/TUNOS, /SAPSLL/TUOMM
Column Name Description
TrdClassfctnNmbrSchm FK Trade Classification Numbering Scheme
TrdClassfctnNmbrSchmCntnt FK Trade Classification Numbering Scheme Content
Product FK Product Number
ValidityStartDate Valid From
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Valid From
ValidityEndDate Valid To
Column Name Description
Column Name Description Domain name
CommodityCode Commodity Code /SAPSLL/CCNGN
Master Data Relations Join Conditions
Country/Region
  • Client
  • Country/Region
  • C_PRODCOMMODITYCODEFORKEYDATE.MANDT == T005.MANDT
  • C_PRODCOMMODITYCODEFORKEYDATE.COUNTRY == T005.LAND1
First Customs Unit of Measure
  • Client
  • First Customs Unit of Measure
  • ?
  • C_PRODCOMMODITYCODEFORKEYDATE.MANDT == /SAPSLL/TUOMC.MANDT
  • C_PRODCOMMODITYCODEFORKEYDATE.CUSTOMSUNITOFMEASURE == /SAPSLL/TUOMC.CUUOM
  • C_PRODCOMMODITYCODEFORKEYDATE.[column in domain "/SAPSLL/NOSMS"] == /SAPSLL/TUOMC.NOSMS
Product Number
  • Client
  • Product Number
  • C_PRODCOMMODITYCODEFORKEYDATE.MANDT == MARA.MANDT
  • C_PRODCOMMODITYCODEFORKEYDATE.PRODUCT == MARA.MATNR
Second Customs Unit of Measure
  • Client
  • ?
  • Second Customs Unit of Measure
  • C_PRODCOMMODITYCODEFORKEYDATE.MANDT == /SAPSLL/TUOMC.MANDT
  • C_PRODCOMMODITYCODEFORKEYDATE.[column in domain "/SAPSLL/NOSMS"] == /SAPSLL/TUOMC.NOSMS
  • C_PRODCOMMODITYCODEFORKEYDATE.SECONDCUSTOMSUNITOFMEASURE == /SAPSLL/TUOMC.CUUOM
Second Supplementary Unit
  • Client
  • Supplementary Unit
  • Second Supplementary Unit
  • C_PRODCOMMODITYCODEFORKEYDATE.MANDT == T006.MANDT
  • C_PRODCOMMODITYCODEFORKEYDATE.SUPPLEMENTARYUNIT == T006.MSEHI
  • C_PRODCOMMODITYCODEFORKEYDATE.SECONDSUPPLEMENTARYUNIT == T006.MSEHI
Supplementary Unit
  • Client
  • Supplementary Unit
  • Second Supplementary Unit
  • C_PRODCOMMODITYCODEFORKEYDATE.MANDT == T006.MANDT
  • C_PRODCOMMODITYCODEFORKEYDATE.SUPPLEMENTARYUNIT == T006.MSEHI
  • C_PRODCOMMODITYCODEFORKEYDATE.SECONDSUPPLEMENTARYUNIT == T006.MSEHI
Trade Classification Numbering Scheme Content
  • Client
  • Trade Classification Numbering Scheme Content
  • C_PRODCOMMODITYCODEFORKEYDATE.MANDT == /SAPSLL/DNOSCT.MANDT
  • C_PRODCOMMODITYCODEFORKEYDATE.TRDCLASSFCTNNMBRSCHMCNTNT == /SAPSLL/DNOSCT.NOSCT
Unit of Measure System
  • Client
  • Unit of Measure System
  • C_PRODCOMMODITYCODEFORKEYDATE.MANDT == /SAPSLL/TUOMS.MANDT
  • C_PRODCOMMODITYCODEFORKEYDATE.UNITOFMEASURESYSTEM == /SAPSLL/TUOMS.NOSMS