C_TrdClassfctnProdPlantCountry

DDL: C_TRDCLASSFCTNPRODPLANTCOUNTRY SQL: CPROCOUNTRY Type: view CONSUMPTION

Trade classification product by country/region

C_TrdClassfctnProdPlantCountry is a Consumption CDS View that provides data about "Trade classification product by country/region" in SAP S/4HANA. It reads from 1 data source (I_ProductPlantBasic) and exposes 3 fields with key fields Product, Country.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductPlantBasic _ProductPlant from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPROCOUNTRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Trade classification product by country/region view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductPlantBasic Product
KEY Country _Address Country
_ProductPlantBasic _ProductPlantBasic 
@AbapCatalog.sqlViewName: 'CPROCOUNTRY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Trade classification product by country/region'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION

define view C_TrdClassfctnProdPlantCountry
  as select from    I_ProductPlantBasic as _ProductPlant
    left outer to one join I_Plant        as _Plant   on _Plant.Plant = _ProductPlant.Plant
    left outer to one join I_Address      as _Address on _Plant.AddressID = _Address.AddressID
    association[1..*] to I_ProductPlantBasic as _ProductPlantBasic on _ProductPlantBasic.Product = $projection.Product
 
{

  key  _ProductPlant.Product,
  key  _Address.Country as Country,
  _ProductPlantBasic
}
group by
  _ProductPlant.Product,
  _Address.Country
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_PLANT",
"I_PRODUCTPLANTBASIC"
],
"ASSOCIATED":
[
"I_PRODUCTPLANTBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More