I_SupDmndAllDocProdnOrd

DDL: I_SUPDMNDALLDOCPRODNORD Type: view COMPOSITE

View for Production Order

I_SupDmndAllDocProdnOrd is a Composite CDS View that provides data about "View for Production Order" in SAP S/4HANA. It reads from 2 data sources (P_ARunAssgmtSup, I_SupDmndAllDocProdnOrdBsc) and exposes 25 fields.

2 data source(s) 25 fields

Data Sources (2)

SourceAliasJoin Type
P_ARunAssgmtSup Assgmt left_outer
I_SupDmndAllDocProdnOrdBsc ProdOrd from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISUPDMNDADPROD view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label View for Production Order view

Fields (25)

KeyFieldSource TableSource FieldDescription
SupplyNumber I_SupDmndAllDocProdnOrdBsc SupplyNumber
SupplyItem I_SupDmndAllDocProdnOrdBsc SupplyItem
MRPArea I_SupDmndAllDocProdnOrdBsc MRPArea
SupplyScheduleLine I_SupDmndAllDocProdnOrdBsc SupplyScheduleLine
AssignedSupplyType I_SupDmndAllDocProdnOrdBsc AssignedSupplyType
SupAssgmtSource I_SupDmndAllDocProdnOrdBsc SupAssgmtSource
SupplyDeliveryDate I_SupDmndAllDocProdnOrdBsc SupplyDeliveryDate
ProductAvailabilityDate I_SupDmndAllDocProdnOrdBsc ProductAvailabilityDate
TotalQuantity I_SupDmndAllDocProdnOrdBsc TotalQuantity
OpenSupplyQuantity
AssignedQuantityInBaseUnit P_ARunAssgmtSup AssignedQuantityInBaseUnit
NormalAssignedQuantityInBsUnt P_ARunAssgmtSup NormalAssignedQuantityInBsUnt
PreviewAssignedQuantityInBsUnt P_ARunAssgmtSup PreviewAssignedQuantityInBsUnt
BaseUnit I_SupDmndAllDocProdnOrdBsc BaseUnit
Material I_SupDmndAllDocProdnOrdBsc Material
MaterialGroup I_SupDmndAllDocProdnOrdBsc MaterialGroup
Plant I_SupDmndAllDocProdnOrdBsc Plant
CrossPlantConfigurableProduct I_SupDmndAllDocProdnOrdBsc CrossPlantConfigurableProduct
OrderType I_SupDmndAllDocProdnOrdBsc OrderType
Batch I_SupDmndAllDocProdnOrdBsc Batch
StorageLocation I_SupDmndAllDocProdnOrdBsc StorageLocation
SalesOrder I_SupDmndAllDocProdnOrdBsc SalesOrder
SalesOrderItem I_SupDmndAllDocProdnOrdBsc SalesOrderItem
StockSegment I_SupDmndAllDocProdnOrdBsc StockSegment
GoodsReceiptDurationInDays I_SupDmndAllDocProdnOrdBsc GoodsReceiptDurationInDays 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISUPDMNDADPROD',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
@EndUserText.label: 'View for Production Order'
define view I_SupDmndAllDocProdnOrd
  as select from    I_SupDmndAllDocProdnOrdBsc as ProdOrd
    left outer join P_ARunAssgmtSup   as Assgmt on  ProdOrd.SupplyNumber       = Assgmt.SupplyNumber
                                                and ProdOrd.SupplyItem         = Assgmt.SupplyItem
    //                                          and ProdOrd.SupplyScheduleLine = Assgmt.SupplyScheduleLine

                                                and ProdOrd.Plant              = Assgmt.Plant
                                                and ProdOrd.Material           = Assgmt.Material
//                                              and ProdOrd.StorageLocation    = Assgmt.StorageLocation

//                                              and ProdOrd.Batch              = Assgmt.Batch

                                                and ProdOrd.AssignedSupplyType = Assgmt.AssignedSupplyType
{
  ProdOrd.SupplyNumber,
  ProdOrd.SupplyItem,
  ProdOrd.MRPArea,
  ProdOrd.SupplyScheduleLine,
  ProdOrd.AssignedSupplyType,
  ProdOrd.SupAssgmtSource,
  ProdOrd.SupplyDeliveryDate,
  ProdOrd.ProductAvailabilityDate,
  ProdOrd.TotalQuantity,
  ( ProdOrd.OpenSupplyQuantity - coalesce( Assgmt.AssignedQuantityInBaseUnit, 0 ) ) as OpenSupplyQuantity,
  Assgmt.AssignedQuantityInBaseUnit,
  Assgmt.NormalAssignedQuantityInBsUnt,
  Assgmt.PreviewAssignedQuantityInBsUnt,
  ProdOrd.BaseUnit,
  ProdOrd.Material,
  ProdOrd.MaterialGroup,
  ProdOrd.Plant,
  ProdOrd.CrossPlantConfigurableProduct,
  ProdOrd.OrderType,
  ProdOrd.Batch,
  ProdOrd.StorageLocation,
  ProdOrd.SalesOrder,
  ProdOrd.SalesOrderItem,
  ProdOrd.StockSegment,
  ProdOrd.GoodsReceiptDurationInDays
}
where
  TotalQuantity > 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPDMNDALLDOCPRODNORDBSC",
"P_ARUNASSGMTSUP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More