I_RO_SAFTProductValuation

DDL: I_RO_SAFTPRODUCTVALUATION SQL: IROSAFTPRDVAL Type: view BASIC Package: GLO_LOG_SAFT_RO

RO SAFT Product Valuation

I_RO_SAFTProductValuation is a Basic CDS View that provides data about "RO SAFT Product Valuation" in SAP S/4HANA. It reads from 1 data source (v_mbew_md) and exposes 9 fields with key fields Product, ValuationArea, ValuationType. It has 1 association to related views. Part of development package GLO_LOG_SAFT_RO.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
v_mbew_md Valuation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IROSAFTPRDVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
EndUserText.label RO SAFT Product Valuation view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY ValuationArea v_mbew_md bwkey
KEY ValuationType v_mbew_md bwtar
IsMarkedForDeletion v_mbew_md lvorm
InventoryValuationProcedure
IsLIFOAndFIFORelevant
LIFOValuationPoolNumber v_mbew_md mypol
ValuationClass v_mbew_md bklas
_Product _Product 
@AbapCatalog.sqlViewName: 'IROSAFTPRDVAL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel:{
    usageType.serviceQuality: #C,
    usageType.sizeCategory : #XL,
    usageType.dataClass: #MASTER
}
@VDM.viewType: #BASIC
@EndUserText.label: 'RO SAFT Product Valuation'
// Scope of this view is V_MBEW _MD no fields from redirect views should be added


define view I_RO_SAFTProductValuation as select from v_mbew_md as Valuation
association [1..1] to I_Product as _Product on $projection.Product = _Product.Product {
  key cast ( Valuation.matnr as productnumber preserving type )              as Product,
  key Valuation.bwkey                                                        as ValuationArea,
  key Valuation.bwtar                                                        as ValuationType,
      Valuation.lvorm                                                        as IsMarkedForDeletion,
      cast (Valuation.vprsv as inventoryvaluationprocedure preserving type ) as InventoryValuationProcedure,
      cast (Valuation.xlifo  as boole_d preserving type)                     as IsLIFOAndFIFORelevant,
      Valuation.mypol                                                        as LIFOValuationPoolNumber,
      Valuation.bklas                                                        as ValuationClass,

      _Product
}

Learn More