P_SFINotAssldTrcblComponent1

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_SFINotAssldTrcblComponent1.
-- 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 P_SFINotAssldTrcblComponent1 AS
SELECT
  ShopFloorItemStatus.ShopFloorItem AS ShopFloorItem,
  OpActyInstanceComponent.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstanceComponent.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstanceComponent.Reservation AS Reservation,
  OpActyInstanceComponent.ReservationItem AS ReservationItem,
  OpActyInstanceComponent.RecordType AS RecordType,
  OpActyInstanceComponent.Material AS Material,
  OpActyInstanceComponent._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  OpActyInstanceComponent.Plant AS Plant,
  OpActyInstanceComponent.StorageLocation AS StorageLocation,
  OpActyInstanceComponent.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OpActyInstanceComponent.BaseUnit AS BaseUnit,
  cast(round(fltp_to_dec( OpActyInstanceComponent.MfgOrderComponentUsageNetQty as abap.dec(13,4) ), 3) as bdmng ) as RequiredQuantity AS dec1343asbdmngasRequiredQuantity,
  OpActyInstanceComponent.EntryUnit AS EntryUnit,
  OpActyInstanceComponent.Batch AS Batch,
  MfgOrderProductPlant.MatlCompAssembleControl AS MatlCompAssembleControl,
  MfgOrderProductPlant._MatlCompAssembleControl._Text[1: Language=$session.system_language].MatlCompAssembleControlName AS MatlCompAssembleControlName,
  OpActyInstanceComponent.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstanceComponent.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  OrderOperation.Operation_2 AS ManufacturingOrderOperation,
  OrderOperation.OperationText AS MfgOrderOperationText,
  ShopFloorItemStatus._ShopFloorItem._MfgOrder.EffectivityParameterVariant AS EffectivityParameterVariant,
  OpActyNtwkInstanceBasic.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  ShopFloorItemStatus.StatusAndActionSchema AS StatusAndActionSchema,
  ShopFloorItemStatus.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  ShopFloorItemStatus.SFIOpActyStsLastChgdByDoc AS SFIOpActyStsLastChgdByDoc,
  ShopFloorItemStatus._SASStatus.SASStatusCategory AS SASStatusCategory,
  ShopFloorItemStatus._SASStatus._Text[1: Language=$session.system_language].SASStatusName AS SASStatusName,
  cast( OpActyInstanceComponent.BillOfMaterialInternalID as mpe_exec_stnum preserving type ) AS BillOfMaterialInternalID,
  OpActyInstanceComponent.BOMItem AS BOMItem,
  OpActyInstanceComponent.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OpActyInstanceComponent.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyInstanceComponent.BillOfMaterialVersion AS BillOfMaterialVersion,
  cast('' as stlan preserving type ) AS BillOfMaterialVariantUsage,
  OpActyInstanceComponent.BOMItemCategory AS BOMItemCategory,
  OpActyInstanceComponent.InheritedBOMItemNode AS InheritedBOMItemNode,
  OrderComponent._BillOfMaterialItem.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  OpActyInstanceComponent.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  OpActyInstanceComponent.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyInstanceComponent.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstanceComponent._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic,
  OpActyInstanceComponent._OperationActivityInstance AS _OperationActivityInstance,
  OpActyInstanceComponent._ReservationHeader AS _ReservationHeader,
  ShopFloorItemStatus._ShopFloorItem AS _ShopFloorItem,
  ShopFloorItemStatus._SASSchema AS _SASSchema,
  ShopFloorItemStatus._SASStatus AS _SASStatus,
  ShopFloorItemStatus._SASStatusText AS _SASStatusText,
  ShopFloorItemStatus._SFIOpActyStsLastChgdByDoc AS _SFIOpActyStsLastChgdByDoc
FROM I_OpActyInstanceComponent AS OpActyInstanceComponent
INNER JOIN I_ShopFloorItemStatus AS ShopFloorItemStatus ON /* join condition not captured in parsed metadata */
INNER JOIN I_MatlPlntCompAssembleControl AS MfgOrderProductPlant ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyNtwkInstanceBasic AS OpActyNtwkInstanceBasic ON /* join condition not captured in parsed metadata */
;