P_Product_Fs

DDL: P_PRODUCT_FS SQL: PPRODUCTFS Type: view BASIC Package: VDM_MD_PRODUCT_OBSOLETE

Private Factsheet - Product

P_Product_Fs is a Basic CDS View that provides data about "Private Factsheet - Product" in SAP S/4HANA. It reads from 5 data sources (I_Product, I_MaterialGroupText, I_MaterialText, I_MaterialTypeText, I_UnitOfMeasureText) and exposes 15 fields with key field Product. Part of development package VDM_MD_PRODUCT_OBSOLETE.

5 data source(s) 15 fields

Data Sources (5)

SourceAliasJoin Type
I_Product Material from
I_MaterialGroupText MaterialGroupText left_outer
I_MaterialText MaterialText left_outer
I_MaterialTypeText MaterialTypeText left_outer
I_UnitOfMeasureText UnitOfMeasureText left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PPRODUCTFS view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Product I_Product Product
MaterialName I_MaterialText MaterialName
MaterialGroupName I_MaterialGroupText MaterialGroupName
MaterialTypeName I_MaterialTypeText MaterialTypeName
ProductType I_Product ProductType
CreatedByUser I_Product CreatedByUser
GrossWeight I_Product GrossWeight
PurchaseOrderQuantityUnit I_Product PurchaseOrderQuantityUnit
WeightUnit I_Product WeightUnit
CompetitorID I_Product CompetitorID
ProductGroup I_Product ProductGroup
BaseUnit I_Product BaseUnit
Division I_Product Division
AuthorizationGroup I_Product AuthorizationGroup
UnitOfMeasureLongName I_UnitOfMeasureText UnitOfMeasureLongName 
//10.12.2015 11:18 am

@AbapCatalog.sqlViewName: 'PPRODUCTFS'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@VDM.private: true
define view P_Product_Fs
  as select from    I_Product           as Material
    left outer join I_MaterialText      as MaterialText      on  MaterialText.Material = Material.Product
                                                             and MaterialText.Language = $session.system_language
    left outer join I_MaterialGroupText as MaterialGroupText on  MaterialGroupText.MaterialGroup = Material.ProductGroup
                                                             and MaterialGroupText.Language      = $session.system_language
    left outer join I_MaterialTypeText  as MaterialTypeText  on  MaterialTypeText.MaterialType = Material.ProductType
                                                             and MaterialTypeText.Language     = $session.system_language
    left outer join I_UnitOfMeasureText as UnitOfMeasureText on  UnitOfMeasureText.Language      = $session.system_language
                                                             and UnitOfMeasureText.UnitOfMeasure = Material.PurchaseOrderQuantityUnit

{

  key Material.Product,
      MaterialText.MaterialName,
      MaterialGroupText.MaterialGroupName,
      MaterialTypeText.MaterialTypeName,
      Material.ProductType,
      Material.CreatedByUser,
      Material.GrossWeight,
      Material.PurchaseOrderQuantityUnit,
      Material.WeightUnit,
      Material.CompetitorID,
      Material.ProductGroup,
      Material.BaseUnit,
      Material.Division,
      Material.AuthorizationGroup,
      UnitOfMeasureText.UnitOfMeasureLongName as UnitOfMeasureLongName

} // where MaterialText.Language = $session.system_language

Learn More