I_SUPDMNDALLDOCPURREQNCOMP

CDS View

View for Sub Contracting Purchase Requisition Components

I_SUPDMNDALLDOCPURREQNCOMP is a CDS View in S/4HANA. View for Sub Contracting Purchase Requisition Components. It contains 28 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 28 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_SupDmndAllDocDemand view union_all COMPOSITE View for Demand of All Documents
I_SupDmndAllDocPurReqnComp1C view inner COMPOSITE Cube View for Sub Contracting PR Components Assignments
I_SupDmndAllDocPurReqnCompC view from COMPOSITE Cube View for Sub Contracting Purchase Requisition Component
P_SupDmndAllDocPurReqnComp view from COMPOSITE

Fields (28)

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
CompanyCode CompanyCode 1
ConfirmedRqmtQtyInBaseUnit ConfirmedRqmtQtyInBaseUnit 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 3
Customer Customer 1
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit 1
Material Material 3
MaterialGroup MaterialGroup 3
MaterialType MaterialType 1
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt 1
OrderType OrderType 1
Plant Plant 3
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt 1
RequestedDeliveryDate RequestedDeliveryDate 3
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: 'ISUPDMNDADCMP2',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
@EndUserText.label: 'View for Sub Contracting Purchase Requisition Components'
define view I_SupDmndAllDocPurReqnComp
  as select from    resb                   as resb
    inner join      I_SupDmndMaterialPlant as marc on  resb.matnr = marc.Material
                                                   and resb.werks = marc.Plant
    inner join      eban                   as eban on  resb.banfn = eban.banfn
                                                   and resb.bnfpo = eban.bnfpo
    left outer join lfa1                   as lfa1 on resb.lifnr = lfa1.lifnr
{
  resb.rsnum                 as RequirementDocumentNumber,
  lpad(resb.rspos,6,'0')     as RequirementDocumentItem,
  'RB'                       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,
  'RB'                       as OrderType,
  marc.CrossPlantConfigurableProduct,
  marc.MaterialType,
  resb.sgt_rcat              as RequirementSegment,
  resb.lgort                 as StorageLocation,
  eban.kunnr                 as Customer,
  eban.extcompanycodeforpurg as CompanyCode,
  resb.kdauf                 as SalesOrder,
  resb.kdpos                 as SalesOrderItem,
  marc.SegmentationStrategy,
  marc.SegmentationStrategyScope,
  eban.banfn                 as PurchasingDocument,
  eban.ebelp                 as PurchasingDocumentItem,
  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.banfn     <> ''
    and   resb.bnfpo     <> '00000'
  ) -- SubContracting Purchase Requisition
  and     not(
        resb.bdart       =  'BB'
        and   resb.bdmng <= resb.enmng
      )
  and(
          resb.lifnr     =  ''
    or(
          resb.lifnr     <> ''
      and lfa1.cvp_xblck =  ''
    )
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPDMNDMATERIALPLANT",
"EBAN",
"LFA1",
"RESB"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More