I_SupDmndAllDocSupProt

DDL: I_SUPDMNDALLDOCSUPPROT Type: view COMPOSITE

Supply Protection relevant for Supply Assignment

I_SupDmndAllDocSupProt is a Composite CDS View that provides data about "Supply Protection relevant for Supply Assignment" in SAP S/4HANA. It reads from 1 data source (I_ARunSupplyProtection) and exposes 28 fields.

Data Sources (1)

SourceAliasJoin Type
I_ARunSupplyProtection SUP from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName ISUPDMNDADSPT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label Supply Protection relevant for Supply Assignment view

Fields (28)

KeyFieldSource TableSource FieldDescription
RequirementDocumentNumber
RequirementDocumentItem
SupProtTimeBucketUUID I_ARunSupplyProtection SupProtTimeBucketUUID
RequestedDate I_ARunSupplyProtection StartDate
ProductAvailabilityDate I_ARunSupplyProtection ProductAvailabilityDate
RequestedDeliveryDate I_ARunSupplyProtection RequestedDeliveryDate
EndDate I_ARunSupplyProtection EndDate
RequirementType I_ARunSupplyProtection RequirementType
RequestedRqmtQtyInBaseUnit SupProtProtectedQuantity
ConfirmedRqmtQtyInBaseUnit SupProtProtectedQuantity
DeliveredQuantityInBaseUnit SupProtConsumedQuantity
OpenDemandQuantity ARunSupProtUnconsumedQty
BaseUnit BaseUnit
AssignedQuantityInBaseUnit 0
NormalAssignedQuantityInBsUnt 0
PreviewAssignedQuantityInBsUnt 0
Material I_ARunSupplyProtection Material
Plant I_ARunSupplyProtection Plant
SupplyProtectionName I_ARunSupplyProtection SupplyProtectionName
SupProtLifecycleStatus I_ARunSupplyProtection SupProtLifecycleStatus
SupProtGroupPriorityValue I_ARunSupplyProtection SupProtGroupPriorityValue
MaterialGroup I_ARunSupplyProtection MaterialGroup
CrossPlantConfigurableProduct I_ARunSupplyProtection CrossPlantConfigurableProduct
SegmentationStrategy I_ARunSupplyProtection SegmentationStrategy
SegmentationStrategyScope I_ARunSupplyProtection SegmentationStrategyScope
RequirementSegment I_ARunSupplyProtection RequirementSegment
Division I_ARunSupplyProtection Division
IsInternalBatchManaged I_ARunSupplyProtection IsInternalBatchManaged
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #NOT_REQUIRED
}
@AbapCatalog: {
  sqlViewName: 'ISUPDMNDADSPT',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
@EndUserText.label: 'Supply Protection relevant for Supply Assignment'
define view I_SupDmndAllDocSupProt
  as select from I_ARunSupplyProtection as SUP
{
  cast( '' as vbeln_va )      as RequirementDocumentNumber,
  cast( '000000' as posnr )   as RequirementDocumentItem,
  SUP.SupProtTimeBucketUUID,
  SUP.StartDate               as RequestedDate,
  SUP.ProductAvailabilityDate as ProductAvailabilityDate,
  SUP.RequestedDeliveryDate   as RequestedDeliveryDate,
  SUP.EndDate,
  SUP.RequirementType,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  SupProtProtectedQuantity    as RequestedRqmtQtyInBaseUnit,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  SupProtProtectedQuantity    as ConfirmedRqmtQtyInBaseUnit,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  SupProtConsumedQuantity     as DeliveredQuantityInBaseUnit,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  ARunSupProtUnconsumedQty    as OpenDemandQuantity,
  @Semantics.unitOfMeasure: true
  BaseUnit,
  0                           as AssignedQuantityInBaseUnit,
  0                           as NormalAssignedQuantityInBsUnt,
  0                           as PreviewAssignedQuantityInBsUnt,
  SUP.Material,
  SUP.Plant,
  SUP.SupplyProtectionName,
  SUP.SupProtLifecycleStatus,
  SUP.SupProtGroupPriorityValue,
  SUP.MaterialGroup,
  SUP.CrossPlantConfigurableProduct,
  SUP.SegmentationStrategy,
  SUP.SegmentationStrategyScope,
  SUP.RequirementSegment,
  SUP.Division,
  SUP.IsInternalBatchManaged
}
where
  ARunSupProtUnconsumedQty > 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ARUNSUPPLYPROTECTION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/