P_MfgOrderOriglComponentAssy

DDL: P_MFGORDERORIGLCOMPONENTASSY SQL: PMPEORIGCOMPASSY Type: view COMPOSITE Package: MPE_EXEC_SFO
23 Fields 3 Data Sources 2 Associations

Manufacturing Order Original Component Assembly

P_MfgOrderOriglComponentAssy is a Composite CDS View that provides data about "Manufacturing Order Original Component Assembly" in SAP S/4HANA. It reads from 3 data sources (I_MfgOrderComponentAssembly, I_OpActyComponentAssignment, I_ReservationItem) and exposes 23 fields with key fields AssemblyDocument, AssemblyDocumentItem. It has 2 associations to related views. Part of development package MPE_EXEC_SFO.

Data Sources (3)

SourceAliasJoin Type
I_MfgOrderComponentAssembly MfgOrderComponentAssembly from
I_OpActyComponentAssignment OpActyComponentAssignment inner
I_ReservationItem ReservationItem inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MfgOrder _MfgOrder $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder
[0..1] I_DebitCreditCode _DebitCreditCode $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPEORIGCOMPASSY 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 (23)

KeyFieldSource TableSource FieldDescription
KEY AssemblyDocument I_MfgOrderComponentAssembly AssemblyDocument Document Number
KEY AssemblyDocumentItem I_MfgOrderComponentAssembly AssemblyDocumentItem Item Number
ReferenceOrderasManufacturingOrder
Reservation I_MfgOrderComponentAssembly Reservation Reservation
AssemblyShopFloorItem I_MfgOrderComponentAssembly AssemblyShopFloorItem Parent SFI ID
ShopFloorItem I_MfgOrderComponentAssembly ShopFloorItem Serial.Mat. ID
Batch I_MfgOrderComponentAssembly Batch Lot No.
Material I_MfgOrderComponentAssembly Material Vehicle Model
MaterialBaseUnit I_MfgOrderComponentAssembly MaterialBaseUnit Valuation Unit
CreationDateTime I_MfgOrderComponentAssembly CreationDateTime Timestamp
CreatedByUser I_MfgOrderComponentAssembly CreatedByUser User Name
Plant I_MfgOrderComponentAssembly Plant Valuation Area
StorageLocation I_MfgOrderComponentAssembly StorageLocation StorageLocation
BOOOpBOMItemInternalID I_OpActyComponentAssignment BOOOpBOMItemInternalID Allocation no.
_MfgOrder _MfgOrder
_Material I_MfgOrderComponentAssembly _Material
_MaterialBaseUnit I_MfgOrderComponentAssembly _MaterialBaseUnit
_ParentShopFloorItem I_MfgOrderComponentAssembly _ParentShopFloorItem
_Plant I_MfgOrderComponentAssembly _Plant
_Reservation I_MfgOrderComponentAssembly _Reservation
_ShopFloorItem I_MfgOrderComponentAssembly _ShopFloorItem
_StorageLocation I_MfgOrderComponentAssembly _StorageLocation
_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_MfgOrderOriglComponentAssy.
-- 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: PMPEORIGCOMPASSY

CREATE VIEW P_MfgOrderOriglComponentAssy AS
SELECT
  MfgOrderComponentAssembly.AssemblyDocument AS AssemblyDocument,
  MfgOrderComponentAssembly.AssemblyDocumentItem AS AssemblyDocumentItem,
  they have same ManufacturingOrder and Reservation ReservationItem.ReferenceOrder as ManufacturingOrder AS ReferenceOrderasManufacturingOrder,
  MfgOrderComponentAssembly.Reservation AS Reservation,
  MfgOrderComponentAssembly.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  MfgOrderComponentAssembly.ShopFloorItem AS ShopFloorItem,
  MfgOrderComponentAssembly.Batch AS Batch,
  MfgOrderComponentAssembly.Material AS Material,
  MfgOrderComponentAssembly.MaterialBaseUnit AS MaterialBaseUnit,
  MfgOrderComponentAssembly.CreationDateTime AS CreationDateTime,
  MfgOrderComponentAssembly.CreatedByUser AS CreatedByUser,
  MfgOrderComponentAssembly.Plant AS Plant,
  MfgOrderComponentAssembly.StorageLocation AS StorageLocation,
  OpActyComponentAssignment.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  MfgOrderComponentAssembly._Material AS _Material,
  MfgOrderComponentAssembly._MaterialBaseUnit AS _MaterialBaseUnit,
  MfgOrderComponentAssembly._ParentShopFloorItem AS _ParentShopFloorItem,
  MfgOrderComponentAssembly._Plant AS _Plant,
  MfgOrderComponentAssembly._Reservation AS _Reservation,
  MfgOrderComponentAssembly._ShopFloorItem AS _ShopFloorItem,
  MfgOrderComponentAssembly._StorageLocation AS _StorageLocation
FROM I_MfgOrderComponentAssembly AS MfgOrderComponentAssembly
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_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
;

Learn More