I_SUPDMNDALLDOCPRODNORDCOMPBSC

CDS View

Basic View for Production Order Components

I_SUPDMNDALLDOCPRODNORDCOMPBSC is a CDS View in S/4HANA. Basic View for Production Order Components. It contains 23 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 23 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SupDmndAllDocDemand view union_all COMPOSITE View for Demand of All Documents
I_SupDmndAllDocProdnOrdComp view from COMPOSITE View for Production Order Components
I_SupDmndAllDocProdnOrdComp1C view left_outer COMPOSITE Cube View for Production Order Components Assignment Details
I_SupDmndAllDocProdnOrdCompC view from COMPOSITE Cube View for Production Order Components

Fields (23)

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
BaseUnit BaseUnit 3
ConfirmedRqmtQtyInBaseUnit ConfirmedRqmtQtyInBaseUnit 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 3
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit 1
Division Division 1
IsInternalBatchManaged IsInternalBatchManaged 1
Material Material 3
MaterialGroup MaterialGroup 3
OrderType OrderType 1
Plant Plant 3
RequestedDeliveryDate RequestedDeliveryDate 2
RequestedRqmtQtyInBaseUnit RequestedRqmtQtyInBaseUnit 1
RequirementSegment RequirementSegment 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
SegmentationStrategy SegmentationStrategy 1
SegmentationStrategyScope SegmentationStrategyScope 1
StorageLocation StorageLocation 3 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISUPDMNDADCMP3B',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
@EndUserText.label: 'Basic View for Production Order Components'
define view I_SupDmndAllDocProdnOrdCompBsc
  as select from resb                   as resb
    inner join   I_SupDmndMaterialPlant as marc on  resb.matnr = marc.Material
                                                and resb.werks = marc.Plant
    inner join   afpo                   as afpo on resb.aufnr = afpo.aufnr
{
  resb.rsnum              as RequirementDocumentNumber,
  lpad(resb.rspos,6,'0')  as RequirementDocumentItem,
  //  'AR'                                              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.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,
  marc.ProdAvailabilityCheckGroup,
  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.aufnr <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPDMNDMATERIALPLANT",
"AFPO",
"RESB"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More