A_ClfnProdSupPlng

DDL: A_CLFNPRODSUPPLNG SQL: ACLFMPRODSUPPLNG Type: view COMPOSITE

Supply Planning Data

A_ClfnProdSupPlng is a Composite CDS View that provides data about "Supply Planning Data" in SAP S/4HANA. It reads from 1 data source (I_ProductSupplyPlanning) and exposes 27 fields with key fields Product, Plant. It has 1 association to related views.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductSupplyPlanning I_ProductSupplyPlanning from

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ACLFMPRODSUPPLNG view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supply Planning Data view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entitySet.name A_ProductSupplyPlanning view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Product Product
KEY Plant Plant
FixedLotSizeQuantity FixedLotSizeQuantity
MaximumLotSizeQuantity MaximumLotSizeQuantity
MinimumLotSizeQuantity MinimumLotSizeQuantity
LotSizeRoundingQuantity LotSizeRoundingQuantity
LotSizingProcedure LotSizingProcedure
MRPType MRPType
MRPResponsible MRPResponsible
SafetyStockQuantity SafetyStockQuantity
MinimumSafetyStockQuantity MinimumSafetyStockQuantity
PlanningTimeFence PlanningTimeFence
ABCIndicator ABCIndicator
MaximumStockQuantity MaximumStockQuantity
ReorderThresholdQuantity ReorderThresholdQuantity
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays
SafetyDuration SafetyDuration
PlanningStrategyGroup PlanningStrategyGroup
TotalReplenishmentLeadTime TotalReplenishmentLeadTime
ProcurementType ProcurementType
ProcurementSubType ProcurementSubType
AssemblyScrapPercent AssemblyScrapPercent
AvailabilityCheckType AvailabilityCheckType
GoodsReceiptDuration GoodsReceiptDuration
MRPGroup MRPGroup
BaseUnit BaseUnit
_Product _Product 
@AbapCatalog.sqlViewName: 'ACLFMPRODSUPPLNG'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Supply Planning Data'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

@OData.entitySet.name : 'A_ProductSupplyPlanning'

define view A_ClfnProdSupPlng
  as select from I_ProductSupplyPlanning

  association [1..1] to A_Product as _Product on $projection.Product = _Product.Product


  //association [0..1] to E_Productplant   as _ProdSupplyPlngExt on  $projection.Product = _ProdSupplyPlngExt.Product

  //                                                             and $projection.Plant   = _ProdSupplyPlngExt.Plant


{

  key Product,
  key Plant,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      FixedLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      MaximumLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      MinimumLotSizeQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      LotSizeRoundingQuantity,
      LotSizingProcedure,
      MRPType,
      MRPResponsible,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      SafetyStockQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      MinimumSafetyStockQuantity,
      PlanningTimeFence,
      ABCIndicator,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      MaximumStockQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      ReorderThresholdQuantity,
      PlannedDeliveryDurationInDays,
      SafetyDuration,
      PlanningStrategyGroup,
      TotalReplenishmentLeadTime,
      ProcurementType,
      ProcurementSubType,
      AssemblyScrapPercent,
      AvailabilityCheckType,
      GoodsReceiptDuration,
      MRPGroup,
      @Semantics.unitOfMeasure: true
      BaseUnit,
      _Product
      //Retail fields -- will be made available in later releases


      // PlanAndOrderDayDetermination,

      // RoundingProfile,

      // DfltStorageLocationExtProcmt


      //   @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]

      // _Product,

      // @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]

      // _Plant



}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCTSUPPLYPLANNING"
],
"ASSOCIATED":
[
"A_PRODUCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More