I_SUPDMNDALLDOCPLNDORDCOMP

CDS View

View for Planned Order Components

I_SUPDMNDALLDOCPLNDORDCOMP is a CDS View in S/4HANA. View for Planned Order Components. It contains 27 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 27 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SupDmndAllDocDemand view union_all COMPOSITE View for Demand of All Documents
I_SupDmndAllDocPlndOrdComp1C view left_outer COMPOSITE Cube View for Planned Order Components Assignment Details
I_SupDmndAllDocPlndOrdCompC view from COMPOSITE Cube View for Planned Order Components
P_SupDmndAllDocPlndOrdComp view from COMPOSITE

Fields (27)

KeyField CDS FieldsUsed in Views
KEY ProductAvailabilityDate ProductAvailabilityDate 3
KEY RequestedDate RequestedDate 3
KEY RequirementDocumentItem RequirementDocumentItem 3
KEY RequirementDocumentNumber RequirementDocumentNumber 3
KEY RequirementType RequirementType 3
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit 1
BaseUnit BaseUnit 3
ConfirmedRqmtQtyInBaseUnit ConfirmedRqmtQtyInBaseUnit 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 3
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit 1
Material Material 3
MaterialGroup MaterialGroup 3
MaterialType MaterialType 1
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt 1
OpenQuantity OpenQuantity 1
OrderType OrderType 1
Plant Plant 3
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt 1
RequestedDeliveryDate RequestedDeliveryDate 2
RequestedRqmtQtyInBaseUnit RequestedRqmtQtyInBaseUnit 1
RequirementSegment RequirementSegment 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
SegmentationStrategy SegmentationStrategy 1
SegmentationStrategyScope SegmentationStrategyScope 1
StorageLocation StorageLocation 3
WithdrawnQuantity WithdrawnQuantity 1 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISUPDMNDADCMP4',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
@EndUserText.label: 'View for Planned Order Components'
define view I_SupDmndAllDocPlndOrdComp
  as select from resb                   as resb
    inner join   I_SupDmndMaterialPlant as marc on  resb.matnr = marc.Material
                                                and resb.werks = marc.Plant
    inner join   plaf                   as plaf on resb.plnum = plaf.plnum
{
  resb.rsnum              as RequirementDocumentNumber,
  lpad(resb.rspos,6,'0')  as RequirementDocumentItem,
  //  'SB'                                              as RequirementType,

  //  resb.rsart                                        as RecordType,

  resb.bdart              as RequirementType,
  resb.bdter              as RequestedDate,
  resb.bdter              as ProductAvailabilityDate,
  resb.bdter              as RequestedDeliveryDate,
  resb.bdmng              as RequestedRqmtQtyInBaseUnit, //OrderedQuantity

  resb.bdmng              as ConfirmedRqmtQtyInBaseUnit,
  0                       as DeliveredQuantityInBaseUnit,
  resb.bdmng - resb.enmng as OpenDemandQuantity,
  0                       as AssignedQuantityInBaseUnit,
  0                       as NormalAssignedQuantityInBsUnt,
  0                       as PreviewAssignedQuantityInBsUnt,
  resb.enmng              as WithdrawnQuantity, //RequestedRqmtQtyInBaseUnit

  resb.bdmng - resb.enmng as OpenQuantity,
  resb.meins              as BaseUnit,
  resb.matnr              as Material,
  marc.MaterialGroup,
  resb.werks              as Plant,
  resb.bdart              as OrderType,
  marc.CrossPlantConfigurableProduct,
  marc.MaterialType,
  resb.sgt_rcat           as RequirementSegment,
  resb.lgort              as StorageLocation,
  resb.kdauf              as SalesOrder,
  resb.kdpos              as SalesOrderItem,
  marc.SegmentationStrategy,
  marc.SegmentationStrategyScope,
  resb.rspos              as ReservationItem,
  marc.Division           as Division,
  marc.IsInternalBatchManaged
}
where
      resb.xloek =  '' -- deleted item should not be selected
  and resb.kzkup =  '' -- coproduct should not be selected
  and resb.kzear =  '' -- final issue for this reservation
  and resb.plnum <> '' -- Planned Order Component
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPDMNDMATERIALPLANT",
"PLAF",
"RESB"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More