CIC_ProductPlantBasic

DDL: CIC_PRODUCTPLANTBASIC Type: view_entity

Product Plant Basic data for CIC

CIC_ProductPlantBasic is a CDS View that provides data about "Product Plant Basic data for CIC" in SAP S/4HANA. It reads from 1 data source (I_ProductPlantBasic) and exposes 23 fields with key fields Product, Plant. It has 1 association to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductPlantBasic ProdPlant from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MRPMaterialStatusCode _MaterialStatus $projection.ProfileCode = _MaterialStatus.MRPMaterialStatus

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Product Plant Basic data for CIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductPlantBasic Product
KEY Plant I_ProductPlantBasic Plant
IsMarkedForDeletion I_ProductPlantBasic IsMarkedForDeletion
DistrCntrDistributionProfile I_ProductPlantBasic DistrCntrDistributionProfile
GoodsIssueUnit I_ProductPlantBasic GoodsIssueUnit
GoodsReceiptDuration I_ProductPlantBasic GoodsReceiptDuration
GoodIssueProcessingDays I_ProductPlantBasic GoodIssueProcessingDays
MRPType I_ProductPlantBasic MRPType
MRPResponsible
MRPPlant
SourceOfSupplyCategory I_ProductPlantBasic SourceOfSupplyCategory
ABCIndicator I_ProductPlantBasic ABCIndicator
UnitOfMeasureGroup I_ProductPlantBasic ProductUnitGroup
PlantCustomer
PlantCategory
SalesPlant
BaseUnit I_ProductPlantBasic BaseUnit
SafetyStockQuantity I_ProductPlantBasic SafetyStockQuantity
ProfileValidityStartDate I_ProductPlantBasic ProfileValidityStartDate
MinimumSafetyStockQuantity
ProfileCode I_ProductPlantBasic ProfileCode
MinimumLotSizeQuantity I_ProductPlantBasic MinimumLotSizeQuantity
ShiftStatusCode _MaterialStatus ShiftStatusCode 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Product Plant Basic data for CIC'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}

define view entity CIC_ProductPlantBasic
as select from I_ProductPlantBasic as ProdPlant
 association [0..1] to I_MRPMaterialStatusCode as _MaterialStatus on $projection.ProfileCode = _MaterialStatus.MRPMaterialStatus
{
  
   key ProdPlant.Product,
   key ProdPlant.Plant,
   ProdPlant.IsMarkedForDeletion,
   ProdPlant.DistrCntrDistributionProfile,
   ProdPlant.GoodsIssueUnit,
   ProdPlant.GoodsReceiptDuration,
   ProdPlant.GoodIssueProcessingDays,
   ProdPlant.MRPType,
   ProdPlant._MRPController.MRPController as MRPResponsible,
   ProdPlant._MRPController.Plant  as MRPPlant,
   ProdPlant.SourceOfSupplyCategory,
   ProdPlant.ABCIndicator,
   ProdPlant.ProductUnitGroup as UnitOfMeasureGroup,
   ProdPlant._Plant.PlantCustomer,
   ProdPlant._Plant.PlantCategory,
   ProdPlant._PlantSales.LoadingGroup as SalesPlant,
   ProdPlant.BaseUnit,
   @Semantics.quantity.unitOfMeasure: 'BaseUnit'
   ProdPlant.SafetyStockQuantity,
   ProdPlant.ProfileValidityStartDate,
   @Semantics.quantity.unitOfMeasure: 'BaseUnit'
   ProdPlant._MaterialLotSizingProcedure.MinimumSafetyStockQuantity,
   ProdPlant.ProfileCode,
   @Semantics.quantity.unitOfMeasure: 'BaseUnit'
   ProdPlant.MinimumLotSizeQuantity,
   _MaterialStatus.ShiftStatusCode
   
   }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MRPCONTROLLER",
"I_MRPMATERIALSTATUSCODE",
"I_PLANT",
"I_PRODUCTPLANTBASIC",
"I_PRODUCTPLANTSALES",
"I_PRODUCTSUPPLYPLANNING"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More