P_SFIAssldTrcblCompLdngResvnSL

DDL: P_SFIASSLDTRCBLCOMPLDNGRESVNSL SQL: PMPESFIASLDTRCL2 Type: view CONSUMPTION Package: MPE_EXEC_SFI
23 Fields 1 Data Sources

SFI Assembled Component By Leading Reservation and StorLoc

P_SFIAssldTrcblCompLdngResvnSL is a Consumption CDS View that provides data about "SFI Assembled Component By Leading Reservation and StorLoc" in SAP S/4HANA. It reads from 1 data source (P_SFIAssldTrcblCompLdngResvn) and exposes 23 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. Part of development package MPE_EXEC_SFI.

Data Sources (1)

SourceAliasJoin Type
P_SFIAssldTrcblCompLdngResvn SFIAssldTrcblCompLdngResvn from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMPESFIASLDTRCL2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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 (23)

KeyFieldSource TableSource FieldDescription
KEY Reservation P_SFIAssldTrcblCompLdngResvn Reservation Reservation
KEY ReservationItem P_SFIAssldTrcblCompLdngResvn ReservationItem Reservation Item
KEY RecordType P_SFIAssldTrcblCompLdngResvn RecordType Reservation Record Type
KEY OpActyNtwkInstance P_SFIAssldTrcblCompLdngResvn OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SFIAssldTrcblCompLdngResvn OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem P_SFIAssldTrcblCompLdngResvn AssemblyShopFloorItem
KEY ShopFloorItem P_SFIAssldTrcblCompLdngResvn ShopFloorItem Serial.Mat. ID
KEY Batch P_SFIAssldTrcblCompLdngResvn Batch Lot No.
KEY Material P_SFIAssldTrcblCompLdngResvn Material Vehicle Model
KEY Plant P_SFIAssldTrcblCompLdngResvn Plant Valuation Area
KEY StorageLocation P_SFIAssldTrcblCompLdngResvn StorageLocation StorageLocation
KEY InventoryUsabilityCode P_SFIAssldTrcblCompLdngResvn InventoryUsabilityCode Stock Type
KEY DgtlMockUpCharcsUUID P_SFIAssldTrcblCompLdngResvn DgtlMockUpCharcsUUID DMU GUID
KEY MfgRefStrucBOMLeafAssgmtUUID P_SFIAssldTrcblCompLdngResvn MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
KEY MfgRefStructureItemDetailUUID P_SFIAssldTrcblCompLdngResvn MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_SFIAssldTrcblCompLdngResvn MfgRefStrucItmDetIsContextual
MaterialComponentQuantity
QuantityInEntryUnit
EntryUnit
MaterialBaseUnit
_Material P_SFIAssldTrcblCompLdngResvn _Material
_Plant P_SFIAssldTrcblCompLdngResvn _Plant
_ProductPlantBasic P_SFIAssldTrcblCompLdngResvn _ProductPlantBasic

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_SFIAssldTrcblCompLdngResvnSL.
-- 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: PMPESFIASLDTRCL2

CREATE VIEW P_SFIAssldTrcblCompLdngResvnSL AS
SELECT
  SFIAssldTrcblCompLdngResvn.Reservation AS Reservation,
  SFIAssldTrcblCompLdngResvn.ReservationItem AS ReservationItem,
  SFIAssldTrcblCompLdngResvn.RecordType AS RecordType,
  SFIAssldTrcblCompLdngResvn.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIAssldTrcblCompLdngResvn.OpActyNtwkElement AS OpActyNtwkElement,
  SFIAssldTrcblCompLdngResvn.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  SFIAssldTrcblCompLdngResvn.ShopFloorItem AS ShopFloorItem,
  SFIAssldTrcblCompLdngResvn.Batch AS Batch,
  SFIAssldTrcblCompLdngResvn.Material AS Material,
  SFIAssldTrcblCompLdngResvn.Plant AS Plant,
  SFIAssldTrcblCompLdngResvn.StorageLocation AS StorageLocation,
  SFIAssldTrcblCompLdngResvn.InventoryUsabilityCode AS InventoryUsabilityCode,
  SFIAssldTrcblCompLdngResvn.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  SFIAssldTrcblCompLdngResvn.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  SFIAssldTrcblCompLdngResvn.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  SFIAssldTrcblCompLdngResvn.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  cast(sum(SFIAssldTrcblCompLdngResvn.MaterialComponentQuantity) as kmpmg preserving type) AS MaterialComponentQuantity,
  cast(sum(SFIAssldTrcblCompLdngResvn.QuantityInEntryUnit) as erfmgv preserving type) AS QuantityInEntryUnit,
  cast(max(SFIAssldTrcblCompLdngResvn.EntryUnit) as erfme preserving type ) AS EntryUnit,
  cast(max(SFIAssldTrcblCompLdngResvn.MaterialBaseUnit) as meins preserving type ) AS MaterialBaseUnit,
  SFIAssldTrcblCompLdngResvn._Material AS _Material,
  SFIAssldTrcblCompLdngResvn._Plant AS _Plant,
  SFIAssldTrcblCompLdngResvn._ProductPlantBasic AS _ProductPlantBasic
FROM P_SFIAssldTrcblCompLdngResvn AS SFIAssldTrcblCompLdngResvn
;

Learn More