P_SFIAssldTrcblCompByLdngResvn

DDL: P_SFIASSLDTRCBLCOMPBYLDNGRESVN SQL: PMPESFIASLDTRCLR Type: view CONSUMPTION
47 Fields 2 Data Sources

P_SFIAssldTrcblCompByLdngResvn is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_UnspltSFITrcblCompAssembly, P_SpltSFITrcblCompAssembly) and exposes 47 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement.

Data Sources (2)

SourceAliasJoin Type
P_UnspltSFITrcblCompAssembly Assembly from
P_SpltSFITrcblCompAssembly Assembly inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMPESFIASLDTRCLR 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 (47)

KeyFieldSource TableSource FieldDescription
KEY Reservation P_SpltSFITrcblCompAssembly Reservation Reservation
KEY ReservationItem P_SpltSFITrcblCompAssembly ReservationItem Reservation Item
KEY RecordType P_SpltSFITrcblCompAssembly RecordType Reservation Record Type
KEY OpActyNtwkInstance P_SpltSFITrcblCompAssembly OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SpltSFITrcblCompAssembly OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem P_SpltSFITrcblCompAssembly AssemblyShopFloorItem
KEY AssembledShopFloorItem P_SpltSFITrcblCompAssembly AssembledShopFloorItem
KEY Batch P_SpltSFITrcblCompAssembly Batch Lot No.
KEY Material P_SpltSFITrcblCompAssembly Material Vehicle Model
KEY Plant P_SpltSFITrcblCompAssembly Plant Valuation Area
KEY OriglDgtlMockUpCharcsUUID P_SpltSFITrcblCompAssembly OriglDgtlMockUpCharcsUUID DMU GUID
KEY MfgRefStrucBOMLeafAssgmtUUID P_SpltSFITrcblCompAssembly MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
KEY MfgRefStructureItemDetailUUID P_SpltSFITrcblCompAssembly MfgRefStructureItemDetailUUID
ActiveReplaceShopFloorItem P_SpltSFITrcblCompAssembly AssemblyShopFloorItem Serial.Mat. ID
OriginalReplacedShopFloorItem P_SpltSFITrcblCompAssembly AssemblyShopFloorItem
MfgRefStrucItmDetIsContextual P_SpltSFITrcblCompAssembly MfgRefStrucItmDetIsContextual
DgtlMockUpCharcsUUID P_SpltSFITrcblCompAssembly DgtlMockUpCharcsUUID DMU GUID
MaterialComponentQuantity
QuantityInEntryUnit
EntryUnit
MaterialBaseUnit
_Material P_SpltSFITrcblCompAssembly _Material
_Plant P_SpltSFITrcblCompAssembly _Plant
ReservationasReservation
KEY ReservationItem P_SpltSFITrcblCompAssembly ReservationItem Reservation Item
KEY RecordType P_SpltSFITrcblCompAssembly RecordType Reservation Record Type
KEY OpActyNtwkInstance P_SpltSFITrcblCompAssembly OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SpltSFITrcblCompAssembly OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem P_SpltSFITrcblCompAssembly AssemblyShopFloorItem
KEY AssembledShopFloorItem P_SpltSFITrcblCompAssembly AssembledShopFloorItem
KEY Batch P_SpltSFITrcblCompAssembly Batch Lot No.
KEY Material P_SpltSFITrcblCompAssembly Material Vehicle Model
KEY Plant P_SpltSFITrcblCompAssembly Plant Valuation Area
KEY OriglDgtlMockUpCharcsUUID P_SpltSFITrcblCompAssembly OriglDgtlMockUpCharcsUUID DMU GUID
KEY MfgRefStrucBOMLeafAssgmtUUID P_SpltSFITrcblCompAssembly MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
KEY MfgRefStructureItemDetailUUID P_SpltSFITrcblCompAssembly MfgRefStructureItemDetailUUID
ActiveReplaceShopFloorItem GenealogyShopFloorItem ShopFloorItem Serial.Mat. ID
OriginalReplacedShopFloorItem GenealogyShopFloorItem OriginalReplacedShopFloorItem
MfgRefStrucItmDetIsContextual P_SpltSFITrcblCompAssembly MfgRefStrucItmDetIsContextual
DgtlMockUpCharcsUUID P_SpltSFITrcblCompAssembly DgtlMockUpCharcsUUID DMU GUID
MaterialComponentQuantity
QuantityInEntryUnit
EntryUnit
MaterialBaseUnit
_Material P_SpltSFITrcblCompAssembly _Material
_Plant P_SpltSFITrcblCompAssembly _Plant
_ProductPlantBasic P_SpltSFITrcblCompAssembly _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_SFIAssldTrcblCompByLdngResvn.
-- 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: PMPESFIASLDTRCLR

CREATE VIEW P_SFIAssldTrcblCompByLdngResvn AS
SELECT
  Assembly.Reservation AS Reservation,
  Assembly.ReservationItem AS ReservationItem,
  Assembly.RecordType AS RecordType,
  Assembly.OpActyNtwkInstance AS OpActyNtwkInstance,
  Assembly.OpActyNtwkElement AS OpActyNtwkElement,
  Assembly.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  Assembly.AssembledShopFloorItem AS AssembledShopFloorItem,
  Assembly.Batch AS Batch,
  Assembly.Material AS Material,
  Assembly.Plant AS Plant,
  Assembly.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  Assembly.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  Assembly.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  Assembly.AssemblyShopFloorItem AS ActiveReplaceShopFloorItem,
  Assembly.AssemblyShopFloorItem AS OriginalReplacedShopFloorItem,
  Assembly.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  Assembly.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  cast(sum(Assembly.MaterialComponentQuantity) as kmpmg preserving type) AS MaterialComponentQuantity,
  cast(sum(Assembly.QuantityInEntryUnit) as erfmgv preserving type) AS QuantityInEntryUnit,
  cast(max(Assembly.EntryUnit) as erfme preserving type ) AS EntryUnit,
  cast(max(Assembly.MaterialBaseUnit) as meins preserving type ) AS MaterialBaseUnit,
  Assembly._Material AS _Material,
  Assembly._Plant AS _Plant,
  Assembly._ProductPlantBasic AS ReservationasReservation,
  Assembly._ProductPlantBasic AS _ProductPlantBasic
FROM P_UnspltSFITrcblCompAssembly AS Assembly
INNER JOIN P_SpltSFITrcblCompAssembly AS Assembly ON /* join condition not captured in parsed metadata */
;

Learn More