I_SupDmndAllDocPurReqnComp

DDL: I_SUPDMNDALLDOCPURREQNCOMP Type: view BASIC
35 Fields 4 Data Sources

View for Sub Contracting Purchase Requisition Components

I_SupDmndAllDocPurReqnComp is a Basic CDS View that provides data about "View for Sub Contracting Purchase Requisition Components" in SAP S/4HANA. It reads from 4 data sources (eban, lfa1, I_SupDmndMaterialPlant, resb) and exposes 35 fields.

Data Sources (4)

SourceAliasJoin Type
eban eban inner
lfa1 lfa1 left_outer
I_SupDmndMaterialPlant marc inner
resb resb from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISUPDMNDADCMP2 view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label View for Sub Contracting Purchase Requisition Components view

Fields (35)

KeyFieldSource TableSource FieldDescription
RequirementDocumentNumber resb rsnum Reservation
RequirementDocumentItem
RequirementType
RequestedDate resb bdter Reqmts date
ProductAvailabilityDate resb bdter Reqmts date
RequestedDeliveryDate resb bdter Reqmts date
RequestedRqmtQtyInBaseUnit resb bdmng Threshold value
ConfirmedRqmtQtyInBaseUnit resb bdmng Threshold value
DeliveredQuantityInBaseUnit 0
OpenDemandQuantity
AssignedQuantityInBaseUnit 0
NormalAssignedQuantityInBsUnt 0
PreviewAssignedQuantityInBsUnt 0
WithdrawnQuantity resb enmng Withdrawal Qty
OpenQuantity
BaseUnit resb meins Valuation Unit
Material resb matnr Vehicle Model
MaterialGroup I_SupDmndMaterialPlant MaterialGroup Product Group
Plant resb werks Receiving Plant
OrderType
CrossPlantConfigurableProduct I_SupDmndMaterialPlant CrossPlantConfigurableProduct Cross-plant CP
MaterialType I_SupDmndMaterialPlant MaterialType Material Type
RequirementSegment resb sgt_rcat Req. Segment
StorageLocation resb lgort Sublocation
Customer eban kunnr Stock customer
CompanyCode eban extcompanycodeforpurg Company Code
SalesOrder resb kdauf SD Document
SalesOrderItem resb kdpos Sales Ord. Item
SegmentationStrategy I_SupDmndMaterialPlant SegmentationStrategy Segment. Strategy
SegmentationStrategyScope I_SupDmndMaterialPlant SegmentationStrategyScope Seg. Scope
PurchasingDocument eban banfn Requisition
PurchasingDocumentItem eban ebelp Item pur. doc.
ReservationItem resb rspos Item no.
Division I_SupDmndMaterialPlant Division Internal Division ID
IsInternalBatchManaged I_SupDmndMaterialPlant IsInternalBatchManaged Batches

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SupDmndAllDocPurReqnComp.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_SupDmndAllDocPurReqnComp AS
SELECT
  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,
  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,
  resb.bdmng - resb.enmng AS OpenQuantity,
  resb.meins AS BaseUnit,
  resb.matnr AS Material,
  marc.MaterialGroup AS MaterialGroup,
  resb.werks AS Plant,
  'RB' AS OrderType,
  marc.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  marc.MaterialType AS 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 AS SegmentationStrategy,
  marc.SegmentationStrategyScope AS SegmentationStrategyScope,
  eban.banfn AS PurchasingDocument,
  eban.ebelp AS PurchasingDocumentItem,
  resb.rspos AS ReservationItem,
  marc.Division AS Division,
  marc.IsInternalBatchManaged AS IsInternalBatchManaged
FROM resb
INNER JOIN I_SupDmndMaterialPlant AS marc ON /* join condition not captured in parsed metadata */
INNER JOIN eban ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 ON /* join condition not captured in parsed metadata */
;

Learn More