I_SupDmndAllDocProdnOrdComp

DDL: I_SUPDMNDALLDOCPRODNORDCOMP Type: view COMPOSITE

View for Production Order Components

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

2 data source(s) 25 fields

Data Sources (2)

SourceAliasJoin Type
P_SUPDMNDSUPASSGMTDMND Assgmt left_outer
I_SupDmndAllDocProdnOrdCompBsc Comp 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 ISUPDMNDADCMP3 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 Components view

Fields (25)

KeyFieldSource TableSource FieldDescription
RequirementDocumentNumber I_SupDmndAllDocProdnOrdCompBsc RequirementDocumentNumber
RequirementDocumentItem I_SupDmndAllDocProdnOrdCompBsc RequirementDocumentItem
RequirementType I_SupDmndAllDocProdnOrdCompBsc RequirementType
RequestedDate I_SupDmndAllDocProdnOrdCompBsc RequestedDate
ProductAvailabilityDate I_SupDmndAllDocProdnOrdCompBsc ProductAvailabilityDate
RequestedRqmtQtyInBaseUnit I_SupDmndAllDocProdnOrdCompBsc RequestedRqmtQtyInBaseUnit
ConfirmedRqmtQtyInBaseUnit I_SupDmndAllDocProdnOrdCompBsc ConfirmedRqmtQtyInBaseUnit
DeliveredQuantityInBaseUnit I_SupDmndAllDocProdnOrdCompBsc DeliveredQuantityInBaseUnit
AssignedQuantityInBaseUnit P_SUPDMNDSUPASSGMTDMND AssignedQuantityInBaseUnit
NormalAssignedQuantityInBsUnt P_SUPDMNDSUPASSGMTDMND NormalAssignedQuantityInBsUnt
PreviewAssignedQuantityInBsUnt P_SUPDMNDSUPASSGMTDMND PreviewAssignedQuantityInBsUnt
BaseUnit I_SupDmndAllDocProdnOrdCompBsc BaseUnit
Material I_SupDmndAllDocProdnOrdCompBsc Material
MaterialGroup I_SupDmndAllDocProdnOrdCompBsc MaterialGroup
Plant I_SupDmndAllDocProdnOrdCompBsc Plant
OrderType I_SupDmndAllDocProdnOrdCompBsc OrderType
CrossPlantConfigurableProduct I_SupDmndAllDocProdnOrdCompBsc CrossPlantConfigurableProduct
StorageLocation I_SupDmndAllDocProdnOrdCompBsc StorageLocation
SalesOrder I_SupDmndAllDocProdnOrdCompBsc SalesOrder
SalesOrderItem I_SupDmndAllDocProdnOrdCompBsc SalesOrderItem
RequirementSegment I_SupDmndAllDocProdnOrdCompBsc RequirementSegment
SegmentationStrategy I_SupDmndAllDocProdnOrdCompBsc SegmentationStrategy
SegmentationStrategyScope I_SupDmndAllDocProdnOrdCompBsc SegmentationStrategyScope
Division I_SupDmndAllDocProdnOrdCompBsc Division
IsInternalBatchManaged I_SupDmndAllDocProdnOrdCompBsc IsInternalBatchManaged 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISUPDMNDADCMP3',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
@EndUserText.label: 'View for Production Order Components'
define view I_SupDmndAllDocProdnOrdComp
  as select from    I_SupDmndAllDocProdnOrdCompBsc as Comp
    left outer join P_SUPDMNDSUPASSGMTDMND         as Assgmt on Comp.RequirementDocumentNumber = Assgmt.RequirementDocumentNumber
                                                            and Comp.RequirementDocumentItem   = Assgmt.RequirementDocumentItem
                                                            and Comp.RequestedDate             = Assgmt.RequestedDate
                                                            and Comp.ProductAvailabilityDate   = Assgmt.ProductAvailabilityDate
                                                            and Comp.RequirementType           = Assgmt.RequirementType
{
  Comp.RequirementDocumentNumber,
  Comp.RequirementDocumentItem,
  Comp.RequirementType,
  Comp.RequestedDate,
  Comp.ProductAvailabilityDate,
  Comp.RequestedRqmtQtyInBaseUnit,
  Comp.ConfirmedRqmtQtyInBaseUnit,
  Comp.DeliveredQuantityInBaseUnit,
  (   Comp.OpenQuantity
    - coalesce( Comp.DeliveredQuantityInBaseUnit, 0 )
    - coalesce( Assgmt.AssignedQuantityInBaseUnit, 0 )
  ) as OpenDemandQuantity,
  Assgmt.AssignedQuantityInBaseUnit,
  Assgmt.NormalAssignedQuantityInBsUnt,
  Assgmt.PreviewAssignedQuantityInBsUnt,
  Comp.BaseUnit,
  Comp.Material,
  Comp.MaterialGroup,
  Comp.Plant,
  Comp.OrderType,
  Comp.CrossPlantConfigurableProduct,
  Comp.StorageLocation,
  Comp.SalesOrder,
  Comp.SalesOrderItem,
  Comp.RequirementSegment,
  Comp.SegmentationStrategy,
  Comp.SegmentationStrategyScope,
  Comp.Division,
  Comp.IsInternalBatchManaged
}
where
  RequestedRqmtQtyInBaseUnit > 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPDMNDALLDOCPRODNORDCOMPBSC",
"P_SUPDMNDSUPASSGMTDMND"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More