P_Salesview_Fs

DDL: P_SALESVIEW_FS SQL: PSALESVIEWFS Type: view COMPOSITE

P_Salesview_Fs is a Composite CDS View in SAP S/4HANA. It reads from 8 data sources and exposes 13 fields with key fields Product, ValuationArea, ValuationType.

8 data source(s) 13 fields

Data Sources (8)

SourceAliasJoin Type
I_CompanyCode CCode left_outer
I_MaterialText MaterialText left_outer
P_PlantAddrDetails_Fs PlantData left_outer
I_Product PrdData left_outer
P_Matlpricecntrltext PriceControl left_outer
I_ProductValuation ProdVal from
I_UnitOfMeasureText UnitOfMeasureText left_outer
I_Purreqvaluationarea ValArea left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PSALESVIEWFS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductValuation Product
KEY ValuationArea I_ProductValuation ValuationArea
KEY ValuationType I_ProductValuation ValuationType
MovingAveragePrice I_ProductValuation MovingAveragePrice
PriceUnitQty I_ProductValuation PriceUnitQty
InventoryValuationProcedure I_ProductValuation InventoryValuationProcedure
StandardPrice I_ProductValuation StandardPrice
CompanyCode I_Purreqvaluationarea CompanyCode
Currency I_CompanyCode Currency
Plant P_PlantAddrDetails_Fs Plant
PlantName P_PlantAddrDetails_Fs PlantName
PriceControlText P_Matlpricecntrltext Description
UnitOfMeasureLongName I_UnitOfMeasureText UnitOfMeasureLongName 
@AbapCatalog.sqlViewName: 'PSALESVIEWFS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
//@EndUserText.label: 'Private Factsheet - Sales View'

define view P_Salesview_Fs
  as select from    I_ProductValuation    as ProdVal
    left outer join I_Purreqvaluationarea as ValArea           on ProdVal.ValuationArea = ValArea.ValuationArea
    left outer join I_Product             as PrdData           on ProdVal.Product = PrdData.Product
  //left outer join I_Plant as PlantData on ProdVal.ValuationArea = PlantData.ValuationArea

    left outer join P_PlantAddrDetails_Fs as PlantData         on ProdVal.ValuationArea = PlantData.ValuationArea
    left outer join I_MaterialText        as MaterialText      on  ProdVal.Product       = MaterialText.Material
                                                               and MaterialText.Language = $session.system_language
    left outer join I_CompanyCode         as CCode             on ValArea.CompanyCode = CCode.CompanyCode //and CCode.Language = $session.system_language

    left outer join P_Matlpricecntrltext  as PriceControl      on  ProdVal.InventoryValuationProcedure = PriceControl.Value
                                                               and PriceControl.Language               = $session.system_language //= 'E'

    left outer join I_UnitOfMeasureText   as UnitOfMeasureText on  UnitOfMeasureText.Language      = $session.system_language
                                                               and UnitOfMeasureText.UnitOfMeasure = PrdData.BaseUnit

{
  key ProdVal.Product                         as Product,
  key ProdVal.ValuationArea                   as ValuationArea,
  key ProdVal.ValuationType                   as ValuationType,
      ProdVal.MovingAveragePrice              as MovingAveragePrice,
      ProdVal.PriceUnitQty                    as PriceUnitQty,
      ProdVal.InventoryValuationProcedure     as InventoryValuationProcedure,
      ProdVal.StandardPrice                   as StandardPrice,
      ValArea.CompanyCode                     as CompanyCode,
      //PrdData.BaseUnit as BaseUnit,

      CCode.Currency                          as Currency,
      PlantData.Plant                         as Plant,


      PlantData.PlantName                     as PlantName,
      PriceControl.Description                as PriceControlText,
      UnitOfMeasureText.UnitOfMeasureLongName as UnitOfMeasureLongName

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

Learn More