P_SFIAssembledMaterial

DDL: P_SFIASSEMBLEDMATERIAL SQL: PMPESFIAMAT Type: view COMPOSITE
29 Fields 3 Data Sources 1 Associations

P_SFIAssembledMaterial is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_OpActyComponentAssignment, I_ReservationItem, I_SFIAtOpActyAssyByComponent) and exposes 29 fields with key fields AssemblyShopFloorItem, OpActyNtwkInstance, OpActyNtwkElement, Reservation, ReservationItem. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_OpActyComponentAssignment OpActyComponentAssignment inner
I_ReservationItem ReservationItem inner
I_SFIAtOpActyAssyByComponent SFIAtOpActyAssyByComponent from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Material _Material $projection.Material = _Material.Material

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPESFIAMAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY AssemblyShopFloorItem I_SFIAtOpActyAssyByComponent AssemblyShopFloorItem
KEY OpActyNtwkInstance I_SFIAtOpActyAssyByComponent OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_SFIAtOpActyAssyByComponent OpActyNtwkElement Element Number
KEY Reservation I_SFIAtOpActyAssyByComponent Reservation Reservation
KEY ReservationItem I_SFIAtOpActyAssyByComponent ReservationItem Reservation Item
KEY RecordType I_SFIAtOpActyAssyByComponent RecordType Reservation Record Type
KEY Material I_SFIAtOpActyAssyByComponent Material Vehicle Model
KEY Plant I_SFIAtOpActyAssyByComponent Plant Valuation Area
MatlCompIsMarkedForBackflush Backflush
GoodsMovementIsAllowed Mvt Allowed
BOOOpBOMItemInternalID I_OpActyComponentAssignment BOOOpBOMItemInternalID Allocation no.
_ParentShopFloorItem I_SFIAtOpActyAssyByComponent _ParentShopFloorItem
_OpActyNtwkInstance I_SFIAtOpActyAssyByComponent _OpActyNtwkInstance
_OperationActivityInstance I_SFIAtOpActyAssyByComponent _OperationActivityInstance
ShopFloorItemasAssemblyShopFloorItem
KEY OpActyNtwkInstance SFICompletedOpActy OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement SFICompletedOpActy OpActyNtwkElement Element Number
KEY Reservation I_ReservationItem Reservation Reservation
KEY ReservationItem I_ReservationItem ReservationItem Reservation Item
KEY RecordType I_ReservationItem RecordType Reservation Record Type
KEY Material I_ReservationItem Material Vehicle Model
KEY Plant I_ReservationItem Plant Valuation Area
MatlCompIsMarkedForBackflush I_ReservationItem MatlCompIsMarkedForBackflush Backflush
GoodsMovementIsAllowed I_ReservationItem GoodsMovementIsAllowed Mvt Allowed
BOOOpBOMItemInternalID I_OpActyComponentAssignment BOOOpBOMItemInternalID Allocation no.
_ParentShopFloorItem SFICompletedOpActy _ShopFloorItem
_OpActyNtwkInstance SFICompletedOpActy _OpActyNtwkInstance
_OperationActivityInstance SFICompletedOpActy _OperationActivityInstance
_Material _Material

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 P_SFIAssembledMaterial.
-- 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.
-- SQL view name: PMPESFIAMAT

CREATE VIEW P_SFIAssembledMaterial AS
SELECT
  SFIAtOpActyAssyByComponent.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  SFIAtOpActyAssyByComponent.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIAtOpActyAssyByComponent.OpActyNtwkElement AS OpActyNtwkElement,
  SFIAtOpActyAssyByComponent.Reservation AS Reservation,
  SFIAtOpActyAssyByComponent.ReservationItem AS ReservationItem,
  SFIAtOpActyAssyByComponent.RecordType AS RecordType,
  SFIAtOpActyAssyByComponent.Material AS Material,
  SFIAtOpActyAssyByComponent.Plant AS Plant,
  cast('' as rgekz preserving type) AS MatlCompIsMarkedForBackflush,
  cast(coalesce(ReservationItem.GoodsMovementIsAllowed, 'X') as xwaok preserving type ) AS GoodsMovementIsAllowed,
  OpActyComponentAssignment.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  SFIAtOpActyAssyByComponent._ParentShopFloorItem AS _ParentShopFloorItem,
  SFIAtOpActyAssyByComponent._OpActyNtwkInstance AS _OpActyNtwkInstance,
  SFIAtOpActyAssyByComponent._OperationActivityInstance AS _OperationActivityInstance,
  SFIAtOpActyAssyByComponent._Material AS ShopFloorItemasAssemblyShopFloorItem
FROM I_SFIAtOpActyAssyByComponent AS SFIAtOpActyAssyByComponent
INNER JOIN I_OpActyComponentAssignment AS OpActyComponentAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN I_ReservationItem AS ReservationItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
;

Learn More