P_SFIOpActyPlanInspChar

DDL: P_SFIOPACTYPLANINSPCHAR SQL: PSFIOAPIC Type: view CONSUMPTION
25 Fields 7 Data Sources

P_SFIOpActyPlanInspChar is a Consumption CDS View in SAP S/4HANA. It reads from 7 data sources and exposes 25 fields with key fields OrderInternalBillOfOperations, OrderOperationInternalID, OpActyNtwkInstance, OpActyNtwkElement, ManufacturingOrder.

Data Sources (7)

SourceAliasJoin Type
I_MfgOrderOperation MfgOrderOperation inner
I_OpActyBOOCharcAssgmt OpActyBOOCharcAssgmt inner
I_OpActyNtwkElement OpActyNtwkElement inner
I_OpActyNtwkInstance OpActyNtwkInstance inner
I_OperationActivityInstance OperationActivityInstance inner
I_OrderOperationBasic OrderOperationBasic inner
I_ShopFloorItem ShopFloorItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PSFIOAPIC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (25)

KeyFieldSource TableSource FieldDescription
ShopFloorItem
KEY OrderInternalBillOfOperations I_MfgOrderOperation OrderInternalBillOfOperations Order Internal Bill of Operations
KEY OrderOperationInternalID I_MfgOrderOperation OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
KEY OpActyNtwkInstance I_MfgOrderOperation ProduceOpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OperationActivityInstance OpActyNtwkElement Element Number
KEY ManufacturingOrder I_ShopFloorItem ManufacturingOrder Order
SerialNumber I_ShopFloorItem SerialNumber Serial Number
ShopFloorItemExternalID I_ShopFloorItem ShopFloorItemExternalID SFI Number
ManufacturingOrderType I_MfgOrderOperation ManufacturingOrderType
ManufacturingOrderCategory I_MfgOrderOperation ManufacturingOrderCategory
Material I_ShopFloorItem Material Vehicle Model
ManufacturingOrderOperation I_MfgOrderOperation ManufacturingOrderOperation Activity
Operation I_OrderOperationBasic Operation Transaction
OpActyNtwkElementElement I_OpActyNtwkElement OpActyNtwkElementElement Operation Activity
OpActyNtwkElementExternalID I_OpActyNtwkElement OpActyNtwkElementExternalID Op. Activity
OperationActivity I_OpActyBOOCharcAssgmt OperationActivity Operation Activity
OperationActyVersionCounter
InspectionCharacteristic I_OpActyBOOCharcAssgmt BOOCharacteristic Characteristic
BillOfOperationsGroup I_OpActyBOOCharcAssgmt BillOfOperationsGroup Group
BOOOperationInternalID I_OpActyBOOCharcAssgmt BOOOperationInternalID Task list node
BillOfOperationsType I_OpActyBOOCharcAssgmt BillOfOperationsType Task List Type
Plant I_OrderOperationBasic Plant Valuation Area
_MfgOrder I_ShopFloorItem _MfgOrder
_Material I_ShopFloorItem _Material
_OrdInternalBillOfOperations I_MfgOrderOperation _OrdInternalBillOfOperations

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_SFIOpActyPlanInspChar.
-- 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: PSFIOAPIC

CREATE VIEW P_SFIOpActyPlanInspChar AS
SELECT
  MfgOrderOperation.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  MfgOrderOperation.OrderIntBillOfOperationsItem AS OrderOperationInternalID,
  MfgOrderOperation.ProduceOpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActivityInstance.OpActyNtwkElement AS OpActyNtwkElement,
  ShopFloorItem.ManufacturingOrder AS ManufacturingOrder,
  ShopFloorItem.SerialNumber AS SerialNumber,
  ShopFloorItem.ShopFloorItemExternalID AS ShopFloorItemExternalID,
  MfgOrderOperation.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrderOperation.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  ShopFloorItem.Material AS Material,
  MfgOrderOperation.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  OrderOperationBasic.Operation AS Operation,
  OpActyNtwkElement.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OpActyNtwkElement.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OpActyBOOCharcAssgmt.OperationActivity AS OperationActivity,
  OpActyNtwkElement._OperationActivity.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyBOOCharcAssgmt.BOOCharacteristic AS InspectionCharacteristic,
  OpActyBOOCharcAssgmt.BillOfOperationsGroup AS BillOfOperationsGroup,
  OpActyBOOCharcAssgmt.BOOOperationInternalID AS BOOOperationInternalID,
  OpActyBOOCharcAssgmt.BillOfOperationsType AS BillOfOperationsType,
  OrderOperationBasic.Plant AS Plant,
  ShopFloorItem._MfgOrder AS _MfgOrder,
  ShopFloorItem._Material AS _Material,
  MfgOrderOperation._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations
FROM I_ShopFloorItem AS ShopFloorItem
INNER JOIN I_MfgOrderOperation AS MfgOrderOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationActivityInstance AS OperationActivityInstance ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyNtwkInstance AS OpActyNtwkInstance ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyNtwkElement AS OpActyNtwkElement ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationBasic AS OrderOperationBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyBOOCharcAssgmt AS OpActyBOOCharcAssgmt ON /* join condition not captured in parsed metadata */
;

Learn More