C_ProductBasicInfo

DDL: C_PRODUCTBASICINFO SQL: CPRODBASICINFO Type: view CONSUMPTION

Product Basic Info View

C_ProductBasicInfo is a Consumption CDS View that provides data about "Product Basic Info View" in SAP S/4HANA. It reads from 1 data source (I_Product) and exposes 21 fields with key field Product.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_Product Product from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPRODBASICINFO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Basic Info View view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey Product view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Product I_Product Product
ProductDescription
ProductType I_Product ProductType
ProductGroup I_Product ProductGroup
ProductCategory I_Product ProductCategory
BaseUnit I_Product BaseUnit
ProductStandardID I_Product ProductStandardID
InternationalArticleNumberCat
AuthorizationGroup I_Product AuthorizationGroup
ProductImageURL
_ProductType _ProductType
_ProductTypeName _ProductTypeName
_ProductGroup_2 _ProductGroup_2
_ProductGroupText_2 _ProductGroupText_2
_ProductCategory _ProductCategory
_ProductCategoryText _ProductCategoryText
_InternationalArticleNumberCat _InternationalArticleNumberCat
_IntArticleNumberText _IntArticleNumberText
_BaseUnitOfMeasure _BaseUnitOfMeasure
_BaseUnitOfMeasureText _BaseUnitOfMeasureText
_Text _Text 
@AbapCatalog.sqlViewName: 'CPRODBASICINFO'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Product Basic Info View'
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    semanticKey: ['Product'],
    createEnabled:true,
    updateEnabled:true,
    usageType.serviceQuality: #A,
    usageType.sizeCategory : #L,
    usageType.dataClass: #MASTER,
    representativeKey: 'Product'
}
@Metadata.allowExtensions: true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_ProductBasicInfo
  as select from I_Product as Product

{

  key Product.Product,
      _Text[1:Language = $session.system_language].ProductName                                      as ProductDescription,

      Product.ProductType,

      Product.ProductGroup,

      Product.ProductCategory,

      Product.BaseUnit,

      Product.ProductStandardID,

      cast(Product.InternationalArticleNumberCat as internationalarticlenumbercat preserving type ) as InternationalArticleNumberCat,

      Product.AuthorizationGroup,
      @ObjectModel.readOnly: true
      @Semantics.imageUrl: true
      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MD_PRODUCT_IMAGE_CALC_EXIT'
      cast( '' as productimageurl )                                                                 as ProductImageURL,
      _ProductType,
      _ProductTypeName,
      _ProductGroup_2,
      _ProductGroupText_2,
      _ProductCategory,
      _ProductCategoryText,
      _InternationalArticleNumberCat,
      _IntArticleNumberText,
      _BaseUnitOfMeasure,
      _BaseUnitOfMeasureText,
      _Text

}

Learn More