I_AssldReltdCompInstceSrlNmbr

DDL: I_ASSLDRELTDCOMPINSTCESRLNMBR SQL: IMPEASSRLTDINST Type: view COMPOSITE
45 Fields 2 Data Sources

Assembled Related Component Instance and/or Serial Number

I_AssldReltdCompInstceSrlNmbr is a Composite CDS View that provides data about "Assembled Related Component Instance and/or Serial Number" in SAP S/4HANA. It reads from 2 data sources (P_AssldReltdComponentInstance, I_ReservationItem) and exposes 45 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement.

Data Sources (2)

SourceAliasJoin Type
P_AssldReltdComponentInstance AssldReltdComponentInstance from
I_ReservationItem ReservationItem inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPEASSRLTDINST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
EndUserText.label Assembled Related Component Instance and/or Serial Number view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY Reservation P_AssldReltdComponentInstance Reservation Reservation
KEY ReservationItem P_AssldReltdComponentInstance ReservationItem Reservation Item
KEY RecordType P_AssldReltdComponentInstance RecordType Reservation Record Type
KEY OpActyNtwkInstance P_AssldReltdComponentInstance OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_AssldReltdComponentInstance OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem P_AssldReltdComponentInstance AssemblyShopFloorItem
KEY ShopFloorItem P_AssldReltdComponentInstance ShopFloorItem Serial.Mat. ID
KEY OriglDgtlMockUpCharcsUUID P_AssldReltdComponentInstance OriglDgtlMockUpCharcsUUID DMU GUID
ReltdOriglDgtlMockUpCharcsUUID P_AssldReltdComponentInstance ReltdOriglDgtlMockUpCharcsUUID
MaterialComponentQuantity
MaterialBaseUnit I_ReservationItem BaseUnit Valuation Unit
ReferenceDesignatorName P_AssldReltdComponentInstance ReferenceDesignatorName
ReferenceDesignatorValue P_AssldReltdComponentInstance ReferenceDesignatorValue Ref. Designator
Batch P_AssldReltdComponentInstance Batch Lot No.
BatchBySupplier
AssembledSerialNumber
ManufacturerSerialNumber
_ReservationHeader P_AssldReltdComponentInstance _ReservationHeader
_OpActyNtwkInstance P_AssldReltdComponentInstance _OpActyNtwkInstance
_OperationActivityInstance P_AssldReltdComponentInstance _OperationActivityInstance
_ParentShopFloorItem P_AssldReltdComponentInstance _ParentShopFloorItem
_MaterialBaseUnit I_ReservationItem _BaseUnit
Reservation Reservation
KEY ReservationItem AssldReltdCompSFINoInstce ReservationItem Reservation Item
KEY RecordType AssldReltdCompSFINoInstce RecordType Reservation Record Type
KEY OpActyNtwkInstance AssldReltdCompSFINoInstce OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement AssldReltdCompSFINoInstce OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem AssldReltdCompSFINoInstce AssemblyShopFloorItem
KEY ShopFloorItem AssldReltdCompSFINoInstce ShopFloorItem Serial.Mat. ID
KEY OriglDgtlMockUpCharcsUUID DMU GUID
ReltdOriglDgtlMockUpCharcsUUID
MaterialComponentQuantity AssldReltdCompSFINoInstce MaterialComponentQuantity
MaterialBaseUnit AssldReltdCompSFINoInstce MaterialBaseUnit Valuation Unit
ReferenceDesignatorName
ReferenceDesignatorValue Ref. Designator
Batch AssldReltdCompSFINoInstce Batch Lot No.
BatchBySupplier
AssembledSerialNumber
ManufacturerSerialNumber
_ReservationHeader AssldReltdCompSFINoInstce _ReservationHeader
_OpActyNtwkInstance AssldReltdCompSFINoInstce _OpActyNtwkInstance
_OperationActivityInstance AssldReltdCompSFINoInstce _OperationActivityInstance
_ParentShopFloorItem AssldReltdCompSFINoInstce _ParentShopFloorItem
_MaterialBaseUnit AssldReltdCompSFINoInstce _MaterialBaseUnit
_ShopFloorItem AssldReltdCompSFINoInstce _ShopFloorItem

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 I_AssldReltdCompInstceSrlNmbr.
-- 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: IMPEASSRLTDINST

CREATE VIEW I_AssldReltdCompInstceSrlNmbr AS
SELECT
  AssldReltdComponentInstance.Reservation AS Reservation,
  AssldReltdComponentInstance.ReservationItem AS ReservationItem,
  AssldReltdComponentInstance.RecordType AS RecordType,
  AssldReltdComponentInstance.OpActyNtwkInstance AS OpActyNtwkInstance,
  AssldReltdComponentInstance.OpActyNtwkElement AS OpActyNtwkElement,
  AssldReltdComponentInstance.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  AssldReltdComponentInstance.ShopFloorItem AS ShopFloorItem,
  AssldReltdComponentInstance.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  AssldReltdComponentInstance.ReltdOriglDgtlMockUpCharcsUUID AS ReltdOriglDgtlMockUpCharcsUUID,
  cast( 1 as kmpmg ) AS MaterialComponentQuantity,
  ReservationItem.BaseUnit AS MaterialBaseUnit,
  AssldReltdComponentInstance.ReferenceDesignatorName AS ReferenceDesignatorName,
  AssldReltdComponentInstance.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  AssldReltdComponentInstance.Batch AS Batch,
  AssldReltdComponentInstance._BatchDistinct.BatchBySupplier AS BatchBySupplier,
  AssldReltdComponentInstance._ShopFloorItem.SerialNumber AS AssembledSerialNumber,
  AssldReltdComponentInstance._ShopFloorItem._Equipment.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  AssldReltdComponentInstance._ReservationHeader AS _ReservationHeader,
  AssldReltdComponentInstance._OpActyNtwkInstance AS _OpActyNtwkInstance,
  AssldReltdComponentInstance._OperationActivityInstance AS _OperationActivityInstance,
  AssldReltdComponentInstance._ParentShopFloorItem AS _ParentShopFloorItem,
  ReservationItem._BaseUnit AS _MaterialBaseUnit,
  AssldReltdCompSFINoInstce._ShopFloorItem AS _ShopFloorItem
FROM P_AssldReltdComponentInstance AS AssldReltdComponentInstance
INNER JOIN I_ReservationItem AS ReservationItem ON /* join condition not captured in parsed metadata */
;

Learn More