A_ProductPlantStorage

DDL: A_PRODUCTPLANTSTORAGE SQL: APRODPLANTSTORG Type: view COMPOSITE Package: VDM_MD_PRODUCT_API_V1

Storage Data at Plant Level

A_ProductPlantStorage is a Composite CDS View that provides data about "Storage Data at Plant Level" in SAP S/4HANA. It reads from 1 data source (I_Productplantstorage) and exposes 8 fields with key fields Product, Plant. It has 1 association to related views. Part of development package VDM_MD_PRODUCT_API_V1.

Data Sources (1)

SourceAliasJoin Type
I_Productplantstorage I_Productplantstorage from

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName APRODPLANTSTORG view
AbapCatalog.compiler.compareFilter true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Storage Data at Plant Level view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Product Product
KEY Plant Plant
InventoryForCycleCountInd InventoryForCycleCountInd
ProvisioningServiceLevel ProvisioningServiceLevel
CycleCountingIndicatorIsFixed CycleCountingIndicatorIsFixed
ProdMaximumStoragePeriodUnit ProdMaximumStoragePeriodUnit
WrhsMgmtPtwyAndStkRemovalStrgy WrhsMgmtPtwyAndStkRemovalStrgy
_Product _Product
@AbapCatalog.sqlViewName: 'APRODPLANTSTORG'
@AbapCatalog.compiler.compareFilter: true
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Storage Data at Plant Level'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
//@ObjectModel.deleteEnabled:true

define view A_ProductPlantStorage
  as select from I_Productplantstorage
  association [1..1] to A_Product as _Product on $projection.Product = _Product.Product
{
      //I_Productplantstorage

  key Product,
  key Plant,
      InventoryForCycleCountInd,
      /// MaximumStoragePeriod,  not in C view

      // ProvisioningServiceLevel,    removing as it has no functional usage and not visible in Product Master App

      //New fields added as part of 2005 release

      ProvisioningServiceLevel,
      CycleCountingIndicatorIsFixed,
      ProdMaximumStoragePeriodUnit,
      @ObjectModel.sapObjectNodeTypeReference:'ProdWrhsMgmtRotationDateType'
      WrhsMgmtPtwyAndStkRemovalStrgy,
      _Product
      // IsActiveEntity

}