P_MfgOrderCompAssemblyAction

DDL: P_MFGORDERCOMPASSEMBLYACTION SQL: PMPECOMPASSYACTN Type: view COMPOSITE Package: MPE_EXEC_SFO
46 Fields 1 Data Sources

Manufacturing Order Component Assembly Action

P_MfgOrderCompAssemblyAction is a Composite CDS View that provides data about "Manufacturing Order Component Assembly Action" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderComponentAssembly) and exposes 46 fields with key fields AssemblyDocument, AssemblyDocumentItem. Part of development package MPE_EXEC_SFO.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderComponentAssembly I_MfgOrderComponentAssembly from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPECOMPASSYACTN view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter 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 (46)

KeyFieldSource TableSource FieldDescription
KEY AssemblyDocument AssemblyDocument Document Number
KEY AssemblyDocumentItem AssemblyDocumentItem Item Number
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
RecordType RecordType Reservation Record Type
OpActyNtwkInstance OpActyNtwkInstance Instance ID
OpActyNtwkElement OpActyNtwkElement Element Number
AssemblyShopFloorItem AssemblyShopFloorItem Parent SFI ID
ShopFloorItem ShopFloorItem Serial.Mat. ID
Batch Batch Lot No.
Material Material Vehicle Model
RequiredQuantity RequiredQuantity Requirement qty
MaterialComponentQuantity MaterialComponentQuantity Value
MaterialBaseUnit MaterialBaseUnit Valuation Unit
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
InventoryUsabilityCode InventoryUsabilityCode Stock Type
CompAssemblyGoodsMvtStatus CompAssemblyGoodsMvtStatus GoodsMovStatus
PostingIsRetroactive PostingIsRetroactive Retroactive Action
QuantityInEntryUnit QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit EntryUnit Unit of Entry
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentYear MaterialDocumentYear Material Document Year
GoodsMovementException GoodsMovementException
GoodsMovementExceptionItem GoodsMovementExceptionItem
ExecOpActyNtwkInstance ExecOpActyNtwkInstance Instance ID
ExecOpActyNtwkElement ExecOpActyNtwkElement Element Number
DebitCreditCode DebitCreditCode Single-Character Flag
_ExecOpActyNtwkInstance _ExecOpActyNtwkInstance
_ExecOperationActivityInstance _ExecOperationActivityInstance
_GoodsMovementException _GoodsMovementException
_GoodsMovementExceptionItem _GoodsMovementExceptionItem
_Material _Material
_MaterialBaseUnit _MaterialBaseUnit
_MaterialDocumentHeader _MaterialDocumentHeader
_MaterialDocumentYear _MaterialDocumentYear
_OpActyNtwkInstance _OpActyNtwkInstance
_OperationActivityInstance _OperationActivityInstance
_ParentShopFloorItem _ParentShopFloorItem
_Plant _Plant
_Reservation _Reservation
_ReservationItem _ReservationItem
_ShopFloorItem _ShopFloorItem
_StorageLocation _StorageLocation

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_MfgOrderCompAssemblyAction.
-- 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: PMPECOMPASSYACTN

CREATE VIEW P_MfgOrderCompAssemblyAction AS
SELECT
  AssemblyDocument,
  AssemblyDocumentItem,
  Reservation,
  ReservationItem,
  RecordType,
  OpActyNtwkInstance,
  OpActyNtwkElement,
  AssemblyShopFloorItem,
  ShopFloorItem,
  Batch,
  Material,
  RequiredQuantity,
  MaterialComponentQuantity,
  MaterialBaseUnit,
  CreationDateTime,
  CreatedByUser,
  Plant,
  StorageLocation,
  InventoryUsabilityCode,
  CompAssemblyGoodsMvtStatus,
  PostingIsRetroactive,
  QuantityInEntryUnit,
  EntryUnit,
  MaterialDocument,
  MaterialDocumentYear,
  GoodsMovementException,
  GoodsMovementExceptionItem,
  ExecOpActyNtwkInstance,
  ExecOpActyNtwkElement,
  DebitCreditCode
FROM I_MfgOrderComponentAssembly
;

Learn More