I_ProdReplnmtRecipient

DDL: I_PRODREPLNMTRECIPIENT SQL: IPRODRPLRCPNT Type: view BASIC

Basic View - Product Replnmt Recipient

I_ProdReplnmtRecipient is a Basic CDS View that provides data about "Basic View - Product Replnmt Recipient" in SAP S/4HANA. It reads from 2 data sources (t001w, wrpl) and exposes 9 fields with key fields Product, Plant. It has 1 association to related views.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
t001w t001w inner
wrpl wrpl from

Associations (1)

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

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPRODRPLRCPNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Basic View - Product Replnmt Recipient view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Product matnr
KEY Plant werks
ProdReplnmtStkRecipient wrpl kunnr
ProdReplnmtTgtStkQuantity sobst
ProdReplnmtTgtCvrgDurnInDays trcov
ProdReplnmtMinTgtStockQuantity prwug
ProdReplnmtMaxTgtStockQuantity prwog
BaseUnit _Product BaseUnit
_Product _Product 
@AbapCatalog.sqlViewName: 'IPRODRPLRCPNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Basic View - Product Replnmt Recipient'
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ProdReplnmtRecipient
  as select from wrpl
    inner join   t001w on wrpl.kunnr = t001w.kunnr
  association [1..1] to I_Product as _Product on $projection.Product = _Product.Product
{
  key matnr             as Product,
  key werks             as Plant,
      wrpl.kunnr        as ProdReplnmtStkRecipient,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      sobst             as ProdReplnmtTgtStkQuantity,
      trcov             as ProdReplnmtTgtCvrgDurnInDays,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      prwug             as ProdReplnmtMinTgtStockQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      prwog             as ProdReplnmtMaxTgtStockQuantity,
      @Semantics.unitOfMeasure: true
      _Product.BaseUnit as BaseUnit,
      _Product
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCT",
"T001W",
"WRPL"
],
"ASSOCIATED":
[
"I_PRODUCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More