P_SupDmndAllDocPlndOrdComp

DDL: P_SUPDMNDALLDOCPLNDORDCOMP Type: view COMPOSITE

P_SupDmndAllDocPlndOrdComp is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SupDmndAllDocPlndOrdComp) and exposes 27 fields.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_SupDmndAllDocPlndOrdComp _SupDmndAllDocPlndPrdComp from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSUPDMNDADCMP4 view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view

Fields (27)

KeyFieldSource TableSource FieldDescription
RequirementDocumentNumber I_SupDmndAllDocPlndOrdComp RequirementDocumentNumber
RequirementDocumentItem I_SupDmndAllDocPlndOrdComp RequirementDocumentItem
RequirementType I_SupDmndAllDocPlndOrdComp RequirementType
RequestedDate I_SupDmndAllDocPlndOrdComp RequestedDate
ProductAvailabilityDate I_SupDmndAllDocPlndOrdComp ProductAvailabilityDate
RequestedRqmtQtyInBaseUnit I_SupDmndAllDocPlndOrdComp RequestedRqmtQtyInBaseUnit
ConfirmedRqmtQtyInBaseUnit I_SupDmndAllDocPlndOrdComp ConfirmedRqmtQtyInBaseUnit
DeliveredQuantityInBaseUnit I_SupDmndAllDocPlndOrdComp DeliveredQuantityInBaseUnit
OpenDemandQuantity
AssignedQuantityInBaseUnit I_SupDmndAllDocPlndOrdComp AssignedQuantityInBaseUnit
NormalAssignedQuantityInBsUnt I_SupDmndAllDocPlndOrdComp NormalAssignedQuantityInBsUnt
PreviewAssignedQuantityInBsUnt I_SupDmndAllDocPlndOrdComp PreviewAssignedQuantityInBsUnt
WithdrawnQuantity I_SupDmndAllDocPlndOrdComp WithdrawnQuantity
OpenQuantity I_SupDmndAllDocPlndOrdComp OpenQuantity
BaseUnit I_SupDmndAllDocPlndOrdComp BaseUnit
Material I_SupDmndAllDocPlndOrdComp Material
MaterialGroup I_SupDmndAllDocPlndOrdComp MaterialGroup
Plant I_SupDmndAllDocPlndOrdComp Plant
OrderType I_SupDmndAllDocPlndOrdComp OrderType
CrossPlantConfigurableProduct I_SupDmndAllDocPlndOrdComp CrossPlantConfigurableProduct
MaterialType I_SupDmndAllDocPlndOrdComp MaterialType
RequirementSegment I_SupDmndAllDocPlndOrdComp RequirementSegment
StorageLocation I_SupDmndAllDocPlndOrdComp StorageLocation
SalesOrder I_SupDmndAllDocPlndOrdComp SalesOrder
SalesOrderItem I_SupDmndAllDocPlndOrdComp SalesOrderItem
SegmentationStrategy I_SupDmndAllDocPlndOrdComp SegmentationStrategy
SegmentationStrategyScope I_SupDmndAllDocPlndOrdComp SegmentationStrategyScope 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE
}
@VDM.private: true
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'PSUPDMNDADCMP4',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XXL
   }
}
define view P_SupDmndAllDocPlndOrdComp
  as select from           I_SupDmndAllDocPlndOrdComp as _SupDmndAllDocPlndPrdComp
    left outer to one join P_ARunAssgmtDmnd           as _ARunAssgmtDmnd on  _SupDmndAllDocPlndPrdComp.RequirementDocumentNumber = _ARunAssgmtDmnd.RequirementDocumentNumber
                                                                         and _SupDmndAllDocPlndPrdComp.RequirementDocumentItem   = _ARunAssgmtDmnd.RequirementDocumentItem
                                                                         and _SupDmndAllDocPlndPrdComp.RequestedDate             = _ARunAssgmtDmnd.RequestedDate
                                                                         and _SupDmndAllDocPlndPrdComp.ProductAvailabilityDate   = _ARunAssgmtDmnd.ProductAvailabilityDate
                                                                         and _SupDmndAllDocPlndPrdComp.RequirementType           = _ARunAssgmtDmnd.RequirementType
{
  _SupDmndAllDocPlndPrdComp.RequirementDocumentNumber,
  _SupDmndAllDocPlndPrdComp.RequirementDocumentItem,
  _SupDmndAllDocPlndPrdComp.RequirementType,
  _SupDmndAllDocPlndPrdComp.RequestedDate,
  _SupDmndAllDocPlndPrdComp.ProductAvailabilityDate,
  _SupDmndAllDocPlndPrdComp.RequestedRqmtQtyInBaseUnit,
  _SupDmndAllDocPlndPrdComp.ConfirmedRqmtQtyInBaseUnit,
  _SupDmndAllDocPlndPrdComp.DeliveredQuantityInBaseUnit,
  ( _SupDmndAllDocPlndPrdComp.OpenDemandQuantity - coalesce( _ARunAssgmtDmnd.AssignedQuantityInBaseUnit , 0 ) ) as OpenDemandQuantity,
  _SupDmndAllDocPlndPrdComp.AssignedQuantityInBaseUnit,
  _SupDmndAllDocPlndPrdComp.NormalAssignedQuantityInBsUnt,
  _SupDmndAllDocPlndPrdComp.PreviewAssignedQuantityInBsUnt,
  _SupDmndAllDocPlndPrdComp.WithdrawnQuantity,
  _SupDmndAllDocPlndPrdComp.OpenQuantity,
  _SupDmndAllDocPlndPrdComp.BaseUnit,
  _SupDmndAllDocPlndPrdComp.Material,
  _SupDmndAllDocPlndPrdComp.MaterialGroup,
  _SupDmndAllDocPlndPrdComp.Plant,
  _SupDmndAllDocPlndPrdComp.OrderType,
  _SupDmndAllDocPlndPrdComp.CrossPlantConfigurableProduct,
  _SupDmndAllDocPlndPrdComp.MaterialType,
  _SupDmndAllDocPlndPrdComp.RequirementSegment,
  _SupDmndAllDocPlndPrdComp.StorageLocation,
  _SupDmndAllDocPlndPrdComp.SalesOrder,
  _SupDmndAllDocPlndPrdComp.SalesOrderItem,
  _SupDmndAllDocPlndPrdComp.SegmentationStrategy,
  _SupDmndAllDocPlndPrdComp.SegmentationStrategyScope
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPDMNDALLDOCPLNDORDCOMP",
"P_ARUNASSGMTDMND"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More