P_SupDmndAllDocPurReqnComp

DDL: P_SUPDMNDALLDOCPURREQNCOMP Type: view COMPOSITE

P_SupDmndAllDocPurReqnComp is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SupDmndAllDocPurReqnComp) and exposes 29 fields.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
I_SupDmndAllDocPurReqnComp _SupDmndAllDocPurReqnComp from

Annotations (9)

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

Fields (29)

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

Learn More