P_SFIAtOpActyBckflshByOrigComp

DDL: P_SFIATOPACTYBCKFLSHBYORIGCOMP SQL: PMPEORIGCOMPBCKF Type: view COMPOSITE Package: MPE_EXEC_SFO
12 Fields 3 Data Sources 3 Associations

SFI@OA backflushed Component by Original Component Assembly

P_SFIAtOpActyBckflshByOrigComp is a Composite CDS View that provides data about "SFI@OA backflushed Component by Original Component Assembly" in SAP S/4HANA. It reads from 3 data sources (I_OpActyComponentAssignment, I_ReservationItem, I_ShopFloorItemStatus) and exposes 12 fields with key fields Reservation, CurrentReservationItem, CurrentRecordType, CurrentOpActyNtwkInstance, CurrentOpActyNtwkElement. It has 3 associations to related views. Part of development package MPE_EXEC_SFO.

Data Sources (3)

SourceAliasJoin Type
I_OpActyComponentAssignment OpActyComponentAssignment from
I_ReservationItem ReservationItem inner
I_ShopFloorItemStatus ShopFloorItemStatus inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MfgOrder _MfgOrder $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder
[1..1] I_ShopFloorItem _ParentShopFloorItem $projection.AssemblyShopFloorItem = _ParentShopFloorItem.ShopFloorItem
[0..1] I_DebitCreditCode _DebitCreditCode $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode

Annotations (10)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
ReferenceOrderasManufacturingOrder
KEY Reservation I_OpActyComponentAssignment Reservation Reservation
KEY CurrentReservationItem I_OpActyComponentAssignment ReservationItem Reservation Item
KEY CurrentRecordType I_OpActyComponentAssignment RecordType Reservation Record Type
KEY CurrentOpActyNtwkInstance I_OpActyComponentAssignment OpActyNtwkInstance Instance ID
KEY CurrentOpActyNtwkElement I_OpActyComponentAssignment OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem I_ShopFloorItemStatus ShopFloorItem Serial.Mat. ID
MaterialBaseUnit I_ReservationItem BaseUnit Unit of Measure
BOOOpBOMItemInternalID I_OpActyComponentAssignment BOOOpBOMItemInternalID Allocation no.
_MfgOrder _MfgOrder
_ParentShopFloorItem _ParentShopFloorItem
_DebitCreditCode _DebitCreditCode

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_SFIAtOpActyBckflshByOrigComp.
-- 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: PMPEORIGCOMPBCKF

CREATE VIEW P_SFIAtOpActyBckflshByOrigComp AS
SELECT
  they have same ManufacturingOrder and Reservation key ReservationItem.ReferenceOrder as ManufacturingOrder AS ReferenceOrderasManufacturingOrder,
  OpActyComponentAssignment.Reservation AS Reservation,
  OpActyComponentAssignment.ReservationItem AS CurrentReservationItem,
  OpActyComponentAssignment.RecordType AS CurrentRecordType,
  OpActyComponentAssignment.OpActyNtwkInstance AS CurrentOpActyNtwkInstance,
  OpActyComponentAssignment.OpActyNtwkElement AS CurrentOpActyNtwkElement,
  ShopFloorItemStatus.ShopFloorItem AS AssemblyShopFloorItem,
  ReservationItem.BaseUnit AS MaterialBaseUnit,
  OpActyComponentAssignment.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID
FROM I_OpActyComponentAssignment AS OpActyComponentAssignment
INNER JOIN I_ShopFloorItemStatus AS ShopFloorItemStatus 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_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ParentShopFloorItem ON AssemblyShopFloorItem = _ParentShopFloorItem.ShopFloorItem  -- association [1..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
;

Learn More