P_SFOAssldTrcblCompLdngResvnSL

DDL: P_SFOASSLDTRCBLCOMPLDNGRESVNSL SQL: PMPESFOASLTRCBL2 Type: view CONSUMPTION
25 Fields 1 Data Sources

P_SFOAssldTrcblCompLdngResvnSL is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_SFOAssldTrcblCompLdngResvn) and exposes 25 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement.

Data Sources (1)

SourceAliasJoin Type
P_SFOAssldTrcblCompLdngResvn SFOAssldTrcblCompLdngResvn from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMPESFOASLTRCBL2 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 (25)

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

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_SFOAssldTrcblCompLdngResvnSL.
-- 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: PMPESFOASLTRCBL2

CREATE VIEW P_SFOAssldTrcblCompLdngResvnSL AS
SELECT
  SFOAssldTrcblCompLdngResvn.Reservation AS Reservation,
  SFOAssldTrcblCompLdngResvn.ReservationItem AS ReservationItem,
  SFOAssldTrcblCompLdngResvn.RecordType AS RecordType,
  SFOAssldTrcblCompLdngResvn.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFOAssldTrcblCompLdngResvn.OpActyNtwkElement AS OpActyNtwkElement,
  SFOAssldTrcblCompLdngResvn.ShopFloorItem AS ShopFloorItem,
  SFOAssldTrcblCompLdngResvn.Batch AS Batch,
  SFOAssldTrcblCompLdngResvn.Material AS Material,
  SFOAssldTrcblCompLdngResvn.Plant AS Plant,
  SFOAssldTrcblCompLdngResvn.StorageLocation AS StorageLocation,
  SFOAssldTrcblCompLdngResvn.InventoryUsabilityCode AS InventoryUsabilityCode,
  SFOAssldTrcblCompLdngResvn.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  SFOAssldTrcblCompLdngResvn.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  SFOAssldTrcblCompLdngResvn.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  SFOAssldTrcblCompLdngResvn.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  cast(sum(SFOAssldTrcblCompLdngResvn.MaterialComponentQuantity) as mpe_consumed_qty_in_base_unit preserving type) AS MaterialComponentQuantity,
  cast(sum(SFOAssldTrcblCompLdngResvn.QuantityInEntryUnit) as erfmgv preserving type) AS QuantityInEntryUnit,
  cast(max(SFOAssldTrcblCompLdngResvn.EntryUnit) as erfme preserving type ) AS EntryUnit,
  cast(max(SFOAssldTrcblCompLdngResvn.MaterialBaseUnit) as meins preserving type ) AS MaterialBaseUnit,
  cast(max(SFOAssldTrcblCompLdngResvn.DebitCreditCode) as shkzg preserving type ) AS DebitCreditCode,
  SFOAssldTrcblCompLdngResvn.ManufacturingOrder AS ManufacturingOrder,
  SFOAssldTrcblCompLdngResvn._Material AS _Material,
  SFOAssldTrcblCompLdngResvn._Plant AS _Plant,
  SFOAssldTrcblCompLdngResvn._ProductPlantBasic AS _ProductPlantBasic,
  SFOAssldTrcblCompLdngResvn._ManufacturingOrder AS _ManufacturingOrder
FROM P_SFOAssldTrcblCompLdngResvn AS SFOAssldTrcblCompLdngResvn
;

Learn More