R_ProdPlantStorageLocationTP_2

DDL: R_PRODPLANTSTORAGELOCATIONTP_2 Type: view_entity TRANSACTIONAL Package: VDM_MD_PRODUCT_BO_V2

Product Plant Storage Location - TP

R_ProdPlantStorageLocationTP_2 is a Transactional CDS View that provides data about "Product Plant Storage Location - TP" in SAP S/4HANA. It reads from 1 data source (I_ProductStorageLocationBasic) and exposes 10 fields with key fields Product, Plant, StorageLocation. It has 2 associations to related views. Part of development package VDM_MD_PRODUCT_BO_V2.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductStorageLocationBasic I_ProductStorageLocationBasic from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_ProductTP_2 _Product $projection.Product = _Product.Product
[1] E_Productstoragelocation _ActiveExtension $projection.Product = _ActiveExtension.Product and $projection.Plant = _ActiveExtension.Plant and $projection.StorageLocation = _ActiveExtension.StorageLocation

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Product Plant Storage Location - TP view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY Plant Plant
KEY StorageLocation StorageLocation
WarehouseStorageBin WarehouseStorageBin
IsMarkedForDeletion IsMarkedForDeletion
LeanWrhsManagementPickingArea LeanWrhsManagementPickingArea
_ProductPlant _ProductPlant
_Product _Product
_StorageLocation _StorageLocation
_ProductDescription_2 _ProductDescription_2 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType:{
      serviceQuality: #A,
      sizeCategory: #XL,
      dataClass: #MASTER
}
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.semanticKey: [ 'Product','Plant' ]
@EndUserText.label: 'Product Plant Storage Location - TP'

define view entity R_ProdPlantStorageLocationTP_2
  as select from I_ProductStorageLocationBasic
  association        to parent R_ProductPlantTP_2  as _ProductPlant  on  $projection.Product = _ProductPlant.Product
                                                                     and $projection.Plant   = _ProductPlant.Plant
  association [1..1] to R_ProductTP_2            as _Product         on  $projection.Product = _Product.Product
  association [1]    to E_Productstoragelocation as _ActiveExtension on  $projection.Product         = _ActiveExtension.Product
                                                                     and $projection.Plant           = _ActiveExtension.Plant
                                                                     and $projection.StorageLocation = _ActiveExtension.StorageLocation
{
      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
  key cast (Product as productnumber preserving type ) as Product,
  key Plant,
  key StorageLocation,
      WarehouseStorageBin,
      IsMarkedForDeletion,
      LeanWrhsManagementPickingArea,
      /* Associations */
      _ProductPlant,
      _Product,
      _StorageLocation,
      _ProductDescription_2
}

Learn More