P_SFIDisassemblyByCompInstce

DDL: P_SFIDISASSEMBLYBYCOMPINSTCE Type: view_entity CONSUMPTION
17 Fields 2 Data Sources

P_SFIDisassemblyByCompInstce is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_OpActyComponentAssignment, I_SFIDisassemblyByCompInstce) and exposes 17 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement.

Data Sources (2)

SourceAliasJoin Type
I_OpActyComponentAssignment OpActyComponentAssignment inner
I_SFIDisassemblyByCompInstce SFIDsassldCompByCompInstce from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_SFIDisassemblyByCompInstce Reservation Reservation
KEY ReservationItem I_SFIDisassemblyByCompInstce ReservationItem Reservation Item
KEY RecordType I_SFIDisassemblyByCompInstce RecordType Reservation Record Type
KEY OpActyNtwkInstance I_SFIDisassemblyByCompInstce OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_SFIDisassemblyByCompInstce OpActyNtwkElement Element Number
KEY OriglDgtlMockUpCharcsUUID I_SFIDisassemblyByCompInstce OriglDgtlMockUpCharcsUUID DMU GUID
KEY AssemblyShopFloorItem I_SFIDisassemblyByCompInstce AssemblyShopFloorItem
KEY ShopFloorItem I_SFIDisassemblyByCompInstce ShopFloorItem Serial.Mat. ID
KEY Batch I_SFIDisassemblyByCompInstce Batch Lot No.
MaterialComponentQuantity I_SFIDisassemblyByCompInstce MaterialComponentQuantity
VariableSizeItemQuantity I_SFIDisassemblyByCompInstce VariableSizeItemQuantity VSI Quantity
VariableSizeItemUnit I_SFIDisassemblyByCompInstce VariableSizeItemUnit VSI unit
MaterialBaseUnit I_SFIDisassemblyByCompInstce MaterialBaseUnit Valuation Unit
ComponentAssemblyType I_OpActyComponentAssignment ComponentAssemblyType Assembly Type
MfgRefStrucBOMLeafAssgmtUUID OpActyCompInstceAssignment MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID OpActyCompInstceAssignment MfgRefStructureItemDetailUUID MRS Item UUID
MfgRefStrucItmDetIsContextual OpActyCompInstceAssignment MfgRefStrucItmDetIsContextual Contextual

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_SFIDisassemblyByCompInstce.
-- 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_SFIDisassemblyByCompInstce AS
SELECT
  SFIDsassldCompByCompInstce.Reservation AS Reservation,
  SFIDsassldCompByCompInstce.ReservationItem AS ReservationItem,
  SFIDsassldCompByCompInstce.RecordType AS RecordType,
  SFIDsassldCompByCompInstce.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIDsassldCompByCompInstce.OpActyNtwkElement AS OpActyNtwkElement,
  SFIDsassldCompByCompInstce.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  SFIDsassldCompByCompInstce.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  SFIDsassldCompByCompInstce.ShopFloorItem AS ShopFloorItem,
  SFIDsassldCompByCompInstce.Batch AS Batch,
  SFIDsassldCompByCompInstce.MaterialComponentQuantity AS MaterialComponentQuantity,
  SFIDsassldCompByCompInstce.VariableSizeItemQuantity AS VariableSizeItemQuantity,
  SFIDsassldCompByCompInstce.VariableSizeItemUnit AS VariableSizeItemUnit,
  SFIDsassldCompByCompInstce.MaterialBaseUnit AS MaterialBaseUnit,
  OpActyComponentAssignment.ComponentAssemblyType AS ComponentAssemblyType,
  OpActyCompInstceAssignment.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyCompInstceAssignment.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual
FROM I_SFIDisassemblyByCompInstce AS SFIDsassldCompByCompInstce
INNER JOIN I_OpActyComponentAssignment AS OpActyComponentAssignment ON /* join condition not captured in parsed metadata */
;

Learn More